DB2 graphic QMF Version 8

SAVE command

The SAVE command stores the contents of an object in temporary storage into the database.

Syntax

>>-- SAVE --- QUERY --- AS ObjectName -----------------------------------<<
           +- PROC --+                 +- ( --- COMMENT = Text ---+
                                             +- CONFIRM = YES/NO -+
                                             +- SHARE = YES/NO ---+


>>-- SAVE FORM AS ObjectName --------------------------------------------<<
                              +- ( --- COMMENT = Text -------------+
                                    +- CONFIRM = YES/NO -----------+
                                    +- SHARE = YES/NO -------------+
                                    +- LANGUAGE = ENGLISH/SESSION -+


>>-- SAVE DATA AS TableName ---------------------------------------------<<
                         +- ( --- COMMENT = Text ----------+
                               +- CONFIRM = YES/NO --------+
                               +- METHOD = REGULAR/FAST --------+
                               +- SCOPE = NumChars --------+
                               +- ROWIDADD = YES/NO --------+

                               +- ROWIDNAME = Text ---------+
                               +- ROWIDDISP = ALWAYS/BYDEFAULT --------+
                               +- ROWIDDISPnnn = EXCLUDE/CONVERT/ALWAYS/BYDEFAULT+
                               +- ACTION = REPLACE/APPEND -+

Parameters

Table 46. SAVE Command Parameters
Parameter Description
ObjectName The name to assign to the object (query, form, procedure, or table) when it is saved.
COMMENT Specifies a comment with the saved object. Enclose the text in quotes.
CONFIRM Specifies whether or not to display a confirmation dialog before replacing or changing an object as a result of this command. If CONFIRM is not specified or is set to NO, the corresponding resource limit is used.
SHARE Specifies whether or not other users are allowed to use the saved object.
LANGUAGE Specifies whether or not a form is saved in English or in the current session language. A form that is saved in English can be run in any NLF session. A form that is saved in the session language can only be run in a session of the same language. The default value is provided by the DSQEC_FORM_LANG global variable.
METHOD Specifies the method of saving the data.
  • Regular save: Sends data from the client back to the database server to be inserted into the table.
  • Fast saved: Reruns the query at the server and inserts the results directly into the table.
SCOPE Specifies the commit scope of the data.
ROWIDADD Specifies whether or not to add the Row ID column to the table.
ROWIDNAME Specifies the name to assign to the new Row ID column.
ROWIDDISP Specifies the disposition of the new Row ID column.
ROWIDDISPnnn Specifies the disposition of existing Row ID columns.
ACTION Specifies whether or not to replace the entire database table or append data to the existing table.

Example

SAVE QUERY AS USER1.QUERY1 (CONFIRM=NO


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