JOINs With Selection Criteria

In order to issue a TABLE request against joined IMS databases with selection criteria on the JOIN TO field, you must first issue the following command:

ENGINE IMS SET SSAOPT OFF

The ENGINE SET SSAOPT OFF command forces the adapter to include only the join criteria in the SSA. FOCUS then processes the other selection criteria.

For example:

ENGINE IMS SET SSAOPT OFF
JOIN SSN IN EMPDB01 TO SSN IN PATINFO AS J1
TABLE FILE EMPDB01 
PRINT EMPDB01.SSN 
IF PATINFO.SSN EQ ' ' 
END

This produces the following SSA:

 set up SSA-Q: 
C5D4D7C9 D5C6D640 5C604040                *EMPINFO *-      *
   set up SSA-Q:
D7C1E3C9 D5C6D640 5C604DE2 E2D54040       *PATINFO *-(SSN  *  
4040407E 40404040 40404040 40405D40       *  =    )        *

If you do not issue the IMS SET SSAOPT OFF command, by default all selection criteria on keys will be passed to IMS for processing. This setting remains in effect for the entire session, unless you issue the IMS SET SSAOPT ON command.


Information Builders