DSXchange

The client may always be KING but even kings are fallible, or ignorant. If the client has demanded that you construct jobs in a way that is against your better (educated) judgment, demand to know why and point out the consequences of following the client's mandate versus your better design. The cour...

Yeah, but there's no "send money for free receipt" notice there.

There is a cost for Design Studio, needed to create TX maps. See this post for details.

I finally got the official answer on the product. The MapStage plug-in is free with DS 7.5.x and up. To create the map itself, you will need the DataStage TX Design Studio. This is a separate product and does cost extra. If you have complex transformations, use complex file formats (like EDI, HIPAA,...

Ascential tech support provided the solution as follows: -Make sure the ftp plug-in is installed in /Ascential/DataStage/Engine/bin. -In DataStage Manager, Go to Tools menu > Register plug-in. -Select the dsftpune.dll file in the path above, and click to check the checkbox for "Parallel stage type r...

That property does not appear to be visible in 7.1, but you can specify "first line is column names" in the format when importing the Sequential File table definition. Loading it from the Repository into the job design should preserve this property.

What did searching on this forum for "abnormal termination" reveal to you about how and where to look for diagnostic information and/or likely causes of this particular message? Is it correct to discern from the error message that the job name is nsar_merge and that there is a Transformer stage call...

In the Job Activity, click on Insert Parameter Value. This opens the External Parameter Helper dialog, on which you will see the Execute Command Activity. Expand this and you will see three things that you can use to supply a value to the currently selected job parameter. $CommandName the name of th...

It's always useful to be able to initialize counters! :D

Welcome aboard! :D That's a pretty heavy duty first post! Obviously placing stubs (including these functions but without having them do anything) would overcome the registration checks, but are these functions essential? I have not played with this interface since version 5.2, and neither of the fun...

You can convert any DataStage job into a Web service using the RTI (real time interface, now called SOA (service oriented architecture)) components. RTI Input ---> stages ---> RTI Output If you need to pass XML documents to and fro, simply add the stages that read and write these. RTI Input ---> XML...

I think it would be much easier to create a DataStage job to perform this task. The job number would have to be a job parameter. You would also probably need a parameter (maybe the same one) to identify the job in your Oracle table(s).

You should be able to get it using

Get one of the Ascential dudes to present it. They do it regularly, and have practice at fielding the questions from left field.

If I were the author of the stage, I would see that behaviour as an entirely reasonable approach.