System table Name

[never]

Hi all,
sorry to disturbing all but...Can somebody to help me!!
I need write script for DB2 but I haven't access now to this DB that I look for this trivial problem.
So..I need find out name of system table where is stored names of all schema. In the concrete i need show all name of tables in some schema.

THX a lot
Never

 

[suesloan]

In Lotusscript you can access an open table in your Approach application in two ways. 1) Use the table name or 2) use the table number relative to zero. The tables are listed in order in the File - Approach File properties part of your application.

You can also access databases that are not opened by your Approach file using SQL. There are some examples of how to do this in the Approach script help and in the SmartMasters that come with Approach.

Sue Sloan

http://www.xpertss.com