Use the Display command to show information about the current Analyzer environment including any stored SQL Select information (such as a Where clause) for your relational data sources. The information displayed depends on the keyword you specify.
You can also use the Display command to show the current values of specific fields, variables, expressions (e.g. the results of calculations) or literals.
When displaying fields, variables, expressions or literals, the Display command provides a heading for the result of each item displayed. Use the AS and WIDTH modifiers to alter the heading displayed and to set the correct display width. For more information see Command Parameters.
Finally, you can use the Display command to create a data file that can be opened in the View to display field definitions for a table.
Tip: When displaying fields, variables, expressions or literals, the Display command provides a heading for the result of each item displayed. Use the AS and WIDTH modifiers to alter the heading displayed and to set the correct display width. For more information see Command Parameters.
This command can only be issued in command mode.
The Display command has the following command parameters:
DISPLAY CONNECTION displays all connections to Arbutus Servers and specifies the active server.
DISPLAY DATE displays the current date and time as defined by your computers operating system and is a synonym for the TIME parameter.
DISPLAY FIELD displays information on the field name being referenced
DISPLAY FIELD DETAIL creates system variables to display information on the field name being referenced. System variables created are:
1. | Arbutus_Fld_Dec - numeric variable containing number of decimals specified for field (0 for non-numeric fields) |
2. | Arbutus_Fld_Len - numeric variable containing field length |
3. | Arbutus_Fld_PIC - character variable containing date input or numeric output format |
4. | Arbutus_Fld_Start - numeric variable containing field start position |
5. | Arbutus_Fld_Type - character variable containing the Arbutus field type |
DISPLAY FREE displays the amount of memory (RAM) available for use and is a synonym for the SPACE parameter. The amount displayed does not include RAM reserved for variables.
DISPLAY HISTORY displays the table history including any refreshable Import command, as described in Table History.
DISPLAY OPEN displays all open tables for your current Analyzer Project.
DISPLAY followed by either PRIMARY or SECONDARY displays the field attributes in either the active primary or secondary file. This includes any SQL Select information (such as a Where clause) for your relational data sources.
Note: DISPLAY issued without specifying either the PRIMARY or SECONDARY parameters defaults to the primary table.
For each data field in the table layout, the following information is displayed:
| name |
| field type |
| start position |
| length |
| decimal places |
| field explanation. |
For each computed field in the table layout, the following information is displayed:
| name |
| field type (COMPUTED) |
| conditional expressions and values (one set per line) |
| default value |
| length |
| decimal places |
If the optional TO parameter is used to specify a table name, then a table is created for storing the attributes for each field from the specified primary or secondary table. The resulting table can then be opened in the View and analyzed.
The command syntax is:
DISPLAY PRIMARY TO filename
DISPLAY SECONDARY TO filename
Note: The 'filename' may not be pathed.
This creates a table with the following columns:
| Name |
| Type |
| CNLD |
| Start |
| Length |
| Decimals |
| Modifiers. |
The table contains:
| one record for each field in the current file. This enables control over procedures that require field information. |
There are three types of records in the table:
| Record 1 always describes the file attributes, where name is the table name, type is either FIXED, CRLF, VARIABLE or DELIMITED, start is the skip value, length is the record length and modifiers is the file name |
| Field records describe all the appropriate column data, one field record is created for each field. |
| Computed Field records where each definition line is placed on a subsequent line in the 'Modifiers' field, with all other columns blank. |
DISPLAY SOURCE displays the default SQL/relational data source set in the Data Definition Wizard or via the SET SOURCE command.
For more information see Set Source.
DISPLAY SPACE displays the amount of memory (RAM) available for use and is a synonym for the FREE parameter. The amount displayed does not include RAM reserved for variables.
DISPLAY TIME displays the current date and time as defined by your computers operating system and is a synonym for the DATE parameter.
DISPLAY VARIABLES displays the values of user variables created by the Accept, Assign, Let or Dialog commands and system variables automatically created by certain Analyzer commands.
In the case of variable arrays, the first 10 array values are displayed. To display a specific variable array element, for example element 5 of 10 in a variable array called NAMES, type:
DISPLAY NAMES[5]
DISPLAY VERSION displays the version of Analyzer and the version of the Arbutus Server (if any) that is currently hosting the primary table. Also creates a variable called Arbutus_Version which stores the version number of Analyzer.
DISPLAY <PRIMARY | SECONDARY>
DISPLAY PRIMARY <TO filename>
DISPLAY SECONDARY <TO filename>
DISPLAY ALL
DISPLAY <field_name | variable_name | expression | literal>
DISPLAY FIELD field_name
DISPLAY FIELD DETAIL field_name
DISPLAY PRIMARY
DISPLAY DATE | TIME
DISPLAY VARIABLES
DISPLAY HISTORY
DISPLAY FREE | SPACE
DISPLAY VERSION
DISPLAY OPEN
DISPLAY RELATION
DISPLAY SOURCE
To display the table layout for the primary file, Inventory, enter in the Command Log text box:
DISPLAY
Analyzer displays the result in the Command Log.
Note: When displaying the table layout, for relational data sources, any SQL Select information (such as a Where clause).