Abort Job While No rows in Source File

[Rubu]

Hi


Job1. Load Data To Sequential File S1

Job2. S1-------->Target

While running job Job2, I want to check the source file S1 for data. If there is no row in the file I want to exit the job with Status Success. How it can be done? Please suggest.

Regards
rubu

[Sainath.Srinivasan]

Why do you need that? That is the default behaviour of datastage.

[chulett]

In other words, there is absolutely no problem with processing an 'empty' sequential file. The job will simply process zero records and then declare everything good, green and A-Ok.

You problem will come in if the file does not exist. That will cause the job to abort.

[ray.wurlod]

Add job control code (job properties dialog) to perform the check and issue a DSStopJob(DSJ.ME) request. Job control code, if present, is executed before any stage is opened.

Code: Select all

FileName = DSGetParamInfo(DSJ.ME, "FileName", DSJ.PARAMVALUE)
If FileName < 0
Then
   Call DSLogFatal("Unable to get FileName job parameter value", "Job control")
End
Else
   Command = "wc -l " : FileName
   Call DSExecute("UNIX", Command, Result, ExitStatus)
   If ExitStatus = 0
   Then
      If Oconv(Result, "MCN") = 0
      Then
         Call DSLogInfo("Job stopped because input file empty.", "Job control")
         ErrCode = DSStopJob(DSJ.ME)
      End
   End
   Else
      Call DSLogWarn("Error in wc command: " : @FM : Result, "Job control")
      ErrCode = DSStopJob(DSJ.ME)
   End
End

[Rubu]

Thanks Ray.....