Hello,

I have the following code:

-DEFAULT &LOOKBACKDAYS = 365;
-SET &TODAY = EDIT(&MDYY,'99$$$$$$')||'/'||EDIT(&MDYY,'$$99$$$$')||'/'||EDIT(&MDYY,'$$$$9999');
-SET &TODATE = AYMD(&YYMD,-1,'I8');
-SET &TODATE = SUBSTR(10,EDIT(&TODATE,'9999/99/99'),6,10,5,A5)||'/'||SUBSTR(10,EDIT(&TODATE,'9999/99/99'),1,4,4,A4);
-SET &FROMDATE = AYMD(&YYMD,-&LOOKBACKDAYS,'I8');
-SET &FROMDATE = SUBSTR(10,EDIT(&FROMDATE,'9999/99/99'),6,10,5,A5)||'/'||SUBSTR(10,EDIT(&FROMDATE,'9999/99/99'),1,4,4,A4);

ENGINE SQLORA SET DEFAULT_CONNECTION ods
SQL SQLORA PREPARE SQLOUT FOR

***sql here***

;
END

SET LINES=99999;

DEFINE FILE SQLOUT
SET LINES=99999;
YEAR/YY=STATUS_CHANGE_DATE;
MONTH/tM=STATUS_CHANGE_DATE;
YEARMND/YYtM=STATUS_CHANGE_DATE;
END

SET LINES=99999;

TABLE FILE SQLOUT


PRINT *
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET PAGE NOPAGE
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
$
ENDSTYLE
END

As you can see, I have tried to put SET LINES=99999 all over the place to try to get my headers to stop repeating every 50 or so rows but nothing seems to be working. Any suggestions would be greatly appreciated. Thanks!

This message has been edited. Last edited by: FP Mod Chuck,

Take out all your SET LINES.
Instead, put ON TABLE SET LINES 99999
in your TABLE request.

Also remove the semicolon on the SET LINES=99999;

Thanks Danny and Waz, works now.