367 lines
23 KiB
HTML
367 lines
23 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
|||
|
<!DOCTYPE html
|
|||
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|||
|
<html lang="en-us" xml:lang="en-us">
|
|||
|
<head>
|
|||
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|||
|
<meta name="security" content="public" />
|
|||
|
<meta name="Robots" content="index,follow" />
|
|||
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
|||
|
<meta name="DC.Type" content="concept" />
|
|||
|
<meta name="DC.Title" content="DB2 UDB CLI functions" />
|
|||
|
<meta name="abstract" content="This topic provides a description of each CLI function." />
|
|||
|
<meta name="description" content="This topic provides a description of each CLI function." />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpkickoff.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpclilist.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnacon.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnaenv.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnahdl.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnastmt.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnbindc.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnbndfc.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnbndfp.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnbndpa.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnbndpm.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfncan.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpclscur.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfncolat.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfncolnpriv.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfncoln.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnconn.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpcpydesc.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfndatas.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfndecol.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfndescprm.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfndconn.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfndvcon.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnendtr.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnerror.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnexecd.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnexec.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnexfet.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnfetch.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfetchsc.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnfkey.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnfconn.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnfenv.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnfhdl.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnfstmt.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngcol.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngcona.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngcono.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngcurn.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngdata.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpgdesfld.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpgdesrec.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfndfld.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfndrec.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngenva.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngfunc.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnginfo.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngtlen.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngtpos.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngstma.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngstmo.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngtsbs.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfngtype.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfncolx.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnmrset.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnnsql.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnnxtres.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnnump.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnnrcol.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnparad.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnpopt.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnprep.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnpkey.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnprcco.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnprcs.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnpdata.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnrelv.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnrowc.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnsconx.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnscono.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnscurn.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpsetdesc.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpsetrec.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnsenva.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnspara.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnsstma.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnsstmo.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnspcol.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfnstats.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfntablpriv.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfntabls.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rzadpfntrans.htm" />
|
|||
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1999, 2006" />
|
|||
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1999, 2006" />
|
|||
|
<meta name="DC.Format" content="XHTML" />
|
|||
|
<meta name="DC.Identifier" content="rzadphdapi" />
|
|||
|
<meta name="DC.Language" content="en-us" />
|
|||
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
|||
|
<!-- US Government Users Restricted Rights -->
|
|||
|
<!-- Use, duplication or disclosure restricted by -->
|
|||
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
|||
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
|||
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
|||
|
<title>DB2 UDB
|
|||
|
CLI functions</title>
|
|||
|
</head>
|
|||
|
<body id="rzadphdapi"><a name="rzadphdapi"><!-- --></a>
|
|||
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|||
|
<h1 class="topictitle1">DB2 UDB
|
|||
|
CLI functions</h1>
|
|||
|
<div><p>This topic provides a description of each CLI function.</p>
|
|||
|
<p></p>
|
|||
|
<p>See <a href="rzadpclilist.htm#rzadpclilist">Categories of DB2 UDB CLIs</a> for
|
|||
|
a categorical listing of the functions.</p>
|
|||
|
<p>Each of the DB2<sup>®</sup> UDB
|
|||
|
CLI function descriptions is presented in a consistent format. </p>
|
|||
|
<p id="rzadphdapi__functdesc"><a name="rzadphdapi__functdesc"><!-- --></a><span class="uicontrol">How the CLI functions are described</span></p>
|
|||
|
<p>The following table shows the type of information that is described in
|
|||
|
each section of the function description.</p>
|
|||
|
|
|||
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" frame="border" border="1" rules="all"><thead align="left"><tr><th valign="top" width="22.613065326633166%" id="d0e39">Type</th>
|
|||
|
<th valign="top" width="77.38693467336684%" id="d0e41">Description</th>
|
|||
|
</tr>
|
|||
|
</thead>
|
|||
|
<tbody><tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">Purpose</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 ">This section gives a brief overview of what the function
|
|||
|
does. It also indicates if any functions should be called before and after
|
|||
|
calling the function being described.</td>
|
|||
|
</tr>
|
|||
|
<tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">Syntax</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 "><p>This section contains the C language
|
|||
|
prototype for the i5/OS™ environment.</p>
|
|||
|
</td>
|
|||
|
</tr>
|
|||
|
<tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">Arguments</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 ">This section lists each function argument, along with
|
|||
|
its data type, a description and whether it is an input or output argument. <p>Each DB2 UDB
|
|||
|
CLI argument is either an input or output argument. With the exception of <samp class="codeph">SQLGetInfo()</samp>, DB2 UDB
|
|||
|
CLI only modifies arguments that are indicated as output.</p>
|
|||
|
<p>Some functions
|
|||
|
contain input or output arguments which are known as <em>deferred</em> or <em>bound</em> arguments.
|
|||
|
These arguments are pointers to buffers allocated by the application. These
|
|||
|
arguments are associated with (or bound to) either a parameter in an SQL statement,
|
|||
|
or a column in a result set. The data areas specified by the function are
|
|||
|
accessed by DB2 UDB
|
|||
|
CLI at a later time. It is important that these deferred data areas are still
|
|||
|
valid at the time DB2 UDB CLI accesses them.</p>
|
|||
|
</td>
|
|||
|
</tr>
|
|||
|
<tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">Usage</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 ">This section provides information about how to use the
|
|||
|
function, and any special considerations. Possible error conditions are not
|
|||
|
discussed here, but are listed in the diagnostics section instead.</td>
|
|||
|
</tr>
|
|||
|
<tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">Return codes</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 "><p>This section lists all the possible function return
|
|||
|
codes. When SQL_ERROR or SQL_SUCCESS_WITH_INFO is returned, error information
|
|||
|
can be obtained by calling <samp class="codeph">SQLError()</samp>.</p>
|
|||
|
<p>Refer to <a href="rzadphddiag.htm#rzadphddiag">Diagnostics in a DB2 UDB CLI application</a> for more information about return
|
|||
|
codes.</p>
|
|||
|
</td>
|
|||
|
</tr>
|
|||
|
<tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">Diagnostics</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 "><p>This section contains a table that lists
|
|||
|
the SQLSTATEs explicitly returned by DB2 UDB CLI (SQLSTATEs generated by the
|
|||
|
Database Management System (DBMS) might also be returned) and indicates the
|
|||
|
cause of the error. These values are obtained by calling <samp class="codeph">SQLError()</samp> after
|
|||
|
the function returns SQL_ERROR or SQL_SUCCESS_WITH_INFO.</p>
|
|||
|
<p>An <strong>*</strong> in
|
|||
|
the first column indicates that the SQLSTATE is returned only by DB2 UDB CLI, and
|
|||
|
is not returned by other ODBC drivers.</p>
|
|||
|
<p>Refer to <a href="rzadphddiag.htm#rzadphddiag">Diagnostics in a DB2 UDB CLI application</a> for
|
|||
|
more information about diagnostics.</p>
|
|||
|
</td>
|
|||
|
</tr>
|
|||
|
<tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">Restrictions</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 ">This section indicates any differences or limitations
|
|||
|
between DB2 UDB
|
|||
|
CLI and ODBC that might affect an application.</td>
|
|||
|
</tr>
|
|||
|
<tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">Example</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 ">This section is a code fragment demonstrating the use
|
|||
|
of the function. The complete source used for all code fragments is listed
|
|||
|
in <a href="rzadphdxmp.htm#rzadphdxmp">Examples: DB2 UDB CLI applications</a>.</td>
|
|||
|
</tr>
|
|||
|
<tr><td valign="top" width="22.613065326633166%" headers="d0e39 ">References</td>
|
|||
|
<td valign="top" width="77.38693467336684%" headers="d0e41 ">This section lists related DB2 UDB CLI functions.</td>
|
|||
|
</tr>
|
|||
|
</tbody>
|
|||
|
</table>
|
|||
|
</div>
|
|||
|
</div>
|
|||
|
<div>
|
|||
|
<ul class="ullinks">
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpclilist.htm">Categories of DB2 UDB CLIs</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnacon.htm">SQLAllocConnect - Allocate connection handle</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnaenv.htm">SQLAllocEnv - Allocate environment handle</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnahdl.htm">SQLAllocHandle - Allocate handle</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnastmt.htm">SQLAllocStmt - Allocate a statement handle</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnbindc.htm">SQLBindCol - Bind a column to an application variable</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnbndfc.htm">SQLBindFileToCol - Bind LOB file reference to LOB column</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnbndfp.htm">SQLBindFileToParam - Bind LOB file reference to LOB parameter</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnbndpa.htm">SQLBindParam - Bind a buffer to a parameter marker</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnbndpm.htm">SQLBindParameter - Bind a parameter marker to a buffer</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfncan.htm">SQLCancel - Cancel statement</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpclscur.htm">SQLCloseCursor - Close cursor statement</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfncolat.htm">SQLColAttributes - Obtain column attributes</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfncolnpriv.htm">SQLColumnPrivileges - Get privileges associated with the columns of a table</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfncoln.htm">SQLColumns - Get column information for a table</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnconn.htm">SQLConnect - Connect to a data source</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpcpydesc.htm">SQLCopyDesc - Copy description statement</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfndatas.htm">SQLDataSources - Get list of data sources</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfndecol.htm">SQLDescribeCol - Describe column attributes</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfndescprm.htm">SQLDescribeParam - Return description of a parameter marker</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfndconn.htm">SQLDisconnect - Disconnect from a data source</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfndvcon.htm">SQLDriverConnect - (Expanded) Connect to a data source</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnendtr.htm">SQLEndTran - Commit or roll back a transaction</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnerror.htm">SQLError - Retrieve error information</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnexecd.htm">SQLExecDirect - Execute a statement directly</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnexec.htm">SQLExecute - Execute a statement</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnexfet.htm">SQLExtendedFetch - Fetch array of rows</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnfetch.htm">SQLFetch - Fetch next row</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfetchsc.htm">SQLFetchScroll - Fetch from a scrollable cursor</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnfkey.htm">SQLForeignKeys - Get the list of foreign key columns</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnfconn.htm">SQLFreeConnect - Free connection handle</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnfenv.htm">SQLFreeEnv - Free environment handle</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnfhdl.htm">SQLFreeHandle - Free a handle</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnfstmt.htm">SQLFreeStmt - Free (or reset) a statement handle</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngcol.htm">SQLGetCol - Retrieve one column of a row of the result set</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngcona.htm">SQLGetConnectAttr - Get the value of a connection attribute</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngcono.htm">SQLGetConnectOption - Return current setting of a connect Option</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngcurn.htm">SQLGetCursorName - Get cursor name</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngdata.htm">SQLGetData - Get data from a column</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpgdesfld.htm">SQLGetDescField - Get descriptor field</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpgdesrec.htm">SQLGetDescRec - Get descriptor record</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfndfld.htm">SQLGetDiagField - Return diagnostic information (extensible)</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfndrec.htm">SQLGetDiagRec - Return diagnostic information (concise)</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngenva.htm">SQLGetEnvAttr - Return current setting of an environment Attribute</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngfunc.htm">SQLGetFunctions - Get functions</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnginfo.htm">SQLGetInfo - Get general information</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngtlen.htm">SQLGetLength - Retrieve length of a string value</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngtpos.htm">SQLGetPosition - Return starting position of string</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngstma.htm">SQLGetStmtAttr - Get the value of a statement attribute</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngstmo.htm">SQLGetStmtOption - Return current setting of a statement option</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngtsbs.htm">SQLGetSubString - Retrieve portion of a string value</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfngtype.htm">SQLGetTypeInfo - Get data type information</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfncolx.htm">SQLLanguages - Get SQL dialect or conformance information</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnmrset.htm">SQLMoreResults - Determine whether there are more result sets</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnnsql.htm">SQLNativeSql - Get native SQL text</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnnxtres.htm">SQLNextResult - Process the next result set</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnnump.htm">SQLNumParams - Get number of parameters in an SQL statement</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnnrcol.htm">SQLNumResultCols - Get number of result columns</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnparad.htm">SQLParamData - Get next parameter for which a data value is needed</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnpopt.htm">SQLParamOptions - Specify an input array for a parameter</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnprep.htm">SQLPrepare - Prepare a statement</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnpkey.htm">SQLPrimaryKeys - Get primary key columns of a table</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnprcco.htm">SQLProcedureColumns - Get input/output parameter information for a procedure</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnprcs.htm">SQLProcedures - Get list of procedure names</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnpdata.htm">SQLPutData - Pass data value for a parameter</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnrelv.htm">SQLReleaseEnv - Release all environment resources</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnrowc.htm">SQLRowCount - Get row count</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnsconx.htm">SQLSetConnectAttr - Set a connection attribute</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnscono.htm">SQLSetConnectOption - Set connection option</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnscurn.htm">SQLSetCursorName - Set cursor name</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpsetdesc.htm">SQLSetDescField - Set a descriptor field</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpsetrec.htm">SQLSetDescRec - Set a descriptor record</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnsenva.htm">SQLSetEnvAttr - Set environment attribute</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnspara.htm">SQLSetParam - Set parameter</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnsstma.htm">SQLSetStmtAttr - Set a statement attribute</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnsstmo.htm">SQLSetStmtOption - Set statement option</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnspcol.htm">SQLSpecialColumns - Get special (row identifier) columns</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfnstats.htm">SQLStatistics - Get index and statistics information for a base table</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfntablpriv.htm">SQLTablePrivileges – Get privileges associated with a table</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfntabls.htm">SQLTables - Get table information</a></strong><br />
|
|||
|
</li>
|
|||
|
<li class="ulchildlink"><strong><a href="rzadpfntrans.htm">SQLTransact - Commit or roll back transaction</a></strong><br />
|
|||
|
</li>
|
|||
|
</ul>
|
|||
|
|
|||
|
<div class="familylinks">
|
|||
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzadpkickoff.htm" title="DB2 UDB call level interface (CLI) is a callable Structured Query Language (SQL) programming interface that is supported in all DB2 environments except for DB2 Universal Database for z/OS and DB2 Server for VSE and VM.">SQL call level interface</a></div>
|
|||
|
</div>
|
|||
|
</div>
|
|||
|
</body>
|
|||
|
</html>
|