467,923 Members | 1,271 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

IMPORT or LOAD commands in ASP

Friends,

Can anyone help me how to use DB2 utilities like IMPORT/LOAD in ASP
scripts ?
Dec 11 '07 #1
  • viewed: 1469
Share:
2 Replies
Shivakumar wrote:
Can anyone help me how to use DB2 utilities like IMPORT/LOAD in ASP
scripts ?
You can execute server-side IMPORT/EXPORT using the admin_cmd()
procedure which is an SQL Interface

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Dec 11 '07 #2
On Tue, 11 Dec 2007 11:34:30 -0000, Serge Rielau <sr*****@ca.ibm.com>
wrote:
Shivakumar wrote:
>Can anyone help me how to use DB2 utilities like IMPORT/LOAD in ASP
scripts ?

You can execute server-side IMPORT/EXPORT using the admin_cmd()
procedure which is an SQL Interface
However, IMPORT and LOAD are only supported with ADMIN_CMD under DB2 9 or
later - on 8.2 (which I think you might be using), only DESCRIBE, EXPORT,
PRUNE HISTORY/LOGFILE, REORG INDEXES/TABLE, RUNSTATS, and UPDATE DATABASE
CONFIGURATION are supported via ADMIN_CMD. If that's the case you're only
option is to launch a shell to get the CLP to run the IMPORT/LOAD command.
On Windows don't forget to use db2cmd to run the CLP, e.g.:

db2cmd -i -w -c db2 -t -v -f myscript.sql
Cheers,

Dave.
Dec 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by news | last post: by
5 posts views Thread by Kajol | last post: by
5 posts views Thread by kk | last post: by
7 posts views Thread by Eric | last post: by
49 posts views Thread by Martin Unsal | last post: by
2 posts views Thread by WP | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.