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)

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)

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)

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)

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)

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)

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)

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)

handle

connection handle (1462), (1477)

descriptor handle (1463), (1686)

environment handle (1461), (1476)

freeing (1977)

statement handle (1457)

HOUR Scalar function (2298)

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)

JULIAN_DAY Scalar function (2299)

KEEPCONNECT, keyword (1807)

KEEPSTATEMENT, keyword (1808)

Keyset-Driven Cursors (1654)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

WARNINGLIST, keyword (1835)

WEEK Scalar function (2310)

What's New (2449)

writing DB2 CLI applications (1469)

X/Open CAE (1550)

X/Open Company (1448)

X/Open SQL CLI (1449)

YEAR Scalar function (2311)

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

[ DB2 List of Books | Search the DB2 Books ]