Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Result of the administration statements

In interactive mode status messages and error messages are sent to SYSOUT and SYSLST, and in batch mode to the console and SYSLST.

In addition, the message number of the last response of the DBH or SESDCN to an administration statement is recorded in an S variable and in a job variable. This permits automatic administration with SESADM.

The  S variable is called SESADM-RESULT. It has to be declared within the SDF procedure beforehand.

The (temporary) job variable is called #SESAM.SESADM.JV.

The following contents are possible for successful statements:

  • SES7215 (DBH), SEN2014 (SESDCN) for “successful information output”

  • SES7290 (DBH), SEN2051 (SESDCN) for “successful administration statement without information output”

The message number of the related error message is output for unsuccessful statements.

If no response exists, blanks are written to the S variable and job variable. The S variable or job variable is not supplied with values if SESADM cannot generate or supply them.

You should delete the content of the S variable or job variable before entering an administration statement as in some cases (e.g. syntax error is detected by SDF) SESAM/SQL is not assigned control and the content of the S variable/job variable remains unchanged.