RESET object

The RESET command restores an object in temporary storage to its initial state. This command does not apply to ANALYTIC objects.

TSO with ISPF TSO without ISPF CICS®
X X X

RESET a QMF object in temporary storage

Read syntax diagramSkip visual syntax diagramRESetpanelname1PROCPROFILEDATAQUERYQUERY optionsFORM.BREAK1.BREAK2.BREAK3.BREAK4.BREAK5.BREAK6.CALC.COLUMNS.CONDITIONS.FINAL.OPTIONS.PAGE.DETAILFORM.DETAIL options
QUERY options
Read syntax diagramSkip visual syntax diagram (,Language=profile2SqlQbePrompted Model=RELRel)
FORM.DETAIL options
Read syntax diagramSkip visual syntax diagram(VARIATION optionUsing= integer)
VARIATION option
Read syntax diagramSkip visual syntax diagramVariation=currentvariationintegerAll
Notes:
  • 1 The name of the QMF object panel currently displayed, if appropriate, is used.
  • 2 The value set in your profile is used.

Description

PROC
Displays an empty procedure panel.
PROFILE
Displays your profile with the values reset to those saved in the database at the current location.
DATA
Purges all data in the DATA temporary storage area and closes the database cursor. The REPORT object in temporary storage is discarded. The QMF home panel is displayed if the RESET command was issued from the REPORT panel.
QUERY
Displays an empty query panel.
QUERY options
LANGUAGE
Specifies which query language to initialize in the query panel.
SQL
Displays a blank SQL Query panel.
QBE
Displays a blank QBE Query panel.
PROMPTED
Displays a blank Prompted Query panel and starts a new Prompted Query dialog.
MODEL
Specifies the data model used for queries. Relational data is the only supported value (REL).
FORM
Displays the FORM.MAIN panel with all parts of the form reset to their default values. The defaults are set to match the column information in the DATA object. If the DATA object is empty, there will be no column information in the form.

If the current panel is FORM.MAIN, the default object for the RESET command is FORM.

FORM.COLUMNS
Displays the FORM.COLUMNS panel with just that part of the form reset to match the column information in the DATA object. If the DATA object is empty, there will be no column information.
FORM.BREAK1
FORM.BREAK2
FORM.BREAK3
FORM.BREAK4
FORM.BREAK5
FORM.BREAK6
FORM.CALC
FORM.CONDITIONS
FORM.FINAL
FORM.OPTIONS
FORM.PAGE
FORM.DETAIL
Displays the specified form panel with just that part of the form reset to its default values.
FORM.DETAIL options
VARIATION
Specifies a detail variation to display with its fields reset.
If this option is omitted, the current detail variation is reset. An exception to this is when more than one detail variation exists and the current panel is not FORM.DETAIL. In this situation, you must specify this option.
integer
The number for a detail variation. The number must be an integer from 1 to 99.

If the specified detail variation has not been created yet, the number is reduced to the next sequential number following all existing detail variations.

ALL
Reset all detail variations to their default values.
USING
Specifies which detail variation to use as a template to reset or create another variation.
This can be helpful if you make a number of modifications to a detail panel and want to create another variation with similar changes.
integer
The number for an existing detail variation. The number must be an integer from 1 to 99.

Examples

  1. To display a prompt panel for the QMF RESET command:
      RESET ?
  2. To display an empty SQL Query panel:
      RESET QUERY (LANGUAGE=SQL
  3. To erase the data in QMF temporary storage:
      RESET DATA
  4. To display the FORM.BREAK6 panel set to the default values for your data:
      RESET FORM.BREAK6
  5. To reset only FORM.DETAIL variation 1:
      RESET FORM.DETAIL (VARIATION=1
  6. To reset detail variation 2 using detail variation 1 as a template:
      RESET FORM.DETAIL (VARIATION=2 USING=1
  7. To reset all detail variations:
      RESET FORM.DETAIL (VARIATION=ALL