By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

IMPORT or LOAD commands in ASP

P: n/a
Friends,

Can anyone help me how to use DB2 utilities like IMPORT/LOAD in ASP
scripts ?
Dec 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.