DSXchange

The short answer to the original question is that the Join stage supports more than two input links if required. They are called "Left", "Intermediate" and "Right" in the Input Link Ordering dialog. I believe that joins are performed pairwise, beginning from the left.

jdsmith575210 wrote:If you just have to have a favorite, try color. I prefer red over green.

Not in DataStage!!!

OK, the domain is IBM Information Server and its associated database, and the services exposed through a WebSphere Application Server. Technically the domain includes all of the Information Server products that are installed as well. The server, for DataStage purposes, is the server on which DataSta...

Read the DataStage BASIC manual about this function, and how the generator is seeded. You may need to create a before-stage subroutine to seed it off something variable like

The reference to VOC may be a complete "red herring". If there were a SH verb followed by a command with mismatched quotes, or containing the same quote character as the one with which the command were delimited, then this error might arise. If this is in your software, then you need to fi...

Possibly, and possibly not. If it stores the precision as character string, then one additional byte would be required ("12" versus "2"). If it stores the precision as an integer, then no change (both 12 and 2 can be stored as any kind of integer).

Have you checked that the diagnosis is accurate - that is, the database server itself is actually unavailable, or has too many connections?

I could, but that would also be a premium post. Until you get your premium membership why not Search DSXchange, where the technique has been discussed and fully described?

Is there a trigger or similar database object that might modify the date?

Make sure your statistics are up to date also - these can affect decisions made by the query optimizer (which gets involved when the SQL statement is prepared).

Preload a hashed file with at least keys from current records in target table, and use this to determine existence and, perhaps, change. In turn this will drive your insert/update decision. You can update the same hashed file from the same Transformer stage if your input stream is likely to contain ...

Do you perhaps mis-type (mis-spell or mis-case) the job name in dsjob commands? Job names are not recorded in VOC in any case, so we really do need to know the exact error message.

There should be no significant change in the Repository if you alter existing metadata. Of course, if you add columns (for example) then a small amount of additional storage would be needed for that, but bytes rather than kilobytes.

Template is not an editable project. I don't believe there is any way to change the default NLS setting - it is determined at installation time from the "language" of the operating system.

Congratulations on finding the answer yourself. Now please mark the topic Resolved using the green button at the top of the page.