I am needing to know if on a DB2 version 8 database,

Can I export a .ixf flat file from a global temporary table session??

If I can, what exactly is the syntax. Thanks

Yes, you can export, but you cannot import.

Syntax:
export to d:\arw.ixf of ixf messages d:\mess.out select * from session.fred

Andy

What about if I am using a java program to run sql on a UNIX box. How can I incorporate the export process to export the file out. Currently, this is one export that I have, but it exports a .dat file

[INSERT]
!!TABLE NAME = SESSION.TEMP_PRICE_DOM
!!EXPORT = /markopt/data/
INSERT into
SESSION.TEMP_PRICE_DOM
SELECT distinct
'PAYLESSCORP',
'PAYLESS',
'1LT' || char(a.num_lt) as lot,
'LOT',
rtrim(char(a.num_co)) || '01S' || rtrim(char(a.num_str)) as store,
'STORE',
TIMESTAMP(@@DTWKE@@ - 6 days),CURRENT TIME),
' ',
CURRENT TIMESTAMP,
'A',
a.amt_unt_rtl,
TIMESTAMP('@@DTWKE@@',CURRENT TIME),
'ACTUAL PRICE',
'USD',
'REG'
FROM
session.domestic a;

You have a problem. Export is not SQL, it is a command and therefore cannot be executed through JDBC.

Andy

Thanks for your help Andy, I think I can work around this somehow. I was just trying to get it all in one job instead of breaking it down to 2. Thanks though.

Rob