third_party/WebKit/LayoutTests/tables/mozilla/bugs/bug113235-1.html

   1 <html>
   2 <body>
   3 <table border>
   4   <tr valign="top">
   5     <td>x</td>
   6     <td>
   7       <!-- this font, and the malformed table below trigger the bug -->
   8       <font face="Arial, sans-serif" size="-1">
   9       <table border>
  10         <tr>
  11           <td width="10">&nbsp;</td>
  12           <td width="443" valign="top" align="left">
  13         <tr>
  14           <td>Search again...</td>
  15         </tr>
  16         <table>
  17           <tr>
  18             This text node only exists once in the original document!
  19             If it were a large collection of inlines, the page would
  20             hang forever.
  21
  22 <A NAME="Top_Of_Page"></A>
  23 <H2><A NAME="ToC">Table of Contents</A></H2>
  24 <P><B><A NAME="ToC_1" HREF="whatever.html">Introduction</A></B><BR>
  25 <BR><A NAME="ToC_2" HREF="whatever.html">Who Should Use This Book</A>
  26 <BR><A NAME="ToC_3" HREF="whatever.html">How To Use This Book</A>
  27 <BR><A NAME="ToC_4" HREF="whatever.html">How This Book is Structured</A>
  28 <BR><A NAME="ToC_5" HREF="whatever.html">How to Read the Syntax Diagrams</A>
  29 <BR><A NAME="ToC_6" HREF="whatever.html">Conventions Used in This Manual</A>
  30 <BR><A NAME="ToC_7" HREF="whatever.html">Error Conditions</A>
  31 <BR><A NAME="ToC_8" HREF="whatever.html">Highlighting Conventions</A>
  32 <BR><A NAME="ToC_9" HREF="whatever.html">Related Documentation for This Book</A>
  33 <P><B><A NAME="ToC_10" HREF="whatever.html">Concepts</A></B><BR>
  34 <BR><A NAME="ToC_11" HREF="whatever.html">Relational Database</A>
  35 <BR><A NAME="ToC_12" HREF="whatever.html">Structured Query Language (SQL)</A>
  36 <BR><A NAME="ToC_13" HREF="whatever.html">Embedded SQL</A>
  37 <BR><A NAME="ToC_14" HREF="whatever.html">Static SQL</A>
  38 <BR><A NAME="ToC_15" HREF="whatever.html">Dynamic SQL</A>
  39 <BR><A NAME="ToC_16" HREF="whatever.html">DB2 Call Level Interface (CLI) &amp; Open Database Connectivity (ODBC)</A>
  40 <BR><A NAME="ToC_17" HREF="whatever.html">Java Database Connectivity (JDBC) and Embedded SQL for Java (SQLJ) Programs</A>
  41 <BR><A NAME="ToC_18" HREF="whatever.html">Interactive SQL</A>
  42 <BR><A NAME="ToC_19" HREF="whatever.html">Schemas</A>
  43 <BR><A NAME="ToC_20" HREF="whatever.html">Controlling Use of Schemas</A>
  44 <BR><A NAME="ToC_21" HREF="whatever.html">Tables</A>
  45 <BR><A NAME="ToC_22" HREF="whatever.html">Views</A>
  46 <BR><A NAME="ToC_23" HREF="whatever.html">Aliases</A>
  47 <BR><A NAME="ToC_24" HREF="whatever.html">Indexes</A>
  48 <BR><A NAME="ToC_25" HREF="whatever.html">Keys</A>
  49 <BR><A NAME="ToC_26" HREF="whatever.html">Unique Keys</A>
  50 <BR><A NAME="ToC_27" HREF="whatever.html">Primary Keys</A>
  51 <BR><A NAME="ToC_28" HREF="whatever.html">Foreign Keys</A>
  52 <BR><A NAME="ToC_29" HREF="whatever.html">Partitioning Keys</A>
  53 <BR><A NAME="ToC_30" HREF="whatever.html">Constraints</A>
  54 <BR><A NAME="ToC_31" HREF="whatever.html">Unique Constraints</A>
  55 <BR><A NAME="ToC_32" HREF="whatever.html">Referential Constraints</A>
  56 <BR><A NAME="ToC_36" HREF="whatever.html">Table Check Constraints</A>
  57 <BR><A NAME="ToC_37" HREF="whatever.html">Triggers</A>
  58 <BR><A NAME="ToC_38" HREF="whatever.html">Event Monitors</A>
  59 <BR><A NAME="ToC_39" HREF="whatever.html">Queries</A>
  60 <BR><A NAME="ToC_40" HREF="whatever.html">Table Expressions</A>
  61 <BR><A NAME="ToC_41" HREF="whatever.html">Common Table Expressions</A>
  62 <BR><A NAME="ToC_42" HREF="whatever.html">Packages</A>
  63 <BR><A NAME="ToC_43" HREF="whatever.html">Catalog Views</A>
  64 <BR><A NAME="ToC_44" HREF="whatever.html">Application Processes, Concurrency, and Recovery</A>
  65 <BR><A NAME="ToC_45" HREF="whatever.html">Isolation Level</A>
  66 <BR><A NAME="ToC_46" HREF="whatever.html">Repeatable Read (RR)</A>
  67 <BR><A NAME="ToC_47" HREF="whatever.html">Read Stability (RS)</A>
  68 <BR><A NAME="ToC_48" HREF="whatever.html">Cursor Stability (CS)</A>
  69 <BR><A NAME="ToC_49" HREF="whatever.html">Uncommitted Read (UR)</A>
  70 <BR><A NAME="ToC_50" HREF="whatever.html">Comparison of Isolation Levels</A>
  71 <BR><A NAME="ToC_51" HREF="whatever.html">Distributed Relational Database</A>
  72 <BR><A NAME="ToC_52" HREF="whatever.html">Application Servers</A>
  73 <BR><A NAME="ToC_53" HREF="whatever.html">CONNECT (Type 1) and CONNECT (Type 2)</A>
  74 <BR><A NAME="ToC_54" HREF="whatever.html">Remote Unit of Work</A>
  75 <BR><A NAME="ToC_56" HREF="whatever.html">Application-Directed Distributed Unit of Work</A>
  76 <BR><A NAME="ToC_64" HREF="whatever.html">Data Representation Considerations</A>
  77 <BR><A NAME="ToC_65" HREF="whatever.html">DB2 Federated Systems</A>
  78 <BR><A NAME="ToC_66" HREF="whatever.html">The Federated Server, Federated Database, and Data Sources</A>
  79 <BR><A NAME="ToC_67" HREF="whatever.html">Tasks to Perform in a DB2 Federated System</A>
  80 <BR><A NAME="ToC_68" HREF="whatever.html">Wrappers and Wrapper Modules</A>
  81 <BR><A NAME="ToC_69" HREF="whatever.html">Server Definitions and Server Options</A>
  82 <BR><A NAME="ToC_73" HREF="whatever.html">User Mappings and User Options</A>
  83 <BR><A NAME="ToC_74" HREF="whatever.html">Data Type Mappings</A>
  84 <BR><A NAME="ToC_75" HREF="whatever.html">Function Mappings, Function Templates, and Function Mapping Options</A>
  85 <BR><A NAME="ToC_76" HREF="whatever.html">Nicknames and Column Options</A>
  86 <BR><A NAME="ToC_77" HREF="whatever.html">Index Specifications</A>
  87 <BR><A NAME="ToC_78" HREF="whatever.html">Distributed Requests</A>
  88 <BR><A NAME="ToC_81" HREF="whatever.html">Compensation</A>
  89 <BR><A NAME="ToC_82" HREF="whatever.html">Pass-Through</A>
  90 <BR><A NAME="ToC_83" HREF="whatever.html">Character Conversion</A>
  91 <BR><A NAME="ToC_84" HREF="whatever.html">Character Sets and Code Pages</A>
  92 <BR><A NAME="ToC_85" HREF="whatever.html">Code Page Attributes</A>
  93 <BR><A NAME="ToC_87" HREF="whatever.html">Authorization and Privileges</A>
  94 <BR><A NAME="ToC_88" HREF="whatever.html">Table Spaces and Other Storage Structures</A>
  95 <BR><A NAME="ToC_89" HREF="whatever.html">Data Partitioning Across Multiple Partitions</A>
  96 <BR><A NAME="ToC_90" HREF="whatever.html">Partitioning Maps</A>
  97 <BR><A NAME="ToC_91" HREF="whatever.html">Table Collocation</A>
  98 <P><B><A NAME="ToC_92" HREF="whatever.html">Language Elements</A></B><BR>
  99 <BR><A NAME="ToC_93" HREF="whatever.html">Characters</A>
 100 <BR><A NAME="ToC_94" HREF="whatever.html">MBCS Considerations</A>
 101 <BR><A NAME="ToC_95" HREF="whatever.html">Tokens</A>
 102 <BR><A NAME="ToC_96" HREF="whatever.html">MBCS Considerations</A>
 103 <BR><A NAME="ToC_97" HREF="whatever.html">Identifiers</A>
 104 <BR><A NAME="ToC_98" HREF="whatever.html">SQL Identifiers</A>
 105 <BR><A NAME="ToC_99" HREF="whatever.html">Host Identifiers</A>
 106 <BR><A NAME="ToC_100" HREF="whatever.html">Naming Conventions and Implicit Object Name Qualifications</A>
 107 <BR><A NAME="ToC_101" HREF="whatever.html">Aliases</A>
 108 <BR><A NAME="ToC_102" HREF="whatever.html">Authorization IDs and authorization-names</A>
 109 <BR><A NAME="ToC_103" HREF="whatever.html">Dynamic SQL Characteristics at run-time</A>
 110 <BR><A NAME="ToC_104" HREF="whatever.html">Authorization IDs and Statement Preparation</A>
 111 <BR><A NAME="ToC_105" HREF="whatever.html">Data Types</A>
 112 <BR><A NAME="ToC_106" HREF="whatever.html">Nulls</A>
 113 <BR><A NAME="ToC_107" HREF="whatever.html">Large Objects (LOBs)</A>
 114 <BR><A NAME="ToC_112" HREF="whatever.html">Character Strings</A>
 115 <BR><A NAME="ToC_119" HREF="whatever.html">Graphic Strings</A>
 116 <BR><A NAME="ToC_123" HREF="whatever.html">Binary String</A>
 117 <BR><A NAME="ToC_124" HREF="whatever.html">Numbers</A>
 118 <BR><A NAME="ToC_131" HREF="whatever.html">Datetime Values</A>
 119 <BR><A NAME="ToC_140" HREF="whatever.html">DATALINK Values</A>
 120 <BR><A NAME="ToC_141" HREF="whatever.html">User Defined Types</A>
 121 <BR><A NAME="ToC_145" HREF="whatever.html">Promotion of Data Types</A>
 122 <BR><A NAME="ToC_146" HREF="whatever.html">Casting Between Data Types</A>
 123 <BR><A NAME="ToC_147" HREF="whatever.html">Assignments and Comparisons</A>
 124 <BR><A NAME="ToC_148" HREF="whatever.html">Numeric Assignments</A>
 125 <BR><A NAME="ToC_154" HREF="whatever.html">String Assignments</A>
 126 <BR><A NAME="ToC_160" HREF="whatever.html">Datetime Assignments</A>
 127 <BR><A NAME="ToC_161" HREF="whatever.html">DATALINK Assignments</A>
 128 <BR><A NAME="ToC_162" HREF="whatever.html">User-defined Type Assignments</A>
 129 <BR><A NAME="ToC_163" HREF="whatever.html">Reference Type Assignments</A>
 130 <BR><A NAME="ToC_164" HREF="whatever.html">Numeric Comparisons</A>
 131 <BR><A NAME="ToC_165" HREF="whatever.html">String Comparisons</A>
 132 <BR><A NAME="ToC_169" HREF="whatever.html">Datetime Comparisons</A>
 133 <BR><A NAME="ToC_170" HREF="whatever.html">User-defined Type Comparisons</A>
 134 <BR><A NAME="ToC_171" HREF="whatever.html">Reference Type Comparisons</A>
 135 <BR><A NAME="ToC_172" HREF="whatever.html">Rules for Result Data Types</A>
 136 <BR><A NAME="ToC_173" HREF="whatever.html">Character Strings</A>
 137 <BR><A NAME="ToC_174" HREF="whatever.html">Graphic Strings</A>
 138 <BR><A NAME="ToC_175" HREF="whatever.html">Binary Large Object (BLOB)</A>
 139 <BR><A NAME="ToC_176" HREF="whatever.html">Numeric</A>
 140 <BR><A NAME="ToC_177" HREF="whatever.html">DATE</A>
 141 <BR><A NAME="ToC_178" HREF="whatever.html">TIME</A>
 142 <BR><A NAME="ToC_179" HREF="whatever.html">TIMESTAMP</A>
 143 <BR><A NAME="ToC_180" HREF="whatever.html">DATALINK</A>
 144 <BR><A NAME="ToC_181" HREF="whatever.html">User-defined Types</A>
 145 <BR><A NAME="ToC_185" HREF="whatever.html">Nullable Attribute of Result</A>
 146 <BR><A NAME="ToC_186" HREF="whatever.html">Rules for String Conversions</A>
 147 <BR><A NAME="ToC_187" HREF="whatever.html">Partition Compatibility</A>
 148 <BR><A NAME="ToC_188" HREF="whatever.html">Constants</A>
 149 <BR><A NAME="ToC_189" HREF="whatever.html">Integer Constants</A>
 150 <BR><A NAME="ToC_190" HREF="whatever.html">Floating-Point Constants</A>
 151 <BR><A NAME="ToC_191" HREF="whatever.html">Decimal Constants</A>
 152 <BR><A NAME="ToC_192" HREF="whatever.html">Character String Constants</A>
 153 <BR><A NAME="ToC_194" HREF="whatever.html">Hexadecimal Constants</A>
 154 <BR><A NAME="ToC_195" HREF="whatever.html">Graphic String Constants</A>
 155 <BR><A NAME="ToC_197" HREF="whatever.html">Using Constants with User-defined Types</A>
 156 <BR><A NAME="ToC_198" HREF="whatever.html">Special Registers</A>
 157 <BR><A NAME="ToC_199" HREF="whatever.html">CURRENT DATE</A>
 158 <BR><A NAME="ToC_201" HREF="whatever.html">CURRENT DEFAULT TRANSFORM GROUP</A>
 159 <BR><A NAME="ToC_203" HREF="whatever.html">CURRENT DEGREE</A>
 160 <BR><A NAME="ToC_204" HREF="whatever.html">CURRENT EXPLAIN MODE</A>
 161 <BR><A NAME="ToC_205" HREF="whatever.html">CURRENT EXPLAIN SNAPSHOT</A>
 162 <BR><A NAME="ToC_207" HREF="whatever.html">CURRENT NODE</A>
 163 <BR><A NAME="ToC_209" HREF="whatever.html">CURRENT PATH</A>
 164 <BR><A NAME="ToC_211" HREF="whatever.html">CURRENT QUERY OPTIMIZATION</A>
 165 <BR><A NAME="ToC_213" HREF="whatever.html">CURRENT REFRESH AGE</A>
 166 <BR><A NAME="ToC_214" HREF="whatever.html">CURRENT SCHEMA</A>
 167 <BR><A NAME="ToC_216" HREF="whatever.html">CURRENT SERVER</A>
 168 <BR><A NAME="ToC_218" HREF="whatever.html">CURRENT TIME</A>
 169 <BR><A NAME="ToC_220" HREF="whatever.html">CURRENT TIMESTAMP</A>
 170 <BR><A NAME="ToC_222" HREF="whatever.html">CURRENT TIMEZONE</A>
 171 <BR><A NAME="ToC_224" HREF="whatever.html">USER</A>
 172 <BR><A NAME="ToC_226" HREF="whatever.html">Column Names</A>
 173 <BR><A NAME="ToC_227" HREF="whatever.html">Qualified Column Names</A>
 174 <BR><A NAME="ToC_228" HREF="whatever.html">Correlation Names</A>
 175 <BR><A NAME="ToC_229" HREF="whatever.html">Column Name Qualifiers to Avoid Ambiguity</A>
 176 <BR><A NAME="ToC_232" HREF="whatever.html">Column Name Qualifiers in Correlated References</A>
 177 <BR><A NAME="ToC_233" HREF="whatever.html">References to Host Variables</A>
 178 <BR><A NAME="ToC_234" HREF="whatever.html">Host Variables in Dynamic SQL</A>
 179 <BR><A NAME="ToC_236" HREF="whatever.html">References to BLOB, CLOB, and DBCLOB Host Variables</A>
 180 <BR><A NAME="ToC_237" HREF="whatever.html">References to Locator Variables</A>
 181 <BR><A NAME="ToC_238" HREF="whatever.html">References to BLOB, CLOB, and DBCLOB File Reference Variables</A>
 182 <BR><A NAME="ToC_241" HREF="whatever.html">References to Structured Type Host Variables</A>
 183 <BR><A NAME="ToC_243" HREF="whatever.html">Functions</A>
 184 <BR><A NAME="ToC_244" HREF="whatever.html">External, SQL and Sourced User-Defined Functions</A>
 185 <BR><A NAME="ToC_245" HREF="whatever.html">Scalar, Column, Row and Table User-Defined Functions</A>
 186 <BR><A NAME="ToC_246" HREF="whatever.html">Function signatures</A>
 187 <BR><A NAME="ToC_247" HREF="whatever.html">SQL Path</A>
 188 <BR><A NAME="ToC_248" HREF="whatever.html">Function Resolution</A>
 189 <BR><A NAME="ToC_252" HREF="whatever.html">Function Invocation</A>
 190 <BR><A NAME="ToC_253" HREF="whatever.html">Methods</A>
 191 <BR><A NAME="ToC_254" HREF="whatever.html">External and SQL User-Defined Methods</A>
 192 <BR><A NAME="ToC_255" HREF="whatever.html">Method Signatures</A>
 193 <BR><A NAME="ToC_256" HREF="whatever.html">Method Invocation</A>
 194 <BR><A NAME="ToC_257" HREF="whatever.html">Method Resolution</A>
 195 <BR><A NAME="ToC_258" HREF="whatever.html">Method of Choosing the Best Fit</A>
 196 <BR><A NAME="ToC_259" HREF="whatever.html">Example of Method Resolution</A>
 197 <BR><A NAME="ToC_260" HREF="whatever.html">Method Invocation</A>
 198 <BR><A NAME="ToC_261" HREF="whatever.html">Conservative Binding Semantics</A>
 199 <BR><A NAME="ToC_262" HREF="whatever.html">Expressions</A>
 200 <BR><A NAME="ToC_263" HREF="whatever.html">Without Operators</A>
 201 <BR><A NAME="ToC_264" HREF="whatever.html">With the Concatenation Operator</A>
 202 <BR><A NAME="ToC_266" HREF="whatever.html">With Arithmetic Operators</A>
 203 <BR><A NAME="ToC_268" HREF="whatever.html">Two Integer Operands</A>
 204 <BR><A NAME="ToC_269" HREF="whatever.html">Integer and Decimal Operands</A>
 205 <BR><A NAME="ToC_270" HREF="whatever.html">Two Decimal Operands</A>
 206 <BR><A NAME="ToC_271" HREF="whatever.html">Decimal Arithmetic in SQL</A>
 207 <BR><A NAME="ToC_275" HREF="whatever.html">Floating-Point Operands</A>
 208 <BR><A NAME="ToC_276" HREF="whatever.html">User-defined Types as Operands</A>
 209 <BR><A NAME="ToC_277" HREF="whatever.html">Scalar Fullselect</A>
 210 <BR><A NAME="ToC_278" HREF="whatever.html">Datetime Operations and Durations</A>
 211 <BR><A NAME="ToC_283" HREF="whatever.html">Datetime Arithmetic in SQL</A>
 212 <BR><A NAME="ToC_293" HREF="whatever.html">Precedence of Operations</A>
 213 <BR><A NAME="ToC_294" HREF="whatever.html">CASE Expressions</A>
 214 <BR><A NAME="ToC_296" HREF="whatever.html">CAST Specifications</A>
 215 <BR><A NAME="ToC_298" HREF="whatever.html">Dereference Operations</A>
 216 <BR><A NAME="ToC_300" HREF="whatever.html">OLAP Functions</A>
 217 <BR><A NAME="ToC_302" HREF="whatever.html">Method Invocation</A>
 218 <BR><A NAME="ToC_304" HREF="whatever.html">Subtype Treatment</A>
 219 <BR><A NAME="ToC_306" HREF="whatever.html">Predicates</A>
 220 <BR><A NAME="ToC_307" HREF="whatever.html">Basic Predicate</A>
 221 <BR><A NAME="ToC_308" HREF="whatever.html">Quantified Predicate</A>
 222 <BR><A NAME="ToC_309" HREF="whatever.html">BETWEEN Predicate</A>
 223 <BR><A NAME="ToC_310" HREF="whatever.html">EXISTS Predicate</A>
 224 <BR><A NAME="ToC_311" HREF="whatever.html">IN Predicate</A>
 225 <BR><A NAME="ToC_312" HREF="whatever.html">LIKE Predicate</A>
 226 <BR><A NAME="ToC_314" HREF="whatever.html">NULL Predicate</A>
 227 <BR><A NAME="ToC_315" HREF="whatever.html">TYPE Predicate</A>
 228 <BR><A NAME="ToC_316" HREF="whatever.html">Search Conditions</A>
 229 <BR><A NAME="ToC_317" HREF="whatever.html">Examples</A>
 230 <P><B><A NAME="ToC_318" HREF="whatever.html">Functions</A></B><BR>
 231 <BR><A NAME="ToC_319" HREF="whatever.html">Column Functions</A>
 232 <BR><A NAME="ToC_320" HREF="whatever.html">AVG</A>
 233 <BR><A NAME="ToC_321" HREF="whatever.html">CORRELATION</A>
 234 <BR><A NAME="ToC_322" HREF="whatever.html">COUNT</A>
 235 <BR><A NAME="ToC_323" HREF="whatever.html">COUNT_BIG</A>
 236 <BR><A NAME="ToC_324" HREF="whatever.html">COVARIANCE</A>
 237 <BR><A NAME="ToC_325" HREF="whatever.html">GROUPING</A>
 238 <BR><A NAME="ToC_326" HREF="whatever.html">MAX</A>
 239 <BR><A NAME="ToC_327" HREF="whatever.html">MIN</A>
 240 <BR><A NAME="ToC_328" HREF="whatever.html">REGRESSION Functions</A>
 241 <BR><A NAME="ToC_329" HREF="whatever.html">STDDEV</A>
 242 <BR><A NAME="ToC_330" HREF="whatever.html">SUM</A>
 243 <BR><A NAME="ToC_331" HREF="whatever.html">VARIANCE</A>
 244 <BR><A NAME="ToC_332" HREF="whatever.html">Scalar Functions</A>
 245 <BR><A NAME="ToC_333" HREF="whatever.html">ABS or ABSVAL</A>
 246 <BR><A NAME="ToC_334" HREF="whatever.html">ACOS</A>
 247 <BR><A NAME="ToC_335" HREF="whatever.html">ASCII</A>
 248 <BR><A NAME="ToC_336" HREF="whatever.html">ASIN</A>
 249 <BR><A NAME="ToC_337" HREF="whatever.html">ATAN</A>
 250 <BR><A NAME="ToC_338" HREF="whatever.html">ATAN2</A>
 251 <BR><A NAME="ToC_339" HREF="whatever.html">BIGINT</A>
 252 <BR><A NAME="ToC_340" HREF="whatever.html">BLOB</A>
 253 <BR><A NAME="ToC_341" HREF="whatever.html">CEILING or CEIL</A>
 254 <BR><A NAME="ToC_342" HREF="whatever.html">CHAR</A>
 255 <BR><A NAME="ToC_343" HREF="whatever.html">CHR</A>
 256 <BR><A NAME="ToC_344" HREF="whatever.html">CLOB</A>
 257 <BR><A NAME="ToC_345" HREF="whatever.html">COALESCE</A>
 258 <BR><A NAME="ToC_346" HREF="whatever.html">CONCAT</A>
 259 <BR><A NAME="ToC_347" HREF="whatever.html">COS</A>
 260 <BR><A NAME="ToC_348" HREF="whatever.html">COT</A>
 261 <BR><A NAME="ToC_349" HREF="whatever.html">DATE</A>
 262 <BR><A NAME="ToC_350" HREF="whatever.html">DAY</A>
 263 <BR><A NAME="ToC_351" HREF="whatever.html">DAYNAME</A>
 264 <BR><A NAME="ToC_352" HREF="whatever.html">DAYOFWEEK</A>
 265 <BR><A NAME="ToC_353" HREF="whatever.html">DAYOFWEEK_ISO</A>
 266 <BR><A NAME="ToC_354" HREF="whatever.html">DAYOFYEAR</A>
 267 <BR><A NAME="ToC_355" HREF="whatever.html">DAYS</A>
 268 <BR><A NAME="ToC_356" HREF="whatever.html">DBCLOB</A>
 269 <BR><A NAME="ToC_357" HREF="whatever.html">DECIMAL</A>
 270 <BR><A NAME="ToC_358" HREF="whatever.html">DEGREES</A>
 271 <BR><A NAME="ToC_359" HREF="whatever.html">DEREF</A>
 272 <BR><A NAME="ToC_360" HREF="whatever.html">DIFFERENCE</A>
 273 <BR><A NAME="ToC_361" HREF="whatever.html">DIGITS</A>
 274 <BR><A NAME="ToC_362" HREF="whatever.html">DLCOMMENT</A>
 275 <BR><A NAME="ToC_363" HREF="whatever.html">DLLINKTYPE</A>
 276 <BR><A NAME="ToC_364" HREF="whatever.html">DLURLCOMPLETE</A>
 277 <BR><A NAME="ToC_365" HREF="whatever.html">DLURLPATH</A>
 278 <BR><A NAME="ToC_366" HREF="whatever.html">DLURLPATHONLY</A>
 279 <BR><A NAME="ToC_367" HREF="whatever.html">DLURLSCHEME</A>
 280 <BR><A NAME="ToC_368" HREF="whatever.html">DLURLSERVER</A>
 281 <BR><A NAME="ToC_369" HREF="whatever.html">DLVALUE</A>
 282 <BR><A NAME="ToC_370" HREF="whatever.html">DOUBLE</A>
 283 <BR><A NAME="ToC_371" HREF="whatever.html">EVENT_MON_STATE</A>
 284 <BR><A NAME="ToC_372" HREF="whatever.html">EXP</A>
 285 <BR><A NAME="ToC_373" HREF="whatever.html">FLOAT</A>
 286 <BR><A NAME="ToC_374" HREF="whatever.html">FLOOR</A>
 287 <BR><A NAME="ToC_375" HREF="whatever.html">GENERATE_UNIQUE</A>
 288 <BR><A NAME="ToC_376" HREF="whatever.html">GRAPHIC</A>
 289 <BR><A NAME="ToC_377" HREF="whatever.html">HEX</A>
 290 <BR><A NAME="ToC_378" HREF="whatever.html">HOUR</A>
 291 <BR><A NAME="ToC_379" HREF="whatever.html">INSERT</A>
 292 <BR><A NAME="ToC_380" HREF="whatever.html">INTEGER</A>
 293 <BR><A NAME="ToC_381" HREF="whatever.html">JULIAN_DAY</A>
 294 <BR><A NAME="ToC_382" HREF="whatever.html">LCASE or LOWER</A>
 295 <BR><A NAME="ToC_383" HREF="whatever.html">LCASE (SYSFUN schema)</A>
 296 <BR><A NAME="ToC_384" HREF="whatever.html">LEFT</A>
 297 <BR><A NAME="ToC_385" HREF="whatever.html">LENGTH</A>
 298 <BR><A NAME="ToC_386" HREF="whatever.html">LN</A>
 299 <BR><A NAME="ToC_387" HREF="whatever.html">LOCATE</A>
 300 <BR><A NAME="ToC_388" HREF="whatever.html">LOG</A>
 301 <BR><A NAME="ToC_389" HREF="whatever.html">LOG10</A>
 302 <BR><A NAME="ToC_390" HREF="whatever.html">LONG_VARCHAR</A>
 303 <BR><A NAME="ToC_391" HREF="whatever.html">LONG_VARGRAPHIC</A>
 304 <BR><A NAME="ToC_392" HREF="whatever.html">LTRIM</A>
 305 <BR><A NAME="ToC_393" HREF="whatever.html">LTRIM (SYSFUN schema)</A>
 306 <BR><A NAME="ToC_394" HREF="whatever.html">MICROSECOND</A>
 307 <BR><A NAME="ToC_395" HREF="whatever.html">MIDNIGHT_SECONDS</A>
 308 <BR><A NAME="ToC_396" HREF="whatever.html">MINUTE</A>
 309 <BR><A NAME="ToC_397" HREF="whatever.html">MOD</A>
 310 <BR><A NAME="ToC_398" HREF="whatever.html">MONTH</A>
 311 <BR><A NAME="ToC_399" HREF="whatever.html">MONTHNAME</A>
 312 <BR><A NAME="ToC_400" HREF="whatever.html">NODENUMBER</A>
 313 <BR><A NAME="ToC_401" HREF="whatever.html">NULLIF</A>
 314 <BR><A NAME="ToC_402" HREF="whatever.html">PARTITION</A>
 315 <BR><A NAME="ToC_403" HREF="whatever.html">POSSTR</A>
 316 <BR><A NAME="ToC_404" HREF="whatever.html">POWER</A>
 317 <BR><A NAME="ToC_405" HREF="whatever.html">QUARTER</A>
 318 <BR><A NAME="ToC_406" HREF="whatever.html">RADIANS</A>
 319 <BR><A NAME="ToC_407" HREF="whatever.html">RAISE_ERROR</A>
 320 <BR><A NAME="ToC_408" HREF="whatever.html">RAND</A>
 321 <BR><A NAME="ToC_409" HREF="whatever.html">REAL</A>
 322 <BR><A NAME="ToC_410" HREF="whatever.html">REPEAT</A>
 323 <BR><A NAME="ToC_411" HREF="whatever.html">REPLACE</A>
 324 <BR><A NAME="ToC_412" HREF="whatever.html">RIGHT</A>
 325 <BR><A NAME="ToC_413" HREF="whatever.html">ROUND</A>
 326 <BR><A NAME="ToC_414" HREF="whatever.html">RTRIM</A>
 327 <BR><A NAME="ToC_415" HREF="whatever.html">RTRIM (SYSFUN schema)</A>
 328 <BR><A NAME="ToC_416" HREF="whatever.html">SECOND</A>
 329 <BR><A NAME="ToC_417" HREF="whatever.html">SIGN</A>
 330 <BR><A NAME="ToC_418" HREF="whatever.html">SIN</A>
 331 <BR><A NAME="ToC_419" HREF="whatever.html">SMALLINT</A>
 332 <BR><A NAME="ToC_420" HREF="whatever.html">SOUNDEX</A>
 333 <BR><A NAME="ToC_421" HREF="whatever.html">SPACE</A>
 334 <BR><A NAME="ToC_422" HREF="whatever.html">SQRT</A>
 335 <BR><A NAME="ToC_423" HREF="whatever.html">SUBSTR</A>
 336 <BR><A NAME="ToC_424" HREF="whatever.html">TABLE_NAME</A>
 337 <BR><A NAME="ToC_425" HREF="whatever.html">TABLE_SCHEMA</A>
 338 <BR><A NAME="ToC_426" HREF="whatever.html">TAN</A>
 339 <BR><A NAME="ToC_427" HREF="whatever.html">TIME</A>
 340 <BR><A NAME="ToC_428" HREF="whatever.html">TIMESTAMP</A>
 341 <BR><A NAME="ToC_429" HREF="whatever.html">TIMESTAMP_ISO</A>
 342 <BR><A NAME="ToC_430" HREF="whatever.html">TIMESTAMPDIFF</A>
 343 <BR><A NAME="ToC_431" HREF="whatever.html">TRANSLATE</A>
 344 <BR><A NAME="ToC_432" HREF="whatever.html">TRUNCATE or TRUNC</A>
 345 <BR><A NAME="ToC_433" HREF="whatever.html">TYPE_ID</A>
 346 <BR><A NAME="ToC_434" HREF="whatever.html">TYPE_NAME</A>
 347 <BR><A NAME="ToC_435" HREF="whatever.html">TYPE_SCHEMA</A>
 348 <BR><A NAME="ToC_436" HREF="whatever.html">UCASE or UPPER</A>
 349 <BR><A NAME="ToC_437" HREF="whatever.html">VALUE</A>
 350 <BR><A NAME="ToC_438" HREF="whatever.html">VARCHAR</A>
 351 <BR><A NAME="ToC_439" HREF="whatever.html">VARGRAPHIC</A>
 352 <BR><A NAME="ToC_440" HREF="whatever.html">WEEK</A>
 353 <BR><A NAME="ToC_441" HREF="whatever.html">WEEK_ISO</A>
 354 <BR><A NAME="ToC_442" HREF="whatever.html">YEAR</A>
 355 <BR><A NAME="ToC_443" HREF="whatever.html">Table Functions</A>
 356 <BR><A NAME="ToC_444" HREF="whatever.html">SQLCACHE_SNAPSHOT</A>
 357 <BR><A NAME="ToC_445" HREF="whatever.html">User-Defined Functions</A>
 358 <P><B><A NAME="ToC_446" HREF="whatever.html">Queries</A></B><BR>
 359 <BR><A NAME="ToC_447" HREF="whatever.html">subselect</A>
 360 <BR><A NAME="ToC_448" HREF="whatever.html">select-clause</A>
 361 <BR><A NAME="ToC_457" HREF="whatever.html">from-clause</A>
 362 <BR><A NAME="ToC_458" HREF="whatever.html">table-reference</A>
 363 <BR><A NAME="ToC_461" HREF="whatever.html">joined-table</A>
 364 <BR><A NAME="ToC_463" HREF="whatever.html">where-clause</A>
 365 <BR><A NAME="ToC_464" HREF="whatever.html">group-by-clause</A>
 366 <BR><A NAME="ToC_468" HREF="whatever.html">having-clause</A>
 367 <BR><A NAME="ToC_469" HREF="whatever.html">Examples of subselects</A>
 368 <BR><A NAME="ToC_470" HREF="whatever.html">Examples of Joins</A>
 369 <BR><A NAME="ToC_471" HREF="whatever.html">Examples of Grouping Sets, Cube, and Rollup</A>
 370 <BR><A NAME="ToC_472" HREF="whatever.html">fullselect</A>
 371 <BR><A NAME="ToC_473" HREF="whatever.html">Examples of a fullselect</A>
 372 <BR><A NAME="ToC_474" HREF="whatever.html">select-statement</A>
 373 <BR><A NAME="ToC_475" HREF="whatever.html">common-table-expression</A>
 374 <BR><A NAME="ToC_476" HREF="whatever.html">order-by-clause</A>
 375 <BR><A NAME="ToC_478" HREF="whatever.html">update-clause</A>
 376 <BR><A NAME="ToC_479" HREF="whatever.html">read-only-clause</A>
 377 <BR><A NAME="ToC_480" HREF="whatever.html">fetch-first-clause</A>
 378 <BR><A NAME="ToC_481" HREF="whatever.html">optimize-for-clause</A>
 379 <BR><A NAME="ToC_482" HREF="whatever.html">Examples of a select-statement</A>
 380 <P><B><A NAME="ToC_483" HREF="whatever.html">SQL Statements</A></B><BR>
 381 <BR><A NAME="ToC_484" HREF="whatever.html">How SQL Statements Are Invoked</A>
 382 <BR><A NAME="ToC_485" HREF="whatever.html">Embedding a Statement in an Application Program</A>
 383 <BR><A NAME="ToC_489" HREF="whatever.html">Dynamic Preparation and Execution</A>
 384 <BR><A NAME="ToC_490" HREF="whatever.html">Static Invocation of a select-statement</A>
 385 <BR><A NAME="ToC_491" HREF="whatever.html">Dynamic Invocation of a select-statement</A>
 386 <BR><A NAME="ToC_492" HREF="whatever.html">Interactive Invocation</A>
 387 <BR><A NAME="ToC_493" HREF="whatever.html">SQL Return Codes</A>
 388 <BR><A NAME="ToC_494" HREF="whatever.html">SQLCODE</A>
 389 <BR><A NAME="ToC_495" HREF="whatever.html">SQLSTATE</A>
 390 <BR><A NAME="ToC_496" HREF="whatever.html">SQL Comments</A>
 391 <BR><A NAME="ToC_497" HREF="whatever.html">ALTER BUFFERPOOL</A>
 392 <BR><A NAME="ToC_498" HREF="whatever.html">ALTER NICKNAME</A>
 393 <BR><A NAME="ToC_499" HREF="whatever.html">ALTER NODEGROUP</A>
 394 <BR><A NAME="ToC_500" HREF="whatever.html">ALTER SERVER</A>
 395 <BR><A NAME="ToC_501" HREF="whatever.html">ALTER TABLE</A>
 396 <BR><A NAME="ToC_504" HREF="whatever.html">ALTER TABLESPACE</A>
 397 <BR><A NAME="ToC_505" HREF="whatever.html">ALTER TYPE (Structured)</A>
 398 <BR><A NAME="ToC_507" HREF="whatever.html">ALTER USER MAPPING</A>
 399 <BR><A NAME="ToC_508" HREF="whatever.html">ALTER VIEW</A>
 400 <BR><A NAME="ToC_509" HREF="whatever.html">BEGIN DECLARE SECTION</A>
 401 <BR><A NAME="ToC_511" HREF="whatever.html">CALL</A>
 402 <BR><A NAME="ToC_513" HREF="whatever.html">CLOSE</A>
 403 <BR><A NAME="ToC_514" HREF="whatever.html">COMMENT ON</A>
 404 <BR><A NAME="ToC_515" HREF="whatever.html">COMMIT</A>
 405 <BR><A NAME="ToC_517" HREF="whatever.html">Compound SQL (Embedded)</A>
 406 <BR><A NAME="ToC_519" HREF="whatever.html">CONNECT (Type 1)</A>
 407 <BR><A NAME="ToC_524" HREF="whatever.html">CONNECT (Type 2)</A>
 408 <BR><A NAME="ToC_525" HREF="whatever.html">CREATE ALIAS</A>
 409 <BR><A NAME="ToC_526" HREF="whatever.html">CREATE BUFFERPOOL</A>
 410 <BR><A NAME="ToC_527" HREF="whatever.html">CREATE DISTINCT TYPE</A>
 411 <BR><A NAME="ToC_528" HREF="whatever.html">CREATE EVENT MONITOR</A>
 412 <BR><A NAME="ToC_529" HREF="whatever.html">CREATE FUNCTION</A>
 413 <BR><A NAME="ToC_530" HREF="whatever.html">CREATE FUNCTION (External Scalar)</A>
 414 <BR><A NAME="ToC_531" HREF="whatever.html">CREATE FUNCTION (External Table)</A>
 415 <BR><A NAME="ToC_532" HREF="whatever.html">CREATE FUNCTION (OLE DB External Table)</A>
 416 <BR><A NAME="ToC_533" HREF="whatever.html">CREATE FUNCTION (Source or Template)</A>
 417 <BR><A NAME="ToC_534" HREF="whatever.html">CREATE FUNCTION (SQL Scalar, Table or Row)</A>
 418 <BR><A NAME="ToC_535" HREF="whatever.html">CREATE FUNCTION MAPPING</A>
 419 <BR><A NAME="ToC_537" HREF="whatever.html">CREATE INDEX</A>
 420 <BR><A NAME="ToC_538" HREF="whatever.html">CREATE INDEX EXTENSION</A>
 421 <BR><A NAME="ToC_539" HREF="whatever.html">CREATE METHOD</A>
 422 <BR><A NAME="ToC_540" HREF="whatever.html">CREATE NICKNAME</A>
 423 <BR><A NAME="ToC_541" HREF="whatever.html">CREATE NODEGROUP</A>
 424 <BR><A NAME="ToC_542" HREF="whatever.html">CREATE PROCEDURE</A>
 425 <BR><A NAME="ToC_543" HREF="whatever.html">CREATE SCHEMA</A>
 426 <BR><A NAME="ToC_544" HREF="whatever.html">CREATE SERVER</A>
 427 <BR><A NAME="ToC_546" HREF="whatever.html">CREATE TABLE</A>
 428 <BR><A NAME="ToC_549" HREF="whatever.html">CREATE TABLESPACE</A>
 429 <BR><A NAME="ToC_550" HREF="whatever.html">CREATE TRANSFORM</A>
 430 <BR><A NAME="ToC_551" HREF="whatever.html">CREATE TRIGGER</A>
 431 <BR><A NAME="ToC_552" HREF="whatever.html">CREATE TYPE (Structured)</A>
 432 <BR><A NAME="ToC_553" HREF="whatever.html">CREATE TYPE MAPPING</A>
 433 <BR><A NAME="ToC_554" HREF="whatever.html">CREATE USER MAPPING</A>
 434 <BR><A NAME="ToC_555" HREF="whatever.html">CREATE VIEW</A>
 435 <BR><A NAME="ToC_557" HREF="whatever.html">CREATE WRAPPER</A>
 436 <BR><A NAME="ToC_558" HREF="whatever.html">DECLARE CURSOR</A>
 437 <BR><A NAME="ToC_560" HREF="whatever.html">DECLARE GLOBAL TEMPORARY TABLE</A>
 438 <BR><A NAME="ToC_561" HREF="whatever.html">DELETE</A>
 439 <BR><A NAME="ToC_562" HREF="whatever.html">DESCRIBE</A>
 440 <BR><A NAME="ToC_563" HREF="whatever.html">DISCONNECT</A>
 441 <BR><A NAME="ToC_564" HREF="whatever.html">DROP</A>
 442 <BR><A NAME="ToC_566" HREF="whatever.html">END DECLARE SECTION</A>
 443 <BR><A NAME="ToC_567" HREF="whatever.html">EXECUTE</A>
 444 <BR><A NAME="ToC_569" HREF="whatever.html">EXECUTE IMMEDIATE</A>
 445 <BR><A NAME="ToC_570" HREF="whatever.html">EXPLAIN</A>
 446 <BR><A NAME="ToC_571" HREF="whatever.html">FETCH</A>
 447 <BR><A NAME="ToC_572" HREF="whatever.html">FLUSH EVENT MONITOR</A>
 448 <BR><A NAME="ToC_573" HREF="whatever.html">FREE LOCATOR</A>
 449 <BR><A NAME="ToC_574" HREF="whatever.html">GRANT (Database Authorities)</A>
 450 <BR><A NAME="ToC_575" HREF="whatever.html">GRANT (Index Privileges)</A>
 451 <BR><A NAME="ToC_576" HREF="whatever.html">GRANT (Package Privileges)</A>
 452 <BR><A NAME="ToC_577" HREF="whatever.html">GRANT (Schema Privileges)</A>
 453 <BR><A NAME="ToC_578" HREF="whatever.html">GRANT (Server Privileges)</A>
 454 <BR><A NAME="ToC_579" HREF="whatever.html">GRANT (Table, View, or Nickname Privileges)</A>
 455 <BR><A NAME="ToC_580" HREF="whatever.html">GRANT (Table Space Privileges)</A>
 456 <BR><A NAME="ToC_581" HREF="whatever.html">INCLUDE</A>
 457 <BR><A NAME="ToC_582" HREF="whatever.html">INSERT</A>
 458 <BR><A NAME="ToC_584" HREF="whatever.html">LOCK TABLE</A>
 459 <BR><A NAME="ToC_585" HREF="whatever.html">OPEN</A>
 460 <BR><A NAME="ToC_587" HREF="whatever.html">PREPARE</A>
 461 <BR><A NAME="ToC_589" HREF="whatever.html">REFRESH TABLE</A>
 462 <BR><A NAME="ToC_590" HREF="whatever.html">RELEASE (Connection)</A>
 463 <BR><A NAME="ToC_591" HREF="whatever.html">RELEASE SAVEPOINT</A>
 464 <BR><A NAME="ToC_592" HREF="whatever.html">RENAME TABLE</A>
 465 <BR><A NAME="ToC_593" HREF="whatever.html">RENAME TABLESPACE</A>
 466 <BR><A NAME="ToC_594" HREF="whatever.html">REVOKE (Database Authorities)</A>
 467 <BR><A NAME="ToC_595" HREF="whatever.html">REVOKE (Index Privileges)</A>
 468 <BR><A NAME="ToC_596" HREF="whatever.html">REVOKE (Package Privileges)</A>
 469 <BR><A NAME="ToC_597" HREF="whatever.html">REVOKE (Schema Privileges)</A>
 470 <BR><A NAME="ToC_598" HREF="whatever.html">REVOKE (Server Privileges)</A>
 471 <BR><A NAME="ToC_599" HREF="whatever.html">REVOKE (Table, View, or Nickname Privileges)</A>
 472 <BR><A NAME="ToC_600" HREF="whatever.html">REVOKE (Table Space Privileges)</A>
 473 <BR><A NAME="ToC_601" HREF="whatever.html">ROLLBACK</A>
 474 <BR><A NAME="ToC_602" HREF="whatever.html">SAVEPOINT</A>
 475 <BR><A NAME="ToC_603" HREF="whatever.html">SELECT</A>
 476 <BR><A NAME="ToC_604" HREF="whatever.html">SELECT INTO</A>
 477 <BR><A NAME="ToC_605" HREF="whatever.html">SET CONNECTION</A>
 478 <BR><A NAME="ToC_606" HREF="whatever.html">SET CURRENT DEFAULT TRANSFORM GROUP</A>
 479 <BR><A NAME="ToC_607" HREF="whatever.html">SET CURRENT DEGREE</A>
 480 <BR><A NAME="ToC_608" HREF="whatever.html">SET CURRENT EXPLAIN MODE</A>
 481 <BR><A NAME="ToC_609" HREF="whatever.html">SET CURRENT EXPLAIN SNAPSHOT</A>
 482 <BR><A NAME="ToC_610" HREF="whatever.html">SET CURRENT PACKAGESET</A>
 483 <BR><A NAME="ToC_611" HREF="whatever.html">SET CURRENT QUERY OPTIMIZATION</A>
 484 <BR><A NAME="ToC_612" HREF="whatever.html">SET CURRENT REFRESH AGE</A>
 485 <BR><A NAME="ToC_613" HREF="whatever.html">SET EVENT MONITOR STATE</A>
 486 <BR><A NAME="ToC_614" HREF="whatever.html">SET INTEGRITY</A>
 487 <BR><A NAME="ToC_616" HREF="whatever.html">SET PASSTHRU</A>
 488 <BR><A NAME="ToC_617" HREF="whatever.html">SET PATH</A>
 489 <BR><A NAME="ToC_618" HREF="whatever.html">SET SCHEMA</A>
 490 <BR><A NAME="ToC_619" HREF="whatever.html">SET SERVER OPTION</A>
 491 <BR><A NAME="ToC_620" HREF="whatever.html">SET transition-variable</A>
 492 <BR><A NAME="ToC_621" HREF="whatever.html">SIGNAL SQLSTATE</A>
 493 <BR><A NAME="ToC_622" HREF="whatever.html">UPDATE</A>
 494 <BR><A NAME="ToC_623" HREF="whatever.html">VALUES</A>
 495 <BR><A NAME="ToC_624" HREF="whatever.html">VALUES INTO</A>
 496 <BR><A NAME="ToC_625" HREF="whatever.html">WHENEVER</A>
 497 <P><B><A NAME="ToC_626" HREF="whatever.html">SQL Procedures</A></B><BR>
 498 <BR><A NAME="ToC_627" HREF="whatever.html">SQL Procedure Statement</A>
 499 <BR><A NAME="ToC_628" HREF="whatever.html">ALLOCATE CURSOR Statement</A>
 500 <BR><A NAME="ToC_629" HREF="whatever.html">Assignment Statement</A>
 501 <BR><A NAME="ToC_630" HREF="whatever.html">ASSOCIATE LOCATORS Statement</A>
 502 <BR><A NAME="ToC_631" HREF="whatever.html">CASE Statement</A>
 503 <BR><A NAME="ToC_632" HREF="whatever.html">Compound Statement</A>
 504 <BR><A NAME="ToC_633" HREF="whatever.html">FOR Statement</A>
 505 <BR><A NAME="ToC_634" HREF="whatever.html">GET DIAGNOSTICS Statement</A>
 506 <BR><A NAME="ToC_635" HREF="whatever.html">GOTO Statement</A>
 507 <BR><A NAME="ToC_636" HREF="whatever.html">IF Statement</A>
 508 <BR><A NAME="ToC_637" HREF="whatever.html">ITERATE Statement</A>
 509 <BR><A NAME="ToC_638" HREF="whatever.html">LEAVE Statement</A>
 510 <BR><A NAME="ToC_639" HREF="whatever.html">LOOP Statement</A>
 511 <BR><A NAME="ToC_640" HREF="whatever.html">REPEAT Statement</A>
 512 <BR><A NAME="ToC_641" HREF="whatever.html">RESIGNAL Statement</A>
 513 <BR><A NAME="ToC_642" HREF="whatever.html">RETURN Statement</A>
 514 <BR><A NAME="ToC_643" HREF="whatever.html">SIGNAL Statement</A>
 515 <BR><A NAME="ToC_644" HREF="whatever.html">WHILE Statement</A>
 516 <P><B><A NAME="ToC_645" HREF="whatever.html">Appendix A. SQL Limits</A></B><BR>
 517 <P><B><A NAME="ToC_646" HREF="whatever.html">Appendix B. SQL Communications (SQLCA)</A></B><BR>
 518 <BR><A NAME="ToC_647" HREF="whatever.html">Viewing the SQLCA Interactively</A>
 519 <BR><A NAME="ToC_648" HREF="whatever.html">SQLCA Field Descriptions</A>
 520 <BR><A NAME="ToC_649" HREF="whatever.html">Order of Error Reporting</A>
 521 <BR><A NAME="ToC_650" HREF="whatever.html">DB2 Enterprise - Extended Edition Usage of the SQLCA</A>
 522 <P><B><A NAME="ToC_651" HREF="whatever.html">Appendix C. SQL Descriptor Area (SQLDA)</A></B><BR>
 523 <BR><A NAME="ToC_652" HREF="whatever.html">Field Descriptions</A>
 524 <BR><A NAME="ToC_653" HREF="whatever.html">Fields in the SQLDA Header</A>
 525 <BR><A NAME="ToC_654" HREF="whatever.html">Fields in an Occurrence of a Base SQLVAR</A>
 526 <BR><A NAME="ToC_655" HREF="whatever.html">Fields in an Occurrence of a Secondary SQLVAR</A>
 527 <BR><A NAME="ToC_656" HREF="whatever.html">Effect of DESCRIBE on the SQLDA</A>
 528 <BR><A NAME="ToC_657" HREF="whatever.html">SQLTYPE and SQLLEN</A>
 529 <BR><A NAME="ToC_658" HREF="whatever.html">Unrecognized and Unsupported SQLTYPES</A>
 530 <BR><A NAME="ToC_659" HREF="whatever.html">Packed Decimal Numbers</A>
 531 <BR><A NAME="ToC_660" HREF="whatever.html">SQLLEN Field for Decimal</A>
 532 <P><B><A NAME="ToC_661" HREF="whatever.html">Appendix D. Catalog Views</A></B><BR>
 533 <BR><A NAME="ToC_662" HREF="whatever.html">Updatable Catalog Views</A>
 534 <BR><A NAME="ToC_663" HREF="whatever.html">'Roadmap' to Catalog Views</A>
 535 <BR><A NAME="ToC_664" HREF="whatever.html">'Roadmap' to Updatable Catalog Views</A>
 536 <BR><A NAME="ToC_665" HREF="whatever.html">SYSIBM.SYSDUMMY1</A>
 537 <BR><A NAME="ToC_666" HREF="whatever.html">SYSCAT.ATTRIBUTES</A>
 538 <BR><A NAME="ToC_667" HREF="whatever.html">SYSCAT.BUFFERPOOLNODES</A>
 539 <BR><A NAME="ToC_668" HREF="whatever.html">SYSCAT.BUFFERPOOLS</A>
 540 <BR><A NAME="ToC_669" HREF="whatever.html">SYSCAT.CASTFUNCTIONS</A>
 541 <BR><A NAME="ToC_670" HREF="whatever.html">SYSCAT.CHECKS</A>
 542 <BR><A NAME="ToC_671" HREF="whatever.html">SYSCAT.COLAUTH</A>
 543 <BR><A NAME="ToC_672" HREF="whatever.html">SYSCAT.COLCHECKS</A>
 544 <BR><A NAME="ToC_673" HREF="whatever.html">SYSCAT.COLDIST</A>
 545 <BR><A NAME="ToC_674" HREF="whatever.html">SYSCAT.COLOPTIONS</A>
 546 <BR><A NAME="ToC_675" HREF="whatever.html">SYSCAT.COLUMNS</A>
 547 <BR><A NAME="ToC_676" HREF="whatever.html">SYSCAT.CONSTDEP</A>
 548 <BR><A NAME="ToC_677" HREF="whatever.html">SYSCAT.DATATYPES</A>
 549 <BR><A NAME="ToC_678" HREF="whatever.html">SYSCAT.DBAUTH</A>
 550 <BR><A NAME="ToC_679" HREF="whatever.html">SYSCAT.EVENTMONITORS</A>
 551 <BR><A NAME="ToC_680" HREF="whatever.html">SYSCAT.EVENTS</A>
 552 <BR><A NAME="ToC_681" HREF="whatever.html">SYSCAT.FULLHIERARCHIES</A>
 553 <BR><A NAME="ToC_682" HREF="whatever.html">SYSCAT.FUNCDEP</A>
 554 <BR><A NAME="ToC_683" HREF="whatever.html">SYSCAT.FUNCMAPOPTIONS</A>
 555 <BR><A NAME="ToC_684" HREF="whatever.html">SYSCAT.FUNCMAPPARMOPTIONS</A>
 556 <BR><A NAME="ToC_685" HREF="whatever.html">SYSCAT.FUNCMAPPINGS</A>
 557 <BR><A NAME="ToC_686" HREF="whatever.html">SYSCAT.FUNCPARMS</A>
 558 <BR><A NAME="ToC_687" HREF="whatever.html">SYSCAT.FUNCTIONS</A>
 559 <BR><A NAME="ToC_688" HREF="whatever.html">SYSCAT.HIERARCHIES</A>
 560 <BR><A NAME="ToC_689" HREF="whatever.html">SYSCAT.INDEXAUTH</A>
 561 <BR><A NAME="ToC_690" HREF="whatever.html">SYSCAT.INDEXCOLUSE</A>
 562 <BR><A NAME="ToC_691" HREF="whatever.html">SYSCAT.INDEXDEP</A>
 563 <BR><A NAME="ToC_692" HREF="whatever.html">SYSCAT.INDEXES</A>
 564 <BR><A NAME="ToC_693" HREF="whatever.html">SYSCAT.INDEXOPTIONS</A>
 565 <BR><A NAME="ToC_694" HREF="whatever.html">SYSCAT.KEYCOLUSE</A>
 566 <BR><A NAME="ToC_695" HREF="whatever.html">SYSCAT.NAMEMAPPINGS</A>
 567 <BR><A NAME="ToC_696" HREF="whatever.html">SYSCAT.NODEGROUPDEF</A>
 568 <BR><A NAME="ToC_697" HREF="whatever.html">SYSCAT.NODEGROUPS</A>
 569 <BR><A NAME="ToC_698" HREF="whatever.html">SYSCAT.PACKAGEAUTH</A>
 570 <BR><A NAME="ToC_699" HREF="whatever.html">SYSCAT.PACKAGEDEP</A>
 571 <BR><A NAME="ToC_700" HREF="whatever.html">SYSCAT.PACKAGES</A>
 572 <BR><A NAME="ToC_701" HREF="whatever.html">SYSCAT.PARTITIONMAPS</A>
 573 <BR><A NAME="ToC_702" HREF="whatever.html">SYSCAT.PASSTHRUAUTH</A>
 574 <BR><A NAME="ToC_703" HREF="whatever.html">SYSCAT.PROCEDURES</A>
 575 <BR><A NAME="ToC_704" HREF="whatever.html">SYSCAT.PROCOPTIONS</A>
 576 <BR><A NAME="ToC_705" HREF="whatever.html">SYSCAT.PROCPARMOPTIONS</A>
 577 <BR><A NAME="ToC_706" HREF="whatever.html">SYSCAT.PROCPARMS</A>
 578 <BR><A NAME="ToC_707" HREF="whatever.html">SYSCAT.REFERENCES</A>
 579 <BR><A NAME="ToC_708" HREF="whatever.html">SYSCAT.REVTYPEMAPPINGS</A>
 580 <BR><A NAME="ToC_709" HREF="whatever.html">SYSCAT.SCHEMAAUTH</A>
 581 <BR><A NAME="ToC_710" HREF="whatever.html">SYSCAT.SCHEMATA</A>
 582 <BR><A NAME="ToC_711" HREF="whatever.html">SYSCAT.SERVEROPTIONS</A>
 583 <BR><A NAME="ToC_712" HREF="whatever.html">SYSCAT.SERVERS</A>
 584 <BR><A NAME="ToC_713" HREF="whatever.html">SYSCAT.STATEMENTS</A>
 585 <BR><A NAME="ToC_714" HREF="whatever.html">SYSCAT.TABAUTH</A>
 586 <BR><A NAME="ToC_715" HREF="whatever.html">SYSCAT.TABCONST</A>
 587 <BR><A NAME="ToC_716" HREF="whatever.html">SYSCAT.TABLES</A>
 588 <BR><A NAME="ToC_717" HREF="whatever.html">SYSCAT.TABLESPACES</A>
 589 <BR><A NAME="ToC_718" HREF="whatever.html">SYSCAT.TABOPTIONS</A>
 590 <BR><A NAME="ToC_719" HREF="whatever.html">SYSCAT.TBSPACEAUTH</A>
 591 <BR><A NAME="ToC_720" HREF="whatever.html">SYSCAT.TRIGDEP</A>
 592 <BR><A NAME="ToC_721" HREF="whatever.html">SYSCAT.TRIGGERS</A>
 593 <BR><A NAME="ToC_722" HREF="whatever.html">SYSCAT.TYPEMAPPINGS</A>
 594 <BR><A NAME="ToC_723" HREF="whatever.html">SYSCAT.USEROPTIONS</A>
 595 <BR><A NAME="ToC_724" HREF="whatever.html">SYSCAT.VIEWDEP</A>
 596 <BR><A NAME="ToC_725" HREF="whatever.html">SYSCAT.VIEWS</A>
 597 <BR><A NAME="ToC_726" HREF="whatever.html">SYSCAT.WRAPOPTIONS</A>
 598 <BR><A NAME="ToC_727" HREF="whatever.html">SYSCAT.WRAPPERS</A>
 599 <BR><A NAME="ToC_728" HREF="whatever.html">SYSSTAT.COLDIST</A>
 600 <BR><A NAME="ToC_729" HREF="whatever.html">SYSSTAT.COLUMNS</A>
 601 <BR><A NAME="ToC_730" HREF="whatever.html">SYSSTAT.FUNCTIONS</A>
 602 <BR><A NAME="ToC_731" HREF="whatever.html">SYSSTAT.INDEXES</A>
 603 <BR><A NAME="ToC_732" HREF="whatever.html">SYSSTAT.TABLES</A>
 604 <P><B><A NAME="ToC_733" HREF="whatever.html">Appendix E. Catalog Views For Use With Structured Types</A></B><BR>
 605 <BR><A NAME="ToC_734" HREF="whatever.html">'Roadmap' to Catalog Views</A>
 606 <BR><A NAME="ToC_735" HREF="whatever.html">OBJCAT.INDEXES</A>
 607 <BR><A NAME="ToC_736" HREF="whatever.html">OBJCAT.INDEXEXPLOITRULES</A>
 608 <BR><A NAME="ToC_737" HREF="whatever.html">OBJCAT.INDEXEXTENSIONDEP</A>
 609 <BR><A NAME="ToC_738" HREF="whatever.html">OBJCAT.INDEXEXTENSIONMETHODS</A>
 610 <BR><A NAME="ToC_739" HREF="whatever.html">OBJCAT.INDEXEXTENSIONPARMS</A>
 611 <BR><A NAME="ToC_740" HREF="whatever.html">OBJCAT.INDEXEXTENSIONS</A>
 612 <BR><A NAME="ToC_741" HREF="whatever.html">OBJCAT.PREDICATESPECS</A>
 613 <BR><A NAME="ToC_742" HREF="whatever.html">OBJCAT.TRANSFORMS</A>
 614 <P><B><A NAME="ToC_743" HREF="whatever.html">Appendix F. Federated Systems</A></B><BR>
 615 <BR><A NAME="ToC_744" HREF="whatever.html">Server Types</A>
 616 <BR><A NAME="ToC_745" HREF="whatever.html">SQL Options for Federated Systems</A>
 617 <BR><A NAME="ToC_746" HREF="whatever.html">Column Options</A>
 618 <BR><A NAME="ToC_747" HREF="whatever.html">Function Mapping Options</A>
 619 <BR><A NAME="ToC_748" HREF="whatever.html">Server Options</A>
 620 <BR><A NAME="ToC_749" HREF="whatever.html">User Options</A>
 621 <BR><A NAME="ToC_750" HREF="whatever.html">Default Data Type Mappings</A>
 622 <BR><A NAME="ToC_751" HREF="whatever.html">Default Type Mappings between DB2 and DB2 Universal Database for OS/390 (and DB2 for MVS/ESA) Data Sources</A>
 623 <BR><A NAME="ToC_752" HREF="whatever.html">Default Type Mappings between DB2 and 2 Universal Database for AS/400 (and DB2 for OS/400) Data Sources</A>
 624 <BR><A NAME="ToC_753" HREF="whatever.html">Default Type Mappings between DB2 and Oracle Data Sources</A>
 625 <BR><A NAME="ToC_754" HREF="whatever.html">Default Type Mappings between DB2 and DB2 for VM and VSE (and SQL/DS) Data Sources</A>
 626 <BR><A NAME="ToC_755" HREF="whatever.html">Pass-Through Facility Processing</A>
 627 <BR><A NAME="ToC_756" HREF="whatever.html">SQL Processing in Pass-Through Sessions</A>
 628 <BR><A NAME="ToC_757" HREF="whatever.html">Considerations and Restrictions</A>
 629 <P><B><A NAME="ToC_760" HREF="whatever.html">Appendix G. Sample Database Tables</A></B><BR>
 630 <BR><A NAME="ToC_761" HREF="whatever.html">The Sample Database</A>
 631 <BR><A NAME="ToC_762" HREF="whatever.html">To Create the Sample Database</A>
 632 <BR><A NAME="ToC_763" HREF="whatever.html">To Erase the Sample Database</A>
 633 <BR><A NAME="ToC_764" HREF="whatever.html">CL_SCHED Table</A>
 634 <BR><A NAME="ToC_765" HREF="whatever.html">DEPARTMENT Table</A>
 635 <BR><A NAME="ToC_766" HREF="whatever.html">EMPLOYEE Table</A>
 636 <BR><A NAME="ToC_767" HREF="whatever.html">EMP_ACT Table</A>
 637 <BR><A NAME="ToC_768" HREF="whatever.html">EMP_PHOTO Table</A>
 638 <BR><A NAME="ToC_769" HREF="whatever.html">EMP_RESUME Table</A>
 639 <BR><A NAME="ToC_770" HREF="whatever.html">IN_TRAY Table</A>
 640 <BR><A NAME="ToC_771" HREF="whatever.html">ORG Table</A>
 641 <BR><A NAME="ToC_772" HREF="whatever.html">PROJECT Table</A>
 642 <BR><A NAME="ToC_773" HREF="whatever.html">SALES Table</A>
 643 <BR><A NAME="ToC_774" HREF="whatever.html">STAFF Table</A>
 644 <BR><A NAME="ToC_775" HREF="whatever.html">STAFFG Table</A>
 645 <BR><A NAME="ToC_776" HREF="whatever.html">Sample Files with BLOB and CLOB Data Type</A>
 646 <BR><A NAME="ToC_777" HREF="whatever.html">Quintana Photo</A>
 647 <BR><A NAME="ToC_778" HREF="whatever.html">Quintana Resume</A>
 648 <BR><A NAME="ToC_779" HREF="whatever.html">Nicholls Photo</A>
 649 <BR><A NAME="ToC_780" HREF="whatever.html">Nicholls Resume</A>
 650 <BR><A NAME="ToC_781" HREF="whatever.html">Adamson Photo</A>
 651 <BR><A NAME="ToC_782" HREF="whatever.html">Adamson Resume</A>
 652 <BR><A NAME="ToC_783" HREF="whatever.html">Walker Photo</A>
 653 <BR><A NAME="ToC_784" HREF="whatever.html">Walker Resume</A>
 654 <P><B><A NAME="ToC_785" HREF="whatever.html">Appendix H. Reserved Schema Names and Reserved Words</A></B><BR>
 655 <BR><A NAME="ToC_786" HREF="whatever.html">Reserved Schemas</A>
 656 <BR><A NAME="ToC_787" HREF="whatever.html">Reserved Words</A>
 657 <BR><A NAME="ToC_788" HREF="whatever.html">IBM SQL Reserved Words</A>
 658 <BR><A NAME="ToC_789" HREF="whatever.html">ISO/ANS SQL92 Reserved Words</A>
 659 <P><B><A NAME="ToC_790" HREF="whatever.html">Appendix I. Comparison of Isolation Levels</A></B><BR>
 660 <P><B><A NAME="ToC_791" HREF="whatever.html">Appendix J. Interaction of Triggers and Constraints</A></B><BR>
 661 <P><B><A NAME="ToC_792" HREF="whatever.html">Appendix K. Explain Tables and Definitions</A></B><BR>
 662 <BR><A NAME="ToC_793" HREF="whatever.html">EXPLAIN_ARGUMENT Table</A>
 663 <BR><A NAME="ToC_794" HREF="whatever.html">EXPLAIN_INSTANCE Table</A>
 664 <BR><A NAME="ToC_795" HREF="whatever.html">EXPLAIN_OBJECT Table</A>
 665 <BR><A NAME="ToC_796" HREF="whatever.html">EXPLAIN_OPERATOR Table</A>
 666 <BR><A NAME="ToC_797" HREF="whatever.html">EXPLAIN_PREDICATE Table</A>
 667 <BR><A NAME="ToC_798" HREF="whatever.html">EXPLAIN_STATEMENT Table</A>
 668 <BR><A NAME="ToC_799" HREF="whatever.html">EXPLAIN_STREAM Table</A>
 669 <BR><A NAME="ToC_800" HREF="whatever.html">ADVISE_INDEX Table</A>
 670 <BR><A NAME="ToC_801" HREF="whatever.html">ADVISE_WORKLOAD Table</A>
 671 <BR><A NAME="ToC_802" HREF="whatever.html">Table Definitions for Explain Tables</A>
 672 <BR><A NAME="ToC_803" HREF="whatever.html">EXPLAIN_ARGUMENT Table Definition</A>
 673 <BR><A NAME="ToC_804" HREF="whatever.html">EXPLAIN_INSTANCE Table Definition</A>
 674 <BR><A NAME="ToC_805" HREF="whatever.html">EXPLAIN_OBJECT Table Definition</A>
 675 <BR><A NAME="ToC_806" HREF="whatever.html">EXPLAIN_OPERATOR Table Definition</A>
 676 <BR><A NAME="ToC_807" HREF="whatever.html">EXPLAIN_PREDICATE Table Definition</A>
 677 <BR><A NAME="ToC_808" HREF="whatever.html">EXPLAIN_STATEMENT Table Definition</A>
 678 <BR><A NAME="ToC_809" HREF="whatever.html">EXPLAIN_STREAM Table Definition</A>
 679 <BR><A NAME="ToC_810" HREF="whatever.html">ADVISE_INDEX Table Definition</A>
 680 <BR><A NAME="ToC_811" HREF="whatever.html">ADVISE_WORKLOAD Table Definition</A>
 681 <P><B><A NAME="ToC_812" HREF="whatever.html">Appendix L. Explain Register Values</A></B><BR>
 682 <P><B><A NAME="ToC_813" HREF="whatever.html">Appendix M. Recursion Example: Bill of Materials</A></B><BR>
 683 <BR><A NAME="ToC_814" HREF="whatever.html">Example 1: Single Level Explosion</A>
 684 <BR><A NAME="ToC_815" HREF="whatever.html">Example 2: Summarized Explosion</A>
 685 <BR><A NAME="ToC_816" HREF="whatever.html">Example 3: Controlling Depth</A>
 686 <P><B><A NAME="ToC_817" HREF="whatever.html">Appendix N. Exception Tables</A></B><BR>
 687 <BR><A NAME="ToC_818" HREF="whatever.html">Rules for Creating an Exception Table</A>
 688 <BR><A NAME="ToC_819" HREF="whatever.html">Handling Rows in the Exception Tables</A>
 689 <BR><A NAME="ToC_820" HREF="whatever.html">Querying the Exception Tables</A>
 690 <P><B><A NAME="ToC_821" HREF="whatever.html">Appendix O. Japanese and Traditional-Chinese EUC Considerations</A></B><BR>
 691 <BR><A NAME="ToC_822" HREF="whatever.html">Language Elements</A>
 692 <BR><A NAME="ToC_823" HREF="whatever.html">Characters</A>
 693 <BR><A NAME="ToC_824" HREF="whatever.html">Tokens</A>
 694 <BR><A NAME="ToC_825" HREF="whatever.html">Identifiers</A>
 695 <BR><A NAME="ToC_827" HREF="whatever.html">Data Types</A>
 696 <BR><A NAME="ToC_830" HREF="whatever.html">Assignments and Comparisons</A>
 697 <BR><A NAME="ToC_833" HREF="whatever.html">Rules for Result Data Types</A>
 698 <BR><A NAME="ToC_834" HREF="whatever.html">Rules for String Conversions</A>
 699 <BR><A NAME="ToC_835" HREF="whatever.html">Constants</A>
 700 <BR><A NAME="ToC_837" HREF="whatever.html">Functions</A>
 701 <BR><A NAME="ToC_838" HREF="whatever.html">Expressions</A>
 702 <BR><A NAME="ToC_840" HREF="whatever.html">Predicates</A>
 703 <BR><A NAME="ToC_842" HREF="whatever.html">Functions</A>
 704 <BR><A NAME="ToC_843" HREF="whatever.html">LENGTH</A>
 705 <BR><A NAME="ToC_844" HREF="whatever.html">SUBSTR</A>
 706 <BR><A NAME="ToC_845" HREF="whatever.html">TRANSLATE</A>
 707 <BR><A NAME="ToC_846" HREF="whatever.html">VARGRAPHIC</A>
 708 <BR><A NAME="ToC_847" HREF="whatever.html">Statements</A>
 709 <BR><A NAME="ToC_848" HREF="whatever.html">CONNECT</A>
 710 <BR><A NAME="ToC_849" HREF="whatever.html">PREPARE</A>
 711 <P><B><A NAME="ToC_850" HREF="whatever.html">Appendix P. BNF Specifications for DATALINKs</A></B><BR>
 712 <P><B><A NAME="ToC_851" HREF="whatever.html">Appendix Q. Using the DB2 Library</A></B><BR>
 713 <BR><A NAME="ToC_852" HREF="whatever.html">DB2 PDF Files and Printed Books</A>
 714 <BR><A NAME="ToC_853" HREF="whatever.html">DB2 Information</A>
 715 <BR><A NAME="ToC_854" HREF="whatever.html">Printing the PDF Books</A>
 716 <BR><A NAME="ToC_855" HREF="whatever.html">Ordering the Printed Books</A>
 717 <BR><A NAME="ToC_856" HREF="whatever.html">DB2 Online Documentation</A>
 718 <BR><A NAME="ToC_857" HREF="whatever.html">Accessing Online Help</A>
 719 <BR><A NAME="ToC_858" HREF="whatever.html">Viewing Information Online</A>
 720 <BR><A NAME="ToC_861" HREF="whatever.html">Using DB2 Wizards</A>
 721 <BR><A NAME="ToC_862" HREF="whatever.html">Setting Up a Document Server</A>
 722 <BR><A NAME="ToC_863" HREF="whatever.html">Searching Information Online</A>
 723 <P><B><A NAME="ToC_864" HREF="whatever.html">Appendix R. Notices</A></B><BR>
 724 <BR><A NAME="ToC_865" HREF="whatever.html">Trademarks</A>
 725 <P><B><A NAME="ToC_866" HREF="whatever.html">Index</A></B><BR>
 726 <P><B><A NAME="ToC_867" HREF="whatever.html">Contacting IBM</A></B><BR>
 727 <BR><A NAME="ToC_868" HREF="whatever.html">Product Information</A>
 728
 729 <A NAME="Bot_Of_Page"></A>
 730
 731           </tr>
 732           <td>x</td>
 733           <td>x</td>
 734           </tr>
 735         </table>
 736           </td>
 737         </tr>
 738       </table>
 739     </td>
 740   </tr>
 741 </table>
 742 </body>
 743 </html>
 744