ADDPFCST (Add Physical File Constraint) syntax diagram


Job: B,I Pgm: B,I REXX: B,I Exec
Threadsafe: Conditional; see Restrictions 
                    .-*LIBL/--------.
>>-ADDPFCST--FILE(--+---------------+--physical-file--)--------->
                    +-*CURLIB/------+
                    '-library-name/-'
 
>--TYPE(--+-*REFCST-+--)---------------------------------------->
          +-*UNQCST-+
          +-*PRIKEY-+
          '-*CHKCST-'
 
              .-----------------.
        (1)   V            (2)  |    (3)
>--KEY(---------field-name------+--)---------------------------->
 
>--+------------------------------+----------------------------->
   |       .-*GEN------------.    |
   '-CST(--+-constraint-name-+--)-'
 
>--+---------------------------------------------+-------------->
   |          (4)   .-*LIBL/---.                 |
   '-PRNFILE(-------+----------+--parent-file--)-'
                    +-*CURLIB/-+
                    '-library/-'
 
>--+------------------------------------------+----------------->
   |               .-*PRNFILE------------.    |
   |               | .-----------------. |    |
   |         (4)   | V            (2)  | |    |
   '-PRNKEY(-------+---field-name------+-+--)-'
 
>--+---------------------------------+-------------------------->
   |          (4)   .-*NOACTION-.    |
   '-DLTRULE(-------+-*RESTRICT-+--)-'
                    +-*CASCADE--+
                    +-*SETNULL--+
                    '-*SETDFT---'
 
>--+---------------------------------+-------------------------->
   |          (4)   .-*NOACTION-.    |
   '-UPDRULE(-------+-*RESTRICT-+--)-'
 
>--+------------------------------------------------+----------><
   |         (5)                                    |
   '-CHKCST(-------'check-constraint-expression'--)-'

Notes:

  1. This parameter is required for TYPE(*REFCST), TYPE(*UNQCST) or TYPE(*PRIKEY).

  2. A maximum of 120 repetitions.

  3. All parameters preceding this point can be specified in positional form.

  4. This parameter is required when TYPE(*REFCST) is specified.

  5. This parameter is required when TYPE(*CHKCST) is specified.