DSXchange

DSWaitForJob only waits for a running job to finish. If the job is not running, DSWaitForJob returns immediately. You need a different strategy.

There's little you can do - most of the Repostory tables are implemented using hashed files. All you can do is not to have too many jobs running at the same time (until T30FILE is increased).

Are you 100% certain that the metadata used in your job (on the output link from the OCI stage) matches that of the Oracle table? In particular, are you trying to select a NUMBER from a VARCHAR2 column?

LIST.READU is available on all platforms. It can also be executed from the operating system as list_readu (the executable is in $DSHOME/bin). On UNIX, you can pipe the output of list_readu through grep to isolate the lock entry for the job itself.

The uv -admin command executes $DSHOME/sample/ds.rc (on most systems the entries in /etc/rc2.d and so on are symbolic links to the script in sample). The difference is that uv -admin has more options available, which go off and do other things, for example uv -admin -version or uv -admin -info comma...

In a word: robustness.

Windows needs to be re-booted too frequently (in my opinion) to be considered in a production environment. UNIX rarely needs to be re-booted - primarily after upgrading of hardware or operating system.

There are other solutions too. Searching the site will find them.

Whatever you did to export the .PST file, wrap that in a BAT file and execute it from DataStage control (for example an Execute Command activity in a job sequence, or a before-job subroutine).

I think the best approach is pattern matching here. InLink.FirstCol Matches "0X'.IR'" : @VM : "0X'.P'" : @VM : "0X'.UN'" For the second, Count() is probably the most efficient. Index() is valid too, as is pattern matching. InLink.SecondColumn Matches "0X'EXCH'0X&qu...

Can you post precisely what the input file looks like, and the exact derivations of the stage variables and output columns used?

I have been unable to reproduce this on version 7.5.1 on Red Hat Linux.

Have all these executions used the same user ID? There is a "permission denied" message emitted - these don't just come and go.

Tell us how you've specified the sorting. It's this that the stage is complaining about. Post the generated OSH related to the Sort stage. Etiquette Note Don't push. This is an all-volunteer site; folks post as and when they can. The hour between your two posts were in the middle of the night where ...

The penalty is related to the need to translate data values from strongly typed in the C environment to untyped in the BASIC environment when invoking the BASIC run machine to execute the BASIC Transformer code, then the reverse translation when returning the row from that stage back into the C envi...

Similarly in DataStage. Your single output column is derived as

I think you want to convert "/" to "-" but you've asked to convert "-" to "/". But why not use SYSDATE ?

Convert() is valid as a function in a parallel Transformer stage.