88 lines
6.0 KiB
HTML
88 lines
6.0 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="What's new for V5R4" />
|
||
<meta name="abstract" content="This topic highlights numerous changes to the SQL call level interface for V5R4." />
|
||
<meta name="description" content="This topic highlights numerous changes to the SQL call level interface for V5R4." />
|
||
<meta name="DC.Relation" scheme="URI" content="rzadpkickoff.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="rzadpwhatsnew" />
|
||
<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>What's new for V5R4 </title>
|
||
</head>
|
||
<body id="rzadpwhatsnew"><a name="rzadpwhatsnew"><!-- --></a>
|
||
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
<h1 class="topictitle1">What's new for V5R4 </h1>
|
||
<div><p>This topic highlights numerous changes to the SQL
|
||
call level interface for V5R4.</p>
|
||
<p><img src="./delta.gif" alt="Start of change" />The limit for the total number of concurrently allocated
|
||
handles is expanded from 80 000 to 160 000.<img src="./deltaend.gif" alt="End of change" /></p>
|
||
<div class="p"><img src="./delta.gif" alt="Start of change" />New environment, connection and statement attributes are
|
||
added, including: <ul><li>Cursor sensitivity statement attribute</li>
|
||
<li>New cursor type statement attribute (SQL_CURSOR_STATIC)</li>
|
||
<li>New query optimizer connection attribute(SQL_ATTR_QUERY_OPTIMIZE_GOAL)</li>
|
||
</ul>
|
||
<img src="./deltaend.gif" alt="End of change" /></div>
|
||
<div class="p"><img src="./delta.gif" alt="Start of change" />New <samp class="codeph">SQLGetInfo</samp> and <samp class="codeph">SQLColAttributes</samp> options
|
||
are added, including: <ul><li>User name for a connection from <samp class="codeph">SQLGetInfo()</samp>: SQL_USER_NAME</li>
|
||
<li>Database name for a connection from <samp class="codeph">SQLGetInfo()</samp>: SQL_DATABASE_NAME</li>
|
||
<li>Display the size needed to display a data type from <samp class="codeph">SQLColAttributes()</samp>:
|
||
SQL_DESC_DISPLAY_SIZE</li>
|
||
</ul>
|
||
<img src="./deltaend.gif" alt="End of change" /></div>
|
||
<div class="p"><img src="./delta.gif" alt="Start of change" />New supports are added, including: <ul><li>XA support through the CLI connection attributes SQL_ATTR_TXN_EXTERNAL
|
||
and SQL_ATTR_TXN_INFO</li>
|
||
<li>Support for array (block) fetching and column-wise binding in the <samp class="codeph">SQLFetchScroll()</samp></li>
|
||
<li>2-megabyte SQL statement support through the CLI interface</li>
|
||
</ul>
|
||
<div class="note"><span class="notetitle">Note:</span> This is not a complete list of the new supports.</div>
|
||
<img src="./deltaend.gif" alt="End of change" /></div>
|
||
<div class="p">The following APIs are changed in this release:<img src="./delta.gif" alt="Start of change" /><ul><li><a href="rzadpfnconn.htm#rzadpfnconn">SQLConnect - Connect to a data source</a></li>
|
||
<li><a href="rzadpfetchsc.htm#rzadpfetchsc">SQLFetchScroll - Fetch from a scrollable cursor</a></li>
|
||
<li><a href="rzadpfngcono.htm#rzadpfngcono">SQLGetConnectOption - Return current setting of a connect Option</a></li>
|
||
<li><a href="rzadpgdesfld.htm#rzadpgdesfld">SQLGetDescField - Get descriptor field</a></li>
|
||
<li><a href="rzadpgdesrec.htm#rzadpgdesrec">SQLGetDescRec - Get descriptor record</a></li>
|
||
<li><a href="rzadpfnginfo.htm#rzadpfnginfo">SQLGetInfo - Get general information</a></li>
|
||
<li><a href="rzadpfngstmo.htm#rzadpfngstmo">SQLGetStmtOption - Return current setting of a statement option</a></li>
|
||
<li><a href="rzadpfngtype.htm#rzadpfngtype">SQLGetTypeInfo - Get data type information</a></li>
|
||
<li><a href="rzadpfnsconx.htm#rzadpfnsconx">SQLSetConnectAttr - Set a connection attribute</a></li>
|
||
<li><a href="rzadpfnscono.htm#rzadpfnscono">SQLSetConnectOption - Set connection option</a></li>
|
||
<li><a href="rzadpfnsenva.htm#rzadpfnsenva">SQLSetEnvAttr - Set environment attribute</a></li>
|
||
<li><a href="rzadpfnsstma.htm#rzadpfnsstma">SQLSetStmtAttr - Set a statement attribute</a></li>
|
||
<li><a href="rzadpfnsstmo.htm#rzadpfnsstmo">SQLSetStmtOption - Set statement option</a></li>
|
||
</ul><img src="./deltaend.gif" alt="End of change" />
|
||
</div>
|
||
<div class="section"><h4 class="sectiontitle">How to see what's new or changed</h4><div class="p">To help you see
|
||
where technical changes have been made, this information uses: <ul><li>The <img src="delta.gif" alt="Start of change" /> image to mark
|
||
where new or changed information begins.</li>
|
||
<li>The <img src="deltaend.gif" alt="End of change" /> image to mark
|
||
where new or changed information ends.</li>
|
||
</ul>
|
||
</div>
|
||
<p>To find other information about what's new or changed this release,
|
||
see the <a href="../rzahg/rzahgmtu.htm">Memo
|
||
to users</a>.</p>
|
||
</div>
|
||
</div>
|
||
<div>
|
||
<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> |