Wasn't there a command front end, maybe even IBM supplied, for the
"Generate Data Definition Language (QSQGNDDL) API"?
I might be thinking about GENDOC, which the only relation that has
is an applicable verb.
CRPence on 09/04/2013 11:44 AM wrote:
On 03 Sep 2013 14:53 Hoteltravelfundotcom wrote:
I have a VIEW but was written now some weeks back. I would like
to see the actual code that created this view.
The definition of the VIEW, the CREATE statement, is stored in the
*FILE object. That information is available from the DSPFD
command, the Retrieve Database File Description (QDBRTVFD) API, and
the Generate Data Definition Language (QSQGNDDL) API. That
statement is also reflected in the *DBXREF data, so that same
information can come from the SQL Catalog as well; e.g. SYSVIEWS.
Any interface that exposes that information from either the file
object or the catalogs, can provide the information in various
other forms; e.g. iNav Database.
As others have suggested, getting the definition from the current
object [or from the catalogs which should reflect the current object]
is probably best.
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact