TABLE

Syntax

Example

Description/Remarks

TABLE "table_type"

TABLE "VDATA"

This command returns the table name specified in the current configuration for the table_type you specify.

Valid table_type parameters are:

ACTIONCA	MFILTER
AUDITTRL	PLAN_VAL
CAUSE	PLAN_AUX
DASHDT	REPORT
DASHRET	SCHFILE
DASHSW	SESSION
DDATA	SFILTER
DDAT_AUX	STATLIST
DDT	TEMPLATE
DESKTOP	TRACEMST
DFILTER	TRPRIMST
DMDL	UDL1
DNOTE	UDL2
DPRI	UDL3
DPRI_DT	UDL4
DPROC	UDL5
DPROCDL	UDL6
DSTATS	VDATA
DSTDS	VDAT_AUX
EVENT	VMON
EVENTCA	VMON_AUX
FILTER	VNOTE
HSICFG	VPRI
HSIRPT *	VPRI_DT
HSIUC	VSTDS

* Note: If you perform SQL queries on the HSIRPT table, do not try to access the HSIFILE column in this table. Limitations of the database access method used by SPC Data Entry will make the program crash if it tries to access this column.

The table_type must be from the list or the command will return "TABLE_NAME_ERROR".

For systems using Btrieve or Pervasive databases, the command will return the entire file path and name of the data file. For other databases, the command will return the table name.

See Tables Used in GainSeeker 8 for a description of each table.