65 lines
5.1 KiB
HTML
65 lines
5.1 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="The zero-length literal and the contains (*CT) function" />
|
||
|
|
<meta name="abstract" content="In the Open Query File (OPNQRYF) command, a zero-length literal is denoted as a quoted string with nothing, not even a blank, between the quotation marks (""). Zero-length literal support changes the results of a comparison when used as the compare argument of the contains (*CT) function." />
|
||
|
|
<meta name="description" content="In the Open Query File (OPNQRYF) command, a zero-length literal is denoted as a quoted string with nothing, not even a blank, between the quotation marks (""). Zero-length literal support changes the results of a comparison when used as the compare argument of the contains (*CT) function." />
|
||
|
|
<meta name="DC.subject" content="zero-length literal and contains (*CT) function, contains (*CT) function and zero-length literal, *CT (contains) function and zero-length literal" />
|
||
|
|
<meta name="keywords" content="zero-length literal and contains (*CT) function, contains (*CT) function and zero-length literal, *CT (contains) function and zero-length literal" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafoopnqf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafoopnex.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="rbafozlt" />
|
||
|
|
<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>The zero-length literal and the contains (*CT) function</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafozlt"><a name="rbafozlt"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">The zero-length literal and the contains (*CT) function</h1>
|
||
|
|
<div><p>In the Open Query File (OPNQRYF) command, a zero-length literal
|
||
|
|
is denoted as a quoted string with nothing, not even a blank, between the
|
||
|
|
quotation marks (""). Zero-length literal support changes the results of a
|
||
|
|
comparison when used as the compare argument of the contains (*CT) function.</p>
|
||
|
|
<p>The concept of a zero-length literal was introduced in Version 2, Release
|
||
|
|
1, Modification 1.</p>
|
||
|
|
<div class="p">Consider this statement: <pre>QRYSLT('field *CT ""')</pre>
|
||
|
|
</div>
|
||
|
|
<div class="p">With zero-length literal support, the statement returns records that contain
|
||
|
|
anything. It is, in essence, a wildcard comparison for any number of characters
|
||
|
|
followed by any number of characters. It is equivalent to: <pre>'field = %WLDCRD("**")'</pre>
|
||
|
|
</div>
|
||
|
|
<div class="p">Before zero-length literal support, (before Version 2, Release 1, Modification
|
||
|
|
1), the argument ("") was interpreted as a single-byte blank. The statement
|
||
|
|
returned records that contained a single blank somewhere in the field. It
|
||
|
|
was, in essence, a wildcard comparison for any number of characters, followed
|
||
|
|
by a blank, followed by any number of characters. It was equivalent to: <pre>'field = %WLDCRD("* *")'</pre>
|
||
|
|
</div>
|
||
|
|
<div class="p">To get pre-Version 2, Release 1, Modification 1 results with the contains
|
||
|
|
function, you must code the QRYSLT to explicitly look for the blank: <pre>QRYSLT('field *CT " "')</pre>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafoopnqf.htm" title="The Open Query File (OPNQRYF) command is a control language (CL) command that allows you to perform many data processing functions on database files. These topics discuss how to create a query using the OPNQRYF command, how to specify parameters for its major functions, and how to use it with your high-level language program.">Use Open Query File (OPNQRYF) command</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
||
|
|
<div><a href="rbafoopnex.htm" title="These usage notes pertain to the examples in the topics that describe how to specify the parameters for the major functions of the Open Query File (OPNQRYF) command and how to use the OPNQRYF command with your high-level language program.">Usage notes for Open Query File (OPNQRYF) command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|