DISPLAY command
Displays information about the specified Analytics item type. Can also display the result of an expression, or the output of a function.
Syntax and parameters
Syntax |
Purpose |
---|---|
DISPLAY |
Displays the field definitions, and any related child tables, for the currently active Analytics table. |
DISPLAY OPEN |
Displays a list of open Analytics tables and project files.
|
DISPLAY {<PRIMARY>|SECONDARY} |
Displays the name and table layout information for the primary or secondary table.
The information displayed includes:
|
DISPLAY HISTORY |
Displays the table history for the currently active Analytics table. Note A table may or may not have associated table history. |
DISPLAY RELATION |
Displays relation information for the currently active Analytics table:
|
DISPLAY {variable_name|VARIABLES}
|
Displays the value of a single variable or all variables.
|
DISPLAY VERSION |
Displays information in the following format about the installed version of Analytics:
|
DISPLAY {DATE|TIME} |
Displays the current operating system date and time. DATE | TIME specify either keyword. The two keywords do the same thing. |
DISPLAY {FREE|SPACE} |
Displays the amount of physical memory (RAM) available for use by Analytics. The amount displayed does not include memory reserved for variables. By default, Analytics reserves 60 KB of physical memory to store variables, but the amount is automatically increased as necessary. FREE | SPACE specify either keyword. The two keywords do the same thing. |
DISPLAY expression
|
Displays the result of an expression. expression the expression to display the result of. |
DISPLAY function
|
Displays the output of a function. function the function to display the output of. |
Examples
Display the layout of an Analytics table
Displaying the layout of a table can be useful in a number of circumstances. For example, you may want to combine two or more tables, and you need to examine field lengths and data types.
The example below displays the layout of the Ap_Trans table:
OPEN Ap_Trans
DISPLAY
The DISPLAY command produces the output to screen shown below.
Note
If you enter DISPLAY directly in the Analytics command line, the output appears immediately.
If you run DISPLAY in a script, double-click the corresponding DISPLAY entry in the command log to display the output.
Output to screen
Relationship
'Vendor' related by 'Vendor_No' using index 'Vendor_on_Vendor_No'
File
'Ap_Trans.fil' (format 'Ap_Trans') is your PRIMARY file.
The record length is 59
Fields
Name | Type | Start | Length | Decimals | Field explanation |
---|---|---|---|---|---|
Vendor_No | ASCII | 1 | 5 | AS "Vendor;Number" WIDTH 7 | |
Invoice_No | ASCII | 6 | 15 | AS "Invoice;Number" | |
Invoice_Date | DATETIME | 21 | 8 | PICTURE "MM/DD/YY" AS "Invoice;Date" WIDTH 8 | |
Invoice_Amount | NUMERIC | 29 | 12 | 2 | PICTURE "(9,999,999.99)" AS "Invoice;Amount" WIDTH 12 |
Prodno | ASCII | 41 | 9 | AS "Product;Number" | |
Quantity | MICRO | 50 | 4 | 0 | PICTURE "(9,999,999)" |
Unit_Cost | NUMERIC | 54 | 6 | 2 | PICTURE "(9,999,999)" AS "Unit;Cost" SUPPRESS |
Display the values of all variables in an Analytics project
DISPLAY VARIABLES generates the same information that appears in the Variables tab in the Navigator. One benefit of using DISPLAY VARIABLES is that you can copy-and-paste the displayed information.
The example below creates two user-defined variables and two system variables and then displays the values of the variables:
ASSIGN v_table_name = "Ap_Trans"
ASSIGN v_field_name = "Invoice_Amount"
OPEN %v_table_name%
TOTAL FIELDS %v_field_name%
DISPLAY VARIABLES
The DISPLAY command produces the output to screen shown below.
Note
If you enter DISPLAY VARIABLES directly in the Analytics command line, the output appears immediately.
If you run DISPLAY VARIABLES in a script, double-click the corresponding DISPLAY VARIABLES entry in the command log to display the output.
Output to screen
Name | Type | Value |
---|---|---|
TOTAL1 | N | 278,641.33 |
OUTPUTFOLDER | C | "/Tables/Accounts_Payable" |
v_field_name | C | "Invoice_Amount" |
v_table_name | C | "Ap_Trans" |
Display the result of an expression
For the selected record, the example below displays the result of multiplying the value in the Sale_Price field by the value in the Quantity_on_Hand field:
DISPLAY Sale_Price * Quantity_on_Hand
Display the output of a function
For the selected record, the example below displays the number of days that have elapsed since the date in the Invoice_Date field:
DISPLAY AGE(Invoice_Date)
Remarks
Location of command results
DISPLAY run from the Analytics command line the results are displayed on screen.
DISPLAY executed in a script the results are written to the Analytics command log. You can double-click the command log entry to display the results on screen.