88 lines
5.8 KiB
HTML
88 lines
5.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="Can a user of DB2 Universal Database for Linux, UNIX and Windows specify that the NLSS sort sequence table of the DRDA job on the iSeries server be used instead of the usual EBCDIC sequence?" />
|
||
|
|
<meta name="abstract" content="The iSeries server recognizes a generic bind option that allows one who prepares a program to be run from DB2 Universal Database for Linux, UNIX and Windows or any other client that supports generic bind options to request that the iSeries server use the NLSS sort sequence associated with the server job in which the client's request is run." />
|
||
|
|
<meta name="description" content="The iSeries server recognizes a generic bind option that allows one who prepares a program to be run from DB2 Universal Database for Linux, UNIX and Windows or any other client that supports generic bind options to request that the iSeries server use the NLSS sort sequence associated with the server job in which the client's request is run." />
|
||
|
|
<meta name="DC.subject" content="sort sequence, definition" />
|
||
|
|
<meta name="keywords" content="sort sequence, definition" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1xplat.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="rbal1faquserofdb2connspecify" />
|
||
|
|
<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>Can a user of DB2 Universal Database for Linux, UNIX and Windows specify
|
||
|
|
that the NLSS sort sequence table of the DRDA job on the iSeries server be used instead of the
|
||
|
|
usual EBCDIC sequence? </title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1faquserofdb2connspecify"><a name="rbal1faquserofdb2connspecify"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Can a user of DB2 Universal Database for Linux, UNIX and Windows specify
|
||
|
|
that the NLSS sort sequence table of the DRDA job on the iSeries server be used instead of the
|
||
|
|
usual EBCDIC sequence? </h1>
|
||
|
|
<div><p>The iSeries™ server
|
||
|
|
recognizes a generic bind option that allows one who prepares a program to
|
||
|
|
be run from DB2
|
||
|
|
Universal Database™ for Linux<sup>®</sup>, UNIX<sup>®</sup> and Windows<sup>®</sup> or any other client that supports
|
||
|
|
generic bind options to request that the iSeries server use the NLSS sort sequence
|
||
|
|
associated with the server job in which the client's request is run.</p>
|
||
|
|
<div class="section"><p>This function is enabled by PTF SI00174 in V5R1. It is in the
|
||
|
|
base operating system for subsequent releases.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>If you choose to take advantage of this enhancement, you need
|
||
|
|
to recreate any SQL packages on DB2 Universal Database for
|
||
|
|
which the new sort sequence option is desired by using the generic bind option
|
||
|
|
SORTSEQ with a value of JOBRUN from the client system.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>The bind option enables a user to specify that the NLSS sort sequence
|
||
|
|
table of the DRDA<sup>®</sup> job
|
||
|
|
on the iSeries server
|
||
|
|
should be used instead of the usual EBCDIC sequence. Previously, only the
|
||
|
|
default *HEX option, which causes the EBCDIC sequence to be used, has been
|
||
|
|
available when connecting from unlike DRDA clients.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>This feature is available from DRDA application requesters that support
|
||
|
|
the DRDA generic
|
||
|
|
bind function. It has undergone limited testing using DB2 Universal Database for Linux, UNIX and Windows 6.1
|
||
|
|
FixPak 1 running on Windows as a client development platform
|
||
|
|
and run environment. DB2 Universal Database for Linux, UNIX and Windows supports
|
||
|
|
the specification of generic bind options on two of its program preparation
|
||
|
|
commands, the precompile (PREP) command and the (BIND) command. JOBRUN sort
|
||
|
|
sequence can be specified on either of them as in the following examples drawn
|
||
|
|
from a Windows batch file: </p>
|
||
|
|
</div>
|
||
|
|
<div class="example"> <pre>DB2 PREP %1.SQC BINDFILE SORTSEQ JOBRUN...
|
||
|
|
DB2 BIND %1.BND SORTSEQ JOBRUN...</pre>
|
||
|
|
</div>
|
||
|
|
<div class="section"><div class="p"> <div class="note"><span class="notetitle">Note:</span> On the Windows development platform, single
|
||
|
|
quotation marks are used around the generic option name/value pair, but on
|
||
|
|
an AIX<sup>®</sup> or UNIX platform,
|
||
|
|
quotation marks should be used.</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>The only other valid value for the SORTSEQ option is HEX, which
|
||
|
|
is the default value, and only possible option from a non-<span class="keyword">iSeries</span> client
|
||
|
|
before the introduction of this feature.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1xplat.htm" title="This topic collection concentrates on describing iSeries support for distributed relational databases in a network of iSeries servers (a like environment).">User FAQs</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|