IBM Books

Cursor Name


Snapshot Information Level
Application

API Structure(s)
sqlm_appl
sqlm_stmt

Monitor Group
Statement
Statement

Resettable

No

 

Event Information Level
Statement

API Structure(s)
sqlm_stmt_event

 

API Element Name
Element Type

cursor_name
information

 

Description:  The name of the cursor corresponding to this SQL statement.

Usage:  You may use this element to identify the SQL statement that is processing when "Statement Text" is blank (that is, for static SQL). This name will be used on an OPEN, FETCH, CLOSE, and PREPARE of an SQL SELECT statement. If a cursor is not used, this field will be blank.

If you are using the database system monitor APIs, note that the API constant sqlm_ident_sz is used to define the length of this element. Only the first 8 characters are currently used.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]