70 lines
5.3 KiB
HTML
70 lines
5.3 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="Declare host variables in PL/I applications that use SQL" />
|
||
|
|
<meta name="abstract" content="The PL/I precompilers only recognize a subset of valid PL/I declarations as valid host variable declarations." />
|
||
|
|
<meta name="description" content="The PL/I precompilers only recognize a subset of valid PL/I declarations as valid host variable declarations." />
|
||
|
|
<meta name="DC.subject" content="host variable, PL/I, declaring, PL/I program" />
|
||
|
|
<meta name="keywords" content="host variable, PL/I, declaring, PL/I program" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajphostvariablespli.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajpplinum.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajpplichar.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajpplibinary.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajpplilob.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajpplirowid.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rzajpdeclarehostpli" />
|
||
|
|
<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>Declare host variables in PL/I applications that use SQL</title>
|
||
|
|
</head>
|
||
|
|
<body id="rzajpdeclarehostpli"><a name="rzajpdeclarehostpli"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Declare host variables in PL/I applications that use SQL</h1>
|
||
|
|
<div><p>The PL/I precompilers only recognize a subset of valid PL/I declarations
|
||
|
|
as valid host variable declarations.</p>
|
||
|
|
<div class="p">Only the names and data attributes of the variables are used by the precompilers;
|
||
|
|
the alignment, scope, and storage attributes are ignored. Even though alignment,
|
||
|
|
scope, and storage are ignored, there are some restrictions on their use that,
|
||
|
|
if ignored, may result in problems when compiling PL/I source code that is
|
||
|
|
created by the precompiler. These restrictions are: <ul><li>A declaration with the <span>EXTERNAL</span> scope attribute and the <span>STATIC</span> storage
|
||
|
|
attribute must also have the <span>INITIAL</span> storage attribute.</li>
|
||
|
|
<li>If the <span>BASED</span> storage attribute is coded, it must be followed
|
||
|
|
by a <span>PL/I</span> element-locator-expression.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajpplinum.htm">Numeric-host variables in PL/I applications that use SQL</a></strong><br />
|
||
|
|
This figure shows the syntax for valid scalar numeric-host variable declarations.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajpplichar.htm">Character-host variables in PL/I applications that use SQL</a></strong><br />
|
||
|
|
This figure shows the syntax for valid scalar character-host variables.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajpplibinary.htm">Binary host variables in PL/I applications that use SQL</a></strong><br />
|
||
|
|
PL/I does not have variables that correspond to the SQL binary data types. To create host variables that can be used with these data types, use the SQL TYPE IS clause. The SQL precompiler replaces this declaration with a PL/I language structure in the output source member.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajpplilob.htm">LOB host variables in PL/I applications that use SQL</a></strong><br />
|
||
|
|
PL/I does not have variables that correspond to the SQL data types for LOBs (large objects). To create host variables that can be used with these data types, use the SQL TYPE IS clause. The SQL precompiler replaces this declaration with a PL/I language structure in the output source member.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajpplirowid.htm">ROWID host variables in PL/I applications that use SQL</a></strong><br />
|
||
|
|
PL/I does not have a variable that corresponds to the SQL data type ROWID. To create host variables that can be used with this data type, use the SQL TYPE IS clause. The SQL precompiler replaces this declaration with a PL/I language structure in the output source member.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzajphostvariablespli.htm" title="All host variables used in SQL statements must be explicitly declared.">Use host variables in PL/I applications that use SQL</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|