×
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.
I have become used to using SYSCOLUMNS & SYSTABLES in QSYS2 to analyse
aspects of an applications data base because files created via DDS & tables
created through DDL both have their meta-data recorded there.
I recently thought I'd use SYSINDEXES & SYSKEYS (for the first time ever for
me) to do some other analysis and realized that DDS defined keys are not
present in these files. I realize that a LF is a hybrid beast and shows
traits of both a view and an index, but it seems a bit extreme to completely
exclude DDS generated entities from some of the system catalog files, but
not others.
Does anyone have a link to a definitive document which details this grey
area of DDS & DDL overlap in the system catalog, or can provide a comment on
the above?
Thanks,
Mike Pantzopoulos
0403 809 442 (mob)
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
