The CICS® DB2® task-related user exit, DFHD2EX1, is enabled with the FORMATEDF keyword and is called by CICS to format the screen for SQL API requests when the transaction is being run under EDF.
In EDF mode, the CICS DB2 attachment facility:
An EDF panel displays a maximum of 55 variables, which is about ten screens. Each EDF SQL session requires 12KB of CICS temporary storage, which is freed on exit from EDF.
EDF screens for SQL statements are shown in Figure 51, and Figure 52.
TRANSACTION: XC05 PROGRAM: TESTC05 TASK:0000097 APPLID: CICS41 DISPLAY:00 STATUS: ABOUT TO EXECUTE COMMAND EXEC SQL OPEN DBRM=TESTC05, STMT=00221, SECT=00001 OFFSET: X'001692' LINE: UNKNOWN EIBFN=X'0E0E' ENTER: PF1 : UNDEFINED PF2 : UNDEFINED PF3 : UNDEFINED PF4 : PF5 : PF6 : PF7 : PF8 : PF9 : PF10: PF11: UNDEFINED PF12:
TRANSACTION: XC05 PROGRAM: TESTC05 TASK:0000097 APPLID: CICS41 DISPLAY:00 STATUS: COMMAND EXECUTION COMPLETE CALL TO RESOURCE MANAGER DSNCSQL EXEC SQL OPEN P.AUTH=SYSADM , S.AUTH= PLAN=TESTC05, DBRM=TESTC05, STMT=00221, SECT=00001 SQL COMMUNICATION AREA: SQLCABC = 136 AT X'03907C00' SQLCODE = -923 AT X'03907C04' SQLERRML = 070 AT X'03907C08' SQLERRMC = ' ACCESS,00000000,00000000, '... AT X'03907C0A' SQLERRP = 'DSNAET03' AT X'03907C50' SQLERRD(1-6) = 000, 000, 00000, 0000000000, 00000, 000 AT X'03907C58' SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _' AT X'03907C70' SQLSTATE = 57015 AT X'03907C7B' OFFSET: X'001692' LINE: UNKNOWN EIBFN=X'0E0E' ENTER: CONTINUE PF1 : UNDEFINED PF2 : UNDEFINED PF3 : END EDF SESSION PF4 : SUPPRESS DISPLAYS PF5 : WORKING STORAGE PF6 : USER DISPLAY PF7 : SCROLL BACK PF8 : SCROLL FORWARD PF9 : STOP CONDITIONS PF10: PREVIOUS DISPLAY PF11: UNDEFINED PF12: ABEND USER TASK