[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Flat file creation problem



I think you can use use -XTB on the command line.

This option preserves the trailing blanks in a .LIS file.

- preserves being the key word.

- you will have to pad with blanks using any number of methods
      ( a pile of email on this one ).


scott

>Does anyone know how to insure that records created in a .lis file
>from an SQR is of a certain length?  Because the last field being
>written out to the .lis file is a description, the record lengths in
>the .lis file vary depending on the length of the description.
>I can insure the record lengths by "opening" a file in the SQR and
>"writing" to this file, but I need it to work via the .lis route using
>the print command.  The command I'm using is as follows
>
>"print $output_buff (1,1,1043)"
>
>If $output_buff is 10  characters then the record length is 10
>If $output_buff is 500 characters then the record length is 500
>
>----------------------------------------
>Bruce Weinstein
>E-mail: bruceweinstein@canada.com
>
>