SqlSystem Class

The SqlSystem class holds information about the active SQL system, typically login information.

Syntax

class SqlSystem extends Object

Run On

Server

Methods

	Method	Description
	cancelTimeOut	Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
	createLoginProperty	Creates the login property to the Microsoft Dynamics AX database.
	databaseId	Returns the Microsoft Dynamics AX ID for the database vendor used as the SQL database backend.
	databaseName	Returns the name of the database vendor used as the SQL database backend.
	dbRequestedUnicodeEnabled	Retrieves the value that indicates if Unicode is supported in the database.
	equal	Determines whether the specified object is equal to the current one. (Inherited from Object.)
	filenameDeadlocks	Retrieves the name of the user specific deadlocks trace logfile.
	filenameQuerytimelimit	Retrieves the name of the user specific querytime limit logfile.
	filenameSqlTrace	Retrieves the filename of the SQL trace log file for specific user.
	filenameWarnings	Retrieves the name of the user specific warnings log file.
	getTimeOutTimerHandle	Returns the timer handle for the object. (Inherited from Object.)
	handle	Retrieves the handle of the class of the object. (Inherited from Object.)
	logfileName	Retrieves the name of the standard Microsoft Dynamics AX SQL error log file.
	logfileWrite	Writes a text string into the standard Microsoft Dynamics AX SQL error logfile.
	loginConnectString	Retrieves the full ODBC connection string.
	loginDatabase	Retrieves the name of the database currently connected to.
	loginDSN	Retrieves the open database connectivity (ODBC) data source name (DSN) used to connect to the database.
	loginName	Retrieves the user name that is used to log-in to the database.
	loginServer	Retrieves the name of the database server currently connected to.
	monocaseFmt	Retrieves the format string that is used for casting the string to one case (e.g. "NLS_LOWER(%1)").
	new	Initializes a new instance of the SqlSystem class. (Overrides the new Method.)
	notify	Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
	notifyAll	Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
	objectOnServer	Determines whether the object is on a server. (Inherited from Object.)
	owner	Returns the instance that owns the object. (Inherited from Object.)
	setTimeOut	Sets up the scheduled execution of a specified method. (Inherited from Object.)
	sqlLiteral	Formats the input AX datatype to correct SQL type.
	toString	Returns a string that represents the current object. (Inherited from Object.)
	usageCount	Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.)
	wait	Pauses a process. (Inherited from Object.)
	xml	Returns an XML string that represents the current object. (Inherited from Object.)
	::clusteredIndexes
	::databaseBackendDesc
	::databaseBackendId
	::databaseBackendName
	::databaseCallLevelInterface
	::databaseHints
	::functionalIndexes
	::modelDatabaseBackendName	Retrieves the name of the model database AOS currently connected to.

Top

Inheritance Hierarchy

Object Class
  SqlSystem Class
    SysSqlSystem Class

See Also

SqlDataDictionary Class