DSXchange

Hi Team, I'm using below query to get source stage and target stage,but its returning deuplicates: QUERY: SELECT A.NAME AS JOB_NAME, B.NAME AS SRC_STAGE, C.NAME AS TGT_STAGE FROM DS_JOBS A, DS_JOBOBJECTS B, DS_JOBOBJECTS C WHERE A.JOBNO=B.OBJIDNO AND B.OLETYPE LIKE'%Stage%' AND B.NAME LIKE'SRC%' AND...

Thanks ray,

Will try EVAL expression.

Hi, I'm using below query in universe stage in a server job and facing below error in view data. QUERY: SELECT A.NAME AS JOB_NAME, CASE WHEN A.JOBNO=B.OBJIDNO AND B.OLETYPE LIKE'%Stage%' AND B.NAME LIKE'Src%' THEN B.NAME END AS SRC_STAGE_NAME, CASE WHEN A.JOBNO=B.OBJIDNO AND B.OLETYPE LIKE'%Stage%' ...

Hi I have a set of parallel jobs and i need to get the count(*) from table that has used in target stage of each job,that count need to be captured in a server job which will load audit table.Is there any way to get the database name and table name and to run the sql queries to get the count capture...

Thanks Jerome,

It worked.

Hi Chulett,

I'm using datatstage 8.7 Version.

Can u briefly explain how to get source and target count using DSGetLinkInfo(),since this function by default returning outgoing link count for a particular stage.

But i need incoming count for a particular stage.

while querying the data from ds_jobs and ds_jobobjects tables,i'm getting entire list of jobs from the project.

I need to restrict that to a specific folder,please help with a query

Thanks Prasson,

Can you also tell where can i run these queries and i need to capture the reults in a table.

can i run below query in Universe stage or is there any separate stage to access or query the operation console tables.

Please elaborate.

Hi,

I need to retrieve the job details specific to a particular folder within my datastage project,i'm using ds_jobs,ds_jobobjects tables for querying.

Please help.

Is there any other option available ,since i can't hardcode the penultimate stage manually as there are more no.of jobs and also my src and tgt stage names are identical for all jobs ie.., src stage name starts with SRC and target with TGT. so it would be more flexible ,if i can use TGT stage to get...

Hi, I need to get the link count for source and target for my jobs,i'm able to get source count using DSGetLinkInfo,since DSGetLinkInfo will always return the outgoing link count for a particular stage,its giving target stage count as 0 as target stage is last stage in my job. source count is the ou...

Hi, I am facing a compilation error in transofrmer stage in my server job,where in i have used a simple routine to get the link name by passing job name and stage name as arguments,below is the code and error msg: Routine: $include DSINCLUDE JOBCONTROL.H JOBHANDLE=DSAttachJob(JOBNAME,DSJ.ERRFATAL) A...

Thanks,

Now its working

Hi, I'm using a server routine to get the count,below is the code. $include DSINCLUDE JOBCONTROL.H JOBHANDLE=DSAttachJob(JOBNAME,DSJ.ERRFATAL) Ans:=DSGetLinkInfo(JOBNAME,STAGENAME,LINKNAME,DSJ.LINKROWCOUNT) But i'm getting count always -1 ,though i could see the count passing through the link. Pleas...

Hi, I have total ten datastage parallel jobs and i need to capture each job src extraction count and target loading count and load it into audit table. And the audit table looks like jobname link_name source_count target_count Assume that src and tgt link names are same for all jobs. I have heard ab...