Hi,

I am new to db2. Can anyone help me out to create a stored procedure to import a csv file to existing database.

I used this command and its working fine.

import from 'C:\test1.csv' of del
insert into det1 (name,age,salary)

Now i need to write a sp for this. How to do this??

I appreciate you kind help.

thanks,
Manoj

have a look at the documentation for ADMIN_CMD command for your version of the database. If IMPORT is supported, you can call this procedure from your SP to do the import. HTH

i think it picks 'C:\test1.csv' from the server path even if you are calling the admin_cmd from client

yes!!!! All Stored Procs runs on the server