I have dbX on a server.I want to create a new database dbY in my local and I want to copy tables from dbX to my new database dbX with sql commands from a .net application. I couldnt write the sql command.Can anyone help me please?

Use Sql commands to redirect restore DB2 database or Export import

-kUmar

but backup and export commands are db2 commands.
I need standart sql commands to copy a tables of a database from .net application.

if u are using v9,
u can use sysproc.admin_cmd procedure to export,import/load.
in v8, i think only export is available . plz check it

Rahul Singh

thank you.I'm using v8 and I can only use export.is it possible to use import in v8? or is there any other way to copy tables from exported files.

Can anyone specify how the sysproc.admin_cmd procedure is to be used for import/export ?

Got the execution of sysibm.admin_cmd proc at
http://publib.boulder.ibm.com/infoce...n/r0012547.htm

But I dont understand one thing. Why do we need to call this procedure with the entire syntaxof export , reorg, runstats or update db config when when we can run this commands directly at the db2 command prompt?

The proc allows the DB2 commands (which are not SQL statements) to be run from inside an application program, stored proc, etc.

If you want to run the commands from the OS command prompt or a shell script, then the proc is obviously not necessary.

Thanks Marcus