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

    • [ Top of Page | Previous Page ]