Panels › (DQDV0) Define Variable

(DQDV0) Define Variable

 =>
 ENTER THE REQUIRED DATA AND PRESS THE APPROPRIATE PFKEY.
 --------------------------------------------------------------------------DQDV0
 DATAQUERY:  DEFINE VARIABLE                      NAME:
 -------------------------------------------------------------------------------
 DESCRIPTION:
 STATUS:
 
 
 
 
 
 VARIABLE ID:               ?
 ENTER THE PROMPT TO BE DISPLAYED FOR THIS VARIABLE:
 _______________________________________________________________________________
 VARIABLE TYPE:           _    C - CHARACTER    N - NUMERIC    A - ALPHABETIC
 VARIABLE LENGTH:
 VARIABLE DEFAULT VALUE:
 _______________________________________________________________________________
 
 -------------------------------------------------------------------------------
 <PF1> HELP        <PF2> RETURN       <PF3> CONTINUE       <PF4> SAVE
 <PF5> RANGE/LIST  <PF6> DELETE       <PF7> PREV VARIABLE  <PF8> NEXT VARIABLE

Description

The required Define Variable panel appears for each variable you enter on the Editor panel. It contains information about the variable you entered and provides two fields that you must complete: a prompt that appears during execution and the data type code that tells CA Dataquery what kind of data will appear as a result of executing the query with this variable. An overview on completing this panel appears in the CA Dataquery User Guide.

Action

Type a prompt that appears when this variable can be substituted during execution or validation. Choose a data type you want to allow for the substitute. Save the definition and go on to the next panel.

Sample

The following sample shows how a typical Define Variable panel appears containing information in the display fields.

 =>
 Enter the required data and press the appropriate PFkey.
 --------------------------------------------------------------------------DQDV0
 DATAQUERY:  DEFINE VARIABLE                      NAME:   AAA-SAMP-DIALOG
 -------------------------------------------------------------------------------
 DESCRIPTION:      SELECT CUSTOMER BY CITY
 STATUS:           COMPLETE
 
 WITH CITY = 1?'DALLAS         '
 WITH PROD = 2?75042
 PRINT       TITLE1 'SAMPLE ORDER ENTRY DATABASE'
 
 VARIABLE ID:             2 ?
 ENTER THE PROMPT TO BE DISPLAYED FOR THIS VARIABLE:
 _______________________________________________________________________________
 VARIABLE TYPE:           _    C - CHARACTER    N - NUMERIC    A - ALPHABETIC
 VARIABLE LENGTH:         05
 VARIABLE DEFAULT VALUE:
 75042
 
 
 -------------------------------------------------------------------------------
 <PF1> HELP        <PF2> RETURN       <PF3> CONTINUE       <PF4> SAVE
 <PF5> RANGE/LIST  <PF6> DELETE       <PF7> PREV VARIABLE  <PF8> NEXT VARIABLE

Display Fields

Refer to the following for explanations of the display fields intended to contain variable data.

NAME:

Name you assigned the dialog or JCL PROC on the Editor panel.

DESCRIPTION:

Description you assigned the dialog or JCL PROC on the Editor panel.

STATUS:

Status options are:

• COMPLETE - The description and all variable definitions have been saved for this dialog or JCL PROC.
• INCOMPLETE - The description or a variable definition has not been saved for this dialog or JCL PROC, or there are definitions saved for variables that have been changed or removed from the Editor panel. Below the Status field, you see a replica of the variables as they appear on the Editor panel.

VARIABLE ID:

Two-digit ID assigned to the variable on the Editor panel.

VARIABLE LENGTH:

Length of the default plus any dialog fill characters. This length may differ from the actual variable length if you have changed the variable on the Editor panel since the last time you saved this variable's definition. If so, delete the definition so that this display field contains the correct information. The maximum length of the variable is 77 characters.

VARIABLE DEFAULT VALUE:

Characters entered on the Editor panel following the two-digit variable ID and dialog symbol and excluding any dialog fill characters.

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Returns to the CA Dataquery Editor (DQD10).

<PF3> CONTINUE

Saves this definition and continues to the next step.

<PF4> SAVE

Saves this definition.

<PF5> RANGE/LIST

Displays Define Variable Range panel if variable is numeric, Define Variable List panel if variable is character type.

<PF6> DELETE

Deletes any saved definition for this variable.

<PF7> PREV VARIABLE

Displays the Definition panel for the previous variable.

<PF8> NEXT VARIABLE

Saves the Definition panel for the next variable.