Base Table (-basetable)

Use Base Table (-basetable) with Table Range Size (-tablerangesize) to specify the range of tables for which you want to collect statistics.

Operating system and syntax UNIX / Windows -basetable n
Use with Maximum value Minimum value Single-user default Multi-user default
Database Server 32767 -32767 1
n
The starting table number in the range of tables for which you want to track access statistics.

Access to the statistics is handled through the Virtual System Tables (VSTs). Table statistics are stored in the _TableStat VST. To obtain table numbers, use the following ABL code:

FOR EACH _file:
  DISPLAY _file._file-num _file._file-name.
END. 

Running the preceding code results in the following output:

_File-Number  File-Name
     n1     table name1
     n2     table name2
     n3     table name3 

For more information on virtual system tables, see Manage the OpenEdge Database.