Re: Flat file creation problem

[Franck Masson <franck.masson@SQRIBE.COM>]

hi,
can you use this

#L      =       length($output_buff)
print $output_buff (1,1)
print  ' '  (1,#L,1043)  fill

Or try this may be it works too

print $output_buff (1,1)
print  ' '  (,,1043)  fill

( I have not tested these code may be there is some mistake like #L
instead of #L+1 )

if yes then create a procedure that you will call.

Franck,

Bruce Weinstein wrote:
>
> 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