DA Data Access

DA type [, param ]

An alternative data access method for the file currently being displayed can be set with this command. This means that the records can be displayed in a different sort sequence, or displayed in another format.

type Type of access. The following access types are implemented:

CODE Character-orientated conversion of the records/data blocks for screen output. The file records are not affected.

I Access an NK-ISAM file according to a secondary key set up with CREate Alternate Index.

FLAM Access a file compressed with the FLAM software product. The records are displayed in original, i.e. uncompressed form.

param Additional parameter for the required access type.

CONV {, CAP | CAP2 | LOW | EBCTOASC | ASCTOEBC} [, K=Y]

CAP Convert all lower case to upper case.

X'00' --> X'00' (unchanged)

X'4F' (ö or |) --> X'4F' (unchanged)

X'FB' (ä or {) --> X'FB' (unchanged)

X'FD' (ü or }) --> X'FD' (unchanged)

CAP2 Convert all lower case to upper case.

X'00' --> X'40' (Blank)

X'4F' (ö or |) --> X'BC' (Ö or ~)

X'FB' (ä or {) --> X'BB' (Ä or [)

X'FD' (ü or }) --> X'BD' (Ü or ])

LOW Convert all upper case to lower case.

X'40' --> X'40' (unchanged)

X'BC' (Ö or ~) --> X'BC' (unchanged)

X'BB' (Ä or [) --> X'BB' (unchanged)

X'BD' (Ü or ]) --> X'BD' (unchanged)

ASCTOEBC

Conversion from ASCII to EBCDIC.

EBCTOASC

Conversion from EBCDIC to ASCII.

K=Y The data contained within the key of an ISAM file is also converted. Normally, the ISAM key is excluded from the conversion.

I For ISAM access, this parameter will specify the desired Alternate Index. The records will be displayed in ascending order according to the Alternate Index.

FLAM If the FLAM option is specified, parameters can be specified which will influence the type of decompression. For example: DAFLAM,TR=A/E. Specifying this parameter will cause the data to be converted from ASCII code to EBCDIC when decompressing. For a full description of all the parameters, see the FLAM User Manual".

NDA The data access type is reset to the standard setting.

Notes:

The DA command can also be used to facilitate user-specific access to databases. A detailed description of the Data Access Interface is available on request.

The W command may be used to write the records in the sequence in which they are displayed, or in the format in which they appear (i.e. decompressed for FLAM) to another file. In the ISAM file created by the Write command, the Keylen and Keypos of the currently active secondary key is used as the primary key.

An alternative method of data access set up by the DA command remains valid until the Display mode is terminated for the current file by pressing the K1 key, or by issuing a D/NF/LF/LST command. During the display, the command NDA can be used to return to the standard access method of CFS.