DSXchange

Use @DATE system variable (which is set to the date that the job started) or call the Date() function (which returns "now"). Depending on which stage type you are using to load the target table, you may need to apply an Oconv() function to format the date appropriately.

Try Search - you are not the first to want to do this. The OCI 8 Load stage simply invokes sqlldr so please check whether you have automatic execution disabled. Find out from whoever created the job why it is set as it is before attempting to change anything - this reason really should be documented...

If there are multiple matches how can you call it a master table? Please take the time to write out a specification (in English, not in "DataStage") about what the rules are. What is your source, where is the master table, on what basis do you match your source records, what (precisely) do you mean ...

Certainly. But first you tell us what the resource consumption per operator per node is of each of your jobs. There are environment variables that you can enable to record this information (at least CPU and memory). After that it's largely a simple supply-and-demand problem.

A VLIST of the DSAttachODBCDriver() function shows that it quite simply checks the licensing. I suspect there's something more - involving the QEWSD entry - but am not prepared to go public with that.

If there are only three (or few) distinct values in the column, Switch stage. If you're reading in sequential mode from Teradata consider using a three-node configuration file and a modulus partitioning algortihm. You may need to map the three values to integers using a Modify stage. Hash partitioni...

Did you re-compile after making it a multi-instance job?

An after job subroutine can be set to executed only if the job completes successfully. Use ExecDOS as such an after-job subroutine to execute an approprate DEL command.

There's an obvious problem with SHARAD23's answer, and it is that U did not ask the question. It was asked by srn2006.

In English, the second person personal pronoun is spelled "you".

Search is your friend. This has been discussed here on DSXchange, links to the IBM certification website have been provided, others' experiences have been discussed, and there are also links to blogs about certification. Note, however, that IBM does NOT offer certification for server edition.

Verry interresting, as someone on Laugh In was wont to exclaim. I've used source on Linux, Solaris and AIX. Useful to know. I wonder if you could create an alias for the . command on HP-UX?

DSAttachODBCDriver() function is not documented in the DataStage BASIC manual nor anywhere else that I can find. Do you have any more information about it?

I will reply off-line about QEWSD (or at least my understanding of it).

There is a virtual Data Set associated with every link in your design; you'd not be introducing one. At version 7.5.2 (maybe even 7.5.1) the Transformer stage has been heavily re-worked - it basically generates an operator these days, and most of the warnings about preferring not to use it belong in...

source is the long form of . for executing shell scripts.

See man source for more information.

Welcome aboard. Do you have cookies disabled? Are you using Internet Explorer version 6 or later? (Word is that other browsers do not work, but that IBM is working on them. Also, even if you are using IE6, do you have any service packs installed? While I'm at it, is this on Windows XP and, if so, wh...