DB Link
API Reference Guide
Product Documentation:

Visualization DB Link
Documentation Home
Enumerations | Variables
ildconst.h File Reference
#include <ildblink/ild.h>

Enumerations

enum  IldInfoItem {
  IldMaxDriverConnections, IldMaxConcurrentActivities, IldDataSourceName, IldFetchDirection,
  IldServerName, IldDBMSName, IldDBMSVersion, IldCursorCommitBehavior,
  IldDataSourceReadOnly, IldDefTransactionIsolation, IldIdentifierCase, IldMaxColumnNameLength,
  IldMaxCursorNameLength, IldMaxSchemaNameLength, IldMaxCatalogNameLength, IldMaxTableNameLength,
  IldScrollConcurrency, IldTransactionCapable, IldUserName, IldTransactionIsolationOpt,
  IldIntegrity, IldGetDataExtension, IldNullCollation, IldAlterTable,
  IldOrderByColumnsInSelect, IldSpecialCharacters, IldMaxColumnsInGroupBy, IldMaxColumnsInOrderBy,
  IldMaxColumnsInSelect, IldMaxColumnsInTable, IldMaxStatementLength, IldMaxTablesInSelect,
  IldMaxUserNameLength, IldOuterJoinCapabilities, IldCursorSensitivity, IldDescribeParameter,
  IldCatalogName, IldCollatingSequence, IldMaxIdentifierLength
}
 The values of this enumeration list the items of server information that can be queried. More...
 

Variables

const IlInt IldAlterTableAddColumn
 
const IlInt IldAlterTableAddConstraint
 
const IlInt IldAlterTableAlterColumn
 
const IlInt IldAlterTableDropColumn
 
const IlInt IldAlterTableDropConstraint
 
const IlInt IldCurBehaviorClose
 
const IlInt IldCurBehaviorDelete
 
const IlInt IldCurBehaviorPreserve
 
const IlInt IldCursorAsensitive
 
const IlInt IldCursorInsensitive
 
const IlInt IldCursorSensitive
 
const IlInt IldFetchDirectionAbsolute
 
const IlInt IldFetchDirectionFirst
 
const IlInt IldFetchDirectionLast
 
const IlInt IldFetchDirectionNext
 
const IlInt IldFetchDirectionPrior
 
const IlInt IldFetchDirectionRelative
 
const IlInt IldGetDataAnyColumn
 
const IlInt IldGetDataAnyOrder
 
const IlInt IldIdentifierLower
 
const IlInt IldIdentifierMixed
 
const IlInt IldIdentifierSensitive
 
const IlInt IldIdentifierUpper
 
const IlInt IldNullCollateHigh
 
const IlInt IldNullCollateLow
 
const IlInt IldOuterJoinAllOps
 
const IlInt IldOuterJoinFull
 
const IlInt IldOuterJoinInner
 
const IlInt IldOuterJoinLeft
 
const IlInt IldOuterJoinNested
 
const IlInt IldOuterJoinNotOrdered
 
const IlInt IldOuterJoinRight
 
const IlInt IldScrollLock
 
const IlInt IldScrollOptRowver
 
const IlInt IldScrollOptValues
 
const IlInt IldScrollReadOnly
 
const short IldSQLAllTypes
 
const short IldSQLBFile
 
const short IldSQLBigint
 
const short IldSQLBin
 
const short IldSQLBit
 
const short IldSQLBitVarying
 
const short IldSQLBLOB
 
const short IldSQLBoolean
 
const short IldSQLByte
 
const short IldSQLChar
 
const short IldSQLCLOB
 
const short IldSQLCursor
 
const short IldSQLDate
 
const short IldSQLDateTime
 
const short IldSQLDecimal
 
const short IldSQLDouble
 
const short IldSQLFloat
 
const short IldSQLInteger
 
const short IldSQLInterval
 
const short IldSQLIntervalDay
 
const short IldSQLIntervalDH
 
const short IldSQLIntervalDM
 
const short IldSQLIntervalDS
 
const short IldSQLIntervalHM
 
const short IldSQLIntervalHour
 
const short IldSQLIntervalHS
 
const short IldSQLIntervalMinute
 
const short IldSQLIntervalMonth
 
const short IldSQLIntervalMS
 
const short IldSQLIntervalSecomd
 
const short IldSQLIntervalYear
 
const short IldSQLIntervalYM
 
const short IldSQLLongBin
 
const short IldSQLMoney
 
const short IldSQLNamedType
 
const short IldSQLNamedTypeRef
 
const short IldSQLNumeric
 
const short IldSQLReal
 
const short IldSQLRef
 
const short IldSQLRow
 
const short IldSQLSmallint
 
