I've installed TR8 for V7R1 on iSeries and iI did some tests for the new SQL procedure GENERATE_SQL.
GENERATE_SQL works as described, I put the sql-source in the file Q_GENSQL.
If I do a CPYTOSTMF from the database file to a streamfile (pcfile) in the IFS. I need it because I work with "run sql scripts" from iNav.
The stramfile has a blank line after each line (each second line is a blank line). I tried all possible values for ENDLINFMT, but did not help.
What can I do to avoid the blank lines (in the database source file are not blank lines)