Adapting SQL applications
Application programs can access UDS/SQL databases using SQL.
When an SQL program processes database key values, a check must be performed to determine if the database keys involved are of type DATABASE-KEY-LONG. If this is the case, the fields of the host language in which the database key values are to be accepted must be of type CHARACTER(8).
Primary and foreign key attributes are unaffected by conversions and retain their INTEGER type.
Adapting IQS and KDBS applications
As in the case of CALL DML and COBOL DML applications, even applications of the interactive system IQS and the compatible database interface UDS-KDBS must be checked to determine whether database key items are directly accessed within them.
If an application accesses a database key item of type DATABASE-KEY-LONG, the related data fields in the application must be adapted with respect to the data type and the supplied values.