Distributed Tuning Objects Enumerations
 
Distributed Tuning Objects Enumerations
Enumerations of the PSQL Distributed Tuning Objects
This chapter provides information about the enumerations used in the Distributed Tuning Objects.
Enumerated Types in DTO
Enumerated Types in DTO
DTO supports the following enumerated types:
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
Btrieve Types
Enumeration
Value
0
dtoTypeString
1
dtoTypeInteger
2
dtoTypeFloat
3
dtoTypeDate
4
dtoTypeTime
5
dtoTypeDecimal
6
dtoTypeMoney
7
dtoTypeLogical
8
dtoTypeNumeric
9
dtoTypeBfloat
10
dtoTypeLString
11
dtoTypeZString
12
dtoTypeNote
13
dtoTypeLvar
14
dtoTypeBinary
15
dtoTypeIdentity
16
dtoTypeBit
17
dtoTypeNumericSTS
18
dtoTypeNumericSA
19
dtoTypeCurrency
20
dtoTypeTimestamp
21
dtoTypeBlob
22
dtoTypeGDecimal
25
dtoTypeWString
26
dtoTypeWZString
27
dtoTypeGUID
30
dtoTypeDateTime
Column Flags
Enumeration
Value
0
dtoColumnDefault
1
dtoColumnCaseSensitive
4
dtoColumnNullable
256
dtoColumnBinary
2048
dtoTypeColumnNText
4096
dtoTypeColumnBinary
Index Flags
Enumeration
Value
0
dtoIndexDefault
1
dtoIndexDuplicatesAllowed
2
dtoIndexModifiable
64
dtoIndexDescending
512
dtoIndexPartial
Segment Flags
Enumeration
Value
0
dtoSegmentAscending
64
dtoSegmentDescending
Table Flags
Enumeration
Value
0
dtoTableLegacy
64
dtoTableTrueNullable
DtoResult
Enumeration
Value
0
Dto_Success
1
Dto_errFailed
2
Dto_errMemoryAllocation
3
Dto_errDictionaryNotFound
4
Dto_errDictionaryAlreadyOpen
5
Dto_errDictionaryNotOpen
6
Dto_errInvalidDictionaryHandle
7
Dto_errTableNotFound
8
Dto_errInvalidTableName
9
Dto_errInvalidColumnName
10
Dto_errInvalidColumnDataType
11
Dto_errDuplicateColumnName
12
Dto_errInvalidDataSize
13
Dto_errInvalidColumnOrder
14
Dto_errInvalidIndexName
15
Dto_errColumnNotFound
16
Dto_errTooManySegments
17
Dto_errStringTooShort
18
Dto_errDictionaryAlreadyExists
19
Dto_errDirectoryError
20
Dto_errSessionSecurityError
21
Dto_errDuplicateTable
22
Dto_errDuplicateIndex
27
Dto_errInvalidNameLength
28
Dto_errInternalProtocolError
29
Dto_errInvalidAccountName
30
Dto_errUserAlreadyExists
31
Dto_errGroupNotEmpty
32
Dto_errGroupAlreadyExists
33
Dto_errUserAlreadyPartOfGroup
34
Dto_errUserNotPartOfGroup
35
Dto_errNotAllowedToDropAdministrator
36
Dto_errDatabaseHasNoSecurity
37
Dto_errInvalidPassword
38
Dto_SuccessWithInfo
87
Dto_errServiceInvalidParameter
123
Dto_errInvalidServiceName
161
Dto_errMaxUserCountReached
423
Dto_errInvalidSession
424
Dto_errInvalidArgument
425
Dto_errNotConnected
426
Dto_errInvalidComputerName
427
Dto_errUnknownError
428
Dto_errTableCouldNotBeDeleted
429
Dto_errItemNotFound
430
Dto_errAPINotImplemented
431
Dto_errAccessDenied
1051
Dto_errServiceDependentServiceRunning
1052
Dto_errServiceInvalidServiceControl
1053
Dto_errServiceRequestTimeout
1055
Dto_errServiceDatabaseLocked
1056
Dto_errServiceAlreadyRunning
1057
Dto_errInvalidServiceAccount
1058
Dto_errServiceDisabled
1059
Dto_errServiceCircularDependency
1060
Dto_errServiceDoesNotExist
1062
Dto_errServiceNotActive
1065
Dto_errServiceDatabaseDoesNotExist
1068
Dto_errServiceDependencyFail
1069
Dto_errServiceLogonFailed
1072
Dto_errServiceMarkedForDelete
1075
Dto_errServiceDependencyDeleted
7001
Dto_errInvalidHandle
7002
Dto_errNullPointer
7003
Dto_errBufferTooSmall
7004
Dto_errDtiFailed
7005
Dto_errInvalidDataType
7006
Dto_errOutOfRange
7007
Dto_errInvalidSelection
7008
Dto_errInvalidSequence
7009
Dto_errDataUnavailable
7010
Dto_errInvalidClient
7011
Dto_errAccessRights
7012
Dto_errDuplicateName
7013
Dto_errDatabaseDoesNotExist
7015
Dto_errFileNotOpen
7016
Dto_errDDFAlreadyExist
7017
Dto_errSharedDDFExist
7018
Dto_errInvalidName
7019
Dto_errDSNAlreadyExist
7020
Dto_errDSNDoesNotExist
7021
Dto_errInvalidOpenMode
7063
See 161
7064
Dto_errNoLicenseObtained
7065
Dto_errNoProductObtained
7101
Dto_errInvalidLicKeyCharacter
7102
Dto_errIllegalLicType
7108
Dto_errLicKeyTooLong
7109
Dto_errLicNotFound
7110
Dto_errLicExpired
7111
Dto_errLicIsTemporary
7112
Dto_errLicAlreadyInstalled
7113
Dto_errLicInvalid
7115
Dto_errInvalidProductId
7118
Dto_errServerNotRunning
7119
Dto_errLocalServerNotRunning
7120
Dto_errLicNotRemovable
7122
Dto_errNoActiveLicense
Setting Rank
Enumeration
Value
0
dtoNormal
1
dtoAdvanced
Setting Type
Enumeration
Value
0
dtoBooleanType
1
dtoLongType
2
dtoStringType
3
dtoSingleSel
4
dtoMultiSel
Client Site
Enumeration
Value
0
dtoClientSiteLocal
1
dtoClientSiteRemote
Client Platform
Enumeration
Value
0
dtoPlatformNotAvailable
1
dtoPlatformWin
2
dtoPlatformWin95
3
dtoPlatformWinWg
4
dtoPlatformNTW
5
dtoPlatformNTS
6
dtoPlatformNW
7
dtoPlatformOS2W
8
dtoPlatformOS2S
9
dtoPlatformDOS
Transaction State
Enumeration
Value
0
dtoNone
19
dtoExclusive
1019
dtoConcurrent
Open Mode
Enumeration
Value
0
dtoNormalOpenMode
255
dtoAcceleratedOpenMode
254
dtoReadOnlyOpenMode
253
dtoVerifyOpenMode
252
dtoExclusiveOpenMode
248
dtoNormalNonTransOpenMode
247
dtoAcceleratedNonTransOpenMode
246
dtoReadOnlyNonTransOpenMode
245
dtoVerifyNonTransOpenMode
244
dtoExclusiveNonTransOpenMode
240
dtoNormalSharedLockingOpenMode
239
dtoAcceleratedSharedLockingOpenMode
238
dtoReadOnlySharedLockingOpenMode
237
dtoVerifySharedLockingOpenMode
236
dtoExclusiveSharedLockingOpenMode
DSN Open Mode
Enumeration
Value
0
dtoNormalDSNOpenMode
1
dtoAcceleratedDSNOpenMode
2
dtoReadOnlyDSNOpenMode
3
dtoExclusiveDSNOpenMode
DSN Translate Option
Enumeration
Value
0
dtoDSNFlagDefault
1
dtoDSNFlagEomAnsi
2
dtoDSNFlagAuto
Lock Type
Enumeration
Value
0
dtoNotLocked
1
dtoSingleLock
2
dtoMultipleLock
Wait State
Enumeration
Value
0
dtoNotWaiting
1
dtoWaitingForRecordLock
2
dtoWaitingForFileLock
Database Code Page
Enumeration
Value
0
dtoDbZeroCodePage
65001
dtoDBCodePageUTF8
Database Flags
Enumeration
Value
0
dtoDbFlagNotApplicable
1
dtoDbFlagBound
2
dtoDbFlagRI
4
dtoDbFlagCreateDDF
32
dtoDbFlagLONGMETADATA
SQL Connection Status
Enumeration
Value
0
dtoSQLConnectionIdle
1
dtoSQLConnectionActive
2
dtoSQLConnectionDying
Service ID
Enumeration
Value
0
dtoServiceTransactional
1
dtoServiceRelational
2
dtoServiceIDS
Service Status
Enumeration
Value
0
dtoServiceStopped
1
dtoServiceStartPending
2
dtoServiceStopPending
3
dtoServiceRunning
4
dtoServiceContinuePending
5
dtoServicePausePending
6
dtoServicePaused
7
dtoServiceNotFound