Call Level Interface Guide and Reference
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
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 ]