var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Exporting an .ixf flat file from a global temp table
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.
export to d:\arw.ixf of ixf messages d:\mess.out select * from session.fred
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
!!TABLE NAME = SESSION.TEMP_PRICE_DOM
!!EXPORT = /markopt/data/
'1LT' || char(a.num_lt) as lot,
rtrim(char(a.num_co)) || '01S' || rtrim(char(a.num_str)) as store,
TIMESTAMP(@@DTWKE@@ - 6 days),CURRENT TIME),
You have a problem. Export is not SQL, it is a command and therefore cannot be executed through JDBC.
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.