Error in the Control, Please help

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Simba
Participant
Posts: 22
Joined: Wed Dec 03, 2003 6:12 pm

Error in the Control, Please help

Post by Simba »

Please see the below code,. The job has been aborted. Control not even passes to the first statement. I couldn't understand what is happening. Please suggest.

Thanks,

Code: Select all

$INCLUDE DSINCLUDE DSR_UVCONST.H
$INCLUDE DSINCLUDE DSR_COMCONST.H 
 
Call DSLogInfo("Start - ")     

      Open 'DS_JOBOBJECTS' To JobFile Else
         Call DSLogFatal("Error opening file - ")
      End
      Call DSLogInfo("Before Select - ")     
     
      Cmd = 'SELECT DS_JOBOBJECTS LIKE ...ROOT'
      Call DSLogInfo("Before - ")     

      Execute Cmd capturing output
      
      Call DSLogInfo("Before - ")     
      
       Loop 
        While Readnext id Do
         READ DsJobsRec from JobFile,id THEN
            category = DsJobsRec<42>
            Call DSLogInfo("Category ":category)
         END
      Repeat

      Call DSLogInfo("After - ")
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Read your BASIC manual for the DSLogFatal and DSLogInfo APIs. They take two arguments, you only have 1.

So, you're now reverse-engineering the DS_JOBOBJECTS repository file?

Also, what you are doing is a waste of time. If you want the folder of a job, you should just look at DS_JOBS. Attribute 5 has the folder for the job. 8)
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply