Glossary
Additional selection criteria
Logical expressions, logical record keywords, and criteria expressions for subscripted fields that you use to tell CA OLQ which rows of data to retrieve for your report. Additional selection criteria are specified in the Additional selection criteria field of the Selection criteria screen.
Aggregate function
A function that performs a predefined operation on a group of report rows. Examples of aggregate functions are: average, high value, low value, count, and total.
ASF (Automatic System Facility)
A tool in CA-IDMS/DB used to create and manage tables. Once you have created a table using CA OLQ, you can use ASF to modify the table definition.
ASF dictionary
An alternate data dictionary used by ASF. You must be using the ASF dictionary when you are creating data tables.
ASF table
A presentation of data as a series of rows and columns from a table associated with the IDMSR schema.
Batch
Batch processing means that the user doesn't have to interact with the computer system in order to perform a function. Usually, a batch job is set up in advance (such as when you fill out your Batch Processing screen). Once the job has started running, you cannot intervene except to suspend execution.
Built-in function
A function that performs a predefined string, arithmetic, date/time, or trigonometric calculation on your report rows. Examples of built-in functions are: substring, Gregorian date, cosine, and square root.
Code table
A table defined in the data dictionary that contains corresponding pairs of values. One column in the table lists internal code values that are used to efficiently store the data in the database. The other column in the table lists external values that are used in programs or reports.
For example, a STATE code table could represent the STATE column as 01 in the internal (encoded) expression and Alabama in the external (decoded) expression.
Column
A vertical division in a table. A column represents a category of information. For example, employee last name.
Column alignment
An editing feature that determines how report data columns align under the column headers. Options are left, right, and center.
Column header
A header at the top of each column of report data.
COMPUTE statement
A CA OLQ syntax statement used to perform calculations in the menu facility. Any time you specify a built-in or aggregate function, CA OLQ creates a COMPUTE statement. You can also provide your own COMPUTE statement.
Current report
The report you're working on in an active CA OLQ session. If you retrieve a saved report, CA OLQ clears out the current report.
Data dictionary
The storage facility used by CA products as a central source for data definitions, modules, and run-time information. Qfile definitions are stored in the data dictionary.
Database view
Another term for subschema.
Destination
When you print a report, you specify an output destination where the report is to be printed. Usually, the destination is a file associated with a printer.
Display sequence
A numeric sequence listed on CA OLQ report formatting screens. The numbers in the display sequence correspond to the order in which report columns are displayed.
Element
The smallest significant unit of data in a CA-IDMS/DB database. Record elements correspond to columns in a table. For example, DEPT-ID-0410 is an element.
External picture
A code that defines the way your column value is formatted in your report. The external picture is used to add punctuation (for example, commas) and special characters (for example, dollar signs) to your column data display.
Group by all
A report total including all rows in your report. Group by all means the same thing as report total.
Group computation
A calculation that CA OLQ performs on a report group.
Group field
A report column whose value is used to divide your report rows into groups. For example, you could list all of the company's employees grouped according to which department they work in. In this case, DEPARTMENT NAME is the group field.
Input file
A file that contains input into a batch program.
Integrated Data Dictionary (IDD)
The CA product used to access definitions stored in the data dictionary.
Interactive
A way of performing a function in which the computer system requires the user to provide input and then responds to that input. An example would be CA OLQ menu mode. Another term to describe interactive processing is online.
Interrupt count
The maximum number of records CA OLQ will retrieve when building a report. If the number of records that meet the selection criteria for that report exceeds the interrupt count, CA OLQ suspends data retrieval and issues a message asking you if you want to continue to retrieve records.
Job control language
A language used to define the special requirements of your batch program to the system. Job control language (JCL) statements name input and output files, the name of your program, and your output destination.
Join
A relational operation through which two or more tables are combined. Tables are joined based on columns that the tables have in common.
Join criteria
A logical expression that compares like columns in two or more tables.
Output destination
Any type of device that receives the report that you have created as a result of your batch job. Output destinations can be a printer, a terminal, or a log.
Output file
A file that contains the results of your batch program.
Page header
A title at the top of each page of your report.
Page footer
A title at the bottom of each page of your report.
Project
A relational operation through which only particular columns of a table are accessed.
Qfile definition
The CA OLQ syntax statements stored in the data dictionary when you create your qfile.
Record
A group of related elements. Records correspond to rows in a table. For example, DEPT-NAME-0410, DEPT-ID-0410, and DEPT-HEAD-ID-0410 are all grouped into the DEPARTMENT record.
Report group
A set of report rows such that each row contains the same value of the group field. For example, the personnel department is a report group with DEPARTMENT NAME as the group field. Each row in this group contains Personnel in the DEPARTMENT NAME field.
Report subtotal
A computation applied to a report group. For example, if you grouped your employees by department, you could create report subtotals that compute the average salary in each department.
Report total
A computation that includes all of the rows in your report. For example, you could compute the total sales revenue earned by all of your employees. Note that a report total does not have to be a sum. It can also be an average, a counter, a high value, or a low value.
Row
A horizontal row in a table. A row represents one data occurrence. For example, information about each employee.
Retention period
The number of days your saved report file is kept in your directory. After the retention period has expired, the report file is deleted.
Saved report
A report file maintained in your user directory that contains a copy of a current CA OLQ report.
Select
A relational operation through which only particular rows of a table are accessed.
Selection criteria
Logical expressions that you use to tell CA OLQ which rows of data to retrieve for your report. Selection criteria are specified in the Selection criteria field of the Column Select screen.
Separator character
A character used to separate group computations from the rest of the report.
Sort
A way to order report rows. CA OLQ sorts the rows in your report based on the value of the sort field that you specify. Rows can be sorted in ascending or descending order.
Sparse/Full option
A CA OLQ editing feature that determines how column values that repeat in consecutive rows are displayed:
SQL table
A presentation of data as a series of rows and columns from a table associated with an SQL schema
Subschema
A view of the database that contains a subset of the records, elements, sets, and areas that make up the entire database. A subschema usually views data that is functionally related.
For example, the personnel department uses a subschema that views employee information such as salary, date of hire, and personal information. All of the information is held in the same database, but the personnel department views only the information that it needs.
Summary computation
Another term for group computation.
Summary line
A report line that displays a group computation.
|
Copyright © 2013 CA.
All rights reserved.
|
|