DBA > Job Interview Questions > Virtual Storage Access Method (VSAM) Interview Questions

Syntax of AMS modal commands ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Syntax of AMS modal commands ?

Note; these can be used only under IDCAMS and not from the TSO prompt.
IF LASTCC (or MAXCC) > (or <,=etc...) value -
THEN-
DO-
command set (such as DELETE, DEFINE etc...)
ELSE -
DO -
command set

LASTCC - Condition code from the last function (such as delete ) executed
MAXCC - Max condition code that was returned by any of the prev functions

SET is also a valid AMS command. SET LASTCC (or MAXCC )= value
The maximum condition code is 16. A condition code of 4 indicates a warning. A condition code of 8 is usually encountered on a DELETE of a dataset that is not present.

(Continued on next question...)

Other Job Interview Questions