DSXchange

The Merge stage in server jobs is specifically designed to join two sequential files.

A running DataStage job is simply another Oracle client application. It will either be doing inserts/updates, or will invoke sqlldr. Tune these as you would for any other client application. Beware that some DataStage developers will try to create 10 million row transactions, so make sure you have s...

It was deprecated in version 5.2. It dumps metadata into an ODBC database - scripts are provided in the directory for creating the requisite tables in Oracle, SQL Server, etc. It does not handle parallel jobs, it does not handle job sequences, and it needs a patch even to be able to handle server jo...

We need to do a pre validation and post-validation of source data before it is really processed by datastage jobs. Why? What benefit will accrue? Are you just recording this information, or truly validating? What happens if a row in the file does not meet the specifications? What happens after that?

I doubt that they'll do this, since the philosophy in parallel jobs is "one stage, one task". Certainly there are no plans to include lookup capability in the Transformer stage. But, hey, if you don't ask it will definitely never happen.

If everything you say is true it's a mystery. Double check everything.

You have to be a Moderator. Roy is the moderator for this forum.

You could simply have right clicked on the link and chosen Convert to Reference then on the other and chosen Convert to Stream.

DataStage can not read your mind!

Well, just phone the generic toll free IBM number - they're pretty helpful folks in my experience.

You should get both client and server. At the top it gives the client version. Here it's DataStage Designer version 7.5.1.A Then there's the copyright notices. In a frame at the bottom of the message box is the following text: Attached to project 'RFUR' on host 'dsprodsvr02' server version 7.5.1.A. ...

Activity variables (such as $UserStatus) are only accessible in job sequences. You can use it to provide a parameter value to a job parameter in a Job activity. You can not access it directly within the job itself.

As a first step - what I did when learning the Modify stage - create a spreadsheet or some other table with three columns. Result - the data type produced by the function Specification - syntax of the function Notes - any additional information Examples date date_from_days_since[date](int32)...

It IS warnings queued. You should test with ten rows, not ten crore!

Contact your account rep - the dude who makes money every time your maintenance is renewed - and have him/her earn some of it by determining your correct support contact/channel.

A much easier routine would be one that reported (true/false) whether it was the third or last Friday in the month.