Hello all,
I am using netezza connector to update a set of records through Netezza connector through Datastage.
I am using RCP enabled data from dataset and moreover i wanted to resue the same job for different table updates.
While using netezza connector and passing the composite key columns to netezza stage via parameter, job aborts due to the following error:
(Netezza stage expects the key column to update and a check mark in columns tab will not surve the purpose.)
The following key column(s): Order_number,Item_number, Order_number,Item_number, Order_number,Item_number, Order_number,Item_number, Order_number,Item_number were not found in the link schema (CC_NZMetadataHelper::validateColumnsAgainstLinkSchema, file CC_NZMetadataHelper.cpp, line 2,917)
Order_Number,Item_number is the composite key which is used for update.
Let me know if any one has the solution for the above stated problem.
Note: It works fine if the composite key columns are selected manually.Problem persists only when passing it through the parameter
Job aborts if composite key columns are passed as a parametr
Moderators: chulett, rschirm, roy
Are you sure your parameter is set correctly. What does the job-log tell your parameter value to be? Is it really "Order_Number,Item_number" or is it "Order_number,Item_number, Order_number,Item_number, Order_number,Item_number, Order_number,Item_number, Order_number,Item_number"?
If it is the latter: How do you select the parameter?
If it is the latter: How do you select the parameter?
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
- Premium Member
- Posts: 62
- Joined: Thu Dec 28, 2006 11:54 pm