BTEQ FOLDLINE

Database
Enthusiast

BTEQ FOLDLINE

Hello,
=> the whole text below is out of date since i tried a .RUN FILE=filename with a length of records > 254 and it works ! (V2R6)
Having to export the description of views in file under Bteq/MVS, with records splitted in parcels in order to fit with the limit of 254 in length(for a .run file), i found a good trick to use a view and the SET commands:
.SET FOLDLINE ON ALL
.SET RETLIMIT n 200
as a first trial i ran an simple SELECT and got the error message :
*** Query completed. One row found. 26 columns returned.
*** Total elapsed time was 1 second.

*** Error: Can not fit the title and at least one record
on a page possibly due to excessive FOLDLINEs.
Try again with less FOLDLINEs or use the command
".Set SideTitles ON"
*** Canceling the output.

Maybe a SET parameter is missing ? the objective being to export "replace views .... " commands on as many lines as needed in a file for use in a .RUN BTEQ
Thanks for help,
Pierre