FBE for a key or IBM AIX field

Each SQL call that is issued by a CICS® VT DDM has a predicate. The predicate columns are the DB2® primary key columns for regular call or the alternate index columns if you are using an alternate index path. Your FBE may have to take this into consideration.

Your FBE uses EXFUNCT to decide if it is building a VSAM field value or a DB2 column value. If your FBE operates on a single field, the exit code is the same for a key and non-key field. An example is DATEFBE which is explained in Reformatting a date field.

More complex FBEs on a key or an IBM® AIX® field may have to use the fields EXVSABLD and EXDB2BLD in conjunction with EXFUNCT. An example of a more complex FBE is CTLRECF, which is explained in FBE for managing a control record.

To illustrate this, consider the case where an application program issues a direct call, such as a START BROWSE, and the key field is managed by an FBE. When the call is processed in CICS VT, the exit is executed at multiple points in the call.

  1. A key value is supplied by the application program. For the first invocation of the FBE, the key value must be transformed from its VSAM format into a DB2 format. In this case, EXFUNCT=D signifies that a DB2 field is being built and EXDB2BLD=N signifies that the entire DB2 record is not being built.
  2. When the DDM retrieves a record from DB2, the exit is invoked for a second time to transform the DB2 column value to a VSAM format. This enables CICS VT to compare the specified key value with the retrieved key value. EXFUNCT=V signifies a VSAM field is being built and EXVSABLD=N signifies that the entire VSAM record area in not being built.
  3. If the converted key matches the key value that is specified in the application call, the remainder of the VSAM record is built. EXFUNCT=V and EXVSABLD=Y in this case.

Your exit must taken account of the values of EXFUNCT, EXVSABLD, and EXDB2BLD to drive the appropriate logic.


Concept Concept

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtdecfbekey.html