DSXchange

A Routine activity can only access a routine whose type is "transform function". This can have between one and 254 arguments. A before/after subroutine is intended to be invoked from job or active stage properties; it is never invoked directly from job control/job sequence. You can, of course, CALL ...

Is the database created without logging? If that's the case, when DataStage sends the COMMIT (after the triplet of UPDATE statements) Informix will reject it because there's no transaction log.

I'd still use a hashed file, even for four rows. Might even populate it with an INSERT statement in ExecTCL before-stage subroutine in this case.

Most databases allow CASE constructs in SELECT statements. You can put the entire construct in the Derivation field in the Columns grid (rather than use user-defined SQL).

And it's perfectly OK to put more than one command into the Command argument; separate them with semi-colon or && operators.

An alternative is to write your own after-job subroutine that executes the commands separately through DSExecute().

Because if the job sequence aborted it may not have had opportunity to update its runtime information (status, date/time, etc.).

Not possible in current versions. The reason for that is that DataStage is driven by the metadata. That is, you can not define derivations, constraints and the like without knowledge of the column names. "They" examined this possibility in the past (version 4?) with a solution of creating a job desi...

Please post the detail of the message (double-click on the event in Director log view). The detail includes the name of the stage from which the error was reported.

The ad on YouTube specifies October 2006, at least for the Information piece.

Can YOU please contribute less than $1 per week to help to fund this site?

Then you can see the premium posts.

Error code 2 means "file not found".
Either d:\Indata_Arch\68159.csv does not exist when the job runs, or you do not have sufficient access privilege to the directory to determine whether it exists.

In a server job the most efficient mechanism is to use a Hashed File stage servicing the reference input link of a Transformer stage.

The main factor to take into account is what other demands for memory occur on the system while you're using hashed file cache. A secondary factor is the row count and row size of the totality of hashed files thar you want to use each cache. Clearly with only 2GB of memory you would not set both cac...

Therefore, export DSHOME=`cat /.dshome` export PATH=PATH:${DSHOME}/bin should set the environment variable. If not, use DSHOME=`cat /.dshome` ; export DSHOME PATH=PATH:${DSHOME}/bin ; export PATH Once DSHOME has been set, the other commands mentioned earlier should work if you ar...

Therefore, export DSHOME=`cat /.dshome` export PATH=PATH:${DSHOME}/bin should set the environment variable. If not, use DSHOME=`cat /.dshome` ; export DSHOME PATH=PATH:${DSHOME}/bin ; export PATH Once DSHOME has been set, the other commands mentioned earlier should work if you ar...