DSXchange

Try this IBM's feature:
https://www.ibm.com/support/knowledgece ... DELIM.html

Still an useful solution after so many years

Hello everyone! In my Web Services Transformer, after sending a request I am getting the following response: <ns0:RetrieveTicketRS xmlns:ns0 = "http://company/CORPORATE/RetrieveTicketRS"> <ns0:Errors> <ns0:Error Code = "310.PT" ShortText = "Not Found" Type = "F&quo...

Maybe this is the situation:
http://www-01.ibm.com/support/docview.w ... wg1JR37562

When you run the select statement in an another application how many records do you get?
Do you have any filters in transformer?
How do you actually see the records loaded into the file, through Monitor or do you open the file?
Try to split the job into pieces to locate the problem.

Regards,
Pedro.

Hello,
Please check viewtopic.php?t=148651&highlight=

Regards,
Pedro.

Hello,
And what happens(log messages) when you run the job?
Regards,
Pedro.

Hello, I believe that with xml output stage it should be possible to get what you want. Make sure that the column selected as Key is correct. The order of the input records is also important since records from the same key must be together. And of course be careful if you are processing in parallel ...

Hello, I cannot make any comment to the "regroup step" since I don't know version 8.5. But that issue on having 2 repeatable elements on the same level is familiar. Our solution was to treat each element separately and putting each group of repetitions in a single field. This is, using you...

I have 2 columns defined as Key, a functional column(like ProdCod) and the new dummy column, but I guess dummy should be enough.

I realized a pattern that is related to the order how input records are processed: If "identic" elements are processed sequentially, i.e., one right after another, then Datastage "aggregates" them inadequately. If by chance they are not processed sequentially then xml is created ...

So far it has been running good. I am declaring this topic as Resolved.

Finally I got it: From previous run DataStage Job 675 Phantom 538 Program "DSRunJob": Line 403, Variable "TempName" previously undefined. Empty string used. Subroutine "DSU.RtSearchStringInJobLog" called with 3 arguments, 0 were expected" Program "JOB.11883440...

XML stages are tipically heavy in my project. Despite this, they dont' take hours to run.
Identify in your log entries which step is taking longer, for example, did you find any log entry with "Requesting delayed metadata"?

Assuming your job is: Source ----> Transformer ------> target 1 (target table) ---------> target 2 (reject table) And that Help says: When the Oracle connector includes a reject link, records that meet specified reject criteria are automatically routed to the target stage on the reject link, and pro...