Re: Documentation of SQL*Forms (3.0) Applications

From: Veikko Visala <vvisala_at_pcuf.fi>
Date: Thu, 30 Sep 1993 13:09:52 GMT
Message-ID: <CE64LC.A5z_at_pcuf.fi>

I suppose we have developed a tool you are looking for. Our tool checks also the code of referenced procedures. Program is written in C and is at the moment running on PC/MS-DOS environment HP 9000 Unix-version is available soon.

---

Here is an example of program output :

---

Report of tables used in each SQL*Forms program PROGRAM1.INP:

                    USER1.TABLE1        Read    Base
                    USER1.TABLE2        Read
PROGRAM2.INP:
                    USER1.TABLE1        Read    Base
PROGRAM3.INP:
                    USER2.TABLE2        Read    Base
PROGRAM4.INP:
                    USER1.TABLE1        Read    Read    Base
                    USER1.TABLE2        Read
                    USER1.TABLE3        Insert  Update
                    USER1.TABLE4        Read    Delete
                    USER2.TABLE2        Read
                    SYSTEM.DUAL         Read    

  ...
Report of table usage in SQL*Forms programs ALL_USERS:

                    PROGRAM1.INP        Read
USER1.TABLE1:
                    PROGRAM1.INP        Read    Base
                    PROGRAM3.INP        Read
                    PROGRAM4.INP        Read
                    PROGRAM5.INP        Read
USER1.TABLE2:
                    PROGRAM2.INP        Read    Base
                    PROGRAM3.INP        Read
USER1.TABLE3:
                    PROGRAM3.INP        Read    Base
USER1.TABLE4:
                    PROGRAM4.INP        Read
                    PROGRAM5.INP        Read    Base
                    PROGRAM6.INP        Read    Update

..

---

Please contact us for further details.
####################################################################

  #                        Veikko Visala                             #
  #  Addr : Mikrolinna Oy               net : vvisala_at_pcuf.fi        #
  #         Sibeliuksenkatu 5 A 3 krs   tel : +358 17 6121 151       #
  #         13100 Hameenlinna           fax : +358 17 6121 545       #
  #         Finland                                                  #


  ####################################################################

Received on Thu Sep 30 1993 - 14:09:52 CET