Share via


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