Somehow I am not able to commenton my post related to this issue.So, I created a new topic.
Dnoeth suggested me to use "Data file with Record mode off and foldline option" but
I am still getting the header as:
"112/11/30 SELECT DISTINCT 'DROP TABLE DB.' || 'TABLENAME' || ';' , CASE WHEN ROW_NUMBER() OVER (ORDER BY TABLE ... Page1
and then for Page 2 and so on...How to get rid of it. I am using Data file with Record mode off and foldline option.
I am using this in BATCH.
I am using the below query:
.export data file = xxx
And split the string in two columns:
'DROP TABLE DB.' || TABLENAME || ' ;',
CASE WHEN ROW_NUMBER() OVER (ORDER BY TABLENAME) MOD 25 = 0
THEN '.HANG 10;' ELSE ' ' END
Looks like there's a HEADING defined (although i don't know how you can get the SELECT in it).
Do a SHOW CONTROL to see the settings and try a FORMAT OFF to switvh off the header.