DB2_UDB stage - Need help

vinothkumar · Post by **vinothkumar** » Wed Apr 27, 2011 2:21 pm

I am trying to get familiar with DB2_UDB stage using one row to insert in table. But while running I am getting the warning "Warning: DB2BulkLoad.DB2_UDB_Load_0: SQL1325N The remote database environment does not support the command or one
of the command options" . Because of that I am not able to see any progress.

Some of the properties in my DB2_UDB stage are
LoadMethod: Sequential File
LoadImmediate : YES
Load from Client : NO
File Type of data format : DEL
Method : D (Default)
Load Mode :INSERT
MODE : LOAD_ONLY

Control file generated is having below contents
LOAD FROM /home/n87511/inpdata.dat OF DEL MODIFIED BY lobsinfile noheader SAVEC
OUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES /home/n87511/Log.txt TEMPFILES PATH /h
ome/n87511/ INSERT into GGDD.ELOAD_EMAIL STATISTICS NO COPY NO DATA BUFFER 0 S
ORT BUFFER 0 CPU_PARALLELISM 0 DISK_PARALLELISM 0 INDEXING MODE AUTOSELECT

vinothkumar · Post by **vinothkumar** » Wed Apr 27, 2011 2:24 pm

This is about DB2_UDB load stage. I forgot to mention this.

vinothkumar · Post by **vinothkumar** » Thu Apr 28, 2011 9:08 am

By referring the belwo topic I am closing this.

http://dsxchange.com/viewtopic.php?t=10 ... 9fa27b1597