Re: sysibm.sqlcolumns column_text

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Rob

I suggest you do NOT use the SYSIBM views - SYSIBM is an ODBC/JDBC 
thing, according to the landscape PDF I referred to in another post, and 
I believe IBM i has things not defined or looked for in ODBC/JDBC

Use, instead, QSYS2.SYSCOLUMNS - there you have COLUMN_HEADING and 
COLUMN_TEXT - the former is the 3-part column heading thing - 3 
segments, 20 long each

Have you looked at the documentation for the IBM i flavor of DB2 to find 
out what LABEL ON variations there are? And what COMMENT ON does? I 
think the latter is that long comment attribute in either of the views - 
I've never used it, it is not an IBM i thing that I recall.

You want LABEL ON column-name - if you use just that, you change the 
column heading

If you use LABEL ON column-name TEXT - you change the column text - 
LABEL ON does touch column_text

HTH - and please note that SQL* views are not specific to IBM i - SYS* 
views are specific to IBM i and have more information

Cheers
Vern

On 11/30/2015 4:47 PM, Rob wrote:
> Via System i Navigator...
>
> I run [ select * from sysibm.sqlcolumns ].  I can see the column_text 
> field.  There is text in this field.
>
> "comment on" and "label on" do not touch it...
>
> [ select table_schem, table_name, remarks, table_text from 
> sysibm.sqltables ]
>
> sysibm.sqltables has remarks and table_text.   COMMENT ON TABLE 
> schema.table IS "Table Comment" changes REMARKS and LABEL ON TABLE 
> schema.table IS "Table Label" changes TABLE_TEXT.
>
> COMMENT ON COLUMN schema.table.column IS "Field Comment" Runs ins 
> System i Navigator without an error. LABEL ON COLUMN 
> schema.table.column IS "Field Label" also Runs ins System i Navigator 
> without an error.
>
> But neither change COLUMN_TEXT.
>
> WebSmart also shows a Heading1 column...  which is the same as 
> column_text.  But it does not show up in a select *.
>
> I want to give my admins the ability to update the Remarks and Texts 
> to better describe the tables and fields.
>
> So thus far I can display and change a Tables Remarks and Table_Text 
> fields.
>
> But I can only display a Fields Column_Text.  I can not update it. And 
> I have no idea what Comment ON and Label ON have done to the table and 
> column I tried to update, even though the executed SQL was reported to 
> have ran successfully.
>
> I need one of you genius detectives on this case to solve the mystery.
>
> Thanks,
> Rob
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus