Home > Class Reference > %SYS namespace > Config.SQL

Config.SQL

persistent class Config.SQL extends %Library.Persistent, Config.CommonSingleMethods, Config.CommonProperties, %SYSTEM.Help

SQL Table Name: Config.SQL

This class allows you to modify and view the [SQL] section of the CPF file through programatic APIs. While properties are usually modified through the System Management portal, there may be some occasion where modifying them through the API's is best for your system. In all the Config methods, if you do not specify the CPFFile parameter, the currently active CPF file is used. If you wish to modify a CPF file which is not the currently active one, then specify the CPFFile you wish to modify in the method call.
The Flags parameter does not normally need to be specified; the defaults are usually sufficient for most cases.
You can use either the provided API's (Get/Modify) to modify the properties by passing in the correct parameters, or use Object sytax to open and directly manipulate the config objects.

EXAMPLE:

; Use class methods to modify properties
%SYS>s Status=##Class(Config.SQL).Get(.Properties)
%SYS>i 'Status w !,"Error="_$SYSTEM.Status.GetErrorText(Status)
%SYS>zw Properties("TCPKeepAlive")
Properties("TCPKeepAlive")=300
%SYS>s Properties("TCPKeepAlive")=200
%SYS>s Status=##Class(Config.SQL).Modify(.Properties)
%SYS>i 'Status w !,"Error="_$SYSTEM.Status.GetErrorText(Status)
; Now use Objects to modify properties
%SYS>s Obj=##Class(Config.SQL).Open()
%SYS>w Obj.TCPKeepAlive
200
%SYS>s Obj.TCPKeepAlive=300
%SYS>s Status=Obj.%Save()
%SYS>i 'Status w !,"Error="_$SYSTEM.Status.GetErrorText(Status)

Properties

property ANSIPrecedence as %Boolean [ InitialExpression = 0 , Required ];
Apply SQL92 operator precedence if this flag is set
Property methods: ANSIPrecedenceDisplayToLogical(), ANSIPrecedenceGet(), ANSIPrecedenceGetStored(), ANSIPrecedenceIsValid(), ANSIPrecedenceLogicalToDisplay(), ANSIPrecedenceLogicalToXSD(), ANSIPrecedenceNormalize(), ANSIPrecedenceSet(), ANSIPrecedenceXSDToLogical()
property AllowRowIDUpdate as %Boolean [ InitialExpression = 0 , Required ];
1 - The table compiler omits the checks to see if the RowID field(s) are being updated.
0 - The checks are performed.
Property methods: AllowRowIDUpdateDisplayToLogical(), AllowRowIDUpdateGet(), AllowRowIDUpdateGetStored(), AllowRowIDUpdateIsValid(), AllowRowIDUpdateLogicalToDisplay(), AllowRowIDUpdateLogicalToXSD(), AllowRowIDUpdateNormalize(), AllowRowIDUpdateSet(), AllowRowIDUpdateXSDToLogical()
property BiasQueriesAsOutlier as %Boolean [ InitialExpression = 0 , Required ];
Set to 1 if queries on fields with non-null outliers often refer to the outlier.
Property methods: BiasQueriesAsOutlierDisplayToLogical(), BiasQueriesAsOutlierGet(), BiasQueriesAsOutlierGetStored(), BiasQueriesAsOutlierIsValid(), BiasQueriesAsOutlierLogicalToDisplay(), BiasQueriesAsOutlierLogicalToXSD(), BiasQueriesAsOutlierNormalize(), BiasQueriesAsOutlierSet(), BiasQueriesAsOutlierXSDToLogical()
property Comment as %Boolean [ InitialExpression = 1 , Required ];
Set the flag that determines if embedded SQL statements are retained as comments in the .INT code version of the routine.
Property methods: CommentDisplayToLogical(), CommentGet(), CommentGetStored(), CommentIsValid(), CommentLogicalToDisplay(), CommentLogicalToXSD(), CommentNormalize(), CommentSet(), CommentXSDToLogical(), CommentsBuildValueArray(), CommentsCollectionToDisplay(), CommentsCollectionToOdbc(), CommentsDisplayToCollection(), CommentsDisplayToLogical(), CommentsGet(), CommentsGetObject(), CommentsGetObjectId(), CommentsGetStored(), CommentsGetSwizzled(), CommentsIsValid(), CommentsLogicalToDisplay(), CommentsLogicalToOdbc(), CommentsNormalize(), CommentsOdbcToCollection(), CommentsSet(), CommentsSetObject(), CommentsSetObjectId()
property DBMSSecurity as %Boolean [ InitialExpression = 1 , Required ];
Set the flag that determines if SQL security is enabled. If SQL security is ON, all Caché SQL security is active. This means: Each user must specify a valid username and password when logging in through ODBC (or by setting the %msql variable directly); Privilege-based table/view security is active, and the user may only perform actions on a table or view they have been granted access to. If SQL Security is off: Any user may access SQL through ODBC, and may be prompted for a username/password but will not be validated; Privilege-based table/view security is suppressed, and user's may perform actions on tables and views to which they have not been given access.
Property methods: DBMSSecurityDisplayToLogical(), DBMSSecurityGet(), DBMSSecurityGetStored(), DBMSSecurityIsValid(), DBMSSecurityLogicalToDisplay(), DBMSSecurityLogicalToXSD(), DBMSSecurityNormalize(), DBMSSecuritySet(), DBMSSecurityXSDToLogical()
property DDLDefineBitmapExtent as %Boolean [ InitialExpression = 1 , Required ];
Sets the flag which determines if a class created by a DDL CREATE TABLE statement defines a bitmap extent index for the class. This setting only applies to classes created through DDL that do not also define an explicit IdKey index. DDLDefineBitmapExtent=0 means a bitmap extent index will not be defined. DDLDefineBitmapExtent=1 means a bitmap extent index will be defined, if possible.
Property methods: DDLDefineBitmapExtentDisplayToLogical(), DDLDefineBitmapExtentGet(), DDLDefineBitmapExtentGetStored(), DDLDefineBitmapExtentIsValid(), DDLDefineBitmapExtentLogicalToDisplay(), DDLDefineBitmapExtentLogicalToXSD(), DDLDefineBitmapExtentNormalize(), DDLDefineBitmapExtentSet(), DDLDefineBitmapExtentXSDToLogical()
property DDLFinal as %Boolean [ InitialExpression = 1 , Required ];
Sets the flag which determines if a class created by a DDL CREATE TABLE statement is Final.
DDLFinal=0 means the class created by the statement will not be defined as Final
DDLFinal=1 means the class created by the statement will be defined as Final.
Property methods: DDLFinalDisplayToLogical(), DDLFinalGet(), DDLFinalGetStored(), DDLFinalIsValid(), DDLFinalLogicalToDisplay(), DDLFinalLogicalToXSD(), DDLFinalNormalize(), DDLFinalSet(), DDLFinalXSDToLogical()
property DDLNo201 as %Boolean [ InitialExpression = 0 , Required ];
Set the flag that determines if an SQLCODE -201 error is returned when an attempt is made to CREATE a previously existing table through DDL.
Property methods: DDLNo201DisplayToLogical(), DDLNo201Get(), DDLNo201GetStored(), DDLNo201IsValid(), DDLNo201LogicalToDisplay(), DDLNo201LogicalToXSD(), DDLNo201Normalize(), DDLNo201Set(), DDLNo201XSDToLogical()
property DDLNo30 as %Boolean [ InitialExpression = 0 , Required ];
Set the flag that determines if an SQLCODE -30 error is returned when an attempt is made to DROP a non-existing table through DDL.
Property methods: DDLNo307DisplayToLogical(), DDLNo307Get(), DDLNo307GetStored(), DDLNo307IsValid(), DDLNo307LogicalToDisplay(), DDLNo307LogicalToXSD(), DDLNo307Normalize(), DDLNo307Set(), DDLNo307XSDToLogical(), DDLNo30DisplayToLogical(), DDLNo30Get(), DDLNo30GetStored(), DDLNo30IsValid(), DDLNo30LogicalToDisplay(), DDLNo30LogicalToXSD(), DDLNo30Normalize(), DDLNo30Set(), DDLNo30XSDToLogical()
property DDLNo307 as %Boolean [ InitialExpression = 0 , Required ];
Set the flag that determines if an SQLCODE -307 error is returned when an attempt is made to a primary key constraint to a table through DDL, when a primary key constraint already exists for that table.
Property methods: DDLNo307DisplayToLogical(), DDLNo307Get(), DDLNo307GetStored(), DDLNo307IsValid(), DDLNo307LogicalToDisplay(), DDLNo307LogicalToXSD(), DDLNo307Normalize(), DDLNo307Set(), DDLNo307XSDToLogical()
property DDLNo311 as %Boolean [ InitialExpression = 0 , Required ];
Setting this parameter to 'Yes' allows you to ADD a foreign key through DDL even if one with the same name already exists. Setting this parameter to 'No' disallows this action and returns an error code.
Property methods: DDLNo311DisplayToLogical(), DDLNo311Get(), DDLNo311GetStored(), DDLNo311IsValid(), DDLNo311LogicalToDisplay(), DDLNo311LogicalToXSD(), DDLNo311Normalize(), DDLNo311Set(), DDLNo311XSDToLogical()
property DDLNo315 as %Boolean [ InitialExpression = 0 , Required ];
Set the flag that determines if an SQLCODE -315 error is returned when an attempt is made to DROP a non-existant constraint through DDL.
Property methods: DDLNo315DisplayToLogical(), DDLNo315Get(), DDLNo315GetStored(), DDLNo315IsValid(), DDLNo315LogicalToDisplay(), DDLNo315LogicalToXSD(), DDLNo315Normalize(), DDLNo315Set(), DDLNo315XSDToLogical()
property DDLNo324 as %Boolean [ InitialExpression = 0 , Required ];
Set the flag that determines if an SQLCODE -324 error is returned when an attempt is made to CREATE a previously existing index through DDL.
Property methods: DDLNo324DisplayToLogical(), DDLNo324Get(), DDLNo324GetStored(), DDLNo324IsValid(), DDLNo324LogicalToDisplay(), DDLNo324LogicalToXSD(), DDLNo324Normalize(), DDLNo324Set(), DDLNo324XSDToLogical()
property DDLNo333 as %Boolean [ InitialExpression = 0 , Required ];
Set the flag that determines if an SQLCODE -333 error is returned when an attempt is made to drop a non-existant index through DDL.
Property methods: DDLNo333DisplayToLogical(), DDLNo333Get(), DDLNo333GetStored(), DDLNo333IsValid(), DDLNo333LogicalToDisplay(), DDLNo333LogicalToXSD(), DDLNo333Normalize(), DDLNo333Set(), DDLNo333XSDToLogical()
property DDLSQLOnlyCompile as %Boolean [ InitialExpression = 0 , Required ];
1 - any class compilation performed as a result of executing a DDL statement will compile the class with the "q" (sqlonly) flag.
0 - the "q" flag is not used. This is the default.
Property methods: DDLSQLOnlyCompileDisplayToLogical(), DDLSQLOnlyCompileGet(), DDLSQLOnlyCompileGetStored(), DDLSQLOnlyCompileIsValid(), DDLSQLOnlyCompileLogicalToDisplay(), DDLSQLOnlyCompileLogicalToXSD(), DDLSQLOnlyCompileNormalize(), DDLSQLOnlyCompileSet(), DDLSQLOnlyCompileXSDToLogical()
property DDLUseSequence as %Boolean [ InitialExpression = 1 , Required ];
Sets the flag which determines if a class created by a DDL CREATE TABLE statement uses $Sequence for ID assignment. The storage keyword IDFUNCTION can be defined as INCREMENT or SEQUENCE. This keyword value is used by the class compiler to determine which system function - $increment or $sequence - is to be used for assigning new ID values for a persistent class using default storage. The default value for IDFUNCTION is INCREMENT, however the default behavior for classes defined through DDL is to define IDFUNCTION as SEQUENCE. To configure the system to have classes created through DDL to define IDFUNCTION as INCREMENT, define DDLUseSequence=0. To configure the system to have classes created through DDL to define IDFUNCTION as SEQUENCE, define DDLUseSequence=1.
Property methods: DDLUseSequenceDisplayToLogical(), DDLUseSequenceGet(), DDLUseSequenceGetStored(), DDLUseSequenceIsValid(), DDLUseSequenceLogicalToDisplay(), DDLUseSequenceLogicalToXSD(), DDLUseSequenceNormalize(), DDLUseSequenceSet(), DDLUseSequenceXSDToLogical()
property DefaultSchema as %String (MAXLEN = 128, MINLEN = 0) [ InitialExpression = "SQLUser" , Required ];
This setting provides the ability to define a default schema name other than SQLUser, the default. When an unqualified table name is encountered in an SQL statement (and there is no #import statement specified), the default schema will be used. You may specify _CURRENT_USER for the default schema name if you wish to use the SQL username the process logged in as the name of the default schema. If the process has not logged in to SQL, SQLUser will be used as the default schema name. You may also specify _CURRENT_USER/. In this case, if the process has not logged in to SQL, will be used as the default schema name. For example: _CURRENT_USER/HMO will use HMO as the default schema if the process has not logged in to SQL. This setting has nothing to do with the mappings between SQL schema names and the class package name, it only specifies the default schema.
Property methods: DefaultSchemaDisplayToLogical(), DefaultSchemaGet(), DefaultSchemaGetStored(), DefaultSchemaIsValid(), DefaultSchemaLogicalToDisplay(), DefaultSchemaLogicalToOdbc(), DefaultSchemaNormalize(), DefaultSchemaSet()
property DelimitedIds as %Boolean [ InitialExpression = 1 , Required ];
Set the flag that determines if double quotes (") in an SQL statement are used for delimited (quoted) identifiers or string constants. If "Yes", a double quoted string ("My String") will be considered an identifier within an SQL statement. If "No", a double quoted string ("My String") will be considered a string literal within an SQL statement.
Property methods: DelimitedIdsDisplayToLogical(), DelimitedIdsGet(), DelimitedIdsGetStored(), DelimitedIdsIsValid(), DelimitedIdsLogicalToDisplay(), DelimitedIdsLogicalToXSD(), DelimitedIdsNormalize(), DelimitedIdsSet(), DelimitedIdsXSDToLogical()
property DropDelete as %Boolean [ InitialExpression = 1 , Required ];
Set the flag that determines whether a DDL DROP TABLE statement deletes the table's data.
Property methods: DropDeleteDisplayToLogical(), DropDeleteGet(), DropDeleteGetStored(), DropDeleteIsValid(), DropDeleteLogicalToDisplay(), DropDeleteLogicalToXSD(), DropDeleteNormalize(), DropDeleteSet(), DropDeleteXSDToLogical()
property ECPSync as %Boolean [ InitialExpression = 0 , Required ];
When an SQL Select statement is executed, forces all pending ECP requests to the DB-server. On completion it guarantees that the client cache is in sync.
Property methods: ECPSyncDisplayToLogical(), ECPSyncGet(), ECPSyncGetStored(), ECPSyncIsValid(), ECPSyncLogicalToDisplay(), ECPSyncLogicalToXSD(), ECPSyncNormalize(), ECPSyncSet(), ECPSyncXSDToLogical()
property ExtrinsicFunctions as %Boolean [ InitialExpression = 0 , Required ];
Allows/disallows extrinsic functions to be used in SQL statements through ODBC, JDBC, and Dynamic Query.
Property methods: ExtrinsicFunctionsDisplayToLogical(), ExtrinsicFunctionsGet(), ExtrinsicFunctionsGetStored(), ExtrinsicFunctionsIsValid(), ExtrinsicFunctionsLogicalToDisplay(), ExtrinsicFunctionsLogicalToXSD(), ExtrinsicFunctionsNormalize(), ExtrinsicFunctionsSet(), ExtrinsicFunctionsXSDToLogical()
property FastDistinct as %Boolean [ InitialExpression = 1 , Required ];
Set the flag that determines if SQL DISTINCT optimization is turned on. If true (the default) many SQL queries involving DISTINCT (and GROUP BY) will run much more efficiently by making better use of indices (if available). This is an optimization added in Cache 5.1. The downside of this is that the values returned by such queries will be collated in the same way they are stored within the index (i.e., results may be in upper case). Some applications care about the case of values returned by such queries. If "Fast DISTINCT" is set to false (0), the SQL will revert to its pre-5.1 behavior with regards to DISTINCT behavior.
Property methods: FastDistinctDisplayToLogical(), FastDistinctGet(), FastDistinctGetStored(), FastDistinctIsValid(), FastDistinctLogicalToDisplay(), FastDistinctLogicalToXSD(), FastDistinctNormalize(), FastDistinctSet(), FastDistinctXSDToLogical()
property IdKey as %Boolean [ InitialExpression = 1 , Required ];
Set the flag that determines whether a Primary Key constraint specified through DDL also
becomes the IDKey index in the class definition or not. By default, the primary key does
also become the idkey index. This generally gives better performance, but means that
the Primary Key fields cannot be updated.
Property methods: IdKeyDisplayToLogical(), IdKeyGet(), IdKeyGetStored(), IdKeyIsValid(), IdKeyLogicalToDisplay(), IdKeyLogicalToXSD(), IdKeyNormalize(), IdKeySet(), IdKeyXSDToLogical()
property IdTrxFrom as %String (MAXLEN = 256, MINLEN = 0) [ InitialExpression = $$$DEFIdTrxFrom ];
Modifies the DDL Identifier Translation mappings. This is for filtering/modifying valid SQL identifier characters when translating SQL identifiers into Objects identifiers. When converting an SQL identifier to an Objects identifier at DDL run-time, the characters in the 'From' list are converted to the characters in the 'To' list.
Property methods: IdTrxFromDisplayToLogical(), IdTrxFromGet(), IdTrxFromGetStored(), IdTrxFromIsValid(), IdTrxFromLogicalToDisplay(), IdTrxFromLogicalToOdbc(), IdTrxFromNormalize(), IdTrxFromSet()
property IdTrxTo as %String (MAXLEN = 256, MINLEN = 0);
Modifies the DDL Identifier Translation mappings. This is for filtering/modifying valid SQL identifier characters when translating SQL identifiers into Objects identifiers. When converting an SQL identifier to an Objects identifier at DDL run-time, the characters in the 'From' list are converted to the characters in the 'To' list.
Property methods: IdTrxToDisplayToLogical(), IdTrxToGet(), IdTrxToGetStored(), IdTrxToIsValid(), IdTrxToLogicalToDisplay(), IdTrxToLogicalToOdbc(), IdTrxToNormalize(), IdTrxToSet()
property JDBCGatewayAddress as Config.Host (MAXLEN = 256, MINLEN = 0);
Address for the JDBC Gateway.
Property methods: JDBCGatewayAddressDisplayToLogical(), JDBCGatewayAddressGet(), JDBCGatewayAddressGetStored(), JDBCGatewayAddressIsValid(), JDBCGatewayAddressLogicalToDisplay(), JDBCGatewayAddressLogicalToOdbc(), JDBCGatewayAddressNormalize(), JDBCGatewayAddressSet()
property JDBCGatewayJVMArgs as %String (MAXLEN = 1024, MINLEN = 0);
Optional JVM arguments to include in the command line when starting the JDBC Gateway.
Property methods: JDBCGatewayJVMArgsDisplayToLogical(), JDBCGatewayJVMArgsGet(), JDBCGatewayJVMArgsGetStored(), JDBCGatewayJVMArgsIsValid(), JDBCGatewayJVMArgsLogicalToDisplay(), JDBCGatewayJVMArgsLogicalToOdbc(), JDBCGatewayJVMArgsNormalize(), JDBCGatewayJVMArgsSet()
property JDBCGatewayLog as %String (MAXLEN = 256, MINLEN = 0);
Name of the JDBC Gateway log file.
Property methods: JDBCGatewayLogDisplayToLogical(), JDBCGatewayLogGet(), JDBCGatewayLogGetStored(), JDBCGatewayLogIsValid(), JDBCGatewayLogLogicalToDisplay(), JDBCGatewayLogLogicalToOdbc(), JDBCGatewayLogNormalize(), JDBCGatewayLogSet()
property JDBCGatewayPort as %Integer (MAXVAL = 99999, MINVAL = 0) [ InitialExpression = 62972 , Required ];
Port number for the JDBC Gateway.
Property methods: JDBCGatewayPortDisplayToLogical(), JDBCGatewayPortGet(), JDBCGatewayPortGetStored(), JDBCGatewayPortIsValid(), JDBCGatewayPortLogicalToDisplay(), JDBCGatewayPortNormalize(), JDBCGatewayPortSet(), JDBCGatewayPortXSDToLogical()
property JDBCGatewayUsePassphrase as %Boolean [ InitialExpression = 0 ];
Require Passhphrase for JDBC connection
Property methods: JDBCGatewayUsePassphraseDisplayToLogical(), JDBCGatewayUsePassphraseGet(), JDBCGatewayUsePassphraseGetStored(), JDBCGatewayUsePassphraseIsValid(), JDBCGatewayUsePassphraseLogicalToDisplay(), JDBCGatewayUsePassphraseLogicalToXSD(), JDBCGatewayUsePassphraseNormalize(), JDBCGatewayUsePassphraseSet(), JDBCGatewayUsePassphraseXSDToLogical()
property JavaClassPath as %SysPath (MAXLEN = 256, MINLEN = 0);
Property methods: JavaClassPathDisplayToLogical(), JavaClassPathGet(), JavaClassPathGetStored(), JavaClassPathIsValid(), JavaClassPathLogicalToDisplay(), JavaClassPathLogicalToOdbc(), JavaClassPathNormalize(), JavaClassPathSet()
property JavaHome as %String (MAXLEN = 256, MINLEN = 0);
Property methods: JavaHomeDisplayToLogical(), JavaHomeGet(), JavaHomeGetStored(), JavaHomeIsValid(), JavaHomeLogicalToDisplay(), JavaHomeLogicalToOdbc(), JavaHomeNormalize(), JavaHomeSet()
property LockThreshold as %Integer [ InitialExpression = 1000 , Required ];
The value n is the lock threshold. This is the number of inserts, updates, or deletes for a single table within a single transaction that will trigger a table-level lock when reached. For example, if the lock threshold is 1000 and a process starts a transaction and then inserts 2000 rows, after the 1001st row is inserted the process will attempt to acquire a table-level lock instead of continue to lock individual rows. This is to help keep the lock table from becoming too full.
Property methods: LockThresholdDisplayToLogical(), LockThresholdGet(), LockThresholdGetStored(), LockThresholdIsValid(), LockThresholdLogicalToDisplay(), LockThresholdNormalize(), LockThresholdSet(), LockThresholdXSDToLogical()
property LockTimeout as %Integer (MAXVAL = 32767, MINVAL = 0) [ InitialExpression = 10 , Required ];
Set the Lock Timeout for Caché locks made during execution of SQL statements.
Property methods: LockTimeoutDisplayToLogical(), LockTimeoutGet(), LockTimeoutGetStored(), LockTimeoutIsValid(), LockTimeoutLogicalToDisplay(), LockTimeoutNormalize(), LockTimeoutSet(), LockTimeoutXSDToLogical()
property ODBCVarcharMaxlen as %Integer [ InitialExpression = 4096 , Required ];
Defines the MaxLen for ODBC fields of type VarChar.
Property methods: ODBCVarcharMaxlenDisplayToLogical(), ODBCVarcharMaxlenGet(), ODBCVarcharMaxlenGetStored(), ODBCVarcharMaxlenIsValid(), ODBCVarcharMaxlenLogicalToDisplay(), ODBCVarcharMaxlenNormalize(), ODBCVarcharMaxlenSet(), ODBCVarcharMaxlenXSDToLogical()
property Prefix as %String (MAXLEN = 24, MINLEN = 1) [ InitialExpression = "CacheSql" , Required ];
Defines what routine prefix name is used for cached query routines.
Property methods: PrefixDisplayToLogical(), PrefixGet(), PrefixGetStored(), PrefixIsValid(), PrefixLogicalToDisplay(), PrefixLogicalToOdbc(), PrefixNormalize(), PrefixSet()
property QueryProcedures as %Boolean [ InitialExpression = 0 , Required ];
Defines whether or not all class queries project as SQL Stored Procedures regardless of the query's SqlProc setting.
Default is 0, only class queries defined with SqlProc=1 will project as Stored Procedures. When set to 1, all class queries will project as stored procedures. When changing this setting, you must recompile the classes with the class queries in order for this change to have an affect.
Property methods: QueryProceduresDisplayToLogical(), QueryProceduresGet(), QueryProceduresGetStored(), QueryProceduresIsValid(), QueryProceduresLogicalToDisplay(), QueryProceduresLogicalToXSD(), QueryProceduresNormalize(), QueryProceduresSet(), QueryProceduresXSDToLogical()
property ReferentialChecks as %Boolean [ InitialExpression = 1 , Required ];
For INSERT, UPDATE, and DELETE, setting this parameter to 'Yes' instructs Caché to validate the foreign key constraint. Setting this parameter to 'No' will bypass foreign key constraint checking.
Property methods: ReferentialChecksDisplayToLogical(), ReferentialChecksGet(), ReferentialChecksGetStored(), ReferentialChecksIsValid(), ReferentialChecksLogicalToDisplay(), ReferentialChecksLogicalToXSD(), ReferentialChecksNormalize(), ReferentialChecksSet(), ReferentialChecksXSDToLogical()
property SaveMAC as %Boolean [ InitialExpression = 0 , Required ];
Defines whether or not the source code (.MAC and .INT) is saved or not. The default is that no source code is saved. This setting is made on a per-system basis.
Property methods: SaveMACDisplayToLogical(), SaveMACGet(), SaveMACGetStored(), SaveMACIsValid(), SaveMACLogicalToDisplay(), SaveMACLogicalToXSD(), SaveMACNormalize(), SaveMACSet(), SaveMACXSDToLogical()
property TCPKeepAlive as %Integer [ InitialExpression = 300 , Required ];
Set the TCP Keep Alive timeout for Caché xDBC TCP connections.
This is the number of seconds between keep alive-messages. The default for this is 300 seconds (5 minutes).]]>
Property methods: TCPKeepAliveDisplayToLogical(), TCPKeepAliveGet(), TCPKeepAliveGetStored(), TCPKeepAliveIsValid(), TCPKeepAliveLogicalToDisplay(), TCPKeepAliveNormalize(), TCPKeepAliveSet(), TCPKeepAliveXSDToLogical()
property TODATEDefaultFormat as %String (MAXLEN = 32, MINLEN = 1) [ InitialExpression = "DD MON YYYY" , Required ];
Default date format for the SQL TO_DATE() function.
Property methods: TODATEDefaultFormatDisplayToLogical(), TODATEDefaultFormatGet(), TODATEDefaultFormatGetStored(), TODATEDefaultFormatIsValid(), TODATEDefaultFormatLogicalToDisplay(), TODATEDefaultFormatLogicalToOdbc(), TODATEDefaultFormatNormalize(), TODATEDefaultFormatSet()
property TimePrecision as %Integer (MAXVAL = 9, MINVAL = 0) [ InitialExpression = 0 , Required ];
Set the default precision for the Time component of the value returned by the GETDATE(), CURRENT_TIME, and CURRENT_TIMESTAMP SQL Scalar functions. The precision, the number of decimal places for the millisecond portion of the time value, has a default is 0, which means milliseconds are not returned in the values returned by the GETDATE(), CURRENT_TIME, and CURRENT_TIMESTAMP functions.
Property methods: TimePrecisionDisplayToLogical(), TimePrecisionGet(), TimePrecisionGetStored(), TimePrecisionIsValid(), TimePrecisionLogicalToDisplay(), TimePrecisionNormalize(), TimePrecisionSet(), TimePrecisionXSDToLogical()

