Controlling Data Retrieval Types
x

The SET CALLTYPE command enables you to set the data retrieval type per session, file, or segment by switching dynamically between physical and logical reads.


Top of page

Example: Using Dynamic CALLTYPE

The following examples illustrate the use of variations of dynamic CALLTYPE syntax:

ENGINE ADBSINX SET CALLTYPE FIND

Uses FIND as the type of data retrieval call for all files.

ENGINE ADBSINX SET CALLTYPE RL AFD EMPFILE

Retrieves data for the EMPFILE using RL as the type of data retrieval call.

Note that you can issue several commands for different files. Each command must be issued separately. Changes are cumulative. For example, the following commands retrieve data for the EMPFILE using FIND as the type of data retrieval call for a particular ADBS segment (segment S02):

ENGINE ADBSINX SET CALLTYPE RL AFD EMPFILE
ENGINE ADBSINX SET CALLTYPE FIND AFD EMP2
ENGINE ADBSINX SET CALLTYPE MIXED AFD VEHICLES
ENGINE ADBSINX SET CALLTYPE FIND AFD EMPFILE SEGNAME S02
ENGINE ADBSINX SET ?

Displays your settings.

ENGINE ADBSINX SET CALLTYPE DEFAULT

Returns to the default settings. This command resets all SET CALLTYPE commands for all Access Files.


Information Builders