to read record from datastage log tables

s_porkalai · Post by **s_porkalai** » Tue Aug 07, 2007 12:55 am

My requirement is to get the statisttics of the records like no of records successfully inserted into target and get failed from the datastage log tables
how can i get the data from the datastage log tables[/code]

ray.wurlod · Post by **ray.wurlod** » Tue Aug 07, 2007 1:46 am

In an after-job subroutine use DataStage API functions such as DSGetLogSummary(), DSGetNewestLogId() and DSGetLogEntry().

s_porkalai · Post by **s_porkalai** » Tue Aug 07, 2007 2:57 am

is there any way to get the status(or to read datastage log/status tables) during job run

kduke · Post by **kduke** » Tue Aug 07, 2007 5:29 am

This is one of the jobs included in EtlStats.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 07, 2007 6:00 am

During a job run the job status is always Running. In an after-job subroutine you can interrogate the "interim status" - the status with which the job will finish if the after-job subroutine returns normally.

aakashahuja · Post by **aakashahuja** » Tue Aug 07, 2007 6:21 am

Y9u can use the dsjob command to get any info while the job is running. but you will have to use this from out of the job after you start execution. the status as Ray mentioned, will be 'Running', but at least you can loop around the accumulated logs.