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,
intsoccersuperstar WebFOCUS 8105m Windows, Excel
March 24, 2019, 03:25 PM
Danny-SRL
Take out all your SET LINES. Instead, put ON TABLE SET LINES 99999 in your TABLE request.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF