DB2 UDB Load stage - Method Option
Posted: Thu Jan 06, 2011 3:32 pm
Hi,
Have anyone used different options in the "METHOD" Prompt in DB2 UDB Load satge's Propertis tab? It is set to Default (D) by default. I am trying to use the Method P, but had no luck with it. Please help.
Basically, my job has a dataset loading into a DB2 table using Bulk load stage. My dataset has 20 columns and the table has 21 columns. I want skip loading the 1st column in the table (as this is a generated sequence number into teh table) and start loading from column 2 through 21.
Please help...
Thanks.
Have anyone used different options in the "METHOD" Prompt in DB2 UDB Load satge's Propertis tab? It is set to Default (D) by default. I am trying to use the Method P, but had no luck with it. Please help.
Basically, my job has a dataset loading into a DB2 table using Bulk load stage. My dataset has 20 columns and the table has 21 columns. I want skip loading the 1st column in the table (as this is a generated sequence number into teh table) and start loading from column 2 through 21.
Please help...
Thanks.