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

Document ID : KB000125711
Last Modified Date : 01/02/2019
Show Technical Document Details
Introduction:
This document states why are column names may be missing on the "Detector SQL Error Call Text" display.
Question:
Why are the column names missing on the "Detector SQL Error Call Text" display?
Environment:
z/OS 1.11 and above.
Answer:
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.