RE: DB2EUG: import/export commands using db2batch

[Vilas, Ajith (USPC.PCT.Hopewell)]

Roy,
 I don't think you can use DB2BATCH to execute EXPORT and IMPORT, because of the fact 
that they are not dynamically "preparable" ;-) statements. DB2BATCH is a CLI 
application and can only execute
statements that can be dynamically prepared using SQLPrepare()/SQLExecDirect() etc.
Regards,
Ajith

-----Original Message-----
From: Roy Reynolds [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 12:22 PM
To: [EMAIL PROTECTED]
Subject: DB2EUG: import/export commands using db2batch


I have a UNIX environment....Solaris, UDB 7.2 and am using DB2BATCH
successfully for DDL statements.
I can't seem to get EXPORT and IMPORT  commands to work with DB2BATCH.
For instance, the following fails
export to LOADALIGNMENTDESCRIPTOR37435.del of del select * from
GKP28_LGJAN.ALIGNMENTDESCRIPTOR

I've tried many variations, putting it in quotes, appending a semicolon,
using a \ for continuation, etc but get various failures.
Am I going about this the wrong way?

My real intent is to export data to a delimited file from an Oracle
table using DB2 federation (nicknames), then import the delimited file
into a DB2 table.  I can do this if I use the CLP, but fail when trying
to use DB2BATCH.
TIA,
Roy


=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod