Declared Temporary Table

Philip Gunning

Declared Temporary Table
Amy, The best reference I found on this is the Redbook,
DB2 UDB Server for OS/390 Version 6 Technical Update, SG24-6108-00.
I know of one site that took a 20 hour job down to an hour using a declared
temporary table. HTH Phil

Philip Gunning
Sr. Systems Consultant
Quest Software

IBM Certified Solutions Expert -- DB2 UDB Database Administration
IBM Certified Solutions Expert -- DB2 Application Development Unix, Win,OS/2

IBM Certified Advanced Technical Expert -- DB2 UDB DRDA (Connect)
IBM Certified Solutions Expert -- CICS Transaction Se