You've to do it in two steps.
SELECT * from temp1 INTO CURSOR crsTemp
COPY TO (sys(2023)+'\tmpCardFile.txt') TYPE SDF
>Hello Everyone!!!
>I have a temp cursor called temp1. I want to write it to a file.
>I have done the following
>
> SELECT * from temp1 TO FILE (sys(2023)+'\tmpCardFile.txt') PLAIN
>
>
>That gets me the file, but I need this file to go straigt accross for 80 characters.
>The Cursor has up to 3 records in it and each record is 80 characters long. But when I look at the file or send the file to the screen, It is wraped. I need it Straight so that I can send this file to the mainframe.
>Is there a command to help do this or do I have to write some low level writes to handle this?
>
>Thanks in advance
--sb--