112 lines
6.8 KiB
HTML
112 lines
6.8 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="reference" />
|
|
<meta name="DC.Title" content="Connection string keywords - Package properties" />
|
|
<meta name="abstract" content="Use these iSeries Access ODBC driver connection string keywords to change Package properties of the ODBC connection." />
|
|
<meta name="description" content="Use these iSeries Access ODBC driver connection string keywords to change Package properties of the ODBC connection." />
|
|
<meta name="DC.Relation" scheme="URI" content="connectkeywords.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="rzaikconnstrkeywordspkgprop" />
|
|
<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>Connection string keywords - Package properties</title>
|
|
</head>
|
|
<body id="rzaikconnstrkeywordspkgprop"><a name="rzaikconnstrkeywordspkgprop"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Connection string keywords - Package properties</h1>
|
|
<div><p>Use these iSeries™ Access ODBC driver connection string keywords
|
|
to change Package properties of the ODBC connection.</p>
|
|
<div class="section"><p>The following table lists connection string keywords for Package
|
|
properties that are recognized by the iSeries Access ODBC driver:</p>
|
|
</div>
|
|
<div class="section">
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" frame="border" border="1" rules="all"><caption>Table 1. iSeries Access ODBC connection string keywords for
|
|
the Package properties</caption><thead align="left"><tr><th align="center" valign="middle" width="21.73913043478261%" id="d0e35">Keyword</th>
|
|
<th align="center" valign="middle" width="35.177865612648226%" id="d0e37">Description</th>
|
|
<th align="center" valign="middle" width="33.59683794466403%" id="d0e39">Choices</th>
|
|
<th align="center" valign="middle" width="9.486166007905137%" id="d0e41">Default</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr><td valign="top" width="21.73913043478261%" headers="d0e35 ">DFTPKGLIB or DefaultPkgLibrary</td>
|
|
<td valign="top" width="35.177865612648226%" headers="d0e37 ">Specifies the library for the SQL package. This property
|
|
has no effect unless the XDYNAMIC property is set to 1.</td>
|
|
<td valign="top" width="33.59683794466403%" headers="d0e39 ">Library for SQL package</td>
|
|
<td valign="top" width="9.486166007905137%" headers="d0e41 ">QGPL</td>
|
|
</tr>
|
|
<tr><td valign="top" width="21.73913043478261%" headers="d0e35 ">PKG or DefaultPackage</td>
|
|
<td valign="top" width="35.177865612648226%" headers="d0e37 ">Specifies how the extended dynamic (package) support
|
|
will behave. The string for this property must be in the following format: <span class="uicontrol">A/DEFAULT(IBM),x,0,y,z,0</span><p>The
|
|
x, y, and z are special attributes that need to be replaced with how the package
|
|
is to be used.</p>
|
|
<ul><li>x = Specifies whether or not to add statements to an existing SQL package.</li>
|
|
<li>y = Specifies the action to take when SQL package errors occur. When a
|
|
SQL package error occurs, the driver will return a return code based on the
|
|
value of this property.</li>
|
|
<li>z = Specifies whether or not to cache SQL packages in memory. Caching
|
|
SQL packages locally reduces the amount of communication to the server in
|
|
some cases.</li>
|
|
</ul>
|
|
<div class="note"><span class="notetitle">Note:</span> This property has no effect unless the XDYNAMIC property is set
|
|
to 1.</div>
|
|
</td>
|
|
<td valign="top" width="33.59683794466403%" headers="d0e39 "> <span class="uicontrol">A/DEFAULT(IBM),x,0,y,z,0</span><p>Values
|
|
for x option: </p>
|
|
<ul><li>1 = Use (Use the package, but do not put any more SQL statements into
|
|
the package)</li>
|
|
<li>2 = Use/Add (Use the package and add new SQL statements into the package)</li>
|
|
</ul>
|
|
<p>Values for y option:</p>
|
|
<ul><li>0 = Return an error (SQL_ERROR) to the application </li>
|
|
<li>1 = Return a warning (SQL_SUCCESS_WITH_INFO) to the application </li>
|
|
<li>2 = Return success (SQL_SUCCESS) to the application </li>
|
|
</ul>
|
|
<p>Values for z option:</p>
|
|
<ul><li>0 = Do not cache SQL package locally</li>
|
|
<li>1 = Cache SQL package locally</li>
|
|
</ul>
|
|
</td>
|
|
<td valign="top" width="9.486166007905137%" headers="d0e41 "><a href="#rzaikconnstrkeywordspkgprop__def1">default</a></td>
|
|
</tr>
|
|
<tr><td valign="top" width="21.73913043478261%" headers="d0e35 ">XDYNAMIC or ExtendedDynamic</td>
|
|
<td valign="top" width="35.177865612648226%" headers="d0e37 ">Specifies whether to use extended dynamic (package)
|
|
support. <p>Extended dynamic support provides a mechanism for caching dynamic
|
|
SQL statements on the server. The first time a particular SQL statement is
|
|
run, it is stored in a SQL package on the server. On subsequent runs of the
|
|
same SQL statement, the server can skip a significant part of the processing
|
|
by using information stored in the SQL package.</p>
|
|
<div class="note"><span class="notetitle">Note:</span> For more information
|
|
see <a href="useedsql.htm#useedsql">Use Extended Dynamic SQL</a>.</div>
|
|
</td>
|
|
<td valign="top" width="33.59683794466403%" headers="d0e39 ">0 = Disable extended dynamic support <p>1 = Enable extended
|
|
dynamic support</p>
|
|
</td>
|
|
<td valign="top" width="9.486166007905137%" headers="d0e41 ">1</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
<div class="note" id="rzaikconnstrkeywordspkgprop__def1"><a name="rzaikconnstrkeywordspkgprop__def1"><!-- --></a><span class="notetitle">Note:</span> <span class="uicontrol">A/DEFAULT(IBM),x,0,y,z,0</span> is
|
|
the default value for PKG or DefaultPackage.</div>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="connectkeywords.htm" title="The iSeries Access ODBC driver has many connection string keywords that can be used to change the behavior of the ODBC connection.">Connection string keywords</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |