Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
VARCHAR columns
1 view
Skip to first unread message
Jonathan Ball
Dec 8, 2010, 5:09:58 PM12/8/10
to
I was surprised to learn that SYSCOLUMNS doesn't contain a column to
show the allocated length of columns for variable length data, e.g.
VARCHAR. That seems like an important piece of information to know, and
the database catalog seems a likely place to try to find it.
show the allocated length of columns for variable length data, e.g.
VARCHAR. That seems like an important piece of information to know, and
the database catalog seems a likely place to try to find it.
CRPence
Dec 9, 2010, 7:59:09 PM12/9/10
to
I thought so too, but was told the ALLOCATE specification was not
stored in the catalog VIEWs of the other DB2 products nor in the ANS
standards, thus that information was similarly to be omitted from the
QADBIFLD tracking on iSeries\DB2 for i. Of course an API or DSPFFD can
retrieve that information if deemed necessary.
Regards, Chuck
0 new messages