IBM Books

Call Level Interface Guide and Reference

Index

Special Characters
A B C D E F G H I J K L M N O P Q R S T U V W X Y
Special Characters
  • (1264), (1622), (1624), (1719), (1721) , (1728), (1738), (1810) See also SQLSTATES, ODBC
  • % (1329)
  • _ (1328)
  • .INI file
  • db2cli.ini (1440)
  • ODBC (1445)
    • A
  • ABS Scalar function (1840)
  • Absolute value Scalar function (1841)
  • ACOS Scalar function (1842)
  • APD descriptor (1369)
  • APPENDAPINAME, keyword (1451)
  • application
  • sample (1997)
  • tasks (1184)
  • application parameter descriptor (1373)
  • application row descriptor (1374)
  • ARD descriptor (1370)
  • array input (1345)
  • array output (1355)
  • ASCII Scalar function (1821)
  • ASIN Scalar function (1843)
  • Assign File Reference, function (1520)
  • ASYNCENABLE, keyword (1452)
  • Asynchronous CLI (1424)
  • Asynchronous ODBC, enabling (1453)
  • ATAN Scalar function (1844)
  • ATAN2 Scalar function (1845)
  • ATOMIC Compound SQL (1387)
  • attributes
  • connection (1300)
  • environment (1299)
  • querying and setting (1298)
  • statement (1301)
    • B
  • BINARY
  • conversion to C (1966)
  • Bind A Buffer To A Parameter Marker, function (1524), (1526)
  • Bind Column, function (1515)
  • Bind File Reference, function (1518)
  • Bind Files and Package Names (1438)
  • BindFileToParam, function (1522)
  • binding DB2 CLI packages (1430)
  • binding, application variables
  • columns (1238)
  • columns with offset (1363)
  • parameter markers (1226)
  • parameter markers with offset (1351)
  • BITDATA, keyword (1454)
  • BLOB (1397)
  • conversion to C (1969)
  • browser.c (1333)
    • C
  • Call Level Interface (CLI)
  • advantages of using (1180), (1182)
  • comparing embedded SQL and DB2 CLI (1167)
  • overview (1165)
  • CALL Statement (1410)
  • Cancel statement, function (1528), (1530)
  • case sensitivity (1286)
  • catalog functions (1325)
  • catalog views
  • PROCEDURE PARAMETERS (1994)
  • PROCEDURES (1993)
  • catalogs, querying (1324)
  • CEILING Scalar function (1846)
  • CHAR
  • conversion to C (1952)
  • display size (1937)
  • length (1922)
  • precision (1892)
  • scale (1907)
  • CHAR Scalar function (1822)
  • character strings (1279), (1285)
  • CLI (1166) See also Call Level Interface (CLI)
  • CLI Stored Procedures (1409)
  • CLI/ODBC keywords (1441)
  • CLOB (1395)
  • conversion to C (1951)
  • Column binding offsets (1362)
  • Column Information, function (1568)
  • Column Privileges, function (1564), (1566)
  • column-wise array insert (1347)
  • Column-Wise Binding (1359)
  • column-wise binding (1357)
  • commit (1249)
  • common server (1820)
  • Compile and link options (1448)
  • Compound SQL (1384)
  • CONCAT Scalar function (1823)
  • concise descriptor functions (1382)
  • configuring
  • ODBC driver (1436), (1437)
  • Connect (1587) See also SQLDriverConnect
  • Connect, function (1572)
  • connection attributes (options) (1303)
  • connection handle (1173)
  • allocating (1194)
  • freeing (1195)
  • Connection Pooling (1730)
  • connection string (1307)
  • CONNECTTYPE, keyword (1455)
  • CONVERT Scalar function (1888)
  • coordinated distributed transactions (1314)
  • copying descriptors (1380)
  • core level functions (1161)
  • COS Scalar function (1847)
  • COT Scalar function (1848)
  • CURDATE Scalar function (1865)
  • CURRENTFUNCTIONPATH, keyword (1456)
  • CURRENTPACKAGESET, keyword (1457)
  • CURRENTSQLID, keyword (1458)
  • cursor (1248)
  • use in CLI (1168)
  • CURSORHOLD, keyword (1459)
  • Cursors
  • holding across rollbacks (1803)
  • scrollable (1335)
  • CURTIME Scalar function (1866)
  • custin.c (1354)
    • D
  • Data Conversion (1950), (1973), (1974), (1987)
  • data conversion
  • C data types (1269)
  • data types (1268)
  • default data types (1271)
  • description (1277)
  • display size of SQL data types (1935)
  • length of SQL data types (1920)
  • Precision of SQL data types (1890)
  • scale of SQL data types (1905)
  • SQL data types (1270)
  • data source information, querying (1290)
  • data types
  • C (1272), (1274)
  • generic (1275)
  • ODBC (1276)
  • SQL (1273)
  • data-at-execute (1339)
  • DATABASE Scalar function (1885)
  • DATE
  • conversion to C (1970)
  • display size (1947)
  • length (1932)
  • precision (1902)
  • scale (1917)
  • DAYNAME Scalar function (1867)
  • DAYOFMONTH Scalar function (1868)
  • DAYOFWEEK Scalar function (1869)
  • DAYOFYEAR Scalar function (1870)
  • DB2 CLI
  • function list (1506)
  • db2cli.ini (1306), (1439)
  • DB2CLI_VER (1808)
  • DB2DEGREE, keyword (1460)
  • DB2ESTIMATE, keyword (1462)
  • DB2EXPLAIN, keyword (1463)
  • DB2OPTIMIZATION, keyword (1464)
  • DBALIAS, keyword (1465)
  • DBCLOB (1396)
  • conversion to C (1958)
  • DBNAME, keyword (1466)
  • DECIMAL
  • conversion to C (1959)
  • display size (1940)
  • length (1925)
  • precision (1895)
  • scale (1910)
  • DEFAULTPROCLIBRARY, keyword (1467)
  • deferred arguments (1228)
  • deferred prepare, migration (1806)
  • DEFERREDPREPARE, keyword (1468)
  • DEGREES Scalar function (1849)
  • deprecated function
  • list of functions (1805)
  • SQLAllocConnect (1508), (1609)
  • SQLAllocEnv (1510)
  • SQLAllocStmt (1512)
  • SQLAllocTransact (1801)
  • SQLBindParam (1740)
  • SQLColAttributes (1560)
  • SQLError (1590)
  • SQLExtendedFetch (1598)
  • SQLFreeConnect (1607)
  • SQLFreeStmt (1611)
  • SQLGetConnectOption (1613)
  • SQLGetStmtOption (1641)
  • SQLParamOptions (1668)
  • SQLSetConnectOption (1722)
  • SQLSetParam (1739)
  • SQLSetStmtOption (1783)
  • Describe Column Attributes, function (1579)
  • descriptor handle (1174), (1366)
  • Descriptors
  • descriptors
  • 4 different types (1368)
  • concise functions (1383)
  • consistency checks (1379)
  • copying (1381)
  • descriptor records (1378)
  • general (1365)
  • header fields (1377)
  • diagnostics (1254)
  • DIFFERENCE Scalar function (1824)
  • DISABLEMULTITHREAD, keyword (1469)
  • Disconnect, function (1582), (1584)
  • display size of SQL data types (1936)
  • distributed transactions (1315)
  • Distributed Unit of Work (1312)
  • distributed unit of work (1313)
  • DOUBLE
  • conversion to C (1965)
  • display size (1946)
  • length (1931)
  • precision (1901)
  • scale (1916)
  • driver manager (1812)
  • driver, CLI (1814)
  • driver, ODBC (1813)
  • DriverConnect, function (1586), (1589)
    • E
  • EARLYCLOSE, keyword (1470)
  • Embedded SQL
  • embedded SQL (1999)
  • Mixing with DB2 CLI (1422)
  • END COMPOUND, CLI extension (1389)
  • environment attributes (options) (1302)
  • environment handle (1172)
  • allocating (1192)
  • freeing (1193)
  • environment information, querying (1289)
  • Escape Clauses, Vendor (1426)
  • establishing coordinated transactions (1321)
  • examples
  • array INSERT (1353)
  • browser.c (1332)
  • catalog functions (1331)
  • Compound SQL (1390)
  • stored procedure (1420)
  • User Defined Type (1407)
  • execute direct (1217)
  • execute statement (1216)
  • Execute statement Directly, function (1593)
  • Execute statement, function (1596)
  • EXP Scalar function (1850)
    • F
  • FAR pointers (1504)
  • Fetch, function (1601)
  • Fetching Data in Pieces (1344)
  • Flags, for compiling and linking (1450)
  • FLOAT
  • conversion to C (1964)
  • display size (1945)
  • length (1930)
  • precision (1899)
  • scale (1915)
  • FLOOR Scalar function (1851)
  • Foreign Key Column Names, function (1606)
  • Foreign Keys Columns, function (1604)
  • FREE LOCATOR statement (1400)
  • function list, ODBC (1815)
  • functions
  • by category (1507)
    • G
  • GATEWAYVERSION, keyword (1471)
  • Get Column Names for a Table, function (1570)
  • Get Cursor Name, function (1616)
  • Get Data Sources, function (1575), (1577)
  • Get Data, function (1619)
  • Get Functions, function (1626), (1628)
  • Get Index and Statistics Information for a Table, function (1790), (1792)
  • Get Info, function (1630), (1632)
  • Get List of Procedure Names (1683)
  • Get List of Procedure Names, function (1685)
  • Get Number of Result Columns (1661)
  • Get Parameters for a Procedure, function (1681)
  • Get Row Count, function (1691)
  • Get Special (Row Identifier) Columns, function (1788)
  • Get Special Column Names, function (1786)
  • Get SQLCA Data Structure, function (1638), (1640)
  • Get Table Information, function (1798), (1800)
  • Get Type Information, function (1646)
  • global dynamic statement cache (1222)
  • GRANTEELIST, keyword (1472)
  • GRANTORLIST, keyword (1473)
  • GRAPHIC
  • conversion to C (1955)
  • GRAPHIC, keyword (1474)
    • H
  • handle
  • connection handle (1176), (1191)
  • descriptor handle (1177), (1367)
  • environment handle (1175), (1190)
  • statement handle (1171)
  • HOUR Scalar function (1871)
    • I
  • IFNULL Scalar function (1886)
  • IGNOREWARNINGS, keyword (1475)
  • implementation parameter descriptor (1375)
  • implementation row descriptor (1376)
  • initialization (1185), (1188)
  • initialization file (1305)
  • initialization file, ODBC (1444)
  • INSERT Scalar function (1825)
  • installing DB2 CLI
  • for application development (1446)
  • INTEGER
  • conversion to C (1962)
  • display size (1943)
  • length (1928)
  • precision (1898)
  • scale (1913)
  • introduction, to CLI (1158)
  • INVALID_HANDLE (1261)
  • IPD descriptor (1371)
  • IRD descriptor (1372)
  • isolation levels, ODBC (1819)
    • J
  • JULIAN_DAY Scalar function (1872)
    • K
  • KEEPCONNECT, keyword (1476)
  • KEEPSTATEMENT, keyword (1477)
    • L
  • Large Objects
  • Binary (BLOB) (1393)
  • Character (CLOB) (1391)
  • Double Byte Character (DBCLOB) (1392)
  • LONGDATACOMPAT (1402)
  • using in ODBC applications (1401)
  • LCASE Scalar function (1826)
  • LEFT Scalar function (1828)
  • length of SQL data types (1921)
  • LENGTH Scalar function (1829)
  • Link options (1449)
  • LOB locator (1398)
  • LOBMAXCOLUMNSIZE, keyword (1478)
  • LOBS (1394) See also see, Large Objects
  • LOCATE Scalar function (1830)
  • locator, LOB (1399)
  • LOG Scalar function (1852)
  • LOG10 Scalar function (1853)
  • long data
  • retrieving in pieces (1338)
  • sending in pieces (1337)
  • LONGDATACOMPAT (1403)
  • LONGDATACOMPAT, keyword (1479)
  • LONGVARBINARY
  • conversion to C (1968)
  • LONGVARCHAR
  • conversion to C (1954)
  • display size (1939)
  • length (1924)
  • precision (1894)
  • scale (1909)
  • LONGVARGRAPHIC
  • conversion to C (1957)
  • Lower case conversion Scalar function (1827)
  • LTRIM Scalar function (1831)
    • M
  • MAXCONN, keyword (1480)
  • metadata characters (1330)
  • Microsoft ODBC (1811)
  • Microsoft ODBC Driver Manager (1433)
  • midnight, seconds since Scalar function (1880)
  • MINUTE Scalar function (1873)
  • Mixing Embedded SQL and DB2 CLI (1423)
  • MOD Scalar function (1854)
  • MODE, keyword (1481)
  • MONTH Scalar function (1874)
  • MONTHNAME Scalar function (1875)
  • More Result Sets, function (1649), (1651)
  • multi-threaded application (1309)
  • MULTICONNECT, keyword (1482)
  • multiple connections (1804)
  • multiple SQL statements (1385)
    • N
  • native error code (1267)
  • Native SQL Text, function (1653), (1655)
  • NOT ATOMIC Compound SQL (1388)
  • NOW Scalar function (1876)
  • null connect (1419)
  • null-terminated strings (1281)
  • null-termination of strings (1282)
  • Number of Parameters, function (1657), (1659)
  • Number of Result Columns, function (1662)
  • NUMERIC
  • conversion to C (1960)
  • display size (1941)
  • length (1926)
  • precision (1896)
  • scale (1911)
    • O
  • ODBC (1213)
  • and DB2 CLI (1159), (1809)
  • core level functions (1160)
  • function list (1816)
  • isolation levels (1817)
  • odbc.ini file (1442)
  • odbcinst.ini file (1443)
  • registering the driver manager (1435)
  • running programs (1431)
  • ODBC vendor escape clauses (1427)
  • odbcad32.exe (1432)
  • offset
  • binding columns (1364)
  • binding parameter markers (1352)
  • OPTIMIZEFORNROWS, keyword (1483)
  • options
  • connection (1296)
  • environment (1295)
  • querying and setting (1294)
  • statement (1297)
    • P
  • Parallelism, Setting degree of (1461)
  • parameter binding offsets (1350)
  • Parameter Data, function (1665), (1667)
  • parameter markers (1169)
  • array input (1346)
  • parameter markers, binding (1225)
  • PATCH1, keyword (1484)
  • PATCH2, keyword (1485)
  • pattern-values (1327)
  • PI Scalar function (1855)
  • pointers, FAR (1505)
  • POPUPMESSAGE, keyword (1486)
  • portability (1181)
  • POWER Scalar function (1856)
  • precision of SQL data types (1891)
  • prepare statement (1215)
  • Prepare statement, function (1671), (1673)
  • prerequisites for DB2 CLI
  • for application development (1447)
  • Primary Key Columns, function (1675), (1677)
  • Procedure Parameter Information, function (1679)
  • Put Data for a Parameter, function (1687), (1689)
  • PWD, keyword (1487)
    • Q
  • QUARTER Scalar function (1877)
  • Query Statements (1233)
  • querying data source information (1288)
  • querying environment information (1287)
  • querying system catalog information (1322)
    • R
  • RADINS Scalar function (1857)
  • RAND Scalar function (1858)
  • REAL
  • conversion to C (1963)
  • display size (1944)
  • length (1929)
  • precision (1900)
  • scale (1914)
  • reentrant (multi-threaded) (1310)
  • registering
  • ODBC driver manager (1434)
  • registering stored procedures (1413)
  • REPEAT Scalar function (1832)
  • REPLACE Scalar function (1833)
  • Retrieve Length of String Value, function (1634)
  • Retrieve Portion of A String Value, function (1644)
  • retrieving multiple rows (1356)
  • return codes (1255)
  • Return Starting Position of String, function (1636)
  • RIGHT Scalar function (1834)
  • rollback (1250)
  • ROUND Scalar function (1859)
  • row-wise array insert (1348)
  • Row-Wise Binding (1358), (1361)
  • rowset
  • scrollable cursors (1336)
  • RTRIM Scalar function (1835)
  • runtime support (1429)
    • S
  • sample application (1998)
  • scale of SQL data types (1906)
  • SCHEMALIST, keyword (1488)
  • Scrollable Cursors (1334)
  • search arguments (1326)
  • SECOND Scalar function (1878)
  • SECONDS_SINCE_MIDNIGHT Scalar function (1879)
  • SELECT (1232)
  • Set Cursor Name, function (1725)
  • SIGN Scalar function (1860)
  • SIN Scalar function (1861)
  • SMALLINT
  • conversion to C (1961)
  • display size (1942)
  • length (1927)
  • precision (1897)
  • scale (1912)
  • SOUNDEX Scalar function (1836)
  • SPACE Scalar function (1837)
  • SQL
  • dynamically prepared (1179)
  • parameter markers (1224)
  • preparing and executing statements (1214)
  • Query Statements (1230)
  • SELECT (1229)
  • statements
  • DELETE (1247)
  • UPDATE (1246)
  • VALUES (1231)
  • SQL Access Group (1164)
  • SQLAllocConnect, deprecated function (1509), (1610)
  • SQLAllocEnv, deprecated function (1511)
  • SQLAllocStmt, deprecated function (1513)
  • SQLAllocStmt, function
  • overview (1196)
  • SQLAllocTransact, deprecated function (1802)
  • SQLBindCol, function
  • description (1514), (1516)
  • overview (1197), (1239)
  • SQLBindFileToCol, function
  • description (1517)
  • SQLBindFileToParam, function
  • description (1519), (1521)
  • SQLBindParam, deprecated function (1742)
  • SQLBindParameter, function
  • description (1523), (1525)
  • overview (1244)
  • SQLCancel, function
  • description (1527), (1529)
  • use in data-at-execute (1343)
  • SQLColAttributes, deprecated function (1561)
  • SQLColAttributes, function
  • overview (1198), (1235)
  • SQLColumnPrivileges, function
  • description (1563), (1565)
  • SQLColumns, function
  • description (1567), (1569)
  • SQLConnect, function
  • description (1571), (1573)
  • SQLDataSources, function
  • description (1574), (1576)
  • overview (1199)
  • SQLDescribeCol, function
  • description (1578), (1580)
  • overview (1200), (1236)
  • SQLDisconnect, function
  • description (1581), (1583)
  • SQLDriverConnect() (1308)
  • SQLDriverConnect, function
  • description (1585), (1588)
  • SQLERRD() (1807)
  • SQLError, deprecated function (1591)
  • SQLExecDirect, function
  • description (1592), (1594)
  • overview (1201), (1218)
  • SQLExecute, function
  • description (1595), (1597)
  • overview (1202), (1219)
  • SQLExtendedFetch, deprecated function (1599)
  • SQLFetch, function
  • description (1600), (1602)
  • overview (1203), (1240)
  • SQLForeignKeys, function
  • description (1603), (1605)
  • SQLFreeConnect, deprecated function (1608)
  • SQLFreeStmt, deprecated function (1612)
  • SQLFreeStmt, function
  • overview (1204)
  • SQLGetConnectOption, deprecated function (1614)
  • SQLGetCursorName, function
  • description (1615), (1617)
  • SQLGetData, function
  • description (1618), (1620)
  • overview (1205), (1241)
  • SQLGetEnvAttr, function (1621), (1623)
  • SQLGetFunctions, function
  • description (1625), (1627)
  • SQLGetInfo, function
  • description (1629), (1631)
  • SQLGetLength, function
  • description (1633)
  • SQLGetPosition, function
  • description (1635)
  • SQLGetSQLCA, function
  • description (1637), (1639)
  • SQLGetStmtOption, deprecated function (1642)
  • SQLGetSubString, function
  • description (1643)
  • SQLGetTypeInfo, function
  • description (1645), (1647)
  • SQLMoreResults, function
  • description (1648), (1650)
  • use of (1349)
  • SQLNativeSql, function
  • description (1652), (1654)
  • SQLNumParams, function
  • description (1656), (1658)
  • SQLNumResultCols, function
  • description (1660), (1663)
  • overview (1206), (1237)
  • SQLParamData, function
  • description (1664), (1666)
  • use in data-at-execute (1341)
  • SQLParamOptions, deprecated function (1669)
  • SQLPrepare, function
  • description (1670), (1672)
  • overview (1207), (1220), (1242)
  • SQLPrimaryKeys, function
  • description (1674), (1676)
  • SQLProcedureColumns, function
  • description (1678), (1680)
  • SQLProcedures, function
  • description (1682), (1684)
  • SQLPutData, function
  • description (1686), (1688)
  • use in data-at-execute (1342)
  • SQLRowCount, function
  • description (1690), (1692)
  • overview (1208)
  • SQLSetConnection, function (1718), (1720)
  • SQLSetConnectOption, deprecated function (1723)
  • SQLSetCursorName, function
  • description (1724), (1726)
  • SQLSetEnvAttr, function (1727), (1737)
  • SQLSetParam, deprecated function (1741)
  • SQLSetParam, function
  • overview (1209), (1221), (1227), (1243)
  • SQLSetStmtOption, deprecated function (1784)
  • SQLSpecialColumns, function
  • description (1785), (1787)
  • SQLSTATE
  • 07002 (1562)
  • function cross reference (1889)
  • in CLI (1178)
  • SQLSTATE, format of (1265)
  • SQLSTATEFILTER, keyword (1489)
  • SQLSTATEs (1263)
  • SQLStatistics, function
  • description (1789), (1791)
  • SQLTablePrivileges, function
  • description (1793), (1795)
  • SQLTables, function
  • description (1797), (1799)
  • SQLTransact, function
  • overview (1210), (1245), (1252)
  • SQL_ATTR_ACCESS_MODE (1693)
  • SQL_ATTR_APP_PARAM_DESC (1743)
  • SQL_ATTR_ASYNC_ENABLE (1694), (1745)
  • SQL_ATTR_AUTOCOMMIT (1696)
  • SQL_ATTR_AUTO_IPD (1695)
  • SQL_ATTR_BIND_TYPE (1746)
  • SQL_ATTR_CONCURRENCY (1747)
  • SQL_ATTR_CONNECTION_POOLING (1729)
  • SQL_ATTR_CONNECTION_TIMEOUT (1698)
  • SQL_ATTR_CONNECTTYPE (1316), (1699), (1731)
  • SQL_ATTR_CONN_CONTEXT (1697)
  • SQL_ATTR_CP_MATCH (1732)
  • SQL_ATTR_CURRENT_CATALOG (1700)
  • SQL_ATTR_CURRENT_SCHEMA (1701)
  • SQL_ATTR_CURSOR_HOLD (1748)
  • SQL_ATTR_CURSOR_TYPE (1749)
  • SQL_ATTR_DB2ESTIMATE (1702)
  • SQL_ATTR_DB2EXPLAIN (1703)
  • SQL_ATTR_DEFERRED_PREPARE (1750)
  • SQL_ATTR_EARLYCLOSE (1751)
  • SQL_ATTR_ENABLE_AUTO_IPD (1752)
  • SQL_ATTR_FETCH_BOOKMARK (1753)
  • SQL_ATTR_IMP_PARAM_DESC (1754)
  • SQL_ATTR_KEYSET_SIZE (1756)
  • SQL_ATTR_LOGIN_TIMEOUT (1704)
  • SQL_ATTR_LONGDATA_COMPAT (1404), (1705)
  • SQL_ATTR_MAXCONN (1706), (1733)
  • SQL_ATTR_MAX_LENGTH (1757)
  • SQL_ATTR_MAX_ROWS (1758)
  • SQL_ATTR_METADATA_ID (1707), (1759)
  • SQL_ATTR_NODESCRIBE (1760)
  • SQL_ATTR_NOSCAN (1761)
  • SQL_ATTR_ODBC_CURSORS (1708)
  • SQL_ATTR_ODBC_VERSION (1734)
  • SQL_ATTR_OUTPUT_NTS (1735)
  • SQL_ATTR_PACKET_SIZE (1709)
  • SQL_ATTR_PARAMOPT_ATOMIC (1766)
  • SQL_ATTR_PARAMSET_SIZE (1768)
  • SQL_ATTR_PARAMS_PROCESSED_PTR (1767)
  • SQL_ATTR_PARAM_BIND_OFFSET_PTR (1762)
  • SQL_ATTR_PARAM_BIND_TYPE (1763)
  • SQL_ATTR_PARAM_OPERATION_PTR (1764)
  • SQL_ATTR_PARAM_STATUS_PTR (1765)
  • SQL_ATTR_QUERY_TIMEOUT (1769)
  • SQL_ATTR_QUIET_MODE (1710)
  • SQL_ATTR_RETRIEVE_DATA (1770)
  • SQL_ATTR_ROWSET_SIZE (1778)
  • SQL_ATTR_ROWS_FETCHED_PTR (1777)
  • SQL_ATTR_ROW_ARRAY_SIZE (1360), (1771)
  • SQL_ATTR_ROW_BIND_OFFSET_PTR (1772)
  • SQL_ATTR_ROW_BIND_TYPE (1773)
  • SQL_ATTR_ROW_DESC (1744), (1755)
  • SQL_ATTR_ROW_NUMBER (1774)
  • SQL_ATTR_ROW_OPERATION_PTR (1775)
  • SQL_ATTR_ROW_STATUS_PTR (1776)
  • SQL_ATTR_SIMULATE_CURSOR (1779)
  • SQL_ATTR_STMTTXN_ISOLATION (1780)
  • SQL_ATTR_SYNC_POINT (1711), (1736)
  • SQL_ATTR_TRACE (1712)
  • SQL_ATTR_TRACEFILE (1713)
  • SQL_ATTR_TRANSLATE_LIB (1714)
  • SQL_ATTR_TRANSLATE_OPTION (1715)
  • SQL_ATTR_TXN_ISOLATION (1716), (1781)
  • SQL_ATTR_USE_BOOKMARKS (1782)
  • SQL_ATTR_WCHARTYPE (1717)
  • SQL_CONCURRENT_TRANS (1317)
  • SQL_COORDINATED_TRANS (1318)
  • SQL_C_BINARY
  • conversion from SQL (1982)
  • SQL_C_BIT
  • conversion from SQL (1981)
  • SQL_C_CHAR
  • conversion from SQL (1975)
  • SQL_C_DATE
  • conversion from SQL (1984)
  • SQL_C_DBCHAR
  • conversion from SQL (1983)
  • SQL_C_DOUBLE
  • conversion from SQL (1979)
  • SQL_C_FLOAT
  • conversion from SQL (1978)
  • SQL_C_LONG
  • conversion from SQL (1977)
  • SQL_C_SHORT
  • conversion from SQL (1976)
  • SQL_C_TIME
  • conversion from SQL (1985)
  • SQL_C_TIMESTAMP
  • conversion from SQL (1986)
  • SQL_C_TINYINT
  • conversion from SQL (1980)
  • SQL_DATA_AT_EXEC (1340)
  • SQL_DESC_AUTO_UNIQUE_VALUE (1531)
  • SQL_DESC_BASE_COLUMN_NAME (1532)
  • SQL_DESC_BASE_TABLE_NAME (1533)
  • SQL_DESC_CASE_SENSITIVE (1534)
  • SQL_DESC_CATALOG_NAME (1535)
  • SQL_DESC_CONCISE_TYPE (1536)
  • SQL_DESC_COUNT (1537)
  • SQL_DESC_DISPLAY_SIZE (1538)
  • SQL_DESC_DISTINCT_TYPE (1539)
  • SQL_DESC_FIXED_PREC_SCALE (1540)
  • SQL_DESC_LABEL (1541)
  • SQL_DESC_LENGTH (1542)
  • SQL_DESC_LITERAL_PREFIX (1543)
  • SQL_DESC_LITERAL_SUFFIX (1544)
  • SQL_DESC_LOCAL_TYPE_NAME (1545)
  • SQL_DESC_NAME (1546)
  • SQL_DESC_NULLABLE (1547)
  • SQL_DESC_NUM_PREX_RADIX (1548)
  • SQL_DESC_OCTECT_LENGTH (1549)
  • SQL_DESC_PRECISION (1550)
  • SQL_DESC_SCALE (1551)
  • SQL_DESC_SCHEMA_NAME (1552)
  • SQL_DESC_SEARCHABLE (1553)
  • SQL_DESC_TABEL_NAME (1554)
  • SQL_DESC_TYPE (1555)
  • SQL_DESC_TYPE_NAME (1556)
  • SQL_DESC_UNNAMED (1557)
  • SQL_DESC_UNSIGNED (1558)
  • SQL_DESC_UPDATABLE (1559)
  • SQL_ERROR (1260)
  • SQL_NEED_DATA (1258)
  • SQL_NO_DATA_FOUND (1259)
  • SQL_NTS (1280)
  • SQL_ONEPHASE (1319)
  • SQL_STILL_EXECUTING (1262)
  • SQL_SUCCESS (1256)
  • SQL_SUCCESS_WITH_INFO (1257)
  • SQL_TWOPHASE (1320)
  • SQRT Scalar function (1862)
  • statement attributes (options) (1304)
  • statement cache (1223)
  • statement handle (1170)
  • allocating (1211)
  • freeing (1253)
  • maximum number of (1212)
  • Stored Procedures
  • argumemts (1414)
  • catalog table (1411)
  • catalog table for stored procedures (1990)
  • example (1421)
  • ODBC escape clause (1428)
  • registering (1412)
  • returning result sets (1416)
  • SYSCAT.PROCEDURES (1988)
  • SYSCAT.PROCEDURES table (1417)
  • SYSCAT.PROCPARMS (1989)
  • using the SQLDA (1415)
  • using with DB2 CLI (1408)
  • string arguments (1278), (1284)
  • sub-statements (1386)
  • SUBSTRING Scalar function (1838)
  • SYNCPOINT, keyword (1490)
  • SYSCAT.PROCEDURES (1991)
  • SYSCAT.PROCEDURES table (1418)
  • SYSCAT.PROCPARMS (1992)
  • SYSSCHEMA, keyword (1491)
  • system catalog
  • DB2CLI.PROCEDURES (1995)
  • pseudo table for stored procedures (1996)
  • system catalogs, querying (1323)
    • T
  • Table Privileges, function (1794), (1796)
  • TABLETYPE, keyword (1492)
  • TAN Scalar function (1863)
  • TEMPDIR, keyword (1493)
  • termination (1187), (1189)
  • threads (multi-threaded) (1311)
  • TIME
  • conversion to C (1971)
  • display size (1948)
  • length (1933)
  • precision (1903)
  • scale (1918)
  • TIMESTAMP
  • conversion to C (1972)
  • display size (1949)
  • length (1934)
  • precision (1904)
  • scale (1919)
  • TIMESTAMPADD Scalar function (1881)
  • TIMESTAMPDIFF Scalar function (1882)
  • TRACE, keyword (1494)
  • TRACEFILENAME, keyword (1495)
  • TRACEFLUSH, keyword (1496)
  • TRACEPATHNAME, keyword (1497)
  • transact isolation levels, ODBC (1818)
  • transaction management (1251)
  • transaction processing (1186)
  • TRANSLATEDLL, keyword (1498)
  • TRANSLATEOPTION, keyword (1499)
  • Triggers (1293)
  • TRUNCATE Scalar function (1864)
  • truncation (1283)
  • TXNISOLATION, keyword (1500)
    • U
  • UCASE Scalar function (1839)
  • UDFs (1292)
  • UDTs (1406)
  • UID, keyword (1501)
  • UNDERSCORE, keyword (1502)
  • User Defined Functions (1291)
  • User Defined Types (1405)
  • USER Scalar function (1887)
    • V
  • VALUES (1234)
  • VARBINARY
  • conversion to C (1967)
  • VARCHAR
  • conversion to C (1953)
  • display size (1938)
  • length (1923)
  • precision (1893)
  • scale (1908)
  • VARGRAPHIC
  • conversion to C (1956)
  • Vendor Escape Clauses (1425)
    • W
  • WARNINGLIST, keyword (1503)
  • WEEK Scalar function (1883)
  • writing DB2 CLI applications (1183)
    • X
  • X/Open CAE (1266)
  • X/Open Company (1162)
  • X/Open SQL CLI (1163)
    • Y
  • YEAR Scalar function (1884)

    • [ Top of Page | Previous Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]