const short IldSQLText
 
const short IldSQLTime
 
const short IldSQLTimestamp
 
const short IldSQLTimestampTZ
 
const short IldSQLTimeTZ
 
const short IldSQLVarBin
 
const short IldSQLVarchar
 
const IlInt IldTransCapableAll
 
const IlInt IldTransCapableDDLCommit
 
const IlInt IldTransCapableDDLIgnore
 
const IlInt IldTransCapableDML
 
const IlInt IldTransCapableNone
 
const IlInt IldTransIsolReadCommitted
 
const IlInt IldTransIsolReadUncommitted
 
const IlInt IldTransIsolRepeatableRead
 
const IlInt IldTransIsolSerializable
 

Detailed Description

Declaration of various constants.

Enumeration Type Documentation

◆ IldInfoItem

enum IldInfoItem

The values of this enumeration list the items of server information that can be queried.

One of these values must be used as the first argument to the function IldDbms::getInfo.

See also
IldDbms
Enumerator
IldMaxDriverConnections 

CLI Code : 0 ; Item Value : integer

IldMaxConcurrentActivities 

CLI Code : 1 ; Item Value : integer

IldDataSourceName 

CLI Code : 2 ; Item Value : string

IldFetchDirection 

CLI Code : 8 ; Item Value : integer ; Possible values :

IldServerName 

CLI Code : 13 ; Item Value : string

IldDBMSName 

CLI Code : 17 ; Item Value : string

IldDBMSVersion 

CLI Code : 18 ; Item Value : string

IldCursorCommitBehavior 

CLI Code : 23 ; Item Value : integer ; Possible values :

IldDataSourceReadOnly 

CLI Code : 25 ; Item Value : string

IldDefTransactionIsolation 

CLI Code : 26 ; Item Value : integer ; Possible values :

IldIdentifierCase 

CLI Code : 28 ; Item Value : integer ; Possible values :

IldMaxColumnNameLength 

CLI Code : 30 ; Item Value : integer

IldMaxCursorNameLength 

CLI Code : 31 ; Item Value : integer

IldMaxSchemaNameLength 

CLI Code : 32 ; Item Value : integer

IldMaxCatalogNameLength 

CLI Code : 34 ; Item Value : integer

IldMaxTableNameLength 

CLI Code : 35 ; Item Value : integer

IldScrollConcurrency 

CLI Code : 43 ; Item Value : integer ; Possible values :

IldTransactionCapable 

CLI Code : 46 ; Item Value : integer ; Possible values :

IldUserName 

CLI Code : 47 ; Item Value : string

IldTransactionIsolationOpt 

CLI Code : 72 ; Item Value : integer ; Possible values :

IldIntegrity 

CLI Code : 73 ; Item Value : string

IldGetDataExtension 

CLI Code : 81 ; Item Value : integer ; For this item, the returned value is always the sum of IldGetDataAnyColumn and IldGetDataAnyOrder because DB Link implements theses capabilities for all supported RDBMSs.

Warning
This value is deprecated. As it is not any more part of the SQL standard (2003), it will be removed in future versions of DB Link.
IldNullCollation 

CLI Code : 85 ; Item Value : integer ; Possible values :

IldAlterTable 

CLI Code : 86 ; Item Value : integer ; Possible values :

IldOrderByColumnsInSelect 

CLI Code : 90 ; Item Value : string

IldSpecialCharacters 

CLI Code : 94 ; Item Value : string

IldMaxColumnsInGroupBy 

CLI Code : 97 ; Item Value : integer

IldMaxColumnsInOrderBy 

CLI Code : 99 ; Item Value : integer

IldMaxColumnsInSelect 

CLI Code : 100 ; Item Value : integer

IldMaxColumnsInTable 

CLI Code : 101 ; Item Value : integer

IldMaxStatementLength 

CLI Code : 105 ; Item Value : integer

IldMaxTablesInSelect 

CLI Code : 106 ; Item Value : integer

IldMaxUserNameLength 

CLI Code : 107 ; Item Value : integer

IldOuterJoinCapabilities 

CLI Code : 115 ; Item Value : integer ; Possible values :

IldCursorSensitivity 

CLI Code : 10001 ; Item Value : integer ; Possible values :

IldDescribeParameter 

CLI Code : 10002 ; Item Value : string

IldCatalogName 

CLI Code : 10003 ; Item Value : string

IldCollatingSequence 

CLI Code : 10004 ; Item Value : string

IldMaxIdentifierLength 

CLI Code : 10005 ; Item Value : integer

Variable Documentation

◆ IldAlterTableAddColumn

const IlInt IldAlterTableAddColumn

IldAlterTableAddColumn

◆ IldAlterTableAddConstraint

const IlInt IldAlterTableAddConstraint

IldAlterTableAddConstraint

◆ IldAlterTableAlterColumn

const IlInt IldAlterTableAlterColumn

IldAlterTableAlterColumn

◆ IldAlterTableDropColumn

const IlInt IldAlterTableDropColumn

IldAlterTableDropColumn

◆ IldAlterTableDropConstraint

const IlInt IldAlterTableDropConstraint

IldAlterTableDropConstraint

◆ IldCurBehaviorClose

const IlInt IldCurBehaviorClose

IldCurBehaviorClose

◆ IldCurBehaviorDelete

const IlInt IldCurBehaviorDelete

IldCurBehaviorDelete

◆ IldCurBehaviorPreserve

const IlInt IldCurBehaviorPreserve

IldCurBehabiorPreserve

◆ IldCursorAsensitive

const IlInt IldCursorAsensitive

IldCursorAsensitive

◆ IldCursorInsensitive

const IlInt IldCursorInsensitive

IldCursorInsensitive

◆ IldCursorSensitive

const IlInt IldCursorSensitive

IldCursorSensitive

◆ IldFetchDirectionAbsolute

const IlInt IldFetchDirectionAbsolute

IldFetchDirectionAbsolute

◆ IldFetchDirectionFirst

const IlInt IldFetchDirectionFirst

IldFetchDirectionFirst

◆ IldFetchDirectionLast

const IlInt IldFetchDirectionLast

IldFetchDirectionLast

◆ IldFetchDirectionNext

const IlInt IldFetchDirectionNext

IldFetchDirectionNext

◆ IldFetchDirectionPrior

const IlInt IldFetchDirectionPrior

IldFetchDirectionPrior

◆ IldFetchDirectionRelative

const IlInt IldFetchDirectionRelative

IldFetchDirectionRelative

◆ IldGetDataAnyColumn

const IlInt IldGetDataAnyColumn

IldGetDataAnyColumn

◆ IldGetDataAnyOrder

const IlInt IldGetDataAnyOrder

IldGetDataAnyOrder

◆ IldIdentifierLower

const IlInt IldIdentifierLower

IldIdentifierLower

◆ IldIdentifierMixed

const IlInt IldIdentifierMixed

IldIdentifierMixed

◆ IldIdentifierSensitive

const IlInt IldIdentifierSensitive

IldIdentifierSensitive

◆ IldIdentifierUpper

const IlInt IldIdentifierUpper

IldIdentifierUpper

◆ IldNullCollateHigh

const IlInt IldNullCollateHigh

IldNullCollateHigh

◆ IldNullCollateLow

const IlInt IldNullCollateLow

IldNullCollateLow

◆ IldOuterJoinAllOps

const IlInt IldOuterJoinAllOps

IldOuterJoinAllOps

◆ IldOuterJoinFull

const IlInt IldOuterJoinFull

IldOuterJoinFull

◆ IldOuterJoinInner

const IlInt IldOuterJoinInner

IldOuterJoinInner

◆ IldOuterJoinLeft

const IlInt IldOuterJoinLeft

IldOuterJoinLeft

◆ IldOuterJoinNested

const IlInt IldOuterJoinNested

IldOuterJoinNested

◆ IldOuterJoinNotOrdered

const IlInt IldOuterJoinNotOrdered

IldOuterJoinNotOrdered

◆ IldOuterJoinRight

const IlInt IldOuterJoinRight

IldOuterJoinRight

◆ IldScrollLock

const IlInt IldScrollLock

IldScrollLock

◆ IldScrollOptRowver

const IlInt IldScrollOptRowver

IldScrollOptRowver

◆ IldScrollOptValues

const IlInt IldScrollOptValues

IldScrollOptValues

◆ IldScrollReadOnly

const IlInt IldScrollReadOnly

IldScrollReadOnly

◆ IldSQLAllTypes

const short IldSQLAllTypes

IldSQLAllTypes

◆ IldSQLBFile

const short IldSQLBFile

IldSQLBFile

◆ IldSQLBigint

const short IldSQLBigint

IldSQLBigint

◆ IldSQLBin

const short IldSQLBin

IldSQLBin

◆ IldSQLBit

const short IldSQLBit

IldSQLBit (Deprecated with ISO/IEC 9075-3:2003)

◆ IldSQLBitVarying

const short IldSQLBitVarying

IldSQLBitVarying (Deprecated with ISO/IEC 9075-3:2003)

◆ IldSQLBLOB

const short IldSQLBLOB

IldSQLBLOB

◆ IldSQLBoolean

const short IldSQLBoolean

IldSQLBoolean

