Viewing SQLCODEs View SQLCODES for the Db2® subsystems monitored by your Query Monitor subsystem. About SQLCODEsThe SQL Communication Area (SQLCA) is a data structure that provides information about the success or failure of requested SQL statements. When Db2® processes an SQL statement in a program, it lists return codes in the SQLCODE and SQLSTATE host variables or corresponding fields of the SQLCA. Grouping SQLCODE informationYou can group SQLCODE information to help you locate problematic SQL activity. Viewing SQLCODE information with no groupingYou can view SQLCODE information without grouping it.Viewing details, SQLCA, and text for an SQLCODEYou can view detailed data captured for a specific SQLCODE. You can access both the SQL Communication Area (SQLCA) and the SQL text for the activity of interest.Parent topic: Using the ISPF interface