x x

ENGINE ADBSINX SET SYNONYM {NEW|STD}

where:

NEW

Requires you to manually describe superdescriptors as groups in the Master File. With NEW synonym format, neither the groups nor their components (fields) have field names specified in the Master File. Aliases are populated using the Adabas FDT (2-byte name).

When a synonym contains the NEW syntax, the Adapter for Adabas uses NEW logic to process the selection criteria of requests involving that synonym. Screening conditions within the request are analyzed and the superdescriptor that covers the highest order component fields required by the selection criteria are used.

Note that you must specify CALLTYPE=RL in the Access File in order to take advantage of superdescriptor-based access.

STD

Incorporates the usual synonym creation behavior, which does not trigger the new logic for requests using superdescriptors. STD is the default value.

Top of page

Example: Setting Synonyms for Superdescriptors

The following Master File illustrates superdescriptors Y6 and Y7 defined as GROUP, with the NEW synonym format:

GROUP=      ,ALIAS=Y6         ,A2    ,A2    ,INDEX=I,$
   FIELD=   ,ALIAS=AF         ,A1    ,A1    ,       ,$
   FIELD=   ,ALIAS=AG         ,A1    ,A1    ,       ,$
GROUP=      ,ALIAS=Y7         ,A22   ,A22   ,INDEX=I,$
   FIELD=   ,ALIAS=AF         ,A1    ,A1    ,       ,$
   FIELD=   ,ALIAS=AG         ,A1    ,A1    ,       ,$
   FIELD=   ,ALIAS=AC         ,A20   ,A20   ,       ,$

The corresponding Access File specifies the superdescriptors Y6 and Y7 and their components, using the keywords SUPER and NUMFLDS:

SUPER=Y6               ,NUMFLDS=2          ,$
  FIELD=AF_FIELD       ,TYPE=   ,NU=NO     ,$
  FIELD=AG_FIELD       ,TYPE=   ,NU=NO     ,$
 SUPER=Y7               ,NUMFLDS=3          ,$
  FIELD=AF_FIELD       ,TYPE=   ,NU=NO     ,$
  FIELD=AG_FIELD       ,TYPE=   ,NU=NO     ,$
  FIELD=AC_FIELD       ,TYPE=   ,NU=NO     ,$

SUPER specifies the native Adabas two-byte field name of the superdescriptor.

NUMFLDS defines the number of participating fields. Descriptions of all participating fields immediately follow the SUPER statement.

The request that follows uses superdescriptor Y6 in the L3 (Read Logical) command in the Access File:

TABLE FILE EMP211
PRINT AF_FIELD AG_FIELD AC_FIELD AD_FIELD
IF AF_FIELD EQ 'S'
IF AG_FIELD EQ 'M'
END

The next request uses superdescriptor Y7 in the L3 (Read Logical) command. Notice that it references an extra field in the last line of the Access File:

TABLE FILE EMP211
PRINT AF_FIELD AG_FIELD AC_FIELD AD_FIELD
IF AF_FIELD EQ 'S'
IF AG_FIELD EQ 'M'
IF AC_FIELD EQ 'C'
END