Looping a Job on Windows

[Amit_111]

Hi All,

I have a DataStage job which needs to be executed 12 times with different set of parameters passed for each run.
I s there any way to loop this job for 12 times? If Yes, How can I do this?
I couldn't find any Start End Loop Activity in DS 6.0.

Thanks in Advance.

[saikir]

Hi,

The 6.x version of DataStage does not have any loop start and stop actvities. These stages have been incorporated in the sequencers from the 7.x version of DataStage

Sai

[saikir]

Hi,

The 6.x version of DataStage does not have any loop start and stop actvities. These stages have been incorporated in the sequencers from the 7.x version of DataStage

Sai

[ray.wurlod]

You can most easily accomplish this with a job control routine. Where do the twelve sets of parameter values come from? The following example assumes one set of parameter values per line in an input file.

Code: Select all

$IFNDEF JOBCONTROL.H
$INCLUDE DSINCLUDE JOBCONTROL.H
$ENDIF
$INCLUDE UNIVERSE.INCLUDE FILEINFO.H
DEFFUN OpenSequentialFile(FilePath,OpenMode,WriteMode,LogMode) Calling "DSU.OpenSequentialFile"

hFile = OpenSequentialFile(pathname, "R", "A", "Y")
If Fileinfo(hFile, FINFO$IS.FILEVAR)
Then

   For LineNo = 1 To 12

      ReadSeq Line From hFile Else Exit
      GoSub ParseParameters

      hJob = DSAttachJob("MyJob", DSJ.ERRNONE)

      ErrCode = DSSetParam(hJob, "Param1", Param1Value)
      ErrCode = DSSetParam(hJob, "Param2", Param2Value)

      ErrCode = DSRunJob(hJob, DSJ.RUNNORMAL)
      ErrCode = DSWaitForJob(hJob)

      JobStatus = DSGetJobInfo(hJob, DSJ.JOBSTATUS)
      Msg = "Iteration " : LineNo : " complete.  Job status = " : JobStatus
      If JobStatus = DSJS.RUNFAILED Or JobStatus = DSJS.CRASHED
         Then Call DSLogWarn(Msg, "JobControl")
         Else Call DSLogInfo(Msg, "JobControl")

      ErrCode = DSDetachJob

   Next LineNo

   CloseSeq hFile

End
Else

   Msg = "Can not open parameters file " : Quote(pathname) : " for reading."
   Call DSLogFatal(Msg, "Job control")

End

MainExit:
RETURN

ParseParameters:
* Here you parse out the parameter values from the line read from file.

Param1Value = Field(Line, ";", 1, 1)
Param2Value = Field(Line, ";", 2, 1)

RETURN

[Amit_111]

Hi Ray,

Actually I have a shell script which executes these jobs fine in Unix wherein I increament the Month by 1 and attach that month with all the Parameters by which all my parameters are updated with the latest.
But don't know how to do this in windows environment.

[Sreedhar]

Hi,

Within Windows env (MS DOS) we have some thing called as Batch programming, using that conver your unix logic into the Batch understandable code, that should solve your problem.


Regards,
Shree

[Amit_111]

From Where will I get to learn this batch programming.............Currently I dont have any knowledge in Batch programming

[chulett]

From a co-worker? Anyone there you could tap for help? They wouldn't need to know anything about DataStage to be able to help convert a script to a batch file.

[ray.wurlod]

Any Microsoft education center would probably be able to help you. There are lots of books out there, such as DOS For Dummies - it's not a DataStage problem that you want to learn batch programming.

You might also acquire a UNIX emulator, such as MKS Toolkit or CygWin, that would mean that you can run your UNIX scripts on a Windows operating system.

[Amit_111]

oooo........So you guys mean to say that all the DataStage commands such as dsjob -run etc. will work in batch files also. Only thing which will change is the syntax from Unix to windows Batch programming??

[chulett]

Yup. :D

[ray.wurlod]

The syntax of dsjob does not change at all

[Amit_111]

Thanks very much Guys....