DT160I MESSAGE FOR SQL TYPE DSCRBINP within Detector

Products

• Detector for DB2 for z/OS

Issue/Introduction

Is the Detector for Db2 for z/OS PDT) DT160I RELATED SQL CALL TEXT COULD NOT BE LOCATED message expected for SQL CALL type DSCRBINP?

Resolution

Retrieval of SQL text is currently not supported for certain SQL types which include but are not limited to the following:

ALOC CSR - ALLOCATE CURSOR
ASCLOCTR - ASSOCIATE LOCATORS
CLSALCCR - CLOSE ALLOC CURSOR
CONNT2 - TYPE2 CONNECT
CONNT2RS - TYPE2 CONNECT RESET
CONNT2TO - TYPE2 CONNECT TO
DSCRCSR - DESCRIBE CURSOR
DSCRPROC - DESCRIBE PROCEDURE
FETALCCR - FETCH ALLOC CURSOR
FREELCTR - FREE LOCATOR
HOLDLCTR - HOLD LOCATOR