TSO With ISPF | TSO Without ISPF | CMS With ISPF | CMS Without ISPF | CICS |
---|---|---|---|---|
X | X | X | X | X |
In DB2 QMF Version 8.1, the SAVE command has been changed to support long owner and table names. See Long names support in Version 8.1.
The SAVE command stores objects from QMF temporary storage into the database at the current location.
SAVE a QMF PROFILE in the database (1) .-panelname------. >>-SAve--+----------------+------------------------------------>< '-PROFILE--------'
SAVE a QMF QUERY or PROC in the database (1) (2) .-panelname------. .-objectname------. >>-SAve--+----------------+--+-----------------+----------------> +-QUERY----------+ '-As objectname---' '-PROC-----------' >--+---------------------------------------------------+------->< | .-+---+--------------------------------. | | | '-,-' | | | V | | '- (---+----------------------------------+-+-+---+-' | (3) | '-)-' | .-=-. .-profile------. | +-CONfirm-+---+-+-Yes----------+---+ | '-No-----------' | | (4) | | .-=-. .-dsqec_share------. | +-SHare-+---+-+-Yes--------------+-+ | '-No---------------' | | .-=-. | '-COMment-+---+-value--------------'
SAVE a QMF FORM in the database (1) (2) .-panelname------. .-objectname------. >>-SAve--+----------------+--+-----------------+----------------> '-FORM-----------' '-As objectname---' >--+----------------------------------------------------------+->< | .-+---+---------------------------------------. | | | '-,-' | | | V | | '- (---+-----------------------------------------+-+-+---+-' | (3) | '-)-' | .-=-. .-dsqec_form_lang------. | +-Language-+---+-+-English--------------+-+ | '-Session--------------' | | (4) | | .-=-. .-profile------. | +-CONfirm-+---+-+-Yes----------+----------+ | '-No-----------' | | (5) | | .-=-. .-dsqec_share------. | +-SHare-+---+-+-Yes--------------+--------+ | '-No---------------' | | .-=-. | '-COMment-+---+-value---------------------'
SAVE QMF DATA in the database >>-SAve--DATA--As tablename-------------------------------------> >--+-------------------------------------------------+--------->< | .-+---+------------------------------. | | | '-,-' | | | V | | '- (---+--------------------------------+-+-+---+-' | .-=-. .-Replace-. | '-)-' +-Action-+---+-+-Append--+-------+ | (1) | | .-=-. .-profile------. | +-CONfirm-+---+-+-Yes----------+-+ | '-No-----------' | | .-=-. | '-COMment-+---+-value------------'
The following table describes the DB2 algorithims used to create the LOB objects:
Object | Algorithm |
---|---|
Index on the LOB table | The index name contains the prefix "_IDX" followed by object (table) name specified in the SAVE data command. The maximum length of the index name is 18 characters; any remaining characters are truncated. |
Table space for each LOB column | The table space name contains the prefix "TB" followed by object (table) name specified in the SAVE data command. The maximum length of the table space name is 8 characters; any remaining characters are truncated. |
Auxiliary table for each LOB column | The index name contains the prefix "_AUX" followed by the LOB column name. The maximum length of the aux table name is 18 characters; any remaining characters are truncated. |
Index for the auxiliary table | The aux table name contains the prefix "_AUXI" followed by the number of the LOB column and then object (table) name specified in the SAVE data command. The maximum length of the aux index name is 18 characters; any remaining characters are truncated. |