|
| 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
|
|
|
|
|
|
|
|
|
|