Source stage (Flat File):
Target stage (ODBC Connector) Usage:
Write mode = Update; Generate SQL = Yes; Table name = #target_table#
NO RCP with this job..
I have the primary key I want to update on selected in the target ODBC connector stage which matches the primary key in the database table
At runtime, I got the following error: Failed to generate where clause for update statement. No key fields defined in the design schema.
Update is done on a key column and yet this error pops up
Whats the problem here???
Update Table NO RCP
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please verify that each column to be mentioned in the WHERE clause is identified in the metadata as Key
Last edited by ray.wurlod on Thu Mar 26, 2015 7:50 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
It's generated SQL, so it will only put fields into the WHERE clause when they are marked as Key fields. I'm assuming that is what was meant by 'selected in the target ODBC connector stage' but please verify.
Still curious why the table name is parameterized.
Still curious why the table name is parameterized.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers