DSXchange

here is some more information reg. the node number clause: When we pull from a partitioned table, we use the nodenumber function and current node option in DB2: The partitioning table option tells DataStage to retrieve the data in parallel, but if you do not include the noe number clause in your wh...

Sainath.Srinivasan,

It is Datastage nodes..

Hi All,

I need information on how to use the Node number in SQL queries running in the DB2 Enterprise stages of ETL Data Stage jobs when we pull data from a partitioned table (DB2 table).

TIA,
Sri

changming, I think way will work. I will try that out.

ray, I did't get what trim @FM means, please explain.

Hi, 1 2 3 4 Filename="test.dat" 5 Jobname="testjob" 6 scriptsdir="/usr/testdir" 7 scriptname="amt.ksh" 8 commd="ksh":" ":scriptsdir:"/":scriptname:" ":Filename:" ":Jobname:" ":"outputfile.dat&quo...

Hi, I have a After job subroutine which calls a UNIX script using DSExecute function and the script returns a decimal value. I want to add this output value to another variable. The problem is iam unable to add them, as the value in Ouput value type is nonnumeric and this can't be added to numeric v...

Hi,

I want to call a unix script with 2 parameters in a After job Sub Routine.
How can i do that?


Thanks,
Srilaxmi