Why are the column names missing on the "Detector SQL Error Call Text" display?

book

Article ID: 125711

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

This document states why are column names may be missing on the "Detector SQL Error Call Text" display.

Why are the column names missing on the "Detector SQL Error Call Text" display?

Environment

z/OS 1.11 and above.

Resolution

The names in question were defined both as columns in the CREATE TABLE statement & as SQL variables in the CREATE PROCEDURE statement. DB2 views them as "SQL variables" (host variables) in the SQL text.