---

 

CRTTBL (Create Table) syntax diagram

Job: B,I Pgm: B,I REXX: B,I Exec

Threadsafe: No

                 .-*CURLIB/------.
>>-CRTTBL--TBL(--+---------------+--table-name--)--------------->
                 '-library-name/-'
 
>--+----------------------------------------------------------+-->
   |             .-*LIBL/--------.  .-QTBLSRC----------.      |
   '-SRCFILE(--+-+---------------+--+-source-file-name-+-+--)-'
               | +-*CURLIB/------+                       |
               | '-library-name/-'                       |
               |         (1)                             |
               '-*PROMPT---------------------------------'
 
                                                    (3)
>--+----------------------------------------------+------------->
   |         (2)   .-*TBL--------------------.    |
   '-SRCMBR(-------+-source-file-member-name-+--)-'
 
>--+-----------------------------+------------------------------>
   |           .-*CVT-------.    |
   '-TBLTYPE(--+-*SRTSEQ----+--)-'
               '-*UCSSRTSEQ-'
 
>--+-----------------------------------------------------+------>
   |                .-*HEX--------------------------.    |
   |          (4)   | .-*LIBL/--------.             |    |
   '-BASETBL(-------+-+---------------+--table-name-+--)-'
                      +-*CURLIB/------+
                      '-library-name/-'
 
>--+--------------------------------------------------------+--->
   |             (5)   .-*JOB--------------------------.    |
   '-BASESRTSEQ(-------+-*LANGIDSHR--------------------+--)-'
                       +-*LANGIDUNQ--------------------+
                       +-*HEX--------------------------+
                       | .-*LIBL/--------.             |
                       '-+---------------+--table-name-'
                         +-*CURLIB/------+
                         '-library-name/-'
 
>--+--------------------------------------+--------------------->
   |             (5)   .-*JOB--------.    |
   '-BASELANGID(-------+-language-ID-+--)-'
 
>--+--------------------------------------------+--------------->
   |        (6)   .-*JOB-------------------.    |
   '-CCSID(-------+-coded-character-set-ID-+--)-'
 
>--+--------------------------------------+--------------------->
   |       .-*LIBCRTAUT--------------.    |
   '-AUT(--+-*CHANGE-----------------+--)-'
           +-*ALL--------------------+
           +-*USE--------------------+
           +-*EXCLUDE----------------+
           '-authorization-list-name-'
 
>--+-----------------------------+-----------------------------><
   |        .-*BLANK--------.    |
   '-TEXT(--+-'description'-+--)-'
 
 

Notes:

1. SRCFILE(*PROMPT) must be specified in an interactive mode.

2. This parameter is not valid when SRCFILE(*PROMPT) is specified.

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

4. This parameter is valid only when TBLTYPE(*CVT) is specified.

5. This parameter is valid only when TBLTYPE(*SRTSEQ) is specified.

6. This parameter is valid only when TBLTYPE(*SRTSEQ) or (*UCSSRTSEQ) is specified. If you specify a TBLTYPE(*UCSSRTSEQ) and let this value default to *JOB then this paramater will be set to 13488.