DSXchange

Welcome aboard.

Is this in a server job or in a parallel job?

(You have posted in the server job forum but marked your job type as parallel.)

Just enclose your design in Code tags to produce "ASCII art":

If you do not specify sorting where sorting is required, DataStage will insert a tsort operator anyway, with default characteristics. This can be seen in the job score. You will probably end up with a sub-optimal solution.

The only version of DataStage capable of running parallel jobs on Windows is 7.5x2 (this is not the same as 7.5.2). You have installed some other version.

Choose Show Toolbar from the View menu.

OK, try running ulimit -a ; id from the before-job subroutine. The id command may yield a clue.

Are they three separate Data Sets, or do all three Data Set stages refer to the same Data Set, or some combination of those? You really should enclose job designs in Code tags, so we can tell where the links connect. I'm guessing that all three Data Sets are reference inputs to the Lookup stage. Wer...

At the very least for testing/diagnostic purposes, yes.

Unless you have a magic wand that you can use to magick away all the errors without doing any investigation. I don't.

The "/usr/vacpp/bin/xlC_r: not found" error message suggests that your APT_COMPILER and APT_LINKER environment variables need to be set to the actual location where your C++ compiler is installed.

Welcome aboard sumanv.

Your suggestion will not work, because karry450 connects to a UNIX server. "Omit" can only work when the DataStage server is installed on a Windows operating system. Read the Help for the connection screen to learn more.

Possibly. You don't get very many columns in the report.

Define "performance" in an ETL context.

Rows/sec is almost totally meaningless as a metric of ETL performance, as I will tell anyone who'll listen.

That would violate licensing agreement. You must obtain through your support provider.

OpenSeq takes its Else clause (and returns 0 through Status() function) if the file is opened but does not yet exist. You have not coded for this possibility. Search the forum for a function called OpenSequentialFile() which covers all the possibliities.