About This Document
Who Should Read This Manual
Distributed Tuning Objects Introduction
What is DTO?
DTO Objects Model and Objects Relationship
Connection
Monitoring and Diagnostic
Configuration
Catalog and Dictionary
DTO Object Tree
DTO Versions
DTO2
W64DTO2
Understanding How Applications and DLLs Interact
32-bit Machine Process
64-bit Machine Process
Getting Started with DTO
Visual Basic
Adding a Reference to DTO to a Project
Using the CreateObject Function
Active Server Pages
Delphi
Importing the DTO Type Library into a Delphi project
Example of Using Pascal Declarations
Example of Using Direct COM Calls
DTO Object Summary
Connection Object
DtoSession
Configuration Objects
DtoCategory
DtoSetting
DtoSelectionItem
DtoServices
DtoLicenseMgr
Monitoring Objects
DtoMonitor
DtoOpenFile
DtoFileHandle
DtoMkdeClient
DtoMkdeClientHandle
DtoMkdeVersion
DtoEngineInformation
DtoSqlClient
DtoCommStat
DtoProtocolStat
Database and Dictionary Objects
DtoDatabase
DtoDSN
DtoDictionary (deprecated)
DtoTable
DtoColumn
DtoIndex
DtoSegment
Working with DTO Collections
Instantiating a Collection
Visual Basic
ASP
Looping through a Collection
Visual Basic
ASP
Obtaining Number of Members
Visual Basic
ASP
Obtaining a Specific Member
Visual Basic and ASP
Where to Find DTO Samples
Establishing a DTO Session
DtoSession Object
Properties
Collections
Objects
Methods
Remarks
Example
See Also
Methods Detail
Connect method
Syntax
Arguments
Return Values
Remarks
Examples
Disconnect method
Syntax
Arguments
Return Values
Remarks
Example
GetSetting method
Syntax
Arguments
Return Values
Remarks
Example
Configuring Zen Servers with DTO
DtoCategories Collection
Properties
Methods
Remarks
Example
See Also
DtoCategory Object
Properties
Collections
Methods
Remarks
Example
See Also
DtoLicenseMgr Object
Properties
Collections
Methods
Remarks
Example
See Also
Methods Detail
AddLicense
Syntax
Arguments
Return Values
Example
DeleteLicense
Syntax
Arguments
Return Values
Remarks
Example
GetProductInfo
Syntax
Arguments
Return Values
Remarks
Example
ValidateLicenses
Syntax
Arguments
Return Values
Remarks
Example
DtoSettings Collection
Properties
Methods
Remarks
Example
See Also
DtoSetting Object
Properties
Collections
Methods
Remarks
Example
See Also
DtoSelectionItems Collection
Properties
Methods
Remarks
Example
See Also
Methods Detail
Add method
Syntax
Arguments
Return Values
Remarks
Example
GetById method
Syntax
Arguments
Return Values
Example
Remove method
Syntax
Arguments
Return Values
Remarks
Example
DtoSelectionItem Object
Properties
Methods
Remarks
Example
See Also
DtoServices Object
Properties
Methods
Remarks
Security Information Regarding DtoServices Object
Examples
See Also
Methods Detail
RestartAllServices method
Syntax
Arguments
Return Values
StartRelational method
Syntax
Arguments
Return Values
StartTransactional method
Syntax
Arguments
Return Values
StopRelational method
Syntax
Arguments
Return Values
StopTransactional method
Syntax
Arguments
Return Values
StartDXAgent
Syntax
Arguments
Return Values
StartDXReplication
Syntax
Arguments
Return Values
StopDXAgent
Syntax
Arguments
Return Values
StopDXReplication
Syntax
Arguments
Return Values
Monitoring Zen Servers with DTO
DtoMonitor Object
Properties
Collections
Objects
Methods
Example
See Also
DtoOpenFiles Collection
Properties
Methods
Remarks
Example
See Also
DtoOpenFile Object
Properties
Methods
Collections
Remarks
Example
See Also
DtoFileHandles Collection
Properties
Methods
Remarks
Example
See Also
DtoFileHandle Object
Properties
Methods
Remarks
Example
See Also
DtoMkdeClients Collection
Properties
Methods
Remarks
Example
See Also
DtoMkdeClient Object
Properties
Collections
Methods
Remarks
Example
See Also
Methods Detail
Disconnect method
Syntax
Arguments
Return Values
Remarks
Example
DtoMkdeClientHandles Collection
Properties
Methods
Remarks
Example
See Also
DtoMkdeClientHandle Object
Properties
Methods
Remarks
Example
See Also
DtoCommStat Object
Properties
Collections
Objects
Methods
Remarks
Example
See Also
DtoProtocolStats Collection
Properties
Methods
Remarks
Example
See Also
DtoProtocolStat Object
Properties
Methods
Remarks
Examples
See Also
DtoSqlClients Collection
Properties
Methods
Remarks
Example
See Also
DtoSqlClient Object
Properties
Methods
Remarks
Example
See Also
Methods Detail
Disconnect method
Syntax
Arguments
Return Values
Remarks
Example
DtoMkdeVersion Object
Properties
Methods
Remarks
Example
See Also
DtoEngineInformation Object
Properties
Methods
Remarks
Example
See Also
Creating and Maintaining Catalogs and Dictionaries with DTO
DtoDatabases Collection
Properties
Methods
Remarks
Example
See Also
Methods Detail
Add method
Syntax
Arguments
Return Values
Remarks
Example
Remove method
Syntax
Arguments
Return Values
Remarks
Example
DtoDatabase Object
Properties
Collections
Methods
Remarks
Examples
See Also
Methods Detail
AddUserToGroup
Syntax
Arguments
Return Values
Remarks
Example
AlterUserName
Syntax
Arguments
Return Values
Remarks
Example
AlterUserPassword
Syntax
Arguments
Return Values
Remarks
Example
Close
Syntax
Arguments
Return Values
Remarks
Example
Copy
Syntax
Arguments
Return Values
Remarks
Example
CreateGroup
Syntax
Arguments
Return Values
Remarks
Example
CreateUser
Syntax
Arguments
Return Values
Remarks
Example
DropGroup
Syntax
Arguments
Return Values
Remarks
Example
DropUser
Syntax
Arguments
Return Values
Remarks
Example
Open
Syntax
Arguments
Return Values
Remarks
Example
RemoveUserFromGroup
Syntax
Arguments
Return Values
Remarks
Example
Secure
Syntax
Arguments
Return Values
Remarks
Example
UnSecure
Syntax
Arguments
Return Values
Remarks
Example
DtoDSNs Collection
Properties
Methods
Remarks
Example
See Also
Methods Detail
Add method
Syntax
Arguments
Return Values
Remarks
Example
Remove method
Syntax
Arguments
Return Values
Remarks
Example
DtoDSN Object
Properties
Methods
Remarks
Examples
To Query the DbName Associated with a DSN
To Add a New DSN
To Get or Set the Encoding Translation
See Also
DtoDictionary Object
Properties
Collections
Methods
Remarks
Example
See Also
Methods Detail
Open method
Syntax
Arguments
Return Values
Remarks
Example
Create method
Syntax
Arguments
Return Values
Remarks
Example
Close method
Syntax
Arguments
Return Values
Remarks
Example
AddTable method
Syntax
Arguments
Return Values
Remarks
Example
DropTable method
Syntax
Arguments
Return Values
Remarks
Example
Reload method
Syntax
Arguments
Return Values
Delete method
Syntax
Arguments
Return Values
DtoTables Collection
Properties
Methods
Remarks
Example
Using DtoDatabase
Using DtoDictionary
See Also
DtoTable Object
Properties
Collections
Methods
Remarks
Example
See Also
DtoColumns Collection
Properties
Methods
Remarks
Example
See Also
Methods Detail
Add method
Syntax
Arguments
Return Values
Remarks
Remove method
Syntax
Arguments
Return Values
Remarks
Clear method
Syntax
Arguments
Return Values
Remarks
DtoColumn Object
Properties
Methods
Remarks
Example
See Also
DtoIndexes Collection
Properties
Methods
Remarks
Example
See Also
Methods Detail
Add method
Syntax
Arguments
Return Values
Remarks
Remove method
Syntax
Arguments
Return Values
Remarks
Clear method
Syntax
Arguments
Return Values
Remarks
DtoIndex Object
Properties
Collections
Methods
Remarks
Example
See Also
DtoSegments Collection
Properties
Methods
Remarks
Example
See Also
Methods Detail
Add method
Syntax
Arguments
Return Values
Remarks
Remove method
Syntax
Arguments
Return Values
Remarks
Clear method
Syntax
Arguments
Return Values
Remarks
DtoSegment Object
Properties
Methods
Remarks
Example
See Also
Distributed Tuning Objects Enumerations
Enumerated Types in DTO
Btrieve Types
Column Flags
Index Flags
Segment Flags
Table Flags
DtoResult
Setting Rank
Setting Type
Client Site
Client Platform
Transaction State
Open Mode
DSN Open Mode
DSN Translate Option
Lock Type
Wait State
Database Code Page
Database Flags
SQL Connection Status
Service ID
Service Status
About This Document
Distributed Tuning Objects Enumerations