DB2 graphic  QMF Version 8

SAVE

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.

Read syntax diagramSkip visual syntax diagramSAVE a QMF PROFILE in the database

                     (1)
         .-panelname------.
>>-SAve--+----------------+------------------------------------><
         '-PROFILE--------'

Notes:
  1. The name of the QMF object panel currently displayed, if appropriate, is used.
Read syntax diagramSkip visual syntax diagramSAVE 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--------------'

Notes:
  1. The name of the QMF object panel currently displayed, if appropriate, is used.
  2. The name of the object currently in QMF temporary storage, if any, is used.
  3. The value set in your profile is used.
  4. For an object being replaced the current value is left unchanged. Otherwise the value set in this global variable is used.
Read syntax diagramSkip visual syntax diagramSAVE 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---------------------'

Notes:
  1. The name of the QMF object panel currently displayed, if appropriate, is used.
  2. The name of the object currently in QMF temporary storage, if any, is used.
  3. The value set in this global variable is used.
  4. The value set in your profile is used.
  5. For an object being replaced the current value is left unchanged. Otherwise the value set in this global variable is used.
Read syntax diagramSkip visual syntax diagramSAVE QMF DATA in the database

>>-SAve--DATA--As tablename------------------------------------->

>--+-------------------------------------------------+---------><
   |    .-+---+------------------------------.       |
   |    | '-,-'                              |       |
   |    V                                    |       |
   '- (---+--------------------------------+-+-+---+-'
          |        .-=-. .-Replace-.       |   '-)-'
          +-Action-+---+-+-Append--+-------+
          |                         (1)    |
          |         .-=-. .-profile------. |
          +-CONfirm-+---+-+-Yes----------+-+
          |               '-No-----------' |
          |         .-=-.                  |
          '-COMment-+---+-value------------'

Notes:
  1. The value set in your profile is used.

The following table describes the DB2 algorithims used to create the LOB objects:

Table 2. DB2 algorithms 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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004