I am exploring the use of global temp tables to improve performance of several reports. The problem is that I can't figure out how to use the data in the temp table. Here is my fex:
APP HOLD ETGA

ENGINE DB2 SET DEFAULT_CONNECTION u1xsl01
SQL DB2 PREPARE SQLOUT FOR
SELECT B_BUDGET_ID FROM XSL.BUDGET_PROJECTED
WHERE B_YEAR = '2009' and B_PROMOTION_MONTH = '12'
WITH UR;
END
TABLE FILE SQLOUT
PRINT
B_BUDGET_ID
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS HOLD_BUDGET_ID FORMAT SAME_DB PERSISTENCE VOLATILE
ON TABLE SET HTMLCSS ON
END
APP HOLD ETGA
TABLE FILE HOLD_BUDGET_ID
PRINT
B_BUDGET_ID

END

and here is the error message:

0 NUMBER OF RECORDS IN TABLE= 158 LINES= 158
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD_BUDGET_ID
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: HOLD_BUDGET_ID
BYPASSING TO END OF COMMAND

Any help would be greatly appreciated.

thanks - John

v7.6.10

why do you put it in an hold file?

if posted in an hold file why do you do all the heading and footings ?

the set APP HOLD ETGA sets the path for the location of the file you want to use....

did you get any training?

Here is a link that will provide you with the correct syntax for using pass-through SQL. Select the link for "Using SQL Translator Commands".

http://documentation.informati...htm?url=topic257.htm

Also, SAME_DB was pretty buggy in the early releases of 7.6. I have ..5 and still won't use it. It looks alright in ..10.

You might want to open a case to check the status of your release.