SAVE command

The SAVE command saves an object from temporary storage to a database.

Syntax

>>-- SAVE --- QUERY --- AS ObjectName --------------------------<<
           +- PROC -+                 ( +- COMMENT = text ------+
                                        +- CONFIRM = YES/NO ----+
                                        +- SHARE = YES/NO ------+
                                        +- FOLDER = foldername -+
>>-- SAVE -- FORM -- AS ObjectName --------------------------<<
                             ( +- COMMENT = text -------------+
                               +- CONFIRM = YES/NO -----------+
                               +- SHARE = YES/NO -------------+
                               +- LANGUAGE = ENGLISH/SESSION -+
                               +- FOLDER = foldername --------+
>>-- SAVE -- DATA -- AS TableName ----------------------------------------------<<
                            ( +- COMMENT = text ---------------------------------+
                              +- CONFIRM = YES/NO -------------------------------+
                              +- METHOD = REGULAR/FAST/FASTSAFE------------------+
                              +- SCOPE = NumChars -------------------------------+
                              +- RESULTSET = integer ----------------------------+
                              +- ROWIDADD = YES/NO ------------------------------+
                              +- ROWIDNAME = text -------------------------------+
                              +- ACCELERATOR = acceleratorname ------------------+
                              +- ACCELERATORDATABASE = databasename -------------+
                              +- ROWIDDISP = EXCLUDE/CONVERT/ALWAYS/BYDEFAULT----+
                              +- ACTION = REPLACE/APPEND ------------------------+
                              +- SPACE = tablespace/database.tablespace----------+
                              +- SPACE DATABASE = database-----------------------+
                              +- MODE = GRID/RAW --------------------------------+

To save visual reports created in QMF for Windows:

>>-- SAVE -- REPORT -- AS ObjectName ----------------------------<<
                              ( +- COMMENT = text -----------------+
                                +- CONFIRM = YES/NO ---------------+
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 NO, the corresponding resource limit is used.
SHARE Specifies whether other users are allowed to use the saved object.
LANGUAGE Specifies whether 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.
FOLDER Specifies the folder in QMF Catalog to that links to the objects must be saved. The default value is provided by the DSQEC_CURR_FOLDER global variable.
METHOD Specifies the method of saving the data.
  • REGULAR sends data from the client back to the database server to be inserted into the table.
  • FAST reruns the query at the server and inserts the results directly into the table.
  • FASTSAFE reruns the query at the server without the ORDER BY clauses and inserts the results directly into the table.
SCOPE Specifies the commit scope of the data.
RESULTSET Specifies the number of the result set to save in queries that have multiple result sets. If you omit this parameter, the current result set will be saved.
ROWIDADD Specifies whether 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.
ACTION Specifies whether to replace the entire database table or append data to the existing table.
SPACE Specifies both the database name and the table space name to save the table in a particular database container and table space.
Note: The table space name that you specify must match the default table space name that is set for your user ID on the Save Data tab of the resource limits settings. If you have the permission to override the default table space name, you can specify any table space name to which you want to save the table. The permission to override the table space name is set on the Save Data tab of the resource limits settings.
Note:
MODE Specifies whether the query result data is saved with formatting and added calculated columns. You can specify one of the following values:
  • GRID to specify that all of the data as it is currently formatted in the current query results will be saved. Any calculated columns that have been added to the query results are included.
  • RAW to specify that all of the data in the current query results will be saved. Any formatting that has been applied to the data will not be saved. Any calculated columns that have been added to the query results will not be saved. This is the default value.
ACCELERATORDATABASE Specifies the name of the accelerator database that you want to use to save your tables. The ACCELERATORDATABASE keyword can be up to 128 characters long. The default value of the ACCELERATORDATABASE parameter is taken from the DSQEC_SAV_ACCELDB global variable. If the DSQEC_SAV_ACCELDB global variable value is not empty, the database specified by the SPACE keyword is ignored. If the ACCELERATORDATABASE parameter value is not empty, the value of the DSQEC_SAV_ACCELDB is ignored.

Example

SAVE QUERY AS USER1.QUERY1 (CONFIRM=NO