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 |