CICS SQLCA formatting routine

DSNTIAR, the IBM® -supplied SQLCODE message formatting procedure, lets you send "SQL messages online" to your application.

With DB2 Version 3 Release 1, DSNTIAR was split into two front-end modules (DSNTIAC and DSNTIAR) and a run-time module (DSNTIA1). DSNTIAC is used for CICS applications and DSNTIAR for other DB2 interfaces. This change removed the need, previous to DB2 3.1, to relink-edit your application modules every time a change is made to DSNTIAR, either by change of release or by applying maintenance. If you have applications that have previously been link-edited with DSNTIAR, you should consider link-editing them again using DSNTIAC instead, which will provide performance improvements and isolate them from changes to DSNTIAR.

The CICS front-end part, DSNTIAC, is supplied as a source member in the DB2 library SDSNSAMP.

The necessary program definitions for DSNTIAC and DSNTIA1 are provided in IBM supplied group DFHDB2 on the CSD. You must add the SDSNLOAD library to the CICS DFHRPL concatenation (after the CICS libraries) so that DSNTIA1 can be loaded.



dfhtk23.html | Timestamp icon Last updated: Monday, 5 June 2017