I have a generic job. This has a dataset with RCP and a field with the change capture in , a filter stage and an Oracle stage. Using this information, I must either insert update or delete rows in a table.
Given that I don't have the SQL, how can I set the key column so that the stage knows which rows to delete or update.
Are there any functions to do this or must I pass in an SQL statement to the job to do this.
Thanks
RCP dataset needs to update/delete/insert an Oracle stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sorry Ray. I dont understand your answer.
Yes, I can import the schema from the table, but the dataset that I have could contain possibly only 1 field in the case of a delete, x fields for an update and all fields for an insert.
Is there anyway of reading the schema of the dataset at runtime and then passing a parameter in to set one of the fields as a key ?
Yes, I can import the schema from the table, but the dataset that I have could contain possibly only 1 field in the case of a delete, x fields for an update and all fields for an insert.
Is there anyway of reading the schema of the dataset at runtime and then passing a parameter in to set one of the fields as a key ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: