Ansicht
Dokumentation

RSINF029 - INFORMIX Tables Information (from systables)

Addresses (Business Address Services)   Vendor Master (General Section)  
Diese Dokumentation steht unter dem Copyright der SAP AG.

Beschreibung

INFORMIX System Monitoring Interface Tables

systables (Table Information)

Column Type Description

tabname CHAR(18) Name of table, view, or synonym

owner CHAR(8) Owner of table(user informix for system
catalog tables and user name for database
tables)

partnum INTEGER Tblspace identifier (similar to tabid)

tabid SERIAL System-assigned sequential ID number
(sytem tables 1-24, user tables 100-nnn)

rowsize SMALLINT Row size

ncols SMALLINT Number of columns

nindexes SMALLINT Number of Indexes

nrows INTEGER Number of rows

created DATE Date created

version INTEGER Number that changes when table is altered

tabtype CHAR(1) Table Type:
T = Table
V = View
P = Private Synonym
P = Synonym(in an ANSI compliant db)
S = Synonym

locklevel CHAR(1) Lock mode for a table:
B = Page
P = Page
R = Row

npused INTEGER Number of data pages in used

fextsize INTEGER Size of initial extent in kilobytes

nextsize INTEGER Size of all subsequent extents in
kilobytes

flags SMALLINT Reserved for future use

site CHAR(18) Reserved for future use in online (use to
store NLS data in NLS databases)

dbname CHAR(18) Reserved for future use

Voraussetzungen

Ausgabe

Beispiel

PERFORM Short Reference   General Material Data  
Diese Dokumentation steht unter dem Copyright der SAP AG.

Length: 2358 Date: 20240531 Time: 144156     sap01-206 ( 20 ms )