Rogue Wave DB Link V5.5 User’s Manual > Configuration Issues > Server Information
 
Server Information
Information about implementation is retrieved by calling the function IldDbms::getInfo. The first argument of this function takes its value in the enumeration type IldInfoItem.
The enumeration is defined in the file ildconst.h. It uses the CLI-defined symbols, prefixed with the Rogue Wave DB Link prefix Ild, and complies with the CLI numeric values of these symbols. The values returned by the function getInfo also are compliant with the CLI specifications except for IldOuterJoinCapabilities, where a number is returned instead of a one-character string.
For information items whose value is a string, the server usually returns the exact value to the appropriate query, but for those with numeric values, these values are translated to symbols derived from the CLI standard.
The following table lists the type of the output argument from the function IldDbms::getInfo that is used to return the value of the item.
Server Information Items 
Symbol
CLI Code
Item Value
Possible Values
IldAlterTable
86
integer
Depending on the RDBMS SQL implementation, this item returns a value resulting from the logical OR combination of:
*IldAlterTableAddColumn (1),
*IldAlterTableDropColumn (2),
*IldAlterTableAlterColumn (4),
*IldAlterTableAddConstraint (8), and
*IldAlterTableDropConstraint (16).
IldCatalogName
10003
string
 
IldCollatingSequence
10004
string
 
IldCursorCommitBehavior
23
integer
This item returns one of the following values, depending on the connected RDBMS:
*IldCurBehaviorDelete (0),
*IldCurBehaviorClose (1), or
*IldCurBehaviorPreserve (2).
IldCursorSensitivity
10001
integer
This item returns one of the following values:
*IldCursorASensitive (0),
*IldCursorInSensitive (1), or
*IldCursorSensitive (2)
IldDataSourceName
2
string
 
IldDataSourceReadOnly
25
string
 
IldDBMSName
17
string
 
IldDBMSVersion
18
string
 
IldDefTransactionIsolation
26
integer
This item returns one of the following values:
*IldTransIsolReadUncommitted (1),
*IldTransIsolReadCommitted (2),
*IldTransIsolRepeatableRead (3), or
*IldTransIsolSerializable (4)
IldDescribeParameter
10002
string
 
IldFetchDirection
8
integer
This item returns a logical OR operation between all supported fetch directions. For databases that do not support scrollable cursors, the only possible value will be IldFetchDirectionNext (1).
*IldFetchDirectionNext (1),
*IldFetchDirectionFirst (2),
*IldFetchDirectionLast (4),
*IldFetchDirectionPrior (8),
*IldFetchDirectionAbsolute(16), and
*IldFetchDirectionRelative (32)
IldGetDataExtension
81
integer
For this item, the returned value is always the sum of:
*IldGetDataAnyColumn (1) and
*IldGetDataAnyOrder (2)
because Rogue Wave DB Link implements these capabilities for all supported RDBMSs.
IldIdentifierCase
28
integer
This item returns one of the following values:
*IldIdentifierUpper (1),
*IldIdentifierLower (2),
*IldIdentifierSensitive (3), or
*IldIdentifierMixed (4)
IldIntegrity
73
string
 
IldMaxCatalogNameLength
34
integer
 
IldMaxColumnsInGroupBy
97
integer
 
IldMaxColumnsInOrderBy
99
integer
 
IldMaxColumnsInSelect
100
integer
 
IldMaxColumnsInTable
101
integer
 
IldMaxColumnNameLength
30
integer
 
IldMaxConcurrentActivities
1
integer
 
IldMaxCursorNameLength
31
integer
 
IldMaxDriverConnections
0
integer
 
IldMaxIdentifierLength
10005
integer
 
IldMaxSchemaNameLength
32
integer
 
IldMaxStatementLength
105
integer
 
IldMaxTableNameLength
35
integer
 
IldMaxTablesInSelect
106
integer
 
IldMaxUserNameLength
107
integer
 
IldNullCollation
85
integer
This item returns one of the following values, depending on whether the RDBMS collates null values first or last in the result sets:
*IldNullCollateHigh (0) or
*IldNullCollateLow (1)
IldOrderByColumnsInSelect
90
string
 
IldOuterJoinCapabilities
115
integer
This item returns a logical OR operation between all supported outer join capabilities:
*IldOuterJoinLeft (1),
*IldOuterJoinRight (2),
*IldOuterJoinFull (4),
*IldOuterJoinNested (8),
*IldOuterJoinNotOrdered (16),
*IldOuterJoinInner (32), or
*IldOuterJoinAllOps (64)
IldScrollConcurrency
43
integer
This item returns a logical OR operation between all supported options:
*IldScrollReadOnly (1),
*IldScrollLock (2),
*IldScrollOptRowver (4), and
*IldScrollOptValues (8)
IldServerName
13
string
 
IldSpecialCharacters
94
string
 
IldTransactionCapable
46
integer
This item returns one of the following values:
*IldTransCapableNone (0),
*IldTransCapableDML (1),
*IldTransCapableAll (2),
*IldTransCapableDDLCommit (3), or
*IldTransCapableDDLIgnore (4).
IldTransactionIsolationOpt
72
integer
This item returns one of the following values:
*IldTransIsolReadUncommitted (1),
*IldTransIsolReadCommitted (2),
*IldTransIsolRepeatableRead (3), or
*IldTransIsolSerializable (4)
IldUserName
47
string
 
For all items that return an integer value, the return value is 0 if the value is unknown. When an error is raised during the retrieval of an information item, the integer argument is set to -1 and the string argument is set to the empty string (the first character is a null character).
Version 6.3
Copyright © 2018, Rogue Wave Software, Inc. All Rights Reserved.