Load global temporary table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vijay_dwi@yahoo.com - 05 Jan 2006 15:52 GMT

Hi all,

I have a fixedwidth .DAT file and a DB2 table, I have to create a flat
file by pulling data from both file and DB2 table. I tried using
IMPORT/LOAD utilities to load to a global temporary table and thought
of joining it and extracting, but IMPORT/LOAD are not allowed on
temporary table.
Can you please suggest me how to go about it...

thanks in advance,
kore

Reply to this Message

Brian Tkatch - 05 Jan 2006 17:07 GMT

Can you Import it to a real TABLE, and then export with a join?

B.

Reply to this Message

vijay_dwi@yahoo.com - 05 Jan 2006 21:01 GMT

As per my requirements I am not supposed to use a real table. Please
suggest me.....

Reply to this Message

Knut Stolze - 05 Jan 2006 21:18 GMT

> As per my requirements I am not supposed to use a real table. Please
> suggest me.....

Why not a real base table? School exercise? Then maybe the goal is to
figure out that it doesn't work that way?

You could do all kinds of things to avoid a base table:
(1) do not use import but rather some other means to access and read the
file, for example a table function
(2) like (1), but use a federated wrapper
(3) You could try a stored procedure that does the import into the temp
table

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message