DSXchange

Not possible in version 7 unless you want to give all users read access. It's done through operating system permissions. This user would not be a member of the group who develop in the project (and therefore have full access), so you need to grant read permission to "others". In version 8 you can as...

It is the default behaviour of DataStage to log the actual command executed by an Execute Command activity.

If you want to change this behaviour, encapsulate your command in a routine and invoke that through a Routine activity.

Because DataStage writes it there if it's an ExecXXX subroutine.

Of couse, if writing from job control, one can determine exactly what to include in your DSLogInfo() and DSLogWarn() calls.

You can prove that it's the extraction that's at fault. Put a constraint of @FALSE on the Transformer stage, so that your job only does the extraction. After that you can figure out whether there is any way to improve the query, perhaps by indexing any column in a WHERE clause. How long does it take...

An environment variable governs transaction size. A search will find its name for you.

You need one Specification per field.

Use an after job subroutine to replace the password in the log. Most error handling has been omitted from the example below for clarity. SUBROUTINE HideLogPassword(InputArg,ErrorCode) $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF * Get job information JobName = Field(DSGetJ...

Fiddling with the Sequential File stage will not impact the extraction performance. Find out why the extraction is slow. For example does it include a correlated subquery, or sorting, or extract from a huge view that has to be materialized before any rows can be delivered?

There is no practical maximum length. But if you try to concatenate a NULL, then everything after that is NULL.

The directory of the hashed file; that is, the directory that contains the DATA.30 file.

For someone sufficiently pedantic, the correct answer is 11.

AmeyJoshi, why do you discard stderr from the dsjob command? I would expect to have this information available in the event of failure.

1) This week DataStage is called IBM InfoSphere DataStage. It is one of a number of products that run on IBM Information Server. 2) Version 8.0 is a differently architected product that provides all of the functionality of version 7.5 and more (except Version Control, which began life as a third par...

Alas, you have to play the game by its rules if you don't want the warnings.

What's the value of DSJ.JOBLASTTIMESTAMP in an after-job subroutine?