Search found 5 matches

by Fon Silvers
Tue Sep 11, 2012 8:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Where do we set Errors Allowed for oracle stage in Datastage
Replies: 3
Views: 1486

Thank you so much for your response. I couldn't see the whole message since I am not premium member but anyhow I do not see any option in the stage that would allow us to set the errors. We want a small number to set so that job will abort. These are the only options I see in the stage. additional c...
by Fon Silvers
Mon Sep 10, 2012 1:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Where do we set Errors Allowed for oracle stage in Datastage
Replies: 3
Views: 1486

Where do we set Errors Allowed for oracle stage in Datastage

We see the following in the oracle log file (for example ora.5636216.0.0.log) for a load job using Oracle stage. Number to load: ALL Number to skip: 0 Errors allowed: 50 Where do we set this errors allowed =50 ? How does the Oracle stage know that the limit is 50. Is there a variable that we can man...
by Fon Silvers
Thu Jun 18, 2009 5:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading XML messages from MQ...
Replies: 5
Views: 2354

Hi, Thats what I did. I have all the required xpath expressions in my MQ and XML stage. And I know I do not get any undefined tags otehr than what I have. But some of our team members expressed concern what if you get a tag that is not in xpath expression. The job is running fine but ignoring those ...
by Fon Silvers
Thu Jun 18, 2009 3:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading XML messages from MQ...
Replies: 5
Views: 2354

Hi Ernie,
Can you be more specific what is meant by xsd and where I need to define it and how I can specify it in XML stage.

If you mean having all the paths for each column in some kind of file.

I am using a server job.

MQ -> XML input stage - > seq files

Thanks.
by Fon Silvers
Wed Jun 17, 2009 10:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading XML messages from MQ...
Replies: 5
Views: 2354

Reading XML messages from MQ...

Hi, We are using MQ and XML for the first time. We have a job which reads the XML messages from MQ using XML input stage and parses the tags based on the xpath mapping and writes to 40 different sequential output files. The job is running fine with all the defined tags mapped to correct fields in se...