RCP enable,Wanted to know if there is a way to avoid warning

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You could use a message handler to demote the warnings to informational messages. Or you could investigate which fields are missing, and either modify the schema file or the data to make sure that the two coincide.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sudha.gundap
Premium Member
Premium Member
Posts: 7
Joined: Thu Jul 14, 2011 9:43 am
Location: NJ

Post by sudha.gundap »

Thanks for the response Ray.
I am able to load data into all tables with no issues.
But, Both(schema File and DB2 Table) have same fields and I am receiving same Warning for all the fields.
It would be of great help if we have a way other than message handler.
TonyInFrance
Premium Member
Premium Member
Posts: 288
Joined: Tue May 27, 2008 3:42 am
Location: Luxembourg

Post by TonyInFrance »

I have this same issue.
I need to use RCP since I'm using a generic job and thus my transformer has certain columns defined, i.e. those that I'm programming specifically. Over and above, I need to copy the columns present in the dataset and thus I select RCP.

I get warnings for the columns not defined explicitly.

Isn't it possible to eradicate these without message handlers?

Thanks

Tony
Tony
BI Consultant - Datastage
Thomas.B
Participant
Posts: 63
Joined: Thu Apr 09, 2015 6:40 am
Location: France - Nantes

Post by Thomas.B »

4 years later, sorry for the grave digging :-)

I had the exact same issue. To solve it, I had to add a "copy" stage right before the database connector, enable RCP and delete all the output columns.
BI Consultant
DSXConsult
Post Reply