SET PAGESIZE 400
SET LINESIZE 120
SPOOL C:\TEMP\FILENAME.TXT
SPOOL OFF
ED
SAVE -> ALT-F4
/
SELECT * FROM TAB
SELECT MAX(LENGTH FIELDNAME) FROM TABLE
COLUMN FIELDNAME FORMAT A25 (FOR TEXT)
Like my sticky notes on the web
SET PAGESIZE 400
SET LINESIZE 120
SPOOL C:\TEMP\FILENAME.TXT
SPOOL OFF
ED
SAVE -> ALT-F4
/
SELECT * FROM TAB
SELECT MAX(LENGTH FIELDNAME) FROM TABLE
COLUMN FIELDNAME FORMAT A25 (FOR TEXT)