DSXchange

Thanks Ernie, I have checked the "Repeating Element required" in the transformation settings of the output tab. What I am trying to figure out is the Yes/No option in the Columns tab for the Key value of the element listed. Here is an example: The source is <QVResponse><Response><Error><Er...

Correct, but I am trying to understand what column to set the key to yes, and why. Thanks

Evidentally the xml file contains an element defined as <PackageServiceOptions><COD/></PackageServiceOptions>

Can anyone explain what the following error means:

Error: No repetition element specified for link datastage

and perhaps provide an example of a repetition element (occurs) and how to interpret it in the xml input stage design?

Thanks

Let me explore some more. Perhaps there is something in the documentation.
Thanks

Hello, Here's a problem I am facing. The xml table definition has some elements that are not defined. The xml table defs were created from the actual source xml file. When it was loaded into the output/columns tab of the xml stage, this is what appears under the description column: /QuantumViewRespo...

Works like a charm. I going to experiment some more, and then start working on the real file rather than the test file I created.
Thank you so much

Hello I have an xml file as follows: <?xml version="1.0"?><QuantumViewResponse><Response><TransactionReference><CustomerContext>Test XML</CustomerContext><XpciVersion>1.0007</XpciVersion></TransactionReference><ResponseStatusCode>1</ResponseStatusCode><ResponseStatusDescription>Success</Re...

Thanks

chulett wrote:No, that requires the use of some kind of "remote shell" capability outside of DataStage. You could script that, however, and then let DataStage execute the script. ...

No, I haven't checked it out, and I will. Can one specify a different server name in the path in the Execute command stage? The exe is to be generated from a vb script Thanks Well... you don't execute a dll. And the others in several ways: DSExecute in a routine, ExecSH before/after job or Execute C...

Can anyone say how one can execute an exe or a dll or a batch file in a DS job? And what if the exe is on another server? Can one execute it?

Thanks

We had a similar issue. IBM thought it was a memory leak issue, and developed a patch. We have yet to apply it to see if it works. The patch they suggested is
patch_JR30596_server_solaris_801fp1.tar

Hello, I have a sequence job A that calls B that calls C that calls a parallel job D. The "Do not checkpoint run" is checked on B and C only. Now if D aborts, I expect the abort status to bubble up to C, B and A, and checkpoint should be established only at A. The question is, is that assu...

What is the syntax using variables as parameters in DSSendMail? I have tried the following and it does not work:

Recipients = ToList
Ans = DSSendMail("From:aaa.xxx.com\nTo:#Recipients#\nSubject:Job Failure\nBody:Hourly failed to load successfully\n")

One more note...I tested the routine independently of the sequence job, and it works fine. The problems seems to be with the sequence job that executes the routine