You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

SQR writing text file line longer than 32767

No replies
Guest's picture

I have an SQR that writes to a CSV file. Each line potentially has a *ton* of text, well exceeding the record length limit of 32767. Has anyone been able to accomplish something like this? Is it possible to write multiple times to the same line? For example, right now I have something like this:

string $var1 $var2 $var3 $var4 into $output_record
write 1 from $output_record

So what I might do is
string $var1 $var2 into $output_record
write 1 from $output_record
string $var3 $var 4 into $output_record
write 1 from $output $record

The problem is, with each write, I get a CR -- I need it all on the one line. I tried

Thanks in advance!