|
IRISLIB database
|
|
|
IRISLIB database
|
|
sysindexes contains one row for each clustered index (IDKey index), one row for each nonclustered index (all other indexes), one row for each table that has no clustered index, and one row for each table that contains text or image columns. More...
Public Attributes | |
| doampg | |
| Page number for the object allocation map of a table. More... | |
| id | |
| ID of a table, or ID of table to which index belongs. More... | |
| indexfields | |
| List of fields in the index. More... | |
| indid | |
| 0 if a table; 1 if a clustered index on an allpages-locked table; More... | |
| ioampg | |
| Page number for the allocation map of an index or (LOB structure) More... | |
| keycnt | |
| Number of keys for a clustered index on an allpages-locked table; number of keys, plus 1 for all other indexes. More... | |
| name | |
| Index or table name. More... | |
| parentobjname | |
| Parent Object name. More... | |
| schema | |
| Name of the schema the column resides in. More... | |
| status | |
| Internal system status information. More... | |
| status2 | |
| Internal system status information. More... | |
Additional Inherited Members | |
 Public Member Functions inherited from Persistent | |
| _.Library.Status | AcquireLock (_.Library.String locktype) |
| Acquires a lock for the current instance. More... | |
| _.Library.Status | LoadData (_.Library.String id) |
| LoadData() - loads an object from storage. More... | |
| _.Library.Status | OnAfterSave (_.Library.Boolean insert) |
| This callback method is invoked by the <METHOD>Save</METHOD> method to. More... | |
| _.Library.Status | OnBeforeSave (_.Library.Boolean insert) |
| This callback method is invoked by the <METHOD>Save</METHOD> method to. More... | |
| _.Library.Status | OnOpen () |
| This callback method is invoked by the <METHOD>Open</METHOD> method to. More... | |
| _.Library.Status | OnReload () |
| This callback method is invoked by the <METHOD>Reload</METHOD> method to. More... | |
| _.Library.Status | OnRollBack () |
| This callback method is invoked by the <METHOD>Save</METHOD> method to. More... | |
| _.Library.Status | ReleaseLock (_.Library.String locktype) |
| Releases a lock for the current instance. More... | |
| _.Library.Status | SaveData (_.Library.String id) |
| SaveData() - saves an object to disk, checks uniqueness and referential More... | |
| Public Member Functions inherited from SwizzleObject | |
| _.Library.Status | OnJournalObject (_.Library.Integer tranid, _.Library.Integer jrnid, _.Library.String filter) |
| This callback method is invoked by the <METHOD>JournalObject</METHOD> method to. More... | |
| Public Member Functions inherited from RegisteredObject | |
| _.Library.Status | OnAddToSaveSet (_.Library.Integer depth, _.Library.Integer insert, _.Library.Integer callcount) |
| This callback method is invoked when the current object is added to the SaveSet,. More... | |
| _.Library.Status | OnClose () |
| This callback method is invoked by the <METHOD>Close</METHOD> method to. More... | |
| _.Library.Status | OnConstructClone (_.Library.RegisteredObject object, _.Library.Boolean deep, _.Library.String cloned) |
| This callback method is invoked by the <METHOD>ConstructClone</METHOD> method to. More... | |
| _.Library.Status | OnNew () |
| This callback method is invoked by the <METHOD>New</METHOD> method to. More... | |
| _.Library.Status | OnValidateObject () |
| This callback method is invoked by the <METHOD>ValidateObject</METHOD> method to. More... | |
| Static Public Member Functions inherited from Persistent | |
| _.Library.Status | DeleteData (_.Library.String id, _.Library.Integer concurrency) |
| This method is normally generated by the storage class for persistent classes using. More... | |
| _.Library.Status | KillExtentData (_.Library.Boolean killstreams) |
| KillExtentData() - kills extent data in storage. More... | |
| _.Library.Status | OnAfterBuildIndices (_.Library.String indexlist) |
| This callback method is invoked by the <METHOD>BuildIndices</METHOD> method after all work is completed. More... | |
| _.Library.Status | OnAfterDelete (_.Library.ObjectIdentity oid) |
| This callback method is invoked by the <METHOD>Delete</METHOD> method to. More... | |
| _.Library.Status | OnAfterPurgeIndices (_.Library.String indexlist) |
| This callback method is invoked by the <METHOD>PurgeIndices</METHOD> method after all work is completed. More... | |
| _.Library.Status | OnBeforeBuildIndices (_.Library.String indexlist) |
| _.Library.Status | OnBeforePurgeIndices (_.Library.String indexlist) |
| _.Library.Status | OnDelete (_.Library.ObjectIdentity oid) |
| This callback method is invoked by the <METHOD>Delete</METHOD> method to. More... | |
| Static Public Attributes inherited from Persistent | |
| XCOMPACTANCESTRY | |
| XCOMPACTANCESTRY can be set to a string to replace the value of the %CLASSNAME property (x__classname field) More... | |
| DATALOCATIONGLOBAL = None | |
| Global name containing master map data for this class. More... | |
| DEFAULTGLOBAL = None | |
| DSCONDITION = None | |
| DSCONDITION is the expression that will be evaluated before deciding whether certain actions must be taken. More... | |
| DSINTERVAL = None | |
| DSINTERVAL is the number of seconds between one DSTIME value and the next. More... | |
| DSTIME = None | |
| If the DSTIME parameter is set to AUTO then the most recent filing operation in the current DSTIME value. More... | |
| EXTENTQUERYSPEC = None | |
| The EXTENTQUERYSPEC parameter defines the properties to be retrieved in. More... | |
| EXTENTSIZE = None | |
| The EXTENTSIZE parameter is used to inform the SQL Query Optimizer More... | |
| GUIDENABLED = None | |
| If this parameter is set to 1 then a GUID will be assigned (to the GUID property) to each new object. More... | |
| IDENTIFIEDBY = None | |
| The IDENTIFIEDBY parameter can optionally be set to the name. More... | |
| MANAGEDEXTENT = None | |
| The MANAGEDEXTENT parameter can be set to 0 (zero) to cause the Extent Manager. More... | |
| READONLY = None | |
| READONLY = 1 means that objects can be created, opened but not saved or deleted. More... | |
| ROWLEVELSECURITY = None | |
| ROWLEVELSECURITY = 1 | <property> means that row level security is active and the list More... | |
| SQLPREVENTFULLSCAN = None | |
| SQLPREVENTFULLSCAN = 1 means an attempt to prepare a query that will result in a full scan More... | |
| STORAGEDEFAULT = None | |
| STORAGEDEFAULT defines the default storage allocation to use for properties in this class. More... | |
| USEEXTENTSET = None | |
| VERSIONCLIENTNAME = None | |
| VERSIONCLIENTNAME can be set to a valid CLIENTNAME (see property CLIENTNAME) value. More... | |
| VERSIONPROPERTY = None | |
| VERSIONPROPERTY = <property> means that the <property> in memory will be compared to. More... | |
| Static Public Attributes inherited from SwizzleObject | |
| DEFAULTCONCURRENCY = None | |
| DEFAULTCONCURRENCY is the default value for the concurrency formal argument. More... | |
| JOURNALSTREAM = None | |
| If OBJJOURNAL is true then the value of the JOURNALSTREAM parameter defines whether or not. More... | |
| OBJJOURNAL = None | |
| if OBJJOURNAL is TRUE then inserts, updates and deletes will be logged in ^OBJ.JournalT More... | |
| Static Public Attributes inherited from RegisteredObject | |
| CAPTION = None | |
| Optional name used by the Form Wizard for a class when generating forms. More... | |
| JAVATYPE = None | |
| The Java type to be used when exported. | |
| PROPERTYVALIDATION = None | |
| This parameter controls the default validation behavior for the object. More... | |
sysindexes contains one row for each clustered index (IDKey index), one row for each nonclustered index (all other indexes), one row for each table that has no clustered index, and one row for each table that contains text or image columns.
| doampg |
Page number for the object allocation map of a table.
| id |
ID of a table, or ID of table to which index belongs.
| indexfields |
List of fields in the index.
NULL for indid = 0 and 255
| indid |
0 if a table; 1 if a clustered index on an allpages-locked table;
>1 if a nonclustered index or a clustered index on a data-only-locked table; 255 if text, image or Java off-row structure (LOB structure)
| ioampg |
Page number for the allocation map of an index or (LOB structure)
| keycnt |
Number of keys for a clustered index on an allpages-locked table; number of keys, plus 1 for all other indexes.
| name |
Index or table name.
| parentobjname |
Parent Object name.
Object name of the parent_obj.
| schema |
Name of the schema the column resides in.
| status |
Internal system status information.
Decimal Hex Status 1 0x1 Index supports foreign key constraint 2 0x2 Index supports primary key/unique declarative constraint 4 0x4 Index includes an IDENTITY column 8 0x8 Constraint name not specified 16 0x10 Large I/Os (prefetch) not enabled for table, index, or text chain 32 0x20 MRU cache strategy not enabled for table, index, or text chain 64 0x40 Ascending inserts turned on for the table 256 0x0100 Index is presorted and does not need to be copied to new extents 512 0x0200 Table is a data-only-locked table with a clustered index 8192 0x2000 Index on a data-only-locked table is suspect
| status2 |
Internal system status information.
Decimal Hex Status 1 0x1 Abort current command or trigger if attempt to insert duplicate key 2 0x2 Unique index 4 0x4 Abort current command or trigger if attempt to insert duplicate row; always 0 for data-only-locked tables 16 0x10 Clustered index 64 0x40 Index allows duplicate rows, if an allpages-locked table; always 0 for data-only-locked tables 128 0x80 Sorted object; not set for tables without clustered indexes or for text objects 512 0x200 sorted data option used in create index statement 2048 0x800 Index on primary key 32768 0x8000 Suspect index; index was created under another sort order
1.9.1