IBM Books

Call Level Interface Guide and Reference


Index

Special Characters
Numerics
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
  • % (1646)
  • .INI file
  • db2cli.ini (1759)
  • ODBC (1764)
  • _ (1645)
  • Numerics
  • 2 phase commit (1602)
  • A
  • ABS Scalar function (2267)
  • Absolute value Scalar function (2268)
  • ACOS Scalar function (2269)
  • Administering Satellites Guide and Reference (2450)
  • Administration Guide (2430)
  • Administrative API Reference (2431)
  • allocating handles (1845)
  • APD descriptor (1688)
  • APPC, CPI-C and SNA Sense Codes (2433)
  • APPENDAPINAME, keyword (1770)
  • application
  • samples listing (2420)
  • tasks (1470)
  • Application Building Guide (2432)
  • Application Development Guide (2434)
  • application parameter descriptor (1692)
  • application row descriptor (1693)
  • ARD descriptor (1689)
  • array input (1664)
  • array output (1674)
  • ASCII Scalar function (2248)
  • ASIN Scalar function (2270)
  • Assign File Reference, function (1858)
  • ASYNCENABLE, keyword (1771)
  • Asynchronous CLI (1743)
  • Asynchronous ODBC, enabling (1772)
  • ATAN Scalar function (2271)
  • ATAN2 Scalar function (2272)
  • ATOMIC Compound SQL (1706)
  • attributes
  • connection (1584)
  • environment (1583)
  • querying and setting (1582)
  • statement (1585)
  • B
  • BIGINT
  • conversion to C (2389)
  • BINARY
  • conversion to C (2394)
  • Bind A Buffer To A Parameter Marker, function (1862), (1864)
  • Bind Column, function (1853)
  • Bind File Reference, function (1856)
  • Bind Files and Package Names (1757)
  • BindFileToParam, function (1860)
  • binding DB2 CLI packages (1749)
  • binding, application variables
  • array of columns (1956)
  • columns (1524)
  • columns with offset (1682)
  • parameter markers (1512)
  • parameter markers with offset (1670)
  • BITDATA, keyword (1773)
  • BLOB (1716)
  • conversion to C (2397)
  • browser.c (1650)
  • Bulk Operations, function (1870)
  • C
  • Call Level Interface (CLI)
  • advantages of using (1466), (1468)
  • comparing embedded SQL and DB2 CLI (1453)
  • overview (1451)
  • CALL Statement (1729)
  • Cancel statement, function (1872), (1874)
  • case sensitivity (1570)
  • catalog functions (1642)
  • catalogs, querying (1641)
  • CEILING Scalar function (2273)
  • CHAR
  • conversion to C (2379)
  • display size (2364)
  • length (2349)
  • precision (2319)
  • scale (2334)
  • CHAR Scalar function (2249)
  • character strings (1563), (1569)
  • CICS (1631)
  • CLI (1452) See also Call Level Interface (CLI)
  • CLI Guide and Reference (2435)
  • CLI Stored Procedures (1728)
  • CLI trace (2425)
  • CLI/ODBC keywords (1760)
  • client
  • accounting string for DB2 connect (2108)
  • application name for DB2 connect (2110)
  • user ID string for DB2 connect (2112)
  • workstation string for DB2 connect (2114)
  • CLISCHEMA, keyword (1774)
  • CLOB (1714)
  • conversion to C (2378)
  • close cursor, function (1876)
  • Column binding offsets (1681)
  • Column Information, function (1915)
  • Column Privileges, function (1911), (1913)
  • column-wise array insert (1666)
  • Column-Wise Binding (1678)
  • column-wise binding (1676)
  • Command Reference (2436)
  • commit (1535)
  • common server (2247)
  • Compile and link options (1767)
  • Compound SQL (1703)
  • CONCAT Scalar function (2250)
  • concise descriptor functions (1701)
  • configuring
  • ODBC driver (1755), (1756)
  • connect (1940) See also SQLDriverConnect
  • function (1919)
  • specify node to connect to (2097)
  • SQLDriverConnect (1941)
  • connection attributes (options) (1587)
  • getting using SQLGetConnectAttr (1986)
  • setting using SQLSetConnectAttr (2085)
  • connection handle (1459)
  • allocating (1480), (1847)
  • freeing (1481), (1979)
  • Connection Pooling (2143)
  • connection pooling, MTS (1625)
  • connection string (1591)
  • Connectivity Supplement (2440)
  • CONNECTNODE, keyword (1776)
  • CONNECTTYPE, keyword (1779)
  • CONVERT Scalar function (2315)
  • coordinated distributed transactions (1598)
  • copying descriptors (1699)
  • function (1922)
  • core level functions (1447)
  • COS Scalar function (2274)
  • COT Scalar function (2275)
  • CURDATE Scalar function (2292)
  • CURRENTFUNCTIONPATH, keyword (1780)
  • CURRENTPACKAGESET, keyword (1781)
  • CURRENTREFRESHAGE, keyword (1782)
  • CURRENTSCHEMA, keyword (1785)
  • CURRENTSQLID, keyword (1787)
  • cursor (1534)
  • use in CLI (1454)
  • CURSORHOLD, keyword (1788)
  • Cursors
  • closing (1877)
  • holding across rollbacks (2231)
  • keyset-driven (1655)
  • scrollable (1652)
  • CURTIME Scalar function (2293)
  • custin.c (1673)
  • D
  • Data Conversion (2377)
  • data conversion
  • C data types (1553)
  • data types (1552)
  • default data types (1555)
  • description (1561)
  • display size of SQL data types (2362)
  • length of SQL data types (2347)
  • Precision of SQL data types (2317)
  • scale of SQL data types (2332)
  • SQL data types (1554)
  • data link
  • build datalink value (1868)
  • Data Movement Utilities Guide and Reference (2437)
  • data source information, querying (1574)
  • data types
  • C (1556), (1558)
  • generic (1559)
  • ODBC (1560)
  • SQL (1557)
  • data-at-execute (1658)
  • DATABASE Scalar function (2312)
  • datalink
  • get datalink attribute value (1996)
  • DATE
  • conversion to C (2398)
  • display size (2374)
  • length (2359)
  • precision (2329)
  • scale (2344)
  • DAYNAME Scalar function (2294)
  • DAYOFMONTH Scalar function (2295)
  • DAYOFWEEK Scalar function (2296)
  • DAYOFYEAR Scalar function (2297)
  • DB2 as transaction manager (1604)
  • DB2 CLI
  • function list (1838)
  • DB2 Connect Enterprise Edition for OS/2 and Windows NT Quick Beginnings (2457)
  • DB2 Connect Enterprise Edition for UNIX Quick Beginnings (2458)
  • DB2 Connect Personal Edition Quick Beginnings (2438)
  • DB2 Connect User's Guide (2439)
  • DB2 Data Links Manager for AIX Quick Beginnings (2459)
  • DB2 Data Links Manager for Windows NT Quick Beginnings (2460)
  • DB2 Enterprise - Extended Edition for UNIX Quick Beginnings (2455)
  • DB2 Enterprise - Extended Edition for Windows NT Quick Beginnings (2456)
  • DB2 library
  • books (2429)
  • Information Center (2467)
  • language identifier for books (2464)
  • late-breaking information (2465)
  • online help (2428)
  • ordering printed books (2472)
  • printing PostScript books (2471)
  • searching online information (2470)
  • setting up document server (2468)
  • SmartGuides (2427)
  • structure of (2426)
  • viewing online information (2466)
  • DB2 Personal Edition Quick Beginnings (2451)
  • DB2 Query Patroller Administration Guide (2461)
  • DB2 Query Patroller Installation Guide (2462)
  • DB2 Query Patroller User's Guide (2463)
  • db2cli.ini (1590), (1758)
  • DB2CLI_VER (2236)
  • DB2CONNECTVERSION, keyword (1789)
  • DB2DEGREE, keyword (1790)
  • DB2ESTIMATE, keyword (1792)
  • DB2EXPLAIN, keyword (1793)
  • DB2NODE (1777)
  • DB2OPTIMIZATION, keyword (1794)
  • DBALIAS, keyword (1795)
  • DBCLOB (1715)
  • conversion to C (2385)
  • DBNAME, keyword (1796)
  • DECIMAL
  • conversion to C (2386)
  • display size (2367)
  • length (2352)
  • precision (2322)
  • scale (2337)
  • DEFAULTPROCLIBRARY, keyword (1798)
  • deferred arguments (1514)
  • deferred prepare, migration (2234)
  • DEFERREDPREPARE, keyword (1799)
  • DEGREES Scalar function (2276)
  • deprecated function
  • list of functions (2233)
  • SQLAllocConnect (1840)
  • SQLAllocEnv (1842)
  • SQLAllocStmt (1850)
  • SQLColAttributes (1907)
  • SQLError (1947)
  • SQLExtendedFetch (1957)
  • SQLFreeConnect (1971)
  • SQLFreeEnv (1973)
  • SQLFreeStmt (1982)
  • SQLGetConnectOption (1987)
  • SQLGetStmtOption (2029)
  • SQLParamOptions (2056)
  • SQLSetColAttributes (2081)
  • SQLSetConnectOption (2130)
  • SQLSetParam (2154)
  • SQLSetStmtOption (2211)
  • SQLTransact (2229)
  • Describe Column Attributes, function (1929)
  • descriptor handle (1460), (1685)
  • allocating (1849)
  • freeing (1981)
  • Descriptors
  • descriptors
  • 4 different types (1687)
  • concise functions (1702)
  • consistency checks (1698)
  • copying (1923)
  • copying (1700)
  • descriptor records (1697)
  • general (1684)
  • get multiple fields (2002)
  • get single field (1999)
  • header fields (1696)
  • set multiple fields (2140)
  • set single field (2137)
  • diagnostics (1540)
  • get a field of diagnostic data (2005)
  • get multiple fields (2008)
  • DIFFERENCE Scalar function (2251)
  • DISABLEMULTITHREAD, keyword (1800)
  • Disconnect, function (1935), (1937)
  • display size of SQL data types (2363)
  • distributed transactions (1599)
  • distributed unit of work (1597)
  • DOUBLE
  • conversion to C (2393)
  • display size (2373)
  • length (2358)
  • precision (2328)
  • scale (2343)
  • DRDA Server (1637)
  • driver manager (2239)
  • driver, CLI (2241)
  • driver, ODBC (2240)
  • DriverConnect, function (1939), (1943)
  • DUOW (1596)
  • CICS (1635)
  • DB2 as transaction manager (1605)
  • DRDA Server (1638)
  • Encina (1634)
  • MTS as transaction manager (1615)
  • processor based transaction manager (1633)
  • E
  • EARLYCLOSE, keyword (1801)
  • Embedded SQL
  • embedded SQL (2423)
  • Mixing with DB2 CLI (1741)
  • Encina (1632)
  • END COMPOUND, CLI extension (1708)
  • end transactions, function (1945)
  • environment attributes (options) (1586)
  • environment handle (1458)
  • allocating (1478), (1846)
  • freeing (1479), (1978)
  • environment information, querying (1573)
  • Escape Clauses, Vendor (1745)
  • establishing coordinated transactions (1611)
  • examples
  • array INSERT (1672)
  • browser.c (1649)
  • catalog functions (1648)
  • Compound SQL (1709)
  • samples listing (2422)
  • stored procedure (1739)
  • User Defined Type (1726)
  • execute direct (1503)
  • execute statement (1502)
  • Execute statement Directly, function (1950)
  • Execute statement, function (1953)
  • EXP Scalar function (2277)
  • F
  • FAR pointers (1836)
  • fetch a rowset, function (1965)
  • Fetch, function (1962)
  • Fetching Data in Pieces (1663)
  • Flags, for compiling and linking (1769)
  • FLOAT
  • conversion to C (2392)
  • display size (2372)
  • length (2357)
  • precision (2326)
  • scale (2342)
  • FLOOR Scalar function (2278)
  • Foreign Key Column Names, function (1970)
  • Foreign Keys Columns, function (1968)
  • free handle resources, function (1976)
  • FREE LOCATOR statement (1719)
  • function list, ODBC (2242)
  • functions
  • by category (1839)
  • G
  • get a field of diagnostic data, function (2004)
  • Get Column Names for a Table, function (1917)
  • get current attribute settings, function (1985)
  • Get Cursor Name, function (1990)
  • Get Data Sources, function (1925), (1927)
  • Get Data, function (1993)
  • Get Functions, function (2011), (2013)
  • Get Index and Statistics Information for a Table, function (2218), (2220)
  • Get Info, function (2015), (2017)
  • Get List of Procedure Names (2071)
  • Get List of Procedure Names, function (2073)
  • get multiple fields of descriptor, function (2001)
  • get multiple fields of diagnostic record, function (2007)
  • Get Number of Result Columns (2049)
  • Get Parameters for a Procedure, function (2069)
  • get required attributes, function (1866)
  • Get Row Count, function (2079)
  • get single field of descriptor, function (1998)
  • Get Special (Row Identifier) Columns, function (2216)
  • Get Special Column Names, function (2214)
  • Get SQLCA Data Structure, function (2023), (2025)
  • get statement attribute setting, function (2027)
  • Get Table Information, function (2226), (2228)
  • Get Type Information, function (2034)
  • global dynamic statement cache (1508)
  • Glossary (2441)
  • GRANTEELIST, keyword (1802)
  • GRANTORLIST, keyword (1803)
  • GRAPHIC
  • conversion to C (2382)
  • GRAPHIC, keyword (1804)
  • H
  • handle
  • connection handle (1462), (1477)
  • descriptor handle (1463), (1686)
  • environment handle (1461), (1476)
  • freeing (1977)
  • statement handle (1457)
  • HOUR Scalar function (2298)
  • I
  • IFNULL Scalar function (2313)
  • IGNOREWARNINGS, keyword (1805)
  • IGNOREWARNLIST, keyword (1806)
  • implementation parameter descriptor (1694)
  • implementation row descriptor (1695)
  • IN DATABASE command (1797)
  • initialization (1471), (1474)
  • initialization file (1589)
  • initialization file, ODBC (1763)
  • INSERT Scalar function (2252)
  • Installation and Configuration Supplement (2442)
  • installing DB2 CLI
  • for application development (1765)
  • INTEGER
  • conversion to C (2390)
  • display size (2370)
  • length (2355)
  • precision (2325)
  • scale (2340)
  • introduction, to CLI (1444)
  • INVALID_HANDLE (1547)
  • IPD descriptor (1690)
  • IRD descriptor (1691)
  • isolation levels, ODBC (2246)
  • J
  • JULIAN_DAY Scalar function (2299)
  • K
  • KEEPCONNECT, keyword (1807)
  • KEEPSTATEMENT, keyword (1808)
  • Keyset-Driven Cursors (1654)
  • L
  • Large Objects
  • Binary (BLOB) (1712)
  • Character (CLOB) (1710)
  • Double Byte Character (DBCLOB) (1711)
  • LONGDATACOMPAT (1721)
  • using in ODBC applications (1720)
  • LCASE Scalar function (2253)
  • LEFT Scalar function (2255)
  • length of SQL data types (2348)
  • LENGTH Scalar function (2256)
  • Link options (1768)
  • LOB locator (1717)
  • LOBMAXCOLUMNSIZE, keyword (1809)
  • LOBS (1713) See also see, Large Objects
  • LOCATE Scalar function (2257)
  • locator, LOB (1718)
  • LOG Scalar function (2279)
  • LOG10 Scalar function (2280)
  • long data
  • retrieving in pieces (1657)
  • sending in pieces (1656)
  • LONGDATACOMPAT (1722)
  • LONGDATACOMPAT, keyword (1810)
  • LONGVARBINARY
  • conversion to C (2396)
  • LONGVARCHAR
  • conversion to C (2381)
  • display size (2366)
  • length (2351)
  • precision (2321)
  • scale (2336)
  • LONGVARGRAPHIC
  • conversion to C (2384)
  • Lower case conversion Scalar function (2254)
  • LTRIM Scalar function (2258)
  • M
  • MAXCONN, keyword (1811)
  • Message Reference (2443)
  • metadata characters (1647)
  • Microsoft ODBC (2238)
  • Microsoft ODBC Driver Manager (1752)
  • Microsoft Transaction Server (1614)
  • connection pooling (1624)
  • enabling support in DB2 (1617)
  • installation and configuration (1619)
  • reusing ODBC connections (1626)
  • software prerequisites (1618)
  • supported DB2 database servers (1622)
  • testing DB2 with sample application (1628)
  • transaction time-out and DB2 connection behavior (1623)
  • tuning TCP/IP communications (1627)
  • verifying the installation (1620)
  • midnight, seconds since Scalar function (2307)
  • MINUTE Scalar function (2300)
  • Mixing Embedded SQL and DB2 CLI (1742)
  • MOD Scalar function (2281)
  • MODE, keyword (1812)
  • MONTH Scalar function (2301)
  • MONTHNAME Scalar function (2302)
  • More Result Sets, function (2037), (2039)
  • multi-threaded application (1593)
  • MULTICONNECT, keyword (1813)
  • multiple connections (2232)
  • multiple SQL statements (1704)
  • multisite updates (1600)
  • N
  • native error code (1551)
  • Native SQL Text, function (2041), (2043)
  • node
  • specify node to connect to (2096)
  • NOT ATOMIC Compound SQL (1707)
  • NOW Scalar function (2303)
  • null connect (1738)
  • null-terminated strings (1565)
  • null-termination of strings (1566)
  • Number of Parameters, function (2045), (2047)
  • Number of Result Columns, function (2050)
  • NUMERIC
  • conversion to C (2387)
  • display size (2368)
  • length (2353)
  • precision (2323)
  • scale (2338)
  • O
  • ODBC (1499)
  • and DB2 CLI (1445), (2237)
  • catalog for DB2 Connect (1775), (2091)
  • close cursor, behavior (2093)
  • core level functions (1446)
  • function list (2243)
  • isolation levels (2244)
  • odbc.ini file (1761)
  • odbcinst.ini file (1762)
  • registering the driver manager (1754)
  • running programs (1750)
  • ODBC vendor escape clauses (1746)
  • odbcad32.exe (1751)
  • offset
  • binding columns (1683)
  • binding parameter markers (1671)
  • optimize for N rows
  • configuration keyword (1815)
  • statement attribute (2185)
  • OPTIMIZEFORNROWS, keyword (1814)
  • OPTIMIZESQLCOLUMNS, keyword (1816)
  • options
  • connection (1580)
  • environment (1579)
  • querying and setting (1578)
  • statement (1581)
  • P
  • Parallelism, Setting degree of (1791)
  • parameter binding offsets (1669)
  • Parameter Data, function (2053), (2055)
  • parameter markers (1455)
  • array input (1665)
  • obtain description using SQLDescribeParam (1933)
  • parameter markers, binding (1511)
  • PATCH1, keyword (1817)
  • PATCH2, keyword (1818)
  • pattern-values (1644)
  • PI Scalar function (2282)
  • pointers, FAR (1837)
  • POPUPMESSAGE, keyword (1819)
  • portability (1467)
  • POWER Scalar function (2283)
  • precision of SQL data types (2318)
  • prepare statement (1501)
  • array of columns (1960)
  • Prepare statement, function (2059), (2061)
  • prerequisites for DB2 CLI
  • for application development (1766)
  • Primary Key Columns, function (2063), (2065)
  • Procedure Parameter Information, function (2067)
  • process-based transaction manager (1630)
  • Put Data for a Parameter, function (2075), (2077)
  • PWD, keyword (1820)
  • Q
  • QUARTER Scalar function (2304)
  • query optimization level statement attribute (2196)
  • Query Statements (1519)
  • querying data source information (1572)
  • querying environment information (1571)
  • querying system catalog information (1639)
  • Quick Beginnings for OS/2 (2452)
  • Quick Beginnings for UNIX (2453)
  • Quick Beginnings for Windows NT (2454)
  • R
  • RADINS Scalar function (2284)
  • RAND Scalar function (2285)
  • REAL
  • conversion to C (2391)
  • display size (2371)
  • length (2356)
  • precision (2327)
  • scale (2341)
  • reentrant (multi-threaded) (1594)
  • REFRESH DEFERRED (1783)
  • REFRESH IMMEDIATE (1784)
  • registering
  • ODBC driver manager (1753)
  • registering stored procedures (1732)
  • REPEAT Scalar function (2259)
  • REPLACE Scalar function (2260)
  • Replication Guide and Reference (2444)
  • Retrieve Length of String Value, function (2019)
  • Retrieve Portion of A String Value, function (2032)
  • retrieving multiple rows (1675)
  • return codes (1541)
  • return description of a parameter marker (1932)
  • Return Starting Position of String, function (2021)
  • RIGHT Scalar function (2261)
  • rollback (1536)
  • ROUND Scalar function (2286)
  • row-wise array insert (1667)
  • Row-Wise Binding (1677), (1680)
  • rowset
  • fetch (1966)
  • scrollable cursors (1653)
  • set cursor position (2158)
  • RTRIM Scalar function (2262)
  • runtime support (1748)
  • S
  • sample CLI applications (2421)
  • scale of SQL data types (2333)
  • SCHEMALIST, keyword (1821)
  • Scrollable Cursors (1651)
  • search arguments (1643)
  • SECOND Scalar function (2305)
  • SECONDS_SINCE_MIDNIGHT Scalar function (2306)
  • SELECT (1518)
  • set connection attributes, function (2084)
  • SET CURRENT SCHEMA (1786)
  • Set Cursor Name, function (2133)
  • set cursor position in a rowset, function (2157)
  • set multiple fields of a descriptor, function (2139)
  • set single field of a descriptor, function (2136)
  • set statement attribute settings, function (2160)
  • setting up document server (2469)
  • SIGN Scalar function (2287)
  • SIN Scalar function (2288)
  • SMALLINT
  • conversion to C (2388)
  • display size (2369)
  • length (2354)
  • precision (2324)
  • scale (2339)
  • SOUNDEX Scalar function (2263)
  • SPACE Scalar function (2264)
  • SQL
  • dynamically prepared (1465)
  • parameter markers (1510)
  • preparing and executing statements (1500)
  • Query Statements (1516)
  • SELECT (1515)
  • statements
  • DELETE (1533)
  • UPDATE (1532)
  • VALUES (1517)
  • SQL Access Group (1450)
  • SQL Getting Started (2445)
  • SQL Reference (2446)
  • SQLAllocConnect, deprecated function (1841)
  • SQLAllocEnv, deprecated function (1843)
  • SQLAllocHandle, function
  • description (1844)
  • SQLAllocStmt, deprecated function (1851)
  • SQLAllocStmt, function
  • overview (1482)
  • SQLBindCol, function
  • description (1852), (1854)
  • overview (1483), (1525)
  • SQLBindFileToCol, function
  • description (1855)
  • SQLBindFileToParam, function
  • description (1857), (1859)
  • SQLBindParameter, function
  • description (1861), (1863)
  • overview (1530)
  • SQLBrowseConnect, function
  • description (1865)
  • SQLBuildDataLink, function
  • description (1867)
  • SQLBulkOperations, function
  • description (1869)
  • SQLCancel, function
  • description (1871), (1873)
  • use in data-at-execute (1662)
  • SQLCloseCursor, function
  • description (1875)
  • SQLColAttributes, deprecated function (1908)
  • SQLColAttributes, function
  • overview (1484), (1521)
  • SQLColumnPrivileges, function
  • description (1910), (1912)
  • SQLColumns, function
  • description (1914), (1916)
  • SQLConnect, function
  • description (1918), (1920)
  • SQLCopyDesc, function
  • description (1921)
  • SQLDataSources, function
  • description (1924), (1926)
  • overview (1485)
  • SQLDescribeCol, function
  • description (1928), (1930)
  • overview (1486), (1522)
  • SQLDescribeParam, function
  • description (1931)
  • SQLDisconnect, function
  • description (1934), (1936)
  • SQLDriverConnect
  • default attribute values (1592)
  • SQLDriverConnect, function
  • description (1938), (1942)
  • SQLEndTran, function
  • description (1944)
  • SQLERRD() (2235)
  • SQLError, deprecated function (1948)
  • SQLExecDirect, function
  • description (1949), (1951)
  • overview (1487), (1504)
  • SQLExecute, function
  • description (1952), (1954)
  • overview (1488), (1505)
  • SQLExtendedBind, function
  • description (1955)
  • SQLExtendedFetch, deprecated function (1958)
  • SQLExtendedPrepare, function
  • description (1959)
  • SQLFetch, function
  • description (1961), (1963)
  • overview (1489), (1526)
  • SQLFetchScroll, function
  • description (1964)
  • SQLForeignKeys, function
  • description (1967), (1969)
  • SQLFreeConnect, deprecated function (1972)
  • SQLFreeEnv, deprecated function (1974)
  • SQLFreeHandle, function
  • description (1975)
  • SQLFreeStmt, deprecated function (1983)
  • SQLFreeStmt, function
  • overview (1490)
  • SQLGetConnectAttr, function
  • description (1984)
  • SQLGetConnectOption, deprecated function (1988)
  • SQLGetCursorName, function
  • description (1989), (1991)
  • SQLGetData, function
  • description (1992), (1994)
  • overview (1491), (1527)
  • SQLGetDataLinkAttr, function
  • description (1995)
  • SQLGetDescField, function
  • description (1997)
  • SQLGetDescRec, function
  • description (2000)
  • SQLGetDiagField, function
  • description (2003)
  • SQLGetDiagRec, function
  • description (2006)
  • SQLGetEnvAttr, function
  • description (2009)
  • SQLGetFunctions, function
  • description (2010), (2012)
  • SQLGetInfo, function
  • description (2014), (2016)
  • SQLGetLength, function
  • description (2018)
  • SQLGetPosition, function
  • description (2020)
  • SQLGetSQLCA, function
  • description (2022), (2024)
  • SQLGetStmtAttr, function
  • description (2026)
  • SQLGetStmtOption, deprecated function (2030)
  • SQLGetSubString, function
  • description (2031)
  • SQLGetTypeInfo, function
  • description (2033), (2035)
  • SQLMoreResults, function
  • description (2036), (2038)
  • use of (1668)
  • SQLNativeSql, function
  • description (2040), (2042)
  • SQLNumParams, function
  • description (2044), (2046)
  • SQLNumResultCols, function
  • description (2048), (2051)
  • overview (1492), (1523)
  • SQLParamData, function
  • description (2052), (2054)
  • use in data-at-execute (1660)
  • SQLParamOptions, deprecated function (2057)
  • SQLPrepare, function
  • description (2058), (2060)
  • overview (1493), (1506), (1528)
  • SQLPrimaryKeys, function
  • description (2062), (2064)
  • SQLProcedureColumns, function
  • description (2066), (2068)
  • SQLProcedures, function
  • description (2070), (2072)
  • SQLPutData, function
  • description (2074), (2076)
  • use in data-at-execute (1661)
  • SQLRowCount, function
  • description (2078), (2080)
  • overview (1494)
  • SQLSetColAttributes, deprecated function (2082)
  • SQLSetConnectAttr, function
  • description (2083)
  • SQLSetConnection, function
  • description (2129)
  • SQLSetConnectOption, deprecated function (2131)
  • SQLSetCursorName, function
  • description (2132), (2134)
  • SQLSetDescField, function
  • description (2135)
  • SQLSetDescRec, function
  • description (2138)
  • SQLSetEnvAttr, function (2153)
  • description (2141)
  • SQLSetParam, deprecated function (2155)
  • SQLSetParam, function
  • overview (1495), (1507), (1513), (1529)
  • SQLSetPos, function
  • description (2156)
  • SQLSetStmtOption, deprecated function (2212)
  • SQLSetStmttAttr, function
  • description (2159)
  • SQLSpecialColumns, function
  • description (2213), (2215)
  • SQLSTATE
  • 07002 (1909)
  • format of (1549)
  • function cross reference (2316)
  • in CLI (1464)
  • SQLSTATEFILTER, keyword (1822)
  • SQLStatistics, function
  • description (2217), (2219)
  • SQLTablePrivileges, function
  • description (2221), (2223)
  • SQLTables, function
  • description (2225), (2227)
  • SQLTransact, deprecated function (2230)
  • SQLTransact, function
  • overview (1496), (1531), (1538)
  • SQL_ATTR_ACCESS_MODE (2086)
  • SQL_ATTR_APP_PARAM_DESC (2162)
  • SQL_ATTR_APP_ROW_DESC (2163)
  • SQL_ATTR_ASYNC_ENABLE (2087), (2164)
  • SQL_ATTR_AUTOCOMMIT (2089)
  • SQL_ATTR_AUTO_IPD (2088)
  • SQL_ATTR_BIND_TYPE (2165)
  • SQL_ATTR_CLISCHEMA (2090)
  • SQL_ATTR_CLOSEOPEN (2166)
  • SQL_ATTR_CLOSE_BEHAVIOR (2092)
  • SQL_ATTR_CONCURRENCY (2167)
  • SQL_ATTR_CONNECTION_DEAD (2098)
  • SQL_ATTR_CONNECTION_POOLING (2142)
  • SQL_ATTR_CONNECTION_TIMEOUT (2099)
  • SQL_ATTR_CONNECTTYPE (1606), (2100), (2144)
  • SQL_ATTR_CONNECT_NODE (2095)
  • SQL_ATTR_CONN_CONTEXT (2094)
  • SQL_ATTR_CP_MATCH (2145)
  • SQL_ATTR_CURRENT_CATALOG (2101)
  • SQL_ATTR_CURRENT_SCHEMA (2102)
  • SQL_ATTR_CURSOR_HOLD (2168)
  • SQL_ATTR_CURSOR_SCROLLABLE (2169)
  • SQL_ATTR_CURSOR_SENSITIVITY (2170)
  • SQL_ATTR_CURSOR_TYPE (2171)
  • SQL_ATTR_DB2ESTIMATE (2104)
  • SQL_ATTR_DB2EXPLAIN (2105)
  • SQL_ATTR_DB2_SQLERRP (2103)
  • SQL_ATTR_DEFERRED_PREPARE (2172)
  • SQL_ATTR_EARLYCLOSE (2173)
  • SQL_ATTR_ENABLE_AUTO_IPD (2174)
  • SQL_ATTR_ENLIST_IN_DTC (2106)
  • SQL_ATTR_FETCH_BOOKMARK (2175)
  • SQL_ATTR_IMP_PARAM_DESC (2176)
  • SQL_ATTR_IMP_ROW_DESC (2177)
  • SQL_ATTR_INFO_ACCTSTR (2107)
  • SQL_ATTR_INFO_APPLNAME (2109)
  • SQL_ATTR_INFO_USERID (2111)
  • SQL_ATTR_INFO_WRKSTNNAME (2113)
  • SQL_ATTR_KEYSET_SIZE (2178)
  • SQL_ATTR_LOGIN_TIMEOUT (2115)
  • SQL_ATTR_LONGDATA_COMPAT (1723), (2116)
  • SQL_ATTR_MAXCONN (2117), (2146)
  • SQL_ATTR_MAX_LENGTH (2179)
  • SQL_ATTR_MAX_ROWS (2180)
  • SQL_ATTR_METADATA_ID (2118), (2181)
  • SQL_ATTR_NODESCRIBE (2182)
  • SQL_ATTR_NOSCAN (2183)
  • SQL_ATTR_ODBC_CURSORS (2119)
  • SQL_ATTR_ODBC_VERSION (2147)
  • SQL_ATTR_OPTIMIZESQLCOLUMNS (2186)
  • SQL_ATTR_OPTIMIZE_FOR_NROWS (2184)
  • SQL_ATTR_OUTPUT_NTS (2148)
  • SQL_ATTR_PACKET_SIZE (2120)
  • SQL_ATTR_PARAMOPT_ATOMIC (2191)
  • SQL_ATTR_PARAMSET_SIZE (2193)
  • SQL_ATTR_PARAMS_PROCESSED_PTR (2192)
  • SQL_ATTR_PARAM_BIND_OFFSET_PTR (2187)
  • SQL_ATTR_PARAM_BIND_TYPE (2188)
  • SQL_ATTR_PARAM_OPERATION_PTR (2189)
  • SQL_ATTR_PARAM_STATUS_PTR (2190)
  • SQL_ATTR_PREFETCH (2194)
  • SQL_ATTR_PROCESSCTRL (2149)
  • SQL_ATTR_QUERY_OPTIMIZATION_LEVEL (2195)
  • SQL_ATTR_QUERY_TIMEOUT (2197)
  • SQL_ATTR_QUIET_MODE (2121)
  • SQL_ATTR_RETRIEVE_DATA (2198)
  • SQL_ATTR_ROWSET_SIZE (2206)
  • SQL_ATTR_ROWS_FETCHED_PTR (2205)
  • SQL_ATTR_ROW_ARRAY_SIZE (1679), (2199)
  • SQL_ATTR_ROW_BIND_OFFSET_PTR (2200)
  • SQL_ATTR_ROW_BIND_TYPE (2201)
  • SQL_ATTR_ROW_NUMBER (2202)
  • SQL_ATTR_ROW_OPERATION_PTR (2203)
  • SQL_ATTR_ROW_STATUS_PTR (2204)
  • SQL_ATTR_SIMULATE_CURSOR (2207)
  • SQL_ATTR_STMTTXN_ISOLATION (2208)
  • SQL_ATTR_SYNC_POINT (2122), (2150)
  • SQL_ATTR_TRACE (2123)
  • SQL_ATTR_TRACEFILE (2124)
  • SQL_ATTR_TRANSLATE_LIB (2125)
  • SQL_ATTR_TRANSLATE_OPTION (2126)
  • SQL_ATTR_TXN_ISOLATION (2127), (2209)
  • SQL_ATTR_USE_2BYTES_OCTET_LENGTH (2151)
  • SQL_ATTR_USE_BOOKMARKS (2210)
  • SQL_ATTR_USE_LIGHT_OUTPUT_SQLDA (2152)
  • SQL_ATTR_WCHARTYPE (2128)
  • SQL_CONCURRENT_TRANS (1607)
  • SQL_COORDINATED_TRANS (1608)
  • SQL_C_BINARY
  • conversion from SQL (2408)
  • SQL_C_BIT
  • conversion from SQL (2407)
  • SQL_C_CHAR
  • conversion from SQL (2401)
  • SQL_C_DATE
  • conversion from SQL (2410)
  • SQL_C_DBCHAR
  • conversion from SQL (2409)
  • SQL_C_DOUBLE
  • conversion from SQL (2405)
  • SQL_C_FLOAT
  • conversion from SQL (2404)
  • SQL_C_LONG
  • conversion from SQL (2403)
  • SQL_C_SHORT
  • conversion from SQL (2402)
  • SQL_C_TIME
  • conversion from SQL (2411)
  • SQL_C_TIMESTAMP
  • conversion from SQL (2412)
  • SQL_C_TINYINT
  • conversion from SQL (2406)
  • SQL_DATA_AT_EXEC (1659)
  • SQL_DESC_AUTO_UNIQUE_VALUE (1878)
  • SQL_DESC_BASE_COLUMN_NAME (1879)
  • SQL_DESC_BASE_TABLE_NAME (1880)
  • SQL_DESC_CASE_SENSITIVE (1881)
  • SQL_DESC_CATALOG_NAME (1882)
  • SQL_DESC_CONCISE_TYPE (1883)
  • SQL_DESC_COUNT (1884)
  • SQL_DESC_DISPLAY_SIZE (1885)
  • SQL_DESC_DISTINCT_TYPE (1886)
  • SQL_DESC_FIXED_PREC_SCALE (1887)
  • SQL_DESC_LABEL (1888)
  • SQL_DESC_LENGTH (1889)
  • SQL_DESC_LITERAL_PREFIX (1890)
  • SQL_DESC_LITERAL_SUFFIX (1891)
  • SQL_DESC_LOCAL_TYPE_NAME (1892)
  • SQL_DESC_NAME (1893)
  • SQL_DESC_NULLABLE (1894)
  • SQL_DESC_NUM_PREX_RADIX (1895)
  • SQL_DESC_OCTECT_LENGTH (1896)
  • SQL_DESC_PRECISION (1897)
  • SQL_DESC_SCALE (1898)
  • SQL_DESC_SCHEMA_NAME (1899)
  • SQL_DESC_SEARCHABLE (1900)
  • SQL_DESC_TABEL_NAME (1901)
  • SQL_DESC_TYPE (1902)
  • SQL_DESC_TYPE_NAME (1903)
  • SQL_DESC_UNNAMED (1904)
  • SQL_DESC_UNSIGNED (1905)
  • SQL_DESC_UPDATABLE (1906)
  • SQL_ERROR (1546)
  • SQL_NEED_DATA (1544)
  • SQL_NO_DATA_FOUND (1545)
  • SQL_NTS (1564)
  • SQL_ONEPHASE (1609)
  • SQL_STILL_EXECUTING (1548)
  • SQL_SUCCESS (1542)
  • SQL_SUCCESS_WITH_INFO (1543)
  • SQL_TWOPHASE (1610)
  • SQRT Scalar function (2289)
  • statement attributes (options) (1588)
  • getting using SQLGetStmtAttr (2028)
  • setting using SQLSetStmtAttr (2161)
  • statement cache (1509)
  • statement handle (1456)
  • allocating (1497), (1848)
  • freeing (1539), (1980)
  • maximum number of (1498)
  • Stored Procedures
  • argumemts (1733)
  • catalog table (1730)
  • catalog table for stored procedures (2415)
  • example (1740)
  • ODBC escape clause (1747)
  • registering (1731)
  • returning result sets (1735)
  • SYSCAT.PROCEDURES (2413)
  • SYSCAT.PROCEDURES table (1736)
  • SYSCAT.PROCPARMS (2414)
  • using the SQLDA (1734)
  • using with DB2 CLI (1727)
  • string arguments (1562), (1568)
  • sub-statements (1705)
  • SUBSTRING Scalar function (2265)
  • supported DB2 database servers for MTS-coordinated transactions (1621)
  • SYNCPOINT, keyword (1823)
  • SYSCAT.PROCEDURES (2416)
  • SYSCAT.PROCEDURES table (1737)
  • SYSCAT.PROCPARMS (2417)
  • SYSSCHEMA, keyword (1824)
  • system catalog
  • DB2CLI.PROCEDURES (2418)
  • pseudo table for stored procedures (2419)
  • system catalogs, querying (1640)
  • System Monitor Guide and Reference (2447)
  • T
  • Table Privileges, function (2222), (2224)
  • TABLETYPE, keyword (1825)
  • TAN Scalar function (2290)
  • target logical node (1778)
  • TEMPDIR, keyword (1826)
  • termination (1473), (1475)
  • threads (multi-threaded) (1595)
  • TIME
  • conversion to C (2399)
  • display size (2375)
  • length (2360)
  • precision (2330)
  • scale (2345)
  • TIMESTAMP
  • conversion to C (2400)
  • display size (2376)
  • length (2361)
  • precision (2331)
  • scale (2346)
  • TIMESTAMPADD Scalar function (2308)
  • TIMESTAMPDIFF Scalar function (2309)
  • trace (2424)
  • TRACE, keyword (1827)
  • TRACECOMM, keyword (1828)
  • TRACEFILENAME, keyword (1829)
  • TRACEFLUSH, keyword (1830)
  • TRACEPATHNAME, keyword (1831)
  • transact isolation levels, ODBC (2245)
  • transaction
  • ending (1946)
  • management (1537)
  • processing (1472)
  • transaction manager
  • DB2 (1603)
  • DRDA based (1636)
  • implementing using Microsoft Transaction Server (1616)
  • Microsoft Transaction Server (1613)
  • MTS (1612)
  • processor based (1629)
  • Triggers (1577)
  • Troubleshooting Guide (2448)
  • TRUNCATE Scalar function (2291)
  • truncation (1567)
  • two phase commit (1601)
  • TXNISOLATION, keyword (1832)
  • U
  • UCASE Scalar function (2266)
  • UDFs (1576)
  • UDTs (1725)
  • UID, keyword (1833)
  • UNDERSCORE, keyword (1834)
  • User Defined Functions (1575)
  • User Defined Types (1724)
  • USER Scalar function (2314)
  • V
  • VALUES (1520)
  • VARBINARY
  • conversion to C (2395)
  • VARCHAR
  • conversion to C (2380)
  • display size (2365)
  • length (2350)
  • precision (2320)
  • scale (2335)
  • VARGRAPHIC
  • conversion to C (2383)
  • Vendor Escape Clauses (1744)
  • W
  • WARNINGLIST, keyword (1835)
  • WEEK Scalar function (2310)
  • What's New (2449)
  • writing DB2 CLI applications (1469)
  • X
  • X/Open CAE (1550)
  • X/Open Company (1448)
  • X/Open SQL CLI (1449)
  • Y
  • YEAR Scalar function (2311)

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

    [ DB2 List of Books | Search the DB2 Books ]