DSXchange

Close, but no cigar. What do you want to do with the time portion?

Convert() is slightly more efficient than Change(), or you can use multiple conversion.

The lock is only set if the lookup fails. It "expects" that that key is about to be written. Just good database practice; prevents lost updates.

I don't believe that DataStage uses the NLS_LANG environment variable at all, but am happy to be proven wrong. I know you can't access Oracle data without NLS_LANG set, presumably other databases have a similar issue. Some also require LANG or LANG_C also to be set.

COMO stays on because the COMO file name is recorded in the printer shared memory segment for the agent process (dsapi_slave) associated with the connected Administrator client. I actually prefer DIVERT.OUT to COMO command, since it doesn't restrict you to the &COMO& sub-directory, and lets ...

One thing that's not totally clear (unless you read the entire manual entry) is that you place one -param option for each parameter (not one -param option for the entire command). You can have as many -param options as you require.

No. The stage picks up its source from stdout of whatever command is executed. There ought to be no file involved (unless, as I did, you employ a shell script).

Welcome aboard! :D Things like this don't "just happen" - something has been changed, probably on the PC. Let us know what was changed, and we may be able to offer more targeted advice. For example, was a new service pack applied? What exactly is the operating system on the client? Can you select th...

If you don't know it probably isn't relevant. EBCDIC and ASCII are two different ways (encodings) for representing characters in computers.

The burning question is: does the UniData table contain multivalued KEY columns? I don't believe the UniData stage can cope with these out of the box. There are configuration parameters that can affect this behaviour.

In server jobs you use the Transformer stage with one stream input link and other reference input links. The stream input link is delivered a stream of rows from one data source (some joins may have been performed there). Each reference input link connects to another data source and is provided with...

Welcome aboard! :D

There are many ways to do this. Explore your repository - you will find there a routine called something like "sendmail tester". You can adapt this to your requirements quite easily.

cron and at are free. They're part of UNIX. That's the only advantage. Other than that it really doesn't matter. A third-party scheduler may fit the enterprise's other scheduling requirements better, but it's not an issue for DataStage.

Disabled, lock for updates.

This sets a record level update lock if the key is not found, on the assumption that you're going to write that key into the hashed file.

Use ExecDOS if on a Windows platform. If you're writing for an unknown platform, then you would be better to create your own before/after subroutine. SUBROUTINE ExecOS(InputArg, ErrorCode) * Test whether operating system is Windows or UNIX using System(91). * Command variable include...

There are many possible answers. Possibly the simplest is to interpose an Execute Command activity to invoke the test -z filename command. Thanks for suggesting a solution, we are unble to find where to execute this command? and what value does this command retuns? and after returning the value how...