◆ IldSQLByte

const short IldSQLByte

IldSQLByte

◆ IldSQLChar

const short IldSQLChar

IldSQLChar

◆ IldSQLCLOB

const short IldSQLCLOB

IldSQLCLOB

◆ IldSQLCursor

const short IldSQLCursor

IldSQLCursor

◆ IldSQLDate

const short IldSQLDate

IldSQLDate

◆ IldSQLDateTime

const short IldSQLDateTime

IldSQLDateTime

◆ IldSQLDecimal

const short IldSQLDecimal

IldSQLDecimal

◆ IldSQLDouble

const short IldSQLDouble

IldSQLDouble

◆ IldSQLFloat

const short IldSQLFloat

IldSQLFloat

◆ IldSQLInteger

const short IldSQLInteger

IldSQLInteger

◆ IldSQLInterval

const short IldSQLInterval

IldSQLInterval

◆ IldSQLIntervalDay

const short IldSQLIntervalDay

IldSQLIntervalDay

◆ IldSQLIntervalDH

const short IldSQLIntervalDH

IldSQLIntervalDH

◆ IldSQLIntervalDM

const short IldSQLIntervalDM

IldSQLIntervalDM

◆ IldSQLIntervalDS

const short IldSQLIntervalDS

IldSQLIntervalDS

◆ IldSQLIntervalHM

const short IldSQLIntervalHM

IldSQLIntervalHM

◆ IldSQLIntervalHour

const short IldSQLIntervalHour

IldSQLIntervalHour

◆ IldSQLIntervalHS

const short IldSQLIntervalHS

IldSQLIntervalHS

◆ IldSQLIntervalMinute

const short IldSQLIntervalMinute

IldSQLIntervalMinute

◆ IldSQLIntervalMonth

const short IldSQLIntervalMonth

IldSQLIntervalMonth

◆ IldSQLIntervalMS

const short IldSQLIntervalMS

IldSQLIntervalMS

◆ IldSQLIntervalSecomd

const short IldSQLIntervalSecomd

IldSQLIntervalSecond

◆ IldSQLIntervalYear

const short IldSQLIntervalYear

IldSQLIntervalYear

◆ IldSQLIntervalYM

const short IldSQLIntervalYM

IldSQLIntervalYM

◆ IldSQLLongBin

const short IldSQLLongBin

IldSQLLongBin

◆ IldSQLMoney

const short IldSQLMoney

IldSQLMoney

◆ IldSQLNamedType

const short IldSQLNamedType

IldSQLNamedType

◆ IldSQLNamedTypeRef

const short IldSQLNamedTypeRef

IldSQLReference

◆ IldSQLNumeric

const short IldSQLNumeric

IldSQLNumeric

◆ IldSQLReal

const short IldSQLReal

IldSQLReal

◆ IldSQLRef

const short IldSQLRef

IldSQLRef

◆ IldSQLRow

const short IldSQLRow

IldSQLRow

◆ IldSQLSmallint

const short IldSQLSmallint

IldSQLSmallint

◆ IldSQLText

const short IldSQLText

IldSQLText

◆ IldSQLTime

const short IldSQLTime

IldSQLTime

◆ IldSQLTimestamp

const short IldSQLTimestamp

IldSQLTimestamp

◆ IldSQLTimestampTZ

const short IldSQLTimestampTZ

IldSQLTimestampTZ

◆ IldSQLTimeTZ

const short IldSQLTimeTZ

IldSQLTimeTZ

◆ IldSQLVarBin

const short IldSQLVarBin

IldSQLVarBin

◆ IldSQLVarchar

const short IldSQLVarchar

IldSQLVarchar

◆ IldTransCapableAll

const IlInt IldTransCapableAll

IldTransCapableAll

◆ IldTransCapableDDLCommit

const IlInt IldTransCapableDDLCommit

IldTransCapableDDLCommit

◆ IldTransCapableDDLIgnore

const IlInt IldTransCapableDDLIgnore

IldTransCapableDDLIgnore

◆ IldTransCapableDML

const IlInt IldTransCapableDML

IldTransCapableDML

◆ IldTransCapableNone

const IlInt IldTransCapableNone

IldTransCapableNone

◆ IldTransIsolReadCommitted

const IlInt IldTransIsolReadCommitted

IldTransIsolReadCommitted

◆ IldTransIsolReadUncommitted

const IlInt IldTransIsolReadUncommitted

IldTransIsolReadUncommitted

◆ IldTransIsolRepeatableRead

const IlInt IldTransIsolRepeatableRead

IldTransIsolRepeatableRead

◆ IldTransIsolSerializable

const IlInt IldTransIsolSerializable

IldTransIsolSerializable