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

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

B.

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

vijay_dwi@yahoo.com wrote:

> 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

--
Knut Stolze
DB2 Information Integration Development
IBM Germany