Disclaimer : I am fairly new to DB2.
Problem: I am looking at
which indicates sqltype for CHAR columns should be 452/453.
and my inquiry against Sysibm.syscolumns for the table in question shows type=char for the column in question.
But my SQLDA info in a COBOL application indicates SQLTYPE=448 (which is varchar). My code is handling SQLLEN wrong (i.e. 00128) instead of whatever method is needed in this situation (obvious DB2 knows it's a char and not a varchar).
Any advice here?
The column was defined as
"USER" char(4) NOT NULL
I assume this has something to do with the double-quotes required by the reserved-name.
Please know that this is not my DB2 system, and it is not an option to "stop using USER as a column name".
Thanks in advance,
Mike in the UK