Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [%SYS] >  [%XSQL] >  [Catalog] >  [Informix] >  [syscolumns]
Private  Storage   

persistent class %XSQL.Catalog.Informix.syscolumns extends %Persistent

Contains one row for every column in every table and view, and a row for each parameter in a stored procedure.

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
1 9 1


Summary

Properties
colname colno coltype maxlen tabid

Methods
%AddToSaveSet %AddToSyncSet %CheckConstraints %CheckConstraintsForExtent
%ClassIsLatestVersion %ClassName %ComposeOid %ConstructClone
%Delete %DeleteExtent %DeleteId %DispatchClassMethod
%DispatchGetModified %DispatchGetProperty %DispatchMethod %DispatchSetModified
%DispatchSetMultidimProperty %DispatchSetProperty %Exists %ExistsId
%Extends %GUID %GUIDSet %GetLock
%GetParameter %GetSwizzleObject %Id %IsA
%IsModified %IsNull %KillExtent %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PurgeIndices %Reload %RemoveFromSaveSet %ResolveConcurrencyConflict
%RollBack %Save %SaveDirect %SerializeObject
%SetModified %SortBegin %SortEnd %SyncObjectIn
%SyncTransport %UnlockExtent %UnlockId %ValidateIndices
%ValidateObject


Parameters

• parameter READONLY = 1;
READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

• property colname as %String(MAXLEN=128);
Name of the column
• property colno as %SmallInt [ Transient ];
Column number sequentially assigned by the system (from left to right within each table)
• property coltype as %SmallInt [ Transient ];
Code (identifier) for column data type: 0 = CHAR 14 = INTERVAL 1 = SMALLINT 15 = NCHAR 2 = INTEGER 16 = NVARCHAR 3 = FLOAT 17 = INT8 4 = SMALLFLOAT 18 = SERIAL8* 5 = DECIMAL 19 = SET 6 = SERIAL* 20 = MULTISET 7 = DATE 21 = LIST 8 = MONEY 22 = ROW 9 = NULL 23 = COLLECTION 10 = DATETIME 24 = ROWREF 11 = BYTE 40 = Variable-length opaque type 12 = TEXT 41 = Fixed-length opaque type 13 = VARCHAR 4118 = Named row type
• property maxlen as %Integer;
Maximum column length (in bytes)
• property tabid as %Integer;
Object ID of the table to which this column belongs

Indices

•index (IDKEYIndex on tabid,colid) [IdKey,Unique];


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.