Groups > DB2 > DB2 on AS400 server > Re: Is it possible to update the iSeries Catalog Tables?




Is it possible to update the iSeries Catalog Tables?

Is it possible to update the iSeries Catalog Tables?
Tue, 08 Apr 2008 10:44:26 EDT
Hi. I am currently modernizing several iSeries applications. First step:
document the data dictionary.<br />
So I am wondering if it is possible to update the iSeries Catalog Tables from an
external program, say Excel. This is because I have gathered that info in Excel
sheets and I have a VBA application that reads the iSeries Catalog views in
order to generate documentation and now I want to write that info in the
catalog.<br />
In particular, I want to update the TABLE_TEXT column from SYSTABLES and the
COLUMN_TEXT column from SYSCOLUMNS.<br />
Any privileges issues?<br />
<br />
Post Reply
Re: Is it possible to update the iSeries Catalog Tables?
Wed, 09 Apr 2008 07:44:22 -050
If I were doing it I'd probably use the SQL "LABEL" statement rather 
than trying to go directly to the catalog. The SQL Reference manual 
lists the authorizations necessary and describes when to use "TEXT IS"

vs "IS" and all the other variations.

-Stevers

luisantoniosalazar@gmail.com wrote:
> In particular, I want to update the TABLE_TEXT column from SYSTABLES and
the COLUMN_TEXT column from SYSCOLUMNS.<br />
Post Reply
Re: Is it possible to update the iSeries Catalog Tables?
Fri, 11 Apr 2008 18:31:36 EDT
Post Reply
about | contact