HP OpenVMS Systems

DCL Error Handling?

» close window

The Question is:

 
I am running SQl*LOADER and using the command procedure I wish to capture
the return code of SQL*LOADER. Based on the success or failure of the load I
intend to branch accordingly  in the procedure.
 
Thanks for your help.
 
Bimal Doshi
 
 

The Answer is :

 
  Please contact the organization that supports the tool for assistance
  with the return status values from the tool -- this tool is not provided
  by Compaq.
 
  In the general case, you can use the ON command in DCL, as well as the
  SET NOON command.
 
  The following will cause execution to be transfered to the DCL at "label"
  on incidence of a warning or more severe error:
 
    $ ON WARNING THEN GOTO label
 
  The following disables the usual exit that occurs on severe errors:
 
    $ SET NOON
 
  The symbols $SEVERITY and $STATUS contain the message severity level
  and the message status code from the last image that executed.
 
  For details on DCL error handling, please see the available OpenVMS DCL
  documentation, available books from DIGITAL Press, and see:
 
    http://www.openvms.digital.com:8000/
      72final/6489/6489pro_039.html#handle_err_sec
 

  

     

     
answer written or last revised on ( 18-AUG-1999 )
     
» close window