•  About This Manual
  • Who Should Read This Manual
  • Conventions
•  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
  •  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 PSQL 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 PSQL 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
        • result = Object.CreateGroup(groupname)
        • Arguments
        • Return Values
        • Remarks
        • Example
      •  CreateUser
        • Syntax
        • Arguments
        • Return Values
        • Remarks
        • Example
      •  DropGroup
        • Syntax
        • result = Object.DropGroup(groupname)
        • Arguments
        • Return Values
        • Remarks
        • Example
      •  DropUser
        • Syntax
        • result = Object.DropUser(username)
        • 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 Manual

Distributed Tuning Objects Enumerations