Table count to a Parameter

mspanda · Post by **mspanda** » Mon Jul 09, 2007 11:51 pm

Hi,

How do I read a Db2 table record count into a job parameter in datastage?

Regards
Prasanna

ArndW · Post by **ArndW** » Tue Jul 10, 2007 12:14 am

One way is to execute the Db2 select clause from a command stage in a sequence, then pass the result as a parameter to a job. Sequences cannot read tables directly.

saikir · Post by **saikir** » Tue Jul 10, 2007 2:57 am

Hi,

An other possible way would be to read the records from the DB2 table, pass the output a transformer stage variable and call the job with the stage variable parameter

kduke · Post by **kduke** » Tue Jul 10, 2007 7:02 am

Write your count in one job to a sequetial file. Read the sequential file in a routine. Feed the parameter from an argument in the routine.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 10, 2007 12:21 pm

Or, to extend Kim's suggestion, use the job's user status area. There's no point using a parallel job to process just one row, and it's much easier to use a server job's user status area. The contents of the user status area are available downstream in the job sequence as an Activity variable called $UserStatus.