Get command option

Get is a command option for the AccessExt command. The command required to access data in a database record previously read using a find statement, and to move its value into a variable.

<Get> :=  GET “<GetExpression>” [ variable ]

The expression is a string not exceeding 150 characters that contains a value describing the database item to be accessed.

<GetExpression> := { database | dataset } {alphabetic_item | group_item |number_item | 
real_item | field_item | count_item | recordtype_item } [ [subscript ] ]

The items are DMS II Attributes. Currently, a DMS II BOOLEAN Attribute might not be accessed. Note that alphabetic item, group item, number item, real item, field item, count item, and record type item are all data names that must be defined within the target database.

The DASDL data required for the AccessExt command access to a database are not necessarily the same as the item names on the screen; they might be prefixed by the Ispec name. Refer to the appropriate system DASDL for the correct name.

For access to a database Ispec containing StoreIfPresent, use the form:

AccessExt DB1 Find "ispec ispec VIA GLB-ispec key"

For example, for an Ispec called ISP1 containing StoreIfPresent, use:

AccessExt DB1 Find "ISP1 ISP1 VIA GLB-ISP1KEY"

Attribute [subscript]

An attribute that is to receive the specified database item value. The type of this item must be the same type as the source item in the DMS II database (alphanumeric or numeric).

subscript

Where an item of data is defined as part of a table in a DMS II structure, the subscript value must be specified. Note that the subscript must be enclosed within square brackets, as shown in the following example.

Get "SETA ELEMENTB [3]"