Inherited Methods

%AddToSaveSet() %Id() %Save()
%AddToSyncSet() %InsertBatch() %SaveDirect()
%BMEBuilt() %IsA() %SaveIndices()
%CheckConstraints() %IsModified() %SerializeObject()
%CheckConstraintsForExtent() %IsNull() %SetModified()
%ClassIsLatestVersion() %KillExtent() %SortBegin()
%ClassName() %KillExtentData() %SortEnd()
%ComposeOid() %LoadFromMemory() %SyncObjectIn()
%ConstructClone() %LockExtent() %SyncTransport()
%Delete() %LockId() %UnlockExtent()
%DeleteExtent() %New() %UnlockId()
%DeleteId() %NormalizeObject() %ValidateIndices()
%DispatchClassMethod() %ObjectIsNull() %ValidateObject()
%DispatchGetModified() %ObjectModified() Get()
%DispatchGetProperty() %Oid() GetList()
%DispatchMethod() %OnBeforeAddToSync() Help()
%DispatchSetModified() %OnDetermineClass() Modify()
%DispatchSetMultidimProperty() %Open() Open()
%DispatchSetProperty() %OpenId() XMLDTD()
%Exists() %OriginalNamespace() XMLExport()
%ExistsId() %PackageName() XMLExportToStream()
%Extends() %PhysicalAddress() XMLExportToString()
%GUID() %PurgeIndices() XMLNew()
%GUIDSet() %Reload() XMLSchema()
%GetLock() %RemoveFromSaveSet() XMLSchemaNamespace()
%GetParameter() %ResolveConcurrencyConflict() XMLSchemaType()
%GetSwizzleObject() %RollBack()

Indexes

index (CPFNameSectionHeaderName on CPFName,SectionHeader,Name) [IdKey, Type = key, Unique];
Index methods: CPFNameSectionHeaderNameCheck(), CPFNameSectionHeaderNameDelete(), CPFNameSectionHeaderNameExists(), CPFNameSectionHeaderNameOpen(), CPFNameSectionHeaderNameSQLCheckUnique(), CPFNameSectionHeaderNameSQLExists(), CPFNameSectionHeaderNameSQLFindPKeyByConstraint(), CPFNameSectionHeaderNameSQLFindRowIDByConstraint()

Storage

Storage Model: CacheStorage (Config.SQL)

^|"^^"_$ZU(12)|SYS("CONFIG")(ID)
=
%%CLASSNAME
AllowRowIDUpdate
Comment
DBMSSecurity
DDLNo30
DDLNo201
DDLNo307
DDLNo311
DDLNo315
DDLNo324
DDLNo333
DDLSQLOnlyCompile
DefaultSchema
DelimitedIds
DropDelete
ExtrinsicFunctions
FastDistinct
IdKey
IdTrxFrom
IdTrxTo
JavaClassPath
JavaHome
JDBCGatewayAddress
JDBCGatewayLog
JDBCGatewayPort
LockThreshold
LockTimeout
ODBCVarcharMaxlen
Prefix
QueryProcedures
ReferentialChecks
SaveMAC
TCPKeepAlive
TimePrecision
TODATEDefaultFormat
ECPSync
JDBCGatewayJVMArgs
BiasQueriesAsOutlier
DDLDefineBitmapExtent
DDLFinal
DDLUseSequence
JDBCGatewayUsePassphrase
ANSIPrecedence
Comments