JDBC-Connector issues

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Asfare
Participant
Posts: 6
Joined: Thu Feb 22, 2018 10:06 am

JDBC-Connector issues

Post by Asfare »

Hi, I'm new in DS job developmen and I triying to create a new job composed by:
CDC_Transaction->Transformer->JDBC_Connector
I test my results updating, inserting and deleting but, I have problems if I try to do a "Delete then Insert" operation.
My job crash because "I did'tn refer all my columns in the statemen"

My question is:
How I can directly refer a specific column in my job?

many thanks
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

What is value of "Drop unmatched fields" in the JDBC stage properties?
Asfare
Participant
Posts: 6
Joined: Thu Feb 22, 2018 10:06 am

Post by Asfare »

The value is set to NO.
I understand that the field should be worth YES, but I still don't know how to correlate the information I get with the specific columns I want to write.
rkashyap
Premium Member
Premium Member
Posts: 532
Joined: Fri Dec 02, 2011 12:02 pm
Location: Richmond VA

Post by rkashyap »

You can see the SQL statement performing Delete and subsequent Insert in DataStage Director. Confirm that ALL columns that the connector can be paired with the target table.
Asfare
Participant
Posts: 6
Joined: Thu Feb 22, 2018 10:06 am

Post by Asfare »

Hi!

I'm performing test of my issues and it's failing again.

How i pair the columns in JDBC_Connector?

Thanks
Asfare
Participant
Posts: 6
Joined: Thu Feb 22, 2018 10:06 am

Post by Asfare »

So...
Can anyone helping please?

Many thanks!
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Delete operation requires at least one column to be marked as Key. If this is being done in SQL, the Key columns are used in the WHERE clause.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply