DSXchange

Hi i am using only one routine activity in Job Sequence which calls the server routine to get LINKROWCOUNT information $INCLUDE DSINCLUDE JOBCONTROL.H handle = DSAttachJob(argJobName,DSJ.ERRFATAL) NumRows = DSGetLinkInfo(handle, argActiveStageName, argLinkName, DSJ.LINKROWCOUNT) If NumRows < 0 Then ...

What about the source and target details?Is it a flat file or database etc?

In our project we are using various generic Jobs,reusable components like server routine,parallel Jobs.Thease are very reusable components for any Project.In future I am not sure which Datastage version i am going to work.Is there any way to export these components so that these components can be im...

Form the dssearch comand for one Job and replace the job name.Use loop activity in datastage or loop concepts in unix to replace the Job name

@ArndW

Thanks for your Input.Now the routine is working fine.The problem is Database server password is expired.

I think this link will help you

http://www.isecor.com/drupal6/node/163

Hi I am using below routine to load audit details for JOb in ETL_JOB_DETAIL. $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE UNIVERSE.INCLUDE ODBC.H Deffun RtnRunSqlDo(A,B,C,D,F) Calling "DSU.RtnRunSqlDo" Equate RoutineName To "SequenceStart" JobName = Arg1 ; JobHandle = DSAttachJob(Job...

HI All, I am using below code to find the Job type which is not developed by me.I understood the code except the thing highlighted in bold letters? $INCLUDE DSINCLUDE JOBCONTROL.H handle=DSAttachJob (Arg1,DSJ.ERRFATAL) if handle <> 0 Then jobName=DSGetJobInfo(handle,DSJ.JOBNAME) jobStatus=DSGetJobIn...

@Ray thanks for reply.

Is there any wat ti identify the function whether it is C language API or DataStage BASIC?

1)When I gone through the manual the second argument for the function DSRunJob must be one ofthese three values. a)DSJ_RUNNORMAL b)DSJ_RUNRESET c)DSJ_RUNVALIDATE But in this link for DSRunJob function they used DSJ.RUNNORMAL for secong argument. Can anybody explain what is meant by DSJ.RUNNORMAL?

If u have not done any changes in the sequence no need to compile it.

Please correct me if i am wrong?

I Updated state file value with 100.Then i am using below JOb sequentialfile---->surrogateKeystage-->sequentialfileoutput o/p I am getting col1,col2,col3 "5","e","101" "1","a","1101" "6","f","2101" "4"...

@DS_SUPPORT

Thanks for your Input

I developed a server routine which will return a value. I want to pass that value to a parameter in the Job in the Job sequence.I Know I have to use routine activity but i do not Know how to proceed furthur?

I am documenting my Datastage jobs present in my project.Can i know any easier way to get the following informations 1)I want to know all the tables used in an sql script/parallel job which inturn is called using a datastage sequence. 2) I want to know the sequences which use a particular table.Agai...