Hi
I am trying to update data from a Dataset to a DB2/UDB stage . It is having Internet_order_nbr(decimal(9,0) key column) and Orderkey(integer(10)) and doing upsert by giving Autogenerated mode as "upsert".After specifying the properties for the DB2 stage. It's giving an error "The schema does not contain the specific field ORDER_KEY;
this field is used as an insert, update, or delete key."
Can anybody help me on this.
getting error in DB2UDB enterpise stage while doing upsert
Moderators: chulett, rschirm, roy
getting error in DB2UDB enterpise stage while doing upsert
Kalpana Marupudi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes below my Insert and Update statements given:ray.wurlod wrote:The schema does not contain the field ORDER_KEY mentioned in your SQL. Perhaps you need to qualify the table name with the correct schema name. ...
INSERT INTO CDW.CS_ORDER_FACT (INTERNET_ORDER_NBR, ORDER_KEY) VALUES (ORCHESTRATE.INTERNET_ORDER_NBR, ORCHESTRATE.ORDER_KEY)
UPDATE CDW.CS_ORDER_FACT SET ORDER_KEY = ORCHESTRATE.ORDER_KEY WHERE (INTERNET_ORDER_NBR = ORCHESTRATE.INTERNET_ORDER_NBR)
Apart from this how can i give schema name?
Kalpana Marupudi
Yes I'm using IBM Data Studio2.2 to access,insert and updating table,it was successful in doing that operation with this tool..ETLJOB wrote:Did you try to Insert/Update data using any database access tool? If yes, was that successful?
Just to make sure you are not making any mistakes with schema/table/column names.
Kalpana Marupudi