DSXchange

Welcome aboard. :D Each enterprise establishes its own naming conventions. You need to find out from whoever is employing you what they are. Some practitioners have their own, which they tend to use on "greenfields" engagements and when their client appears not to have any conventions in place.

Just set the "Lookup Failed" rule to "Fail", which is its default value.

There is no DataStage limit to the number of instances of a multi-instance job that can be running at the same time, provided each has a unique invocation ID. There obviously are resource limitations. When you include any inter-process communication into the mix, then there seems to be some kind of ...

Does your Lookup stage have two inputs?

Is it possible to call them from version 7? If so, then the answer to your question is "yes, using the same technique". A marketing answer is also "yes", provided you are using EE MVS edition (in which DataStage has generated COBOL source code that you compile and run on your mainframe). What are yo...

Can you connect to Netezza using DS_CONNECT test utility?

The workaround was not to partition the inputs to the Funnel stage (but, perhaps, to do it upstream of there).

Fair enough - obviously jmckeever's site doesn't use server jobs. CCustomInput and CCustomOutput are generic names for plug-in stage types, so that might be an issue for you. You should find most, if not all, of the class types in the DSR_ESPROPS.H header file in DSINCLUDE directory in your project.

I don't believe g++ and AIX is a valid combination. I understand that you must use the XLC compiler on AIX. (But I would be happy to be corrected.)

I believe the third number is run mode - 1=normal, 2=validate, 3=reset.

Investigate the Fold() function. Fold your string into 3, make sure that the delimiter is @FM, and simply write the string into a single VarChar field with delimiter set to 000 and quote character set to 000.

What do you want to replace them with? Use a Convert() function.

I have been handed over around 30 odd jobs for performance improvement. Why? Are you a performance improvement specialist? If so, are your services for hire? I don't think there's much there that you'll be able to do - column names are not dynamic in server jobs, hence the need for separate jobs (o...

I did ask Ascential this question once, but they claimed it was proprietary knowledge and refused to tell me.

Just because Oracle does it doesn't make it a standard. AL32UTF8 is - to my mind - Oracle being precious (I think it stands for American/ASCII Language 32-bit Unicode Transformation Format 8-bit, which the rest of the world knows as UTF-8). That said, there is more than one eight-bit encoding for Un...