SqlSystem Class

Definition

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

public ref class SqlSystem : Microsoft::Dynamics::Ax::Xpp::XppObjectBase
[Microsoft.Dynamics.Ax.Xpp.KernelClass]
public class SqlSystem : Microsoft.Dynamics.Ax.Xpp.XppObjectBase
[<Microsoft.Dynamics.Ax.Xpp.KernelClass>]
type SqlSystem = class
    inherit XppObjectBase
Public Class SqlSystem
Inherits XppObjectBase
Inheritance
Microsoft.Dynamics.AX.KernelInterop.ProxyBase
SqlSystem
Attributes

Constructors

SqlSystem()
SqlSystem(IntPtr)

Fields

__k_SqlSystemId
kernelClass (Inherited from XppObjectBase)

Methods

__shouldCallNew(Type)
addXppProxyReference(Type, Object) (Inherited from XppObjectBase)
Call(String, Object[], Type[], Object[]) (Inherited from XppObjectBase)
cancelTimeOut(Int32) (Inherited from XppObjectBase)
clusteredIndexes()
createKernelClass(Object[], Type[], Object[]) (Inherited from XppObjectBase)
createLoginProperty()

Creates the login property to the database.

databaseBackendDesc()
databaseBackendId()
databaseBackendName()
databaseCallLevelInterface()
databaseHints()
databaseHints(Int32)
databaseId()

Returns the 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(XppObjectBase) (Inherited from XppObjectBase)
filenameDeadlocks(String)

Retrieves the name of the user specific deadlocks trace logfile.

filenameQuerytimelimit(String)

Retrieves the name of the user specific querytime limit logfile.

filenameSqlTrace(String)

Retrieves the filename of the SQL trace log file for specific user.

filenameWarnings(String)

Retrieves the name of the user specific warnings log file.

finalize() (Inherited from XppObjectBase)
functionalIndexes()
GetIntPtr() (Inherited from XppObjectBase)
GetKernelInstanceUniqueId() (Inherited from XppObjectBase)
getTimeOutTimerHandle() (Inherited from XppObjectBase)
getXppProxyReference(Type) (Inherited from XppObjectBase)
handle()
IsManagedValid() (Inherited from XppObjectBase)
kernelhandle()
KernelInstanceDisposed() (Inherited from XppObjectBase)
logfileName()

Retrieves the name of the standard SQL error log file.

logfileName(Boolean)
logfileWrite(String)

Writes a text string into the standard 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.

MakeReflectionCall(String, Object[]) (Inherited from XppObjectBase)
managedConnectionString()
modelDatabaseBackendName()

Retrieves the name of the model database AOS currently connected to.

monocaseFmt()

Retrieves the format string that is used for casting the string to one case (e.g. "NLS_LOWER(%1)").

monocaseFmt(Int32)
monocaseFmt(Int32, Int32)
monocaseFmt(Int32, Int32, Boolean)
monocaseFmt(Int32, Int32, Boolean, Boolean)
newmethod()

Initializes a new instance of the SqlSystem class.

notify() (Inherited from XppObjectBase)
notifyAll() (Inherited from XppObjectBase)
objectOnServer()
Obsolete.
(Inherited from XppObjectBase)
setTimeOut(String, Int32)
Obsolete.
(Inherited from XppObjectBase)
setTimeOut(String, Int32, Boolean)
Obsolete.
(Inherited from XppObjectBase)
sqlLiteral(Object)

Formats the input AX datatype to correct SQL type.

sqlLiteral(Object, Boolean)
sqlLiteral(Object, Boolean, Boolean)
sqlLiteral(Object, Boolean, Boolean, Boolean)
sqlLiteral(Object, Boolean, Boolean, Boolean, Int32)
usageCount() (Inherited from XppObjectBase)
VerifyKernelClass() (Inherited from XppObjectBase)
wait() (Inherited from XppObjectBase)
Xml() (Inherited from XppObjectBase)
Xml(Int32) (Inherited from XppObjectBase)

Applies to