Sybase - Print more than 512 K per output line to output - flat file
Posted on 2003-03-27
I want to procude a flat file, but receive errors when I try PRINT a single given line to the output file that is more than 512 bytes long. I want to use just a single procedure if posible and not drop out to a unix shell script if it can be avoided.
I am not really use to Sybase, but more Oracle. In Oracle I get around this constraint as follows: UTL_FILE.FOPEN(v_dir,v_file_out,'w',32767);
How can I can around the 512K limitation?
PRINT command failed because the resulting string exceeded the maximum length of 512 bytes.
(return status = -6)