I’m running a report (see below) from an oracle table (WT0050) on unix.
The width of the data goes out to column 773 and is printed fine.
However the column headings are folding over at about column 683
Is there anyway to keep these column headings on 1 line
Thanks
Richard



SET PANEL=999
SET PAGE-NUM=NOPAGE
SET LINES=999999
SET ASNAMES=ON
SET NODATA=' '
SET MORE=OFF
FILEDEF OFFLINE DISK add.ftm append lrecl 999
OFFLINE
-*
TABLE FILE WT0050
PRINT *
WHERE RECORDLIMIT EQ 4
END

This message has been edited. Last edited by: Kerry,

Hi Richardh

Could you try and remove the set commands and do an ON TABLE HOLD FORMAT WP or ON TABLE HOLD FORMAT DOC and then print it out.

Best of Luck
Barry

Format WP will not work as 773 characters exceeds the maximum width for a WP report.

You are also exceeding the maximum width for a heading, not sure what the Unix FOCUS limit is but in WebFOCUS it's supposed to be 410 characters.

Thanks Barry
I tried both suggestions and ON TABLE HOLD FORMAT WP works fine

That surprises me either the FOCUS and WebFOCUS limits are different or the WebFOCUS documentation is wrong.