DSXchange

There's bound to be. Create more queues, and be selective what you write into them via the logic of your job.

A configurable ETL engine is an ETL engine that can be configured. DataStage can be configured in a number of different ways, including uvconfig, dsenv, osh configuration file, and so on. It is, therefore, by any reasonable definition, a configurable ETL engine. Some stages allow a schema file to de...

Sleep ?????

Then my original response ("probably not") remains.

Beware that not all databases (particularly Oracle) like receiving "" and will convert the same to NULL.

I don't have access to enterprise edition at the moment. Does the ODBC Enterprise stage have another write mode? Something like "Write" or "Direct"? Please start a separate thread for the merge failure. This will assist future searchers. Don't forget to supply as much information as possible, in par...

What is the functionality of DSLinkRowcount...? It reports the number of rows processed on a link. The macro is defined as DSGetLinkInfo(DSJ.ME,DSJ.ME,DSJ.ME,DSJ.LINKROWCOUNT) plz provide the equivalent of DSLinkRowcount macro in parallel..?? There isn't one. You would normally use this macro/funct...

I don't think that's it, Arnd. The command is a perfectly valid DataStage/SQL statement. Unless you know something about this particular project. In any case, it's the "on-the-fly" testbed program that's throwing the improper data type error, not the routine itself. This is one you will need to repo...

To use an after-stage subroutine, rather than a before-job subroutine, would make more sense. I would use a separate activity, or even two, in a job sequence to detect the zero row count and to send the email. These would, of course, be executed after the job in question, though possibly in the same...

Due to performance issues, we have to avoid using unix-scripting/routine for this purpose. Who said? Ask someone who knows what they're talking about. You ultimately have to execute a single UNIX mv command, irrespective of where you do it. As Craig said, there is no "performance issue". Indeed, th...

Nothing new in the server job world.

Issue both CLEAR.FILE commands adjacently in the Administrator client Command window. Then select both commands from the history pane and click Save. You will be prompted for a name under which to save, I suggest something meaningful like CLEAR_TWO_HASHED_FILES. Then, in your job, execute CLEAR_TWO_...

What stage type are you using? If an Enterprise stage, what write mode are you using? Have you considered writing to a text file (or an FTP stage) and loading the SQL Server table using the bulk loading utility?

The "not enough space" is in /u04/tmp.

Use ExecUV as a before-job subroutine. Execute a CLEAR.FILE command to clear all records from the hashed file. Change your Hashed File stages so that they do not delete before writing. If you have created the hashed file in a directory you will need to create a VOC pointer to it using a SETFILE comm...