date: Thu, 17 Dec 2015 16:14:13 +0000
from: Justin Dearing <zippy1981@xxxxxxxxx>
subject: Displaying the contents of QSYS2.SYSTABLES.TABLE_TEXT
TL;DR: SYSTABLES.TABLE_TEXT is supposed to contain table labels. I know
this table has a label. I can't get strsql or sqlworkbench to display
anything in that field.
I have a query like so:
TABLE_SCHEMA AS OBJ_SCHEMA, TABLE_NAME AS OBJ_NAME,
WHEN 'P' THEN 'TABLE'
WHEN 'T' THEN 'TABLE'
WHEN 'L' THEN 'VIEW'
WHEN 'V' THEN 'VIEW'
END AS OBJ_TYPE,
TABLE_TEXT AS OBJ_TEXT
That's actually inside a CTE (window function) and the main query generates
some GENERATE_SQL() calls. I hope to post a polished version of this later.
TABLE_TEXT seems to always become an empty string, but if I run
GENERATE_SQL() on these tables, a LABEL statement gets generated.
The docs say the following about TABLE_TEXT:
TABLE_TEXTLABELVARGRAPHIC(50) CCSID 1200A character string provided with
the LABEL statement.
I tried the following, and still get no results:
CAST(TABLE_TEXT AS VARCHAR(25))
VARCHAR(TABLE_TEXT). I've used sqlworkbench, and strsql and the field is
always blank. I would figure the green screen would be more forgiving in
What am I doing wrong?