DSXchange

And the ever-hasty DSguruji has posted a routine with imbalanced routine code. There is one End statement missing. Also, there's probably no need to compare the arguments twice. Ans = "NULL" If (Arg1 <> Arg2) Then If (Index(Arg1, "NETWORKING_EXCHANGE", 1) >= 1...

The .developer.adm file in the project simply stores what you specify in the Administrator client. It contains a list of those operating system groups that you have allocated to the Developer role. There are similar .*.adm files for the Operator and Production Manager roles. The files should be writ...

Arnd has govered the gamut of approaches.

I'd be asking "them" why the COBOL file definition does not match the COBOL file.

If you are 100% certain that you will deliver good data, you can drop indexes and constraints on the fact table and rebuild them afterwards.

I assume you are already using bulk loader technology; if not, do so, as it's way faster than SQL inserts.

That looks more like LD_LIBRARY_PATH than APT_COMPILER. If it's really APT_COMPILER (which should be the pathname of a CC compiler executable followed by some command line executables) then your system is severly horked, to borrow one of Craig's words.

There is no ODBC stage for mainframe jobs. You use a Relational stage to access your DB2 data on the mainframe. DCLGen is simply one way of representing metadata; you can import the table definition into DataStage from a DCLGen.

What makes you so sure that the job is still running? What Director's status view is reporting is the last time the job reported its status back to the status table. If it had been killed without the opportunity to update the status table, there's no way that the Director can read any other status t...

sreelalpp wrote:Can I conclude that Merge can NOT be used to do the same functionality of Lookup if it contains duplicates in the merge key from the master ?

Yes

7.5x2 is the only Windows supported in Datastage as of now. What kumar_s has tried to indicate is that, while other versions can be used to create parallel jobs on Windows platforms, only version 7.5x2 (which is not the same thing as version 7.5.2) can be used to run jobs. View Data actually create...

Yes

I assume you're referring here to the terms used in the Expression Editor's operands menu. A routine is a separately compiled, stand-alone piece of DataStage BASIC code that is stored in the Routines branch of the Repository. A transform is a DataStage BASIC expression, not separately compiled, that...

You will find a link to an IsValid() function here

Stop thinking like a server job developer. Give some thought to how you might construct a sequence that is unique over all partitions, apart from the simple-minded approach of sequential execution of the generator. Hint: you will need to include the partition number and partition count in your calcu...