Hi

Can any one help me Please

i have sql query in that i did some calculation for below each FIELDS nearly 15 col

after im hold it in Hold file
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS MYFILE FORMAT ALPHA
END

but im getting error like this
"0 NUMBER OF RECORDS IN TABLE= 10 LINES= 10
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 1
(FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: 44.11 INCHES
(FOC1517) UNRECOGNIZED COMMAND ON TABLE HOLD AS CVRTUF FORMAT ALPHA
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: MYFILE
NO DATA FILE IS CURRENTLY ACTIVE"

But after sql part i can see the description part



FILENAME= SQLOUT
FILED_11 E01 A105V
FILED_12 E02 P20.4
FILED_13 E03 P20.4
FILED_14 E04 P20.4
FILED_15 E05 P20.4
FILED_16 E06 P20.4
FILED_17 E07 P20.4
FILED_18 E08 P20.4
FILED_1 E18 I11


each FIELD values have these may digits for all calculation FIELDS= 12,345,678.20

This message has been edited. Last edited by: <Kathryn Henning>,

Do a

?FF SQLOUT

before your TABLE FILE SQLOUT to see what the synonym says is in there (SQLOUT), and show us the results of that. Then do a

TABLE FILE SALOUT PRINT * WHERE RECORDLIMIT EQ 10 ON TABLE HOLD
END

and show us those results as well...

before TABLE FILE SQLOUT
?FF SQLOUT

this is i got synonym

FILENAME= SQLOUT
FILED_11 E01 A105V
FILED_12 E02 P20.4
FILED_13 E03 P20.4
FILED_14 E04 P20.4
FILED_15 E05 P20.4
FILED_16 E06 P20.4
FILED_17 E07 P20.4
FILED_18 E08 P20.4
FILED_19 E18 I11


the query have top 15 records only

but my question is because of this values ( all calculation FIELDS= 12,345,678.20) its not sorting in hold file ?

Developer,
You are not showing us everything:

quote:

(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 1
(FOC3218) NOTE: REPORT WILL BE PANELED; TOTAL WIDTH IS: 44.11 INCHES

This makes me believe your output is PDF.

quote:

(FOC1517) UNRECOGNIZED COMMAND ON TABLE HOLD AS CVRTUF FORMAT ALPHA

Is this command not part of a TABLE request?

quote:

(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: MYFILE

MYFILE has not been saved or is empty.