DSXchange

Any chance of sharing?

Thank you for sharing that.

Can you please expand on exactly what you mean, and how you want to design to achieve your goals. What is "stale" mode? In a separate table? Are the records in your tables timestamped? If not, how do you propose to identify "1 year data"?

In the uvconfig file there is a directory whose pathname is recorded as UVTEMP. You can remove any files from here that are owned by a DataStage process, provided the DataStage process is no longer running. You can purge most entries from &PH& in each project, particularly the older ones. If...

I believe the routine needs four separate loops - for single, two-level, three-level and four-level combinations. But I haven't given it a lot of help. Probably nested counted (for..next) loops would work.

You did not mention originally that you are using a QualityStage plug-in stage from DataStage. Otherwise I would have asked you to check qsrtmngr as well as qsserv processes. For this combination to work, the qsrtmngr process must be running. If you like, qsrtmngr is the "listener" - like a real-tim...

Should there really be four rows 29?

That's probably right. You're used to seeing XA for master, DA for duplicate and RA for residual from a single file (UNDUP) match. The A means "first file". Now you also see B, meaning "second file", the other file in a two file match (MATCH for one-to-one, GEOMATCH for many-to-one). This A and B co...

Create a DataStage job or routine that can dump the contents of a job log into somewhere else - a text file, perhaps. This will allow you to use larger numbers than integers. This job or routine could also purge the job log, but there are implications in that the control records' values also need to...

This would be Oracle bin Larry to whom you're referring as "Ellison"?

There is/was an Ascential class called Programming with DataStage BASIC

<AD>I have also prepared material (for sale) on writing routines - please contact me off line for details</AD>

Search also for OpenSequentialFile - it's a re-usable routine that, among other things, will position to end of file. It also handles all possible "bad" conditions.

A [rejects] link processes any row that has not been output on any earlier-executed output link. Read that statement carefully. What it means is that the reject link will not capture any row that fails to be put onto any subsequently executed output link. It also means that a second [rejects] link w...

You are paying good money for "maintenance" to your support provider. They may as well earn some of it!

What happens if you install a new client on an entirely new (never had DataStage installed) PC?

If it happens there as well, it suggests that there's some difficulty with how the data are being presented from the server.

If you are on an earlier version than 7.5, you can call the UtilityRunJob routine from within a Transformer stage in the job that is processing the ten rows.