The SAVE command stores the contents of an object in temporary storage into the database.
>>-- 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 -+
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.
|
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. |
SAVE QUERY AS USER1.QUERY1 (CONFIRM=NO