×
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.
Patrik,
You could also do something like:
DMPOBJ library/filename *FILE
for the PF or LF for an SQL TABLE, INDEX or VIEW, and in that dump, search for the "associated space" and in there, you will find the SQL statements used to create the table, index or view -- (that 's where the QSQGNDDL API finds that stuff ...)
Also true for programs with embedded SQL -- after the SQL precompiler does its thing, and invokes the regular compiler, the compiled object will end up having the SQL statements stored in an associated space. For OPM *PGMs (SQLRPG or SQLCBL etc.) it will be in the "primary associated space" -- for ILE (SQLRPGLE or SQLCBLLE etc.) it will be in a secondary associated space -- each *MODULE has its own associated spaces.
You can also use STRSST to create a dump of these objects, to a spool file.
Mark
On Sunday, September 13, 2020, 2:03:10 PM EDT, Patrik Schindler <poc@xxxxxxxxxx> wrote:
Hello,
V4R5 lacks the SYSIBM collection as well as a DESCRIBE statement.
How can I retrieve the schema of a table in question?
Could not find anything helpful online. V4 is a bit dated. ;-)
Thanks!
:wq! PoC
PGP-Key: DDD3 4ABF 6413 38DE -
https://www.pocnet.net/poc-key.asc
midrange.com
