× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 in
System i Navigator without an error. [ LABEL ON COLUMN
schema.table.column IS "Field Label" ] also Runs in System i Navigator
without an error.

But neither change COLUMN_TEXT.

System i Navigaotr 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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.