54 lines
3.6 KiB
HTML
54 lines
3.6 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="CCSID of dynamic SQL statements" />
|
||
|
|
<meta name="abstract" content="The SQL statement is normally a host variable. The CCSID of the host variable is used as the CCSID of the statement text. In PL/I, it also can be a string expression. In this case, the job CCSID is used as the CCSID of the statement text." />
|
||
|
|
<meta name="description" content="The SQL statement is normally a host variable. The CCSID of the host variable is used as the CCSID of the statement text. In PL/I, it also can be a string expression. In this case, the job CCSID is used as the CCSID of the statement text." />
|
||
|
|
<meta name="DC.subject" content="CCSID, dynamic SQL statement, dynamic SQL" />
|
||
|
|
<meta name="keywords" content="CCSID, dynamic SQL statement, dynamic SQL" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafydynmic.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="rbafyccsiddyn" />
|
||
|
|
<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>CCSID of dynamic SQL statements</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafyccsiddyn"><a name="rbafyccsiddyn"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">CCSID of dynamic SQL statements</h1>
|
||
|
|
<div><p>The SQL statement is normally a host variable. The CCSID of the
|
||
|
|
host variable is used as the CCSID of the statement text. In PL/I, it also
|
||
|
|
can be a string expression. In this case, the job CCSID is used as the CCSID
|
||
|
|
of the statement text.</p>
|
||
|
|
<div class="section"><p>Dynamic SQL statements are processed using the CCSID of the statement
|
||
|
|
text. This affects variant characters. For example, the not sign (¬) is located
|
||
|
|
at 'BA'X in CCSID 500. This means that if the CCSID of your statement text
|
||
|
|
is 500, SQL expects the not sign (¬) to be represented by the value
|
||
|
|
'BA'X.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>If the statement text CCSID is 65535, SQL processes variant characters
|
||
|
|
as if they had a CCSID of 37. This means that SQL looks for the not sign (¬)
|
||
|
|
at '5F'X.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafydynmic.htm" title="Dynamic SQL allows an application to define and run SQL statements at program run time. An application that provides for dynamic SQL accepts as input (or builds) an SQL statement in the form of a character string. The application does not need to know what type of SQL statement it will run.">Dynamic SQL applications</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|