DSXchange

Row Generator stage can generate as many 'Y' values as you desire.

You might find this recent tutorial on creating custom DataStage operators interesting. The screen shots are from version 8.0, but the content is valid at earlier releases, and it's for Windows rather than UNIX.

NLS is either globally enabled or globally disabled on a DataStage server. It is not possible to disable it on a project-specific basis. What is the value if NLSMODE in uvconfig? What is the result of the following UNIX command? $DSHOME/bin/analyze.shm -t | grep NLSMODE In the Administrator client, ...

UniVerse and UniData are database products, in the same way that Oracle, Sybase, Informix and DB2 are. You can gain more information here on the IBM website, since IBM has owned these two databases since 2001.

You missed Arnd's point. The operating system will only allow one process at a time to write to a file. Therefore if you want multi-instance, the job invocations must write to separate files.

To cite an older variant: "the floggings shall continue until morale improves".

There were no support staff at this particular training; just the (billable) consultants.

I imagine that support staff will get/have had their own training.

Have you redeployed the QualityStage job accessed by the plug-in stage?

Ah, the ever-hasty DSguruji!

You can slice of a piece of the mainframe and run UNIX Support Services (USS) there. DataStage can run on USS, and access mainframe data. You would need to check with IBM whether DataStage USS version can access CICS. It can certainly access IMS datasets and viewsets, and various other mainframe dat...

In the Administrator client, is the NLS button enabled when you select that project's properties? If so, that's where you choose the character map and locale that you want to serve as the defaults for the project.

That's news to me. So my sprintf(LineCount, "%d lines written.\n\n", lines); statement, which has worked for many years, isn't valid?

This could be a segment of the virtual Data Set that the Lookup stage is creating from the DB2 table. There are definitely upper limits on these. Remember that to use a normal lookup, the virtual Data Set must fit in memory. Consider using sparse lookup (if your data meet the guidelines) or using a ...

If they're in a table definition, why can't you simply Load them into your Pivot stage?

You still need to make sure you compare apples with apples. Performance test results such as these do not translate readily except into identical situations of hardware, software and data volumes. Having conducted benchmarks professionally for a number of years I can attest that you can construct a ...

The dsjob command line utility has an -import option in your version of DataStage.