DSXchange

I suspect Narayana, along with your peers, was using "Sequencer" to mean "Job Sequence". But I do prefer to use correct terminology (pedantic? do a search for apostrophe!), even when Ascential's own manuals and training materials fail to do so! A Job Sequence, as Roy said, is a graphical user interf...

Use DataStage to create the data file then use BCP.

Bulk loaders will beat INSERT statements 10 times out of 10.

Provided that you are running with MetaStage proxy mode enabled and the listener is running, process metadata can automatically be captured by MetaStage. You can arrange for the captured data to be distributed from MetaStage. In an upcoming release, DataStage and MetaStage will share the same reposi...

You have not provided enough information. What kind of table is Table A? (That is, what brand of database?) What leads you to believe that the table (which table?) is locked? Have you checked with your DBA, who can inspect locks? What error/warning messages are being posted in the DataStage log? Do ...

A Sequencer, to be pedantic, is like a link collector in a Job Sequence.
Its output(s) can be triggered if Any, or only if All, of its inputs have been triggered. Any/All is the only configurable property of a Sequencer, apart from its name, size and position on the canvas, of course.

I'd be more inclined to use the UNIX tr command as a filter in a Sequential File stage, assuming that's what your source is. Use the tr class for characters in Control Set 0 (those with ASCII codes below 32) and translate them all to space or "". If you must do it in a Transformer stage, construct a...

Chances are that you haven't chosen the correct process initially. See my earlier post about child and parent processes. It's not as easy as using WMDs. You have to be very selective.

Using environment variables for passwords means that there's somewhere on your system where the password is stored in clear. Apart from that, there's no reason not to use environment variables if you want. However, here are several reasons that I'd tend still to use "proper" job parameters. Using a ...

Welcome aboard! :D There is a lot of useful information in DataStage error and warning messages, if people would only take the time to read and understand it all. For example, it will tell you in exactly which part of the job it found the problem. So please do post the detail of the message, so we h...

I think the only way to do it would be to call DSExecute to invoke the appropriate OrchAdmin command. DSExecute captures the output of the command, or the command could redirect output to a text file and the BASIC program read that.

If you read the entire error message, it also reports the stage about which it's complaining. This will help you to narrow down the culprit. Then open this stage (link, perhaps) and determine which User ID field has been left blank.

Masked hexadecimal. There's also "MO" (octal) and "MB" (binary). They're all in the online help - drill down from Iconv or Oconv topics. You can also use "MCXD" (masked character hex to decimal) and "MCDX" (masked character decimal to hex). They never ask this kind of stuff at trivia nights!

Make sure you always kill child processes before parent processes!

(I'm still uneasy about kill, even kill -14, and prefer UNLOCK.)

It's certainly worth a try.

You can set it for just that column; scroll to the right in the Columns grid of the Sequential File stage's Inputs tab Columns page to see how.

You can define a token and, based on whether that token is defined or not, conditionally compile the PRINT statement. In this way you can turn it on again when you need to test the next version. * Toggle between $DEFINE and $UNDEFINE to enable/disable test statements $UNDEFINE TESTING $IFDEF TESTING...