Re: Max record length on created flat file from SQR

[Tony DeLia <tdelia@EROLS.COM>]

I don't have access to SQR documentation but if you try to open a file
with a length greater than 32767 or (2**15)-1 it will not compile...

Example 1:
----------

open 'c:\temp\reclen.txt' as 1 for-writing record=32767:vary
close 1

This compiles and executes without a problem...

Example 2:
----------

open 'c:\temp\reclen.txt' as 1 for-writing record=32768:vary
close 1

This does not compile and displays the error message:

   (SQR 2902) OPEN missing required qualifiers:
   RECORD={rec_len}  FOR-READING|FOR-WRITING|FOR-APPEND


The version of SQR I used to test this is 3.0.13.2 which leads me to
believe a half-word (16 bit) is used to store the length (FCB or DCB
area) without utilizing the high-order bit (which may indicate a file
attribute/mode)... I think 32767 is sufficient in most cases...

                Tony DeLia


Sharon Bennett wrote:
>
> I have not found documentation, although I really haven't looked. However, I
> know I have a couple of SQRs that read and write 1080 characters per record.
>
> -----Original Message-----
> From:   Discussion of SQR,             SQRIBE Technologies's database
> reporting language [mailto:SQR-USERS@list.iex.net] On Behalf Of Ackerson,
> Glenn
> Sent:   Wednesday, April 14, 1999 6:04 PM
> To:     Multiple recipients of list SQR-USERS
> Subject:        Max record length on created flat file from SQR
>
> Has anyone found documentation telling what the maximum record
> length is that's allowed creating/writing to a flat file from an SQR
> program? I'm creating an extract file for one of our departments and
> the record length is getting VERY large. I'd rather keep the format
> of the file with 1 record type rather than creating multiple record
> types per employee if I can. Thanks if you know!
>
> Glenn Ackerson
> **************************************************
> Glenn Ackerson
> Information Technology Professional III
> Internet Address: gsacker@is.unco.edu
> University of Northern Colorado
> Information Services
> Carter Hall   Greeley, CO  80639

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com