Creating Dynamic Table and Load the data from CSV file.

db2pro · #1 (**permalink**) 07-08-09, 10:44

Hi All,

Can anyone please help me in creating a dynamic table and load that table with the values from a CSV file.

Thanks a lot

sathyaram_s · #2 (**permalink**) 07-08-09, 10:47

Pardon my ignorance. What is a dynamic table ?

And what platform and db2 version are you using ?

Can you give an example

Cheers
Sathyaram

db2pro · #3 (**permalink**) 07-08-09, 10:57

Hi Sathyaram, Thanks for ur reply..

Dynamic table is a temporary table... which should go off after I use the values from that table in a stored proc.

I am trying to fetch the values into this table from a CSV file and then I will use the values in a stored proc...This will happen frequently so I am thinking of creating a dynamic table.

DB2 Version: v9.5.0.3

OS LEVEL: AIX 5.3

n_i · #4 (**permalink**) 07-08-09, 11:22

Check the global temporary tables and the IMPORT and LOAD commands in the manuals.

Internet Services

Web Development

Digital Marketing

Consumer Tech