1180 lines
91 KiB
HTML
1180 lines
91 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="copyright" content="(C) Copyright IBM Corporation 2005" />
|
|||
|
<meta name="DC.rights.owner" content="(C) Copyright IBM Corporation 2005" />
|
|||
|
<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="Copy files that contain large objects" />
|
|||
|
<meta name="abstract" content="You can specify CRTFILE(*YES) on the CPYF and CPYFRMQRYF commands when you copy files that contain large objects (LOBs). If the from-file is an SQL table, view, or index that contains a LOB, these commands create an SQL table." />
|
|||
|
<meta name="description" content="You can specify CRTFILE(*YES) on the CPYF and CPYFRMQRYF commands when you copy files that contain large objects (LOBs). If the from-file is an SQL table, view, or index that contains a LOB, these commands create an SQL table." />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="rbal3copycomplex.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpyf.htm" />
|
|||
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpyfrmqryf.htm" />
|
|||
|
<meta name="DC.Format" content="XHTML" />
|
|||
|
<meta name="DC.Identifier" content="rbal3cpylo" />
|
|||
|
<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>Copy files that contain large objects</title>
|
|||
|
</head>
|
|||
|
<body id="rbal3cpylo"><a name="rbal3cpylo"><!-- --></a>
|
|||
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|||
|
<h1 class="topictitle1">Copy files that contain large objects</h1>
|
|||
|
<div><p>You can specify CRTFILE(*YES) on the CPYF and CPYFRMQRYF commands
|
|||
|
when you copy files that contain large objects (LOBs). If the from-file is
|
|||
|
an SQL table, view, or index that contains a LOB, these commands create an
|
|||
|
SQL table.</p>
|
|||
|
<div class="p"><span class="keyword">iSeries™</span> supports three large
|
|||
|
object data types: Binary Large OBjects (BLOBs), single-byte or mixed Character
|
|||
|
Large OBjects (CLOBs), and Double-Byte Character Large OBjects (DBCLOBs).
|
|||
|
When you copy files that contain these objects using the <a href="../cl/cpyf.htm">Copy File (CPYF)</a> command, you should
|
|||
|
consider the following restrictions and requirements: <ul><li>LOB data is not copied when you copy from and to device files, when you
|
|||
|
copy to *PRINT, or when you specify values of *NOCHK or *CVTSRC on the FMTOPT
|
|||
|
parameter. In these cases, only the default buffer value for the LOB field
|
|||
|
is copied, including "*POINTER". This is true even when you copy a file that
|
|||
|
contains a LOB field to an identical file. Valid LOB data is copied only when
|
|||
|
you have specified *NONE, *MAP, or *DROP on the FMTOPT parameter.</li>
|
|||
|
<li>LOB data is not copied when you copy to a tape or diskette. In these cases,
|
|||
|
only the buffer value (including "*POINTER") is written to the tape or diskette.
|
|||
|
In addition, if you copy from the tape or diskette back to the same file,
|
|||
|
you might receive errors; this is because the file contains only the "*POINTER"
|
|||
|
value and not a valid pointer to actual LOB data.</li>
|
|||
|
<li>When you specify *UPDADD on the MBROPT parameter of the CPYF command,
|
|||
|
the to-file can contain a LOB field. LOB fields are also updated when duplicate
|
|||
|
keys are encountered.</li>
|
|||
|
<li>When you specify *CVTFLOAT or *NULLFLAGS on the FMTOPT parameter of the
|
|||
|
CPYF command, the to-file cannot contain a LOB field.</li>
|
|||
|
<li>If you want to print a file that contains LOB fields, specify *PRINT on
|
|||
|
the TOFILE parameter of the CPYF command. "*POINTER" will appear in the print
|
|||
|
listing in place of the LOB field data, and other non-LOB field data will
|
|||
|
also appear in the listing. If you have not specified *PRINT on the TOFILE
|
|||
|
parameter and you specified *COPIED, *EXCLUDE, or *ERROR on the PRINT parameter,
|
|||
|
then you must specify *NOCHK or *CVTSRC on the FMTOPT parameter for the copy
|
|||
|
to be allowed.</li>
|
|||
|
<li>You cannot specify LOB fields on the INCCHAR and INCREL parameters. You
|
|||
|
can specify *RCD or *FLD on the INCCHAR parameter, but only the fixed buffer
|
|||
|
length is compared, and not any actual LOB data.</li>
|
|||
|
<li>You cannot copy DDM files that contain LOB fields to <span class="keyword">iSeries</span> servers.</li>
|
|||
|
</ul>
|
|||
|
</div>
|
|||
|
<div class="p">The following tables show how LOBs are mapped to other data types during
|
|||
|
copy operations. The first table shows the mapping when both fields contain
|
|||
|
LOB field types. In the tables, consider the following guidelines: <ul><li>The mapping of LOBs from and to DATE or TIME types is not allowed.</li>
|
|||
|
<li>These mappings are valid only for FMTOPT(*MAP) except where noted.</li>
|
|||
|
<li>There are similar data restrictions for large objects as those for normal
|
|||
|
character data (single-byte, mixed, and double-byte).</li>
|
|||
|
</ul>
|
|||
|
</div>
|
|||
|
|
|||
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><caption>Table 1. From-file and to-file mapping when
|
|||
|
both fields are large objects</caption><thead align="left"><tr><th rowspan="2" align="left" valign="top" width="14.629629629629628%" id="d0e58">Field A type</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="15.185185185185185%" id="d0e60">Field B type</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="15.37037037037037%" id="d0e62">Allowed and copy direction</th>
|
|||
|
<th colspan="2" align="left" valign="top" id="d0e64">Data CCSID or
|
|||
|
attributes</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="12.592592592592592%" id="d0e66">CCSIDs</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="12.592592592592592%" id="d0e68">Conversion translation performed</th>
|
|||
|
</tr>
|
|||
|
<tr><th align="left" valign="top" width="14.814814814814813%" id="d0e71">Field A</th>
|
|||
|
<th align="left" valign="top" width="14.814814814814813%" id="d0e73">Field B</th>
|
|||
|
</tr>
|
|||
|
</thead>
|
|||
|
<tbody><tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y* <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">65535</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Same</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y* <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Same</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y* <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Same</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y* <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Same</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y* <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Same </td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">65535</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">65535</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">65535</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">65535</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">1200</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Same</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">65535</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">1208</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Same</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.629629629629628%" headers="d0e58 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="15.185185185185185%" headers="d0e60 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="15.37037037037037%" headers="d0e62 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e71 ">65535</td>
|
|||
|
<td align="left" valign="top" width="14.814814814814813%" headers="d0e64 d0e73 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e66 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.592592592592592%" headers="d0e68 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td colspan="7" align="left" valign="top" headers="d0e58 d0e60 d0e62 d0e64 d0e66 d0e68 d0e71 d0e73 "> <div class="note"><span class="notetitle">Note:</span> * These
|
|||
|
mappings are valid for FMTOPT(*MAP), FMTOPT(*NONE), and FMTOPT(*DROP).</div>
|
|||
|
</td>
|
|||
|
</tr>
|
|||
|
</tbody>
|
|||
|
</table>
|
|||
|
</div>
|
|||
|
<p>The second table shows the mapping between fixed-length data types and
|
|||
|
large objects.</p>
|
|||
|
|
|||
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><caption>Table 2. From-file and to-file mapping between
|
|||
|
fixed-length data types and large objects</caption><thead align="left"><tr><th rowspan="2" align="left" valign="top" width="14.003944773175542%" id="d0e531">Field A type</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="14.595660749506903%" id="d0e533">Field B type</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="13.609467455621301%" id="d0e535">Allowed and copy direction</th>
|
|||
|
<th colspan="2" align="left" valign="top" id="d0e537">Data CCSID or
|
|||
|
attributes</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="16.173570019723865%" id="d0e539">CCSIDs</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="13.806706114398423%" id="d0e541">Conversion translation performed</th>
|
|||
|
</tr>
|
|||
|
<tr><th align="left" valign="top" width="15.187376725838265%" id="d0e544">Field A</th>
|
|||
|
<th align="left" valign="top" width="12.6232741617357%" id="d0e546">Field B</th>
|
|||
|
</tr>
|
|||
|
</thead>
|
|||
|
<tbody><tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Either</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Either</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Only</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Only</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Same/Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No/Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Either</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Either</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Only</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Only</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Same/Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No/Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Either</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Either</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Only</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Only</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Either</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Either</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Only</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Only</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Same/Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No/Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Not 65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Not 65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Either</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Not 65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Only</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Not 65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Same/Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No/Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Open</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Either</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Only</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Same</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Same</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">65535</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Same</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Character</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Open</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">UTF-8</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">1208</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="14.003944773175542%" headers="d0e531 ">Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.595660749506903%" headers="d0e533 ">UTF-16</td>
|
|||
|
<td align="left" valign="top" width="13.609467455621301%" headers="d0e535 ">N</td>
|
|||
|
<td align="left" valign="top" width="15.187376725838265%" headers="d0e537 d0e544 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.6232741617357%" headers="d0e537 d0e546 ">1200</td>
|
|||
|
<td align="left" valign="top" width="16.173570019723865%" headers="d0e539 ">Different</td>
|
|||
|
<td align="left" valign="top" width="13.806706114398423%" headers="d0e541 ">–</td>
|
|||
|
</tr>
|
|||
|
</tbody>
|
|||
|
</table>
|
|||
|
</div>
|
|||
|
<p>The second table shows the mapping variable-length data types and large
|
|||
|
object.</p>
|
|||
|
|
|||
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><caption>Table 3. From-file and to-file mapping between
|
|||
|
variable-length data types and large objects</caption><thead align="left"><tr><th rowspan="2" align="left" valign="top" width="16.30648330058939%" id="d0e1329">Field A type</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="14.341846758349705%" id="d0e1331">Field B type</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="14.734774066797643%" id="d0e1333">Allowed and copy direction</th>
|
|||
|
<th colspan="2" align="left" valign="top" id="d0e1335">Data CCSID or
|
|||
|
attributes</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="15.717092337917485%" id="d0e1337">CCSIDs</th>
|
|||
|
<th rowspan="2" align="left" valign="top" width="12.573673870333987%" id="d0e1339">Conversion translation performed</th>
|
|||
|
</tr>
|
|||
|
<tr><th align="left" valign="top" width="14.145383104125736%" id="d0e1342">Field A</th>
|
|||
|
<th align="left" valign="top" width="12.180746561886052%" id="d0e1344">Field B</th>
|
|||
|
</tr>
|
|||
|
</thead>
|
|||
|
<tbody><tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Open</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Either</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Either</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Only</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Only</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Character</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Same/Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No/Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Open</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Character</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Either</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Either</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Character</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Only</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Only</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Character</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Character</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">—</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Character</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Open</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Same/Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No/Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Either</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Either</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Only</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Only</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Character</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Open</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Open</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Either</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Either</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Only</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Only</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Same/Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No/Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Not 65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Open</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 "> Not 65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Either</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Not 65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Only</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Not 65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Graphic</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UCS2</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Same/Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No/Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Open</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Either</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Only</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UTF8</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">1208</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different/Same</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes/No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN UTF16</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">1200</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different/Same</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">Yes/No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">BLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">65535</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Same</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Character</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">CLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">Y <—></td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Open</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">No</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">Graphic</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">DBCLOB</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">UCS2</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">UTF-8</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">1208</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
<tr><td align="left" valign="top" width="16.30648330058939%" headers="d0e1329 ">VARLEN Binary character</td>
|
|||
|
<td align="left" valign="top" width="14.341846758349705%" headers="d0e1331 ">UTF-16</td>
|
|||
|
<td align="left" valign="top" width="14.734774066797643%" headers="d0e1333 ">N</td>
|
|||
|
<td align="left" valign="top" width="14.145383104125736%" headers="d0e1335 d0e1342 ">65535</td>
|
|||
|
<td align="left" valign="top" width="12.180746561886052%" headers="d0e1335 d0e1344 ">1200</td>
|
|||
|
<td align="left" valign="top" width="15.717092337917485%" headers="d0e1337 ">Different</td>
|
|||
|
<td align="left" valign="top" width="12.573673870333987%" headers="d0e1339 ">–</td>
|
|||
|
</tr>
|
|||
|
</tbody>
|
|||
|
</table>
|
|||
|
</div>
|
|||
|
</div>
|
|||
|
<div>
|
|||
|
<div class="familylinks">
|
|||
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal3copycomplex.htm" title="You can copy from and to files that contain user-defined functions (UDFs), user-defined types (UDTs), DataLinks (DLs), large objects (LOBs), identity columns, or ROWIDs.">Copy complex objects</a></div>
|
|||
|
</div>
|
|||
|
<div class="relinfo"><strong>Related information</strong><br />
|
|||
|
<div><a href="../cl/cpyf.htm">CPYF command</a></div>
|
|||
|
<div><a href="../cl/cpyfrmqryf.htm">CPYFRMQRYF command</a></div>
|
|||
|
</div>
|
|||
|
</div>
|
|||
|
</body>
|
|||
|
</html>
|