Home > Class Reference > ENSLIB namespace > %Library.SQLConnection
Private  Storage   

%Library.SQLConnection


persistent class %Library.SQLConnection extends %Persistent, %XML.Adaptor

SQL Table Name: sys_SQLConnection

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
20 2 2 1


Summary


Properties
DSN Name ReverseOJ URL
Usr bUnicodeStream classpath driver
isJDBC needlongdatalen noconcat nodefq
nofnconv nvl properties pwd
useCAST useCASTCHAR useCOALESCE xadriver

Methods
%AddToSaveSet %AddToSyncSet %BMEBuilt %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
%InsertBatch %IsA %IsModified %IsNull
%KillExtent %KillExtentData %LoadFromMemory %LockExtent
%LockId %New %NormalizeObject %ObjectIsNull
%ObjectModified %Oid %OnBeforeAddToSync %OnDetermineClass
%Open %OpenId %OriginalNamespace %PackageName
%PhysicalAddress %PurgeIndices %Reload %RemoveFromSaveSet
%ResolveConcurrencyConflict %RollBack %Save %SaveDirect
%SaveIndices %SerializeObject %SetModified %SortBegin
%SortEnd %SyncObjectIn %SyncTransport %UnlockExtent
%UnlockId %ValidateIndices %ValidateObject ConnExists
XMLDTD XMLExport XMLExportToStream XMLExportToString
XMLNew XMLSchema XMLSchemaNamespace XMLSchemaType
setEncode


Properties


• property DSN as %String(CAPTION="DSN",MAXLEN=256);
• property Name as %String(CAPTION="Connection Name") [ SqlFieldName = Connection_Name,Required ];
• property ReverseOJ as %Boolean(CAPTION="Legacy Sybase outer join syntax");
• property URL as %String(CAPTION="URL",MAXLEN=4096);
• property Usr as %String(CAPTION="User");
• property bUnicodeStream as %Boolean(CAPTION="Supports Unicode Streams") [ InitialExpression = 1 ];
• property classpath as %Library.String(CAPTION="Class Path",MAXLEN=4096);
• property driver as %String(CAPTION="driver",MAXLEN=256);
• property isJDBC as %Boolean(CAPTION="Is JDBC connection");
• property needlongdatalen as %Boolean(CAPTION="Needs long data length");
• property noconcat as %Boolean(CAPTION="Do not generate {fn concat()}");
• property nodefq as %Boolean(CAPTION="Do not use delimited identifiers by default");
• property nofnconv as %Boolean(CAPTION="Do not generate {fn conv ...} by default");
• property nvl as %Boolean(CAPTION="Use NVL() instead of IFNULL()");
• property properties as %Library.String(CAPTION="Properties",MAXLEN=256);
• property pwd as %CSP.Util.Passwd(CAPTION="Password");
• property useCAST as %Boolean(CAPTION="Use CAST as VARCHAR");
• property useCASTCHAR as %Boolean(CAPTION="Use CAST as CHAR");
• property useCOALESCE as %Boolean(CAPTION="Use COALESCE") [ InitialExpression = 1 ];
• property xadriver as %String(CAPTION="driver",MAXLEN=256);

Methods


• classmethod ConnExists(nm As %String) as %Boolean
• method setEncode(val As %Boolean)

Queries


• query ByConnection()
Selects Connection_Name, DSN, User, ID
SQL Query :
SELECT Connection_Name, DSN, usr, %ID
FROM %Library.sys_SQLConnection
WHERE Connection_Name is not null
ORDER BY Connection_Name
Lookup by Connection name without input parameter
• query ByName(name As %String = "")
Selects Connection_Name, DSN, User, ID, isJDBC
SQL Query :
SELECT Connection_Name, DSN, usr, %ID, isJDBC
FROM %Library.sys_SQLConnection
WHERE Connection_Name %STARTSWITH %ALPHAUP(:name)
ORDER BY Connection_Name
Lookup by Connection name

Indices


•index (NameIndex on Name) [Unique];
Index for property Name