| <html> |
| <body> |
| <table border> |
| <tr valign="top"> |
| <td>x</td> |
| <td> |
| <!-- this font, and the malformed table below trigger the bug --> |
| <font face="Arial, sans-serif" size="-1"> |
| <table border> |
| <tr> |
| <td width="10"> </td> |
| <td width="443" valign="top" align="left"> |
| <tr> |
| <td>Search again...</td> |
| </tr> |
| <table> |
| <tr> |
| This text node only exists once in the original document! |
| If it were a large collection of inlines, the page would |
| hang forever. |
| |
| <A NAME="Top_Of_Page"></A> |
| <H2><A NAME="ToC">Table of Contents</A></H2> |
| <P><B><A NAME="ToC_1" HREF="whatever.html">Introduction</A></B><BR> |
| <BR><A NAME="ToC_2" HREF="whatever.html">Who Should Use This Book</A> |
| <BR><A NAME="ToC_3" HREF="whatever.html">How To Use This Book</A> |
| <BR><A NAME="ToC_4" HREF="whatever.html">How This Book is Structured</A> |
| <BR><A NAME="ToC_5" HREF="whatever.html">How to Read the Syntax Diagrams</A> |
| <BR><A NAME="ToC_6" HREF="whatever.html">Conventions Used in This Manual</A> |
| <BR><A NAME="ToC_7" HREF="whatever.html">Error Conditions</A> |
| <BR><A NAME="ToC_8" HREF="whatever.html">Highlighting Conventions</A> |
| <BR><A NAME="ToC_9" HREF="whatever.html">Related Documentation for This Book</A> |
| <P><B><A NAME="ToC_10" HREF="whatever.html">Concepts</A></B><BR> |
| <BR><A NAME="ToC_11" HREF="whatever.html">Relational Database</A> |
| <BR><A NAME="ToC_12" HREF="whatever.html">Structured Query Language (SQL)</A> |
| <BR><A NAME="ToC_13" HREF="whatever.html">Embedded SQL</A> |
| <BR><A NAME="ToC_14" HREF="whatever.html">Static SQL</A> |
| <BR><A NAME="ToC_15" HREF="whatever.html">Dynamic SQL</A> |
| <BR><A NAME="ToC_16" HREF="whatever.html">DB2 Call Level Interface (CLI) & Open Database Connectivity (ODBC)</A> |
| <BR><A NAME="ToC_17" HREF="whatever.html">Java Database Connectivity (JDBC) and Embedded SQL for Java (SQLJ) Programs</A> |
| <BR><A NAME="ToC_18" HREF="whatever.html">Interactive SQL</A> |
| <BR><A NAME="ToC_19" HREF="whatever.html">Schemas</A> |
| <BR><A NAME="ToC_20" HREF="whatever.html">Controlling Use of Schemas</A> |
| <BR><A NAME="ToC_21" HREF="whatever.html">Tables</A> |
| <BR><A NAME="ToC_22" HREF="whatever.html">Views</A> |
| <BR><A NAME="ToC_23" HREF="whatever.html">Aliases</A> |
| <BR><A NAME="ToC_24" HREF="whatever.html">Indexes</A> |
| <BR><A NAME="ToC_25" HREF="whatever.html">Keys</A> |
| <BR><A NAME="ToC_26" HREF="whatever.html">Unique Keys</A> |
| <BR><A NAME="ToC_27" HREF="whatever.html">Primary Keys</A> |
| <BR><A NAME="ToC_28" HREF="whatever.html">Foreign Keys</A> |
| <BR><A NAME="ToC_29" HREF="whatever.html">Partitioning Keys</A> |
| <BR><A NAME="ToC_30" HREF="whatever.html">Constraints</A> |
| <BR><A NAME="ToC_31" HREF="whatever.html">Unique Constraints</A> |
| <BR><A NAME="ToC_32" HREF="whatever.html">Referential Constraints</A> |
| <BR><A NAME="ToC_36" HREF="whatever.html">Table Check Constraints</A> |
| <BR><A NAME="ToC_37" HREF="whatever.html">Triggers</A> |
| <BR><A NAME="ToC_38" HREF="whatever.html">Event Monitors</A> |
| <BR><A NAME="ToC_39" HREF="whatever.html">Queries</A> |
| <BR><A NAME="ToC_40" HREF="whatever.html">Table Expressions</A> |
| <BR><A NAME="ToC_41" HREF="whatever.html">Common Table Expressions</A> |
| <BR><A NAME="ToC_42" HREF="whatever.html">Packages</A> |
| <BR><A NAME="ToC_43" HREF="whatever.html">Catalog Views</A> |
| <BR><A NAME="ToC_44" HREF="whatever.html">Application Processes, Concurrency, and Recovery</A> |
| <BR><A NAME="ToC_45" HREF="whatever.html">Isolation Level</A> |
| <BR><A NAME="ToC_46" HREF="whatever.html">Repeatable Read (RR)</A> |
| <BR><A NAME="ToC_47" HREF="whatever.html">Read Stability (RS)</A> |
| <BR><A NAME="ToC_48" HREF="whatever.html">Cursor Stability (CS)</A> |
| <BR><A NAME="ToC_49" HREF="whatever.html">Uncommitted Read (UR)</A> |
| <BR><A NAME="ToC_50" HREF="whatever.html">Comparison of Isolation Levels</A> |
| <BR><A NAME="ToC_51" HREF="whatever.html">Distributed Relational Database</A> |
| <BR><A NAME="ToC_52" HREF="whatever.html">Application Servers</A> |
| <BR><A NAME="ToC_53" HREF="whatever.html">CONNECT (Type 1) and CONNECT (Type 2)</A> |
| <BR><A NAME="ToC_54" HREF="whatever.html">Remote Unit of Work</A> |
| <BR><A NAME="ToC_56" HREF="whatever.html">Application-Directed Distributed Unit of Work</A> |
| <BR><A NAME="ToC_64" HREF="whatever.html">Data Representation Considerations</A> |
| <BR><A NAME="ToC_65" HREF="whatever.html">DB2 Federated Systems</A> |
| <BR><A NAME="ToC_66" HREF="whatever.html">The Federated Server, Federated Database, and Data Sources</A> |
| <BR><A NAME="ToC_67" HREF="whatever.html">Tasks to Perform in a DB2 Federated System</A> |
| <BR><A NAME="ToC_68" HREF="whatever.html">Wrappers and Wrapper Modules</A> |
| <BR><A NAME="ToC_69" HREF="whatever.html">Server Definitions and Server Options</A> |
| <BR><A NAME="ToC_73" HREF="whatever.html">User Mappings and User Options</A> |
| <BR><A NAME="ToC_74" HREF="whatever.html">Data Type Mappings</A> |
| <BR><A NAME="ToC_75" HREF="whatever.html">Function Mappings, Function Templates, and Function Mapping Options</A> |
| <BR><A NAME="ToC_76" HREF="whatever.html">Nicknames and Column Options</A> |
| <BR><A NAME="ToC_77" HREF="whatever.html">Index Specifications</A> |
| <BR><A NAME="ToC_78" HREF="whatever.html">Distributed Requests</A> |
| <BR><A NAME="ToC_81" HREF="whatever.html">Compensation</A> |
| <BR><A NAME="ToC_82" HREF="whatever.html">Pass-Through</A> |
| <BR><A NAME="ToC_83" HREF="whatever.html">Character Conversion</A> |
| <BR><A NAME="ToC_84" HREF="whatever.html">Character Sets and Code Pages</A> |
| <BR><A NAME="ToC_85" HREF="whatever.html">Code Page Attributes</A> |
| <BR><A NAME="ToC_87" HREF="whatever.html">Authorization and Privileges</A> |
| <BR><A NAME="ToC_88" HREF="whatever.html">Table Spaces and Other Storage Structures</A> |
| <BR><A NAME="ToC_89" HREF="whatever.html">Data Partitioning Across Multiple Partitions</A> |
| <BR><A NAME="ToC_90" HREF="whatever.html">Partitioning Maps</A> |
| <BR><A NAME="ToC_91" HREF="whatever.html">Table Collocation</A> |
| <P><B><A NAME="ToC_92" HREF="whatever.html">Language Elements</A></B><BR> |
| <BR><A NAME="ToC_93" HREF="whatever.html">Characters</A> |
| <BR><A NAME="ToC_94" HREF="whatever.html">MBCS Considerations</A> |
| <BR><A NAME="ToC_95" HREF="whatever.html">Tokens</A> |
| <BR><A NAME="ToC_96" HREF="whatever.html">MBCS Considerations</A> |
| <BR><A NAME="ToC_97" HREF="whatever.html">Identifiers</A> |
| <BR><A NAME="ToC_98" HREF="whatever.html">SQL Identifiers</A> |
| <BR><A NAME="ToC_99" HREF="whatever.html">Host Identifiers</A> |
| <BR><A NAME="ToC_100" HREF="whatever.html">Naming Conventions and Implicit Object Name Qualifications</A> |
| <BR><A NAME="ToC_101" HREF="whatever.html">Aliases</A> |
| <BR><A NAME="ToC_102" HREF="whatever.html">Authorization IDs and authorization-names</A> |
| <BR><A NAME="ToC_103" HREF="whatever.html">Dynamic SQL Characteristics at run-time</A> |
| <BR><A NAME="ToC_104" HREF="whatever.html">Authorization IDs and Statement Preparation</A> |
| <BR><A NAME="ToC_105" HREF="whatever.html">Data Types</A> |
| <BR><A NAME="ToC_106" HREF="whatever.html">Nulls</A> |
| <BR><A NAME="ToC_107" HREF="whatever.html">Large Objects (LOBs)</A> |
| <BR><A NAME="ToC_112" HREF="whatever.html">Character Strings</A> |
| <BR><A NAME="ToC_119" HREF="whatever.html">Graphic Strings</A> |
| <BR><A NAME="ToC_123" HREF="whatever.html">Binary String</A> |
| <BR><A NAME="ToC_124" HREF="whatever.html">Numbers</A> |
| <BR><A NAME="ToC_131" HREF="whatever.html">Datetime Values</A> |
| <BR><A NAME="ToC_140" HREF="whatever.html">DATALINK Values</A> |
| <BR><A NAME="ToC_141" HREF="whatever.html">User Defined Types</A> |
| <BR><A NAME="ToC_145" HREF="whatever.html">Promotion of Data Types</A> |
| <BR><A NAME="ToC_146" HREF="whatever.html">Casting Between Data Types</A> |
| <BR><A NAME="ToC_147" HREF="whatever.html">Assignments and Comparisons</A> |
| <BR><A NAME="ToC_148" HREF="whatever.html">Numeric Assignments</A> |
| <BR><A NAME="ToC_154" HREF="whatever.html">String Assignments</A> |
| <BR><A NAME="ToC_160" HREF="whatever.html">Datetime Assignments</A> |
| <BR><A NAME="ToC_161" HREF="whatever.html">DATALINK Assignments</A> |
| <BR><A NAME="ToC_162" HREF="whatever.html">User-defined Type Assignments</A> |
| <BR><A NAME="ToC_163" HREF="whatever.html">Reference Type Assignments</A> |
| <BR><A NAME="ToC_164" HREF="whatever.html">Numeric Comparisons</A> |
| <BR><A NAME="ToC_165" HREF="whatever.html">String Comparisons</A> |
| <BR><A NAME="ToC_169" HREF="whatever.html">Datetime Comparisons</A> |
| <BR><A NAME="ToC_170" HREF="whatever.html">User-defined Type Comparisons</A> |
| <BR><A NAME="ToC_171" HREF="whatever.html">Reference Type Comparisons</A> |
| <BR><A NAME="ToC_172" HREF="whatever.html">Rules for Result Data Types</A> |
| <BR><A NAME="ToC_173" HREF="whatever.html">Character Strings</A> |
| <BR><A NAME="ToC_174" HREF="whatever.html">Graphic Strings</A> |
| <BR><A NAME="ToC_175" HREF="whatever.html">Binary Large Object (BLOB)</A> |
| <BR><A NAME="ToC_176" HREF="whatever.html">Numeric</A> |
| <BR><A NAME="ToC_177" HREF="whatever.html">DATE</A> |
| <BR><A NAME="ToC_178" HREF="whatever.html">TIME</A> |
| <BR><A NAME="ToC_179" HREF="whatever.html">TIMESTAMP</A> |
| <BR><A NAME="ToC_180" HREF="whatever.html">DATALINK</A> |
| <BR><A NAME="ToC_181" HREF="whatever.html">User-defined Types</A> |
| <BR><A NAME="ToC_185" HREF="whatever.html">Nullable Attribute of Result</A> |
| <BR><A NAME="ToC_186" HREF="whatever.html">Rules for String Conversions</A> |
| <BR><A NAME="ToC_187" HREF="whatever.html">Partition Compatibility</A> |
| <BR><A NAME="ToC_188" HREF="whatever.html">Constants</A> |
| <BR><A NAME="ToC_189" HREF="whatever.html">Integer Constants</A> |
| <BR><A NAME="ToC_190" HREF="whatever.html">Floating-Point Constants</A> |
| <BR><A NAME="ToC_191" HREF="whatever.html">Decimal Constants</A> |
| <BR><A NAME="ToC_192" HREF="whatever.html">Character String Constants</A> |
| <BR><A NAME="ToC_194" HREF="whatever.html">Hexadecimal Constants</A> |
| <BR><A NAME="ToC_195" HREF="whatever.html">Graphic String Constants</A> |
| <BR><A NAME="ToC_197" HREF="whatever.html">Using Constants with User-defined Types</A> |
| <BR><A NAME="ToC_198" HREF="whatever.html">Special Registers</A> |
| <BR><A NAME="ToC_199" HREF="whatever.html">CURRENT DATE</A> |
| <BR><A NAME="ToC_201" HREF="whatever.html">CURRENT DEFAULT TRANSFORM GROUP</A> |
| <BR><A NAME="ToC_203" HREF="whatever.html">CURRENT DEGREE</A> |
| <BR><A NAME="ToC_204" HREF="whatever.html">CURRENT EXPLAIN MODE</A> |
| <BR><A NAME="ToC_205" HREF="whatever.html">CURRENT EXPLAIN SNAPSHOT</A> |
| <BR><A NAME="ToC_207" HREF="whatever.html">CURRENT NODE</A> |
| <BR><A NAME="ToC_209" HREF="whatever.html">CURRENT PATH</A> |
| <BR><A NAME="ToC_211" HREF="whatever.html">CURRENT QUERY OPTIMIZATION</A> |
| <BR><A NAME="ToC_213" HREF="whatever.html">CURRENT REFRESH AGE</A> |
| <BR><A NAME="ToC_214" HREF="whatever.html">CURRENT SCHEMA</A> |
| <BR><A NAME="ToC_216" HREF="whatever.html">CURRENT SERVER</A> |
| <BR><A NAME="ToC_218" HREF="whatever.html">CURRENT TIME</A> |
| <BR><A NAME="ToC_220" HREF="whatever.html">CURRENT TIMESTAMP</A> |
| <BR><A NAME="ToC_222" HREF="whatever.html">CURRENT TIMEZONE</A> |
| <BR><A NAME="ToC_224" HREF="whatever.html">USER</A> |
| <BR><A NAME="ToC_226" HREF="whatever.html">Column Names</A> |
| <BR><A NAME="ToC_227" HREF="whatever.html">Qualified Column Names</A> |
| <BR><A NAME="ToC_228" HREF="whatever.html">Correlation Names</A> |
| <BR><A NAME="ToC_229" HREF="whatever.html">Column Name Qualifiers to Avoid Ambiguity</A> |
| <BR><A NAME="ToC_232" HREF="whatever.html">Column Name Qualifiers in Correlated References</A> |
| <BR><A NAME="ToC_233" HREF="whatever.html">References to Host Variables</A> |
| <BR><A NAME="ToC_234" HREF="whatever.html">Host Variables in Dynamic SQL</A> |
| <BR><A NAME="ToC_236" HREF="whatever.html">References to BLOB, CLOB, and DBCLOB Host Variables</A> |
| <BR><A NAME="ToC_237" HREF="whatever.html">References to Locator Variables</A> |
| <BR><A NAME="ToC_238" HREF="whatever.html">References to BLOB, CLOB, and DBCLOB File Reference Variables</A> |
| <BR><A NAME="ToC_241" HREF="whatever.html">References to Structured Type Host Variables</A> |
| <BR><A NAME="ToC_243" HREF="whatever.html">Functions</A> |
| <BR><A NAME="ToC_244" HREF="whatever.html">External, SQL and Sourced User-Defined Functions</A> |
| <BR><A NAME="ToC_245" HREF="whatever.html">Scalar, Column, Row and Table User-Defined Functions</A> |
| <BR><A NAME="ToC_246" HREF="whatever.html">Function signatures</A> |
| <BR><A NAME="ToC_247" HREF="whatever.html">SQL Path</A> |
| <BR><A NAME="ToC_248" HREF="whatever.html">Function Resolution</A> |
| <BR><A NAME="ToC_252" HREF="whatever.html">Function Invocation</A> |
| <BR><A NAME="ToC_253" HREF="whatever.html">Methods</A> |
| <BR><A NAME="ToC_254" HREF="whatever.html">External and SQL User-Defined Methods</A> |
| <BR><A NAME="ToC_255" HREF="whatever.html">Method Signatures</A> |
| <BR><A NAME="ToC_256" HREF="whatever.html">Method Invocation</A> |
| <BR><A NAME="ToC_257" HREF="whatever.html">Method Resolution</A> |
| <BR><A NAME="ToC_258" HREF="whatever.html">Method of Choosing the Best Fit</A> |
| <BR><A NAME="ToC_259" HREF="whatever.html">Example of Method Resolution</A> |
| <BR><A NAME="ToC_260" HREF="whatever.html">Method Invocation</A> |
| <BR><A NAME="ToC_261" HREF="whatever.html">Conservative Binding Semantics</A> |
| <BR><A NAME="ToC_262" HREF="whatever.html">Expressions</A> |
| <BR><A NAME="ToC_263" HREF="whatever.html">Without Operators</A> |
| <BR><A NAME="ToC_264" HREF="whatever.html">With the Concatenation Operator</A> |
| <BR><A NAME="ToC_266" HREF="whatever.html">With Arithmetic Operators</A> |
| <BR><A NAME="ToC_268" HREF="whatever.html">Two Integer Operands</A> |
| <BR><A NAME="ToC_269" HREF="whatever.html">Integer and Decimal Operands</A> |
| <BR><A NAME="ToC_270" HREF="whatever.html">Two Decimal Operands</A> |
| <BR><A NAME="ToC_271" HREF="whatever.html">Decimal Arithmetic in SQL</A> |
| <BR><A NAME="ToC_275" HREF="whatever.html">Floating-Point Operands</A> |
| <BR><A NAME="ToC_276" HREF="whatever.html">User-defined Types as Operands</A> |
| <BR><A NAME="ToC_277" HREF="whatever.html">Scalar Fullselect</A> |
| <BR><A NAME="ToC_278" HREF="whatever.html">Datetime Operations and Durations</A> |
| <BR><A NAME="ToC_283" HREF="whatever.html">Datetime Arithmetic in SQL</A> |
| <BR><A NAME="ToC_293" HREF="whatever.html">Precedence of Operations</A> |
| <BR><A NAME="ToC_294" HREF="whatever.html">CASE Expressions</A> |
| <BR><A NAME="ToC_296" HREF="whatever.html">CAST Specifications</A> |
| <BR><A NAME="ToC_298" HREF="whatever.html">Dereference Operations</A> |
| <BR><A NAME="ToC_300" HREF="whatever.html">OLAP Functions</A> |
| <BR><A NAME="ToC_302" HREF="whatever.html">Method Invocation</A> |
| <BR><A NAME="ToC_304" HREF="whatever.html">Subtype Treatment</A> |
| <BR><A NAME="ToC_306" HREF="whatever.html">Predicates</A> |
| <BR><A NAME="ToC_307" HREF="whatever.html">Basic Predicate</A> |
| <BR><A NAME="ToC_308" HREF="whatever.html">Quantified Predicate</A> |
| <BR><A NAME="ToC_309" HREF="whatever.html">BETWEEN Predicate</A> |
| <BR><A NAME="ToC_310" HREF="whatever.html">EXISTS Predicate</A> |
| <BR><A NAME="ToC_311" HREF="whatever.html">IN Predicate</A> |
| <BR><A NAME="ToC_312" HREF="whatever.html">LIKE Predicate</A> |
| <BR><A NAME="ToC_314" HREF="whatever.html">NULL Predicate</A> |
| <BR><A NAME="ToC_315" HREF="whatever.html">TYPE Predicate</A> |
| <BR><A NAME="ToC_316" HREF="whatever.html">Search Conditions</A> |
| <BR><A NAME="ToC_317" HREF="whatever.html">Examples</A> |
| <P><B><A NAME="ToC_318" HREF="whatever.html">Functions</A></B><BR> |
| <BR><A NAME="ToC_319" HREF="whatever.html">Column Functions</A> |
| <BR><A NAME="ToC_320" HREF="whatever.html">AVG</A> |
| <BR><A NAME="ToC_321" HREF="whatever.html">CORRELATION</A> |
| <BR><A NAME="ToC_322" HREF="whatever.html">COUNT</A> |
| <BR><A NAME="ToC_323" HREF="whatever.html">COUNT_BIG</A> |
| <BR><A NAME="ToC_324" HREF="whatever.html">COVARIANCE</A> |
| <BR><A NAME="ToC_325" HREF="whatever.html">GROUPING</A> |
| <BR><A NAME="ToC_326" HREF="whatever.html">MAX</A> |
| <BR><A NAME="ToC_327" HREF="whatever.html">MIN</A> |
| <BR><A NAME="ToC_328" HREF="whatever.html">REGRESSION Functions</A> |
| <BR><A NAME="ToC_329" HREF="whatever.html">STDDEV</A> |
| <BR><A NAME="ToC_330" HREF="whatever.html">SUM</A> |
| <BR><A NAME="ToC_331" HREF="whatever.html">VARIANCE</A> |
| <BR><A NAME="ToC_332" HREF="whatever.html">Scalar Functions</A> |
| <BR><A NAME="ToC_333" HREF="whatever.html">ABS or ABSVAL</A> |
| <BR><A NAME="ToC_334" HREF="whatever.html">ACOS</A> |
| <BR><A NAME="ToC_335" HREF="whatever.html">ASCII</A> |
| <BR><A NAME="ToC_336" HREF="whatever.html">ASIN</A> |
| <BR><A NAME="ToC_337" HREF="whatever.html">ATAN</A> |
| <BR><A NAME="ToC_338" HREF="whatever.html">ATAN2</A> |
| <BR><A NAME="ToC_339" HREF="whatever.html">BIGINT</A> |
| <BR><A NAME="ToC_340" HREF="whatever.html">BLOB</A> |
| <BR><A NAME="ToC_341" HREF="whatever.html">CEILING or CEIL</A> |
| <BR><A NAME="ToC_342" HREF="whatever.html">CHAR</A> |
| <BR><A NAME="ToC_343" HREF="whatever.html">CHR</A> |
| <BR><A NAME="ToC_344" HREF="whatever.html">CLOB</A> |
| <BR><A NAME="ToC_345" HREF="whatever.html">COALESCE</A> |
| <BR><A NAME="ToC_346" HREF="whatever.html">CONCAT</A> |
| <BR><A NAME="ToC_347" HREF="whatever.html">COS</A> |
| <BR><A NAME="ToC_348" HREF="whatever.html">COT</A> |
| <BR><A NAME="ToC_349" HREF="whatever.html">DATE</A> |
| <BR><A NAME="ToC_350" HREF="whatever.html">DAY</A> |
| <BR><A NAME="ToC_351" HREF="whatever.html">DAYNAME</A> |
| <BR><A NAME="ToC_352" HREF="whatever.html">DAYOFWEEK</A> |
| <BR><A NAME="ToC_353" HREF="whatever.html">DAYOFWEEK_ISO</A> |
| <BR><A NAME="ToC_354" HREF="whatever.html">DAYOFYEAR</A> |
| <BR><A NAME="ToC_355" HREF="whatever.html">DAYS</A> |
| <BR><A NAME="ToC_356" HREF="whatever.html">DBCLOB</A> |
| <BR><A NAME="ToC_357" HREF="whatever.html">DECIMAL</A> |
| <BR><A NAME="ToC_358" HREF="whatever.html">DEGREES</A> |
| <BR><A NAME="ToC_359" HREF="whatever.html">DEREF</A> |
| <BR><A NAME="ToC_360" HREF="whatever.html">DIFFERENCE</A> |
| <BR><A NAME="ToC_361" HREF="whatever.html">DIGITS</A> |
| <BR><A NAME="ToC_362" HREF="whatever.html">DLCOMMENT</A> |
| <BR><A NAME="ToC_363" HREF="whatever.html">DLLINKTYPE</A> |
| <BR><A NAME="ToC_364" HREF="whatever.html">DLURLCOMPLETE</A> |
| <BR><A NAME="ToC_365" HREF="whatever.html">DLURLPATH</A> |
| <BR><A NAME="ToC_366" HREF="whatever.html">DLURLPATHONLY</A> |
| <BR><A NAME="ToC_367" HREF="whatever.html">DLURLSCHEME</A> |
| <BR><A NAME="ToC_368" HREF="whatever.html">DLURLSERVER</A> |
| <BR><A NAME="ToC_369" HREF="whatever.html">DLVALUE</A> |
| <BR><A NAME="ToC_370" HREF="whatever.html">DOUBLE</A> |
| <BR><A NAME="ToC_371" HREF="whatever.html">EVENT_MON_STATE</A> |
| <BR><A NAME="ToC_372" HREF="whatever.html">EXP</A> |
| <BR><A NAME="ToC_373" HREF="whatever.html">FLOAT</A> |
| <BR><A NAME="ToC_374" HREF="whatever.html">FLOOR</A> |
| <BR><A NAME="ToC_375" HREF="whatever.html">GENERATE_UNIQUE</A> |
| <BR><A NAME="ToC_376" HREF="whatever.html">GRAPHIC</A> |
| <BR><A NAME="ToC_377" HREF="whatever.html">HEX</A> |
| <BR><A NAME="ToC_378" HREF="whatever.html">HOUR</A> |
| <BR><A NAME="ToC_379" HREF="whatever.html">INSERT</A> |
| <BR><A NAME="ToC_380" HREF="whatever.html">INTEGER</A> |
| <BR><A NAME="ToC_381" HREF="whatever.html">JULIAN_DAY</A> |
| <BR><A NAME="ToC_382" HREF="whatever.html">LCASE or LOWER</A> |
| <BR><A NAME="ToC_383" HREF="whatever.html">LCASE (SYSFUN schema)</A> |
| <BR><A NAME="ToC_384" HREF="whatever.html">LEFT</A> |
| <BR><A NAME="ToC_385" HREF="whatever.html">LENGTH</A> |
| <BR><A NAME="ToC_386" HREF="whatever.html">LN</A> |
| <BR><A NAME="ToC_387" HREF="whatever.html">LOCATE</A> |
| <BR><A NAME="ToC_388" HREF="whatever.html">LOG</A> |
| <BR><A NAME="ToC_389" HREF="whatever.html">LOG10</A> |
| <BR><A NAME="ToC_390" HREF="whatever.html">LONG_VARCHAR</A> |
| <BR><A NAME="ToC_391" HREF="whatever.html">LONG_VARGRAPHIC</A> |
| <BR><A NAME="ToC_392" HREF="whatever.html">LTRIM</A> |
| <BR><A NAME="ToC_393" HREF="whatever.html">LTRIM (SYSFUN schema)</A> |
| <BR><A NAME="ToC_394" HREF="whatever.html">MICROSECOND</A> |
| <BR><A NAME="ToC_395" HREF="whatever.html">MIDNIGHT_SECONDS</A> |
| <BR><A NAME="ToC_396" HREF="whatever.html">MINUTE</A> |
| <BR><A NAME="ToC_397" HREF="whatever.html">MOD</A> |
| <BR><A NAME="ToC_398" HREF="whatever.html">MONTH</A> |
| <BR><A NAME="ToC_399" HREF="whatever.html">MONTHNAME</A> |
| <BR><A NAME="ToC_400" HREF="whatever.html">NODENUMBER</A> |
| <BR><A NAME="ToC_401" HREF="whatever.html">NULLIF</A> |
| <BR><A NAME="ToC_402" HREF="whatever.html">PARTITION</A> |
| <BR><A NAME="ToC_403" HREF="whatever.html">POSSTR</A> |
| <BR><A NAME="ToC_404" HREF="whatever.html">POWER</A> |
| <BR><A NAME="ToC_405" HREF="whatever.html">QUARTER</A> |
| <BR><A NAME="ToC_406" HREF="whatever.html">RADIANS</A> |
| <BR><A NAME="ToC_407" HREF="whatever.html">RAISE_ERROR</A> |
| <BR><A NAME="ToC_408" HREF="whatever.html">RAND</A> |
| <BR><A NAME="ToC_409" HREF="whatever.html">REAL</A> |
| <BR><A NAME="ToC_410" HREF="whatever.html">REPEAT</A> |
| <BR><A NAME="ToC_411" HREF="whatever.html">REPLACE</A> |
| <BR><A NAME="ToC_412" HREF="whatever.html">RIGHT</A> |
| <BR><A NAME="ToC_413" HREF="whatever.html">ROUND</A> |
| <BR><A NAME="ToC_414" HREF="whatever.html">RTRIM</A> |
| <BR><A NAME="ToC_415" HREF="whatever.html">RTRIM (SYSFUN schema)</A> |
| <BR><A NAME="ToC_416" HREF="whatever.html">SECOND</A> |
| <BR><A NAME="ToC_417" HREF="whatever.html">SIGN</A> |
| <BR><A NAME="ToC_418" HREF="whatever.html">SIN</A> |
| <BR><A NAME="ToC_419" HREF="whatever.html">SMALLINT</A> |
| <BR><A NAME="ToC_420" HREF="whatever.html">SOUNDEX</A> |
| <BR><A NAME="ToC_421" HREF="whatever.html">SPACE</A> |
| <BR><A NAME="ToC_422" HREF="whatever.html">SQRT</A> |
| <BR><A NAME="ToC_423" HREF="whatever.html">SUBSTR</A> |
| <BR><A NAME="ToC_424" HREF="whatever.html">TABLE_NAME</A> |
| <BR><A NAME="ToC_425" HREF="whatever.html">TABLE_SCHEMA</A> |
| <BR><A NAME="ToC_426" HREF="whatever.html">TAN</A> |
| <BR><A NAME="ToC_427" HREF="whatever.html">TIME</A> |
| <BR><A NAME="ToC_428" HREF="whatever.html">TIMESTAMP</A> |
| <BR><A NAME="ToC_429" HREF="whatever.html">TIMESTAMP_ISO</A> |
| <BR><A NAME="ToC_430" HREF="whatever.html">TIMESTAMPDIFF</A> |
| <BR><A NAME="ToC_431" HREF="whatever.html">TRANSLATE</A> |
| <BR><A NAME="ToC_432" HREF="whatever.html">TRUNCATE or TRUNC</A> |
| <BR><A NAME="ToC_433" HREF="whatever.html">TYPE_ID</A> |
| <BR><A NAME="ToC_434" HREF="whatever.html">TYPE_NAME</A> |
| <BR><A NAME="ToC_435" HREF="whatever.html">TYPE_SCHEMA</A> |
| <BR><A NAME="ToC_436" HREF="whatever.html">UCASE or UPPER</A> |
| <BR><A NAME="ToC_437" HREF="whatever.html">VALUE</A> |
| <BR><A NAME="ToC_438" HREF="whatever.html">VARCHAR</A> |
| <BR><A NAME="ToC_439" HREF="whatever.html">VARGRAPHIC</A> |
| <BR><A NAME="ToC_440" HREF="whatever.html">WEEK</A> |
| <BR><A NAME="ToC_441" HREF="whatever.html">WEEK_ISO</A> |
| <BR><A NAME="ToC_442" HREF="whatever.html">YEAR</A> |
| <BR><A NAME="ToC_443" HREF="whatever.html">Table Functions</A> |
| <BR><A NAME="ToC_444" HREF="whatever.html">SQLCACHE_SNAPSHOT</A> |
| <BR><A NAME="ToC_445" HREF="whatever.html">User-Defined Functions</A> |
| <P><B><A NAME="ToC_446" HREF="whatever.html">Queries</A></B><BR> |
| <BR><A NAME="ToC_447" HREF="whatever.html">subselect</A> |
| <BR><A NAME="ToC_448" HREF="whatever.html">select-clause</A> |
| <BR><A NAME="ToC_457" HREF="whatever.html">from-clause</A> |
| <BR><A NAME="ToC_458" HREF="whatever.html">table-reference</A> |
| <BR><A NAME="ToC_461" HREF="whatever.html">joined-table</A> |
| <BR><A NAME="ToC_463" HREF="whatever.html">where-clause</A> |
| <BR><A NAME="ToC_464" HREF="whatever.html">group-by-clause</A> |
| <BR><A NAME="ToC_468" HREF="whatever.html">having-clause</A> |
| <BR><A NAME="ToC_469" HREF="whatever.html">Examples of subselects</A> |
| <BR><A NAME="ToC_470" HREF="whatever.html">Examples of Joins</A> |
| <BR><A NAME="ToC_471" HREF="whatever.html">Examples of Grouping Sets, Cube, and Rollup</A> |
| <BR><A NAME="ToC_472" HREF="whatever.html">fullselect</A> |
| <BR><A NAME="ToC_473" HREF="whatever.html">Examples of a fullselect</A> |
| <BR><A NAME="ToC_474" HREF="whatever.html">select-statement</A> |
| <BR><A NAME="ToC_475" HREF="whatever.html">common-table-expression</A> |
| <BR><A NAME="ToC_476" HREF="whatever.html">order-by-clause</A> |
| <BR><A NAME="ToC_478" HREF="whatever.html">update-clause</A> |
| <BR><A NAME="ToC_479" HREF="whatever.html">read-only-clause</A> |
| <BR><A NAME="ToC_480" HREF="whatever.html">fetch-first-clause</A> |
| <BR><A NAME="ToC_481" HREF="whatever.html">optimize-for-clause</A> |
| <BR><A NAME="ToC_482" HREF="whatever.html">Examples of a select-statement</A> |
| <P><B><A NAME="ToC_483" HREF="whatever.html">SQL Statements</A></B><BR> |
| <BR><A NAME="ToC_484" HREF="whatever.html">How SQL Statements Are Invoked</A> |
| <BR><A NAME="ToC_485" HREF="whatever.html">Embedding a Statement in an Application Program</A> |
| <BR><A NAME="ToC_489" HREF="whatever.html">Dynamic Preparation and Execution</A> |
| <BR><A NAME="ToC_490" HREF="whatever.html">Static Invocation of a select-statement</A> |
| <BR><A NAME="ToC_491" HREF="whatever.html">Dynamic Invocation of a select-statement</A> |
| <BR><A NAME="ToC_492" HREF="whatever.html">Interactive Invocation</A> |
| <BR><A NAME="ToC_493" HREF="whatever.html">SQL Return Codes</A> |
| <BR><A NAME="ToC_494" HREF="whatever.html">SQLCODE</A> |
| <BR><A NAME="ToC_495" HREF="whatever.html">SQLSTATE</A> |
| <BR><A NAME="ToC_496" HREF="whatever.html">SQL Comments</A> |
| <BR><A NAME="ToC_497" HREF="whatever.html">ALTER BUFFERPOOL</A> |
| <BR><A NAME="ToC_498" HREF="whatever.html">ALTER NICKNAME</A> |
| <BR><A NAME="ToC_499" HREF="whatever.html">ALTER NODEGROUP</A> |
| <BR><A NAME="ToC_500" HREF="whatever.html">ALTER SERVER</A> |
| <BR><A NAME="ToC_501" HREF="whatever.html">ALTER TABLE</A> |
| <BR><A NAME="ToC_504" HREF="whatever.html">ALTER TABLESPACE</A> |
| <BR><A NAME="ToC_505" HREF="whatever.html">ALTER TYPE (Structured)</A> |
| <BR><A NAME="ToC_507" HREF="whatever.html">ALTER USER MAPPING</A> |
| <BR><A NAME="ToC_508" HREF="whatever.html">ALTER VIEW</A> |
| <BR><A NAME="ToC_509" HREF="whatever.html">BEGIN DECLARE SECTION</A> |
| <BR><A NAME="ToC_511" HREF="whatever.html">CALL</A> |
| <BR><A NAME="ToC_513" HREF="whatever.html">CLOSE</A> |
| <BR><A NAME="ToC_514" HREF="whatever.html">COMMENT ON</A> |
| <BR><A NAME="ToC_515" HREF="whatever.html">COMMIT</A> |
| <BR><A NAME="ToC_517" HREF="whatever.html">Compound SQL (Embedded)</A> |
| <BR><A NAME="ToC_519" HREF="whatever.html">CONNECT (Type 1)</A> |
| <BR><A NAME="ToC_524" HREF="whatever.html">CONNECT (Type 2)</A> |
| <BR><A NAME="ToC_525" HREF="whatever.html">CREATE ALIAS</A> |
| <BR><A NAME="ToC_526" HREF="whatever.html">CREATE BUFFERPOOL</A> |
| <BR><A NAME="ToC_527" HREF="whatever.html">CREATE DISTINCT TYPE</A> |
| <BR><A NAME="ToC_528" HREF="whatever.html">CREATE EVENT MONITOR</A> |
| <BR><A NAME="ToC_529" HREF="whatever.html">CREATE FUNCTION</A> |
| <BR><A NAME="ToC_530" HREF="whatever.html">CREATE FUNCTION (External Scalar)</A> |
| <BR><A NAME="ToC_531" HREF="whatever.html">CREATE FUNCTION (External Table)</A> |
| <BR><A NAME="ToC_532" HREF="whatever.html">CREATE FUNCTION (OLE DB External Table)</A> |
| <BR><A NAME="ToC_533" HREF="whatever.html">CREATE FUNCTION (Source or Template)</A> |
| <BR><A NAME="ToC_534" HREF="whatever.html">CREATE FUNCTION (SQL Scalar, Table or Row)</A> |
| <BR><A NAME="ToC_535" HREF="whatever.html">CREATE FUNCTION MAPPING</A> |
| <BR><A NAME="ToC_537" HREF="whatever.html">CREATE INDEX</A> |
| <BR><A NAME="ToC_538" HREF="whatever.html">CREATE INDEX EXTENSION</A> |
| <BR><A NAME="ToC_539" HREF="whatever.html">CREATE METHOD</A> |
| <BR><A NAME="ToC_540" HREF="whatever.html">CREATE NICKNAME</A> |
| <BR><A NAME="ToC_541" HREF="whatever.html">CREATE NODEGROUP</A> |
| <BR><A NAME="ToC_542" HREF="whatever.html">CREATE PROCEDURE</A> |
| <BR><A NAME="ToC_543" HREF="whatever.html">CREATE SCHEMA</A> |
| <BR><A NAME="ToC_544" HREF="whatever.html">CREATE SERVER</A> |
| <BR><A NAME="ToC_546" HREF="whatever.html">CREATE TABLE</A> |
| <BR><A NAME="ToC_549" HREF="whatever.html">CREATE TABLESPACE</A> |
| <BR><A NAME="ToC_550" HREF="whatever.html">CREATE TRANSFORM</A> |
| <BR><A NAME="ToC_551" HREF="whatever.html">CREATE TRIGGER</A> |
| <BR><A NAME="ToC_552" HREF="whatever.html">CREATE TYPE (Structured)</A> |
| <BR><A NAME="ToC_553" HREF="whatever.html">CREATE TYPE MAPPING</A> |
| <BR><A NAME="ToC_554" HREF="whatever.html">CREATE USER MAPPING</A> |
| <BR><A NAME="ToC_555" HREF="whatever.html">CREATE VIEW</A> |
| <BR><A NAME="ToC_557" HREF="whatever.html">CREATE WRAPPER</A> |
| <BR><A NAME="ToC_558" HREF="whatever.html">DECLARE CURSOR</A> |
| <BR><A NAME="ToC_560" HREF="whatever.html">DECLARE GLOBAL TEMPORARY TABLE</A> |
| <BR><A NAME="ToC_561" HREF="whatever.html">DELETE</A> |
| <BR><A NAME="ToC_562" HREF="whatever.html">DESCRIBE</A> |
| <BR><A NAME="ToC_563" HREF="whatever.html">DISCONNECT</A> |
| <BR><A NAME="ToC_564" HREF="whatever.html">DROP</A> |
| <BR><A NAME="ToC_566" HREF="whatever.html">END DECLARE SECTION</A> |
| <BR><A NAME="ToC_567" HREF="whatever.html">EXECUTE</A> |
| <BR><A NAME="ToC_569" HREF="whatever.html">EXECUTE IMMEDIATE</A> |
| <BR><A NAME="ToC_570" HREF="whatever.html">EXPLAIN</A> |
| <BR><A NAME="ToC_571" HREF="whatever.html">FETCH</A> |
| <BR><A NAME="ToC_572" HREF="whatever.html">FLUSH EVENT MONITOR</A> |
| <BR><A NAME="ToC_573" HREF="whatever.html">FREE LOCATOR</A> |
| <BR><A NAME="ToC_574" HREF="whatever.html">GRANT (Database Authorities)</A> |
| <BR><A NAME="ToC_575" HREF="whatever.html">GRANT (Index Privileges)</A> |
| <BR><A NAME="ToC_576" HREF="whatever.html">GRANT (Package Privileges)</A> |
| <BR><A NAME="ToC_577" HREF="whatever.html">GRANT (Schema Privileges)</A> |
| <BR><A NAME="ToC_578" HREF="whatever.html">GRANT (Server Privileges)</A> |
| <BR><A NAME="ToC_579" HREF="whatever.html">GRANT (Table, View, or Nickname Privileges)</A> |
| <BR><A NAME="ToC_580" HREF="whatever.html">GRANT (Table Space Privileges)</A> |
| <BR><A NAME="ToC_581" HREF="whatever.html">INCLUDE</A> |
| <BR><A NAME="ToC_582" HREF="whatever.html">INSERT</A> |
| <BR><A NAME="ToC_584" HREF="whatever.html">LOCK TABLE</A> |
| <BR><A NAME="ToC_585" HREF="whatever.html">OPEN</A> |
| <BR><A NAME="ToC_587" HREF="whatever.html">PREPARE</A> |
| <BR><A NAME="ToC_589" HREF="whatever.html">REFRESH TABLE</A> |
| <BR><A NAME="ToC_590" HREF="whatever.html">RELEASE (Connection)</A> |
| <BR><A NAME="ToC_591" HREF="whatever.html">RELEASE SAVEPOINT</A> |
| <BR><A NAME="ToC_592" HREF="whatever.html">RENAME TABLE</A> |
| <BR><A NAME="ToC_593" HREF="whatever.html">RENAME TABLESPACE</A> |
| <BR><A NAME="ToC_594" HREF="whatever.html">REVOKE (Database Authorities)</A> |
| <BR><A NAME="ToC_595" HREF="whatever.html">REVOKE (Index Privileges)</A> |
| <BR><A NAME="ToC_596" HREF="whatever.html">REVOKE (Package Privileges)</A> |
| <BR><A NAME="ToC_597" HREF="whatever.html">REVOKE (Schema Privileges)</A> |
| <BR><A NAME="ToC_598" HREF="whatever.html">REVOKE (Server Privileges)</A> |
| <BR><A NAME="ToC_599" HREF="whatever.html">REVOKE (Table, View, or Nickname Privileges)</A> |
| <BR><A NAME="ToC_600" HREF="whatever.html">REVOKE (Table Space Privileges)</A> |
| <BR><A NAME="ToC_601" HREF="whatever.html">ROLLBACK</A> |
| <BR><A NAME="ToC_602" HREF="whatever.html">SAVEPOINT</A> |
| <BR><A NAME="ToC_603" HREF="whatever.html">SELECT</A> |
| <BR><A NAME="ToC_604" HREF="whatever.html">SELECT INTO</A> |
| <BR><A NAME="ToC_605" HREF="whatever.html">SET CONNECTION</A> |
| <BR><A NAME="ToC_606" HREF="whatever.html">SET CURRENT DEFAULT TRANSFORM GROUP</A> |
| <BR><A NAME="ToC_607" HREF="whatever.html">SET CURRENT DEGREE</A> |
| <BR><A NAME="ToC_608" HREF="whatever.html">SET CURRENT EXPLAIN MODE</A> |
| <BR><A NAME="ToC_609" HREF="whatever.html">SET CURRENT EXPLAIN SNAPSHOT</A> |
| <BR><A NAME="ToC_610" HREF="whatever.html">SET CURRENT PACKAGESET</A> |
| <BR><A NAME="ToC_611" HREF="whatever.html">SET CURRENT QUERY OPTIMIZATION</A> |
| <BR><A NAME="ToC_612" HREF="whatever.html">SET CURRENT REFRESH AGE</A> |
| <BR><A NAME="ToC_613" HREF="whatever.html">SET EVENT MONITOR STATE</A> |
| <BR><A NAME="ToC_614" HREF="whatever.html">SET INTEGRITY</A> |
| <BR><A NAME="ToC_616" HREF="whatever.html">SET PASSTHRU</A> |
| <BR><A NAME="ToC_617" HREF="whatever.html">SET PATH</A> |
| <BR><A NAME="ToC_618" HREF="whatever.html">SET SCHEMA</A> |
| <BR><A NAME="ToC_619" HREF="whatever.html">SET SERVER OPTION</A> |
| <BR><A NAME="ToC_620" HREF="whatever.html">SET transition-variable</A> |
| <BR><A NAME="ToC_621" HREF="whatever.html">SIGNAL SQLSTATE</A> |
| <BR><A NAME="ToC_622" HREF="whatever.html">UPDATE</A> |
| <BR><A NAME="ToC_623" HREF="whatever.html">VALUES</A> |
| <BR><A NAME="ToC_624" HREF="whatever.html">VALUES INTO</A> |
| <BR><A NAME="ToC_625" HREF="whatever.html">WHENEVER</A> |
| <P><B><A NAME="ToC_626" HREF="whatever.html">SQL Procedures</A></B><BR> |
| <BR><A NAME="ToC_627" HREF="whatever.html">SQL Procedure Statement</A> |
| <BR><A NAME="ToC_628" HREF="whatever.html">ALLOCATE CURSOR Statement</A> |
| <BR><A NAME="ToC_629" HREF="whatever.html">Assignment Statement</A> |
| <BR><A NAME="ToC_630" HREF="whatever.html">ASSOCIATE LOCATORS Statement</A> |
| <BR><A NAME="ToC_631" HREF="whatever.html">CASE Statement</A> |
| <BR><A NAME="ToC_632" HREF="whatever.html">Compound Statement</A> |
| <BR><A NAME="ToC_633" HREF="whatever.html">FOR Statement</A> |
| <BR><A NAME="ToC_634" HREF="whatever.html">GET DIAGNOSTICS Statement</A> |
| <BR><A NAME="ToC_635" HREF="whatever.html">GOTO Statement</A> |
| <BR><A NAME="ToC_636" HREF="whatever.html">IF Statement</A> |
| <BR><A NAME="ToC_637" HREF="whatever.html">ITERATE Statement</A> |
| <BR><A NAME="ToC_638" HREF="whatever.html">LEAVE Statement</A> |
| <BR><A NAME="ToC_639" HREF="whatever.html">LOOP Statement</A> |
| <BR><A NAME="ToC_640" HREF="whatever.html">REPEAT Statement</A> |
| <BR><A NAME="ToC_641" HREF="whatever.html">RESIGNAL Statement</A> |
| <BR><A NAME="ToC_642" HREF="whatever.html">RETURN Statement</A> |
| <BR><A NAME="ToC_643" HREF="whatever.html">SIGNAL Statement</A> |
| <BR><A NAME="ToC_644" HREF="whatever.html">WHILE Statement</A> |
| <P><B><A NAME="ToC_645" HREF="whatever.html">Appendix A. SQL Limits</A></B><BR> |
| <P><B><A NAME="ToC_646" HREF="whatever.html">Appendix B. SQL Communications (SQLCA)</A></B><BR> |
| <BR><A NAME="ToC_647" HREF="whatever.html">Viewing the SQLCA Interactively</A> |
| <BR><A NAME="ToC_648" HREF="whatever.html">SQLCA Field Descriptions</A> |
| <BR><A NAME="ToC_649" HREF="whatever.html">Order of Error Reporting</A> |
| <BR><A NAME="ToC_650" HREF="whatever.html">DB2 Enterprise - Extended Edition Usage of the SQLCA</A> |
| <P><B><A NAME="ToC_651" HREF="whatever.html">Appendix C. SQL Descriptor Area (SQLDA)</A></B><BR> |
| <BR><A NAME="ToC_652" HREF="whatever.html">Field Descriptions</A> |
| <BR><A NAME="ToC_653" HREF="whatever.html">Fields in the SQLDA Header</A> |
| <BR><A NAME="ToC_654" HREF="whatever.html">Fields in an Occurrence of a Base SQLVAR</A> |
| <BR><A NAME="ToC_655" HREF="whatever.html">Fields in an Occurrence of a Secondary SQLVAR</A> |
| <BR><A NAME="ToC_656" HREF="whatever.html">Effect of DESCRIBE on the SQLDA</A> |
| <BR><A NAME="ToC_657" HREF="whatever.html">SQLTYPE and SQLLEN</A> |
| <BR><A NAME="ToC_658" HREF="whatever.html">Unrecognized and Unsupported SQLTYPES</A> |
| <BR><A NAME="ToC_659" HREF="whatever.html">Packed Decimal Numbers</A> |
| <BR><A NAME="ToC_660" HREF="whatever.html">SQLLEN Field for Decimal</A> |
| <P><B><A NAME="ToC_661" HREF="whatever.html">Appendix D. Catalog Views</A></B><BR> |
| <BR><A NAME="ToC_662" HREF="whatever.html">Updatable Catalog Views</A> |
| <BR><A NAME="ToC_663" HREF="whatever.html">'Roadmap' to Catalog Views</A> |
| <BR><A NAME="ToC_664" HREF="whatever.html">'Roadmap' to Updatable Catalog Views</A> |
| <BR><A NAME="ToC_665" HREF="whatever.html">SYSIBM.SYSDUMMY1</A> |
| <BR><A NAME="ToC_666" HREF="whatever.html">SYSCAT.ATTRIBUTES</A> |
| <BR><A NAME="ToC_667" HREF="whatever.html">SYSCAT.BUFFERPOOLNODES</A> |
| <BR><A NAME="ToC_668" HREF="whatever.html">SYSCAT.BUFFERPOOLS</A> |
| <BR><A NAME="ToC_669" HREF="whatever.html">SYSCAT.CASTFUNCTIONS</A> |
| <BR><A NAME="ToC_670" HREF="whatever.html">SYSCAT.CHECKS</A> |
| <BR><A NAME="ToC_671" HREF="whatever.html">SYSCAT.COLAUTH</A> |
| <BR><A NAME="ToC_672" HREF="whatever.html">SYSCAT.COLCHECKS</A> |
| <BR><A NAME="ToC_673" HREF="whatever.html">SYSCAT.COLDIST</A> |
| <BR><A NAME="ToC_674" HREF="whatever.html">SYSCAT.COLOPTIONS</A> |
| <BR><A NAME="ToC_675" HREF="whatever.html">SYSCAT.COLUMNS</A> |
| <BR><A NAME="ToC_676" HREF="whatever.html">SYSCAT.CONSTDEP</A> |
| <BR><A NAME="ToC_677" HREF="whatever.html">SYSCAT.DATATYPES</A> |
| <BR><A NAME="ToC_678" HREF="whatever.html">SYSCAT.DBAUTH</A> |
| <BR><A NAME="ToC_679" HREF="whatever.html">SYSCAT.EVENTMONITORS</A> |
| <BR><A NAME="ToC_680" HREF="whatever.html">SYSCAT.EVENTS</A> |
| <BR><A NAME="ToC_681" HREF="whatever.html">SYSCAT.FULLHIERARCHIES</A> |
| <BR><A NAME="ToC_682" HREF="whatever.html">SYSCAT.FUNCDEP</A> |
| <BR><A NAME="ToC_683" HREF="whatever.html">SYSCAT.FUNCMAPOPTIONS</A> |
| <BR><A NAME="ToC_684" HREF="whatever.html">SYSCAT.FUNCMAPPARMOPTIONS</A> |
| <BR><A NAME="ToC_685" HREF="whatever.html">SYSCAT.FUNCMAPPINGS</A> |
| <BR><A NAME="ToC_686" HREF="whatever.html">SYSCAT.FUNCPARMS</A> |
| <BR><A NAME="ToC_687" HREF="whatever.html">SYSCAT.FUNCTIONS</A> |
| <BR><A NAME="ToC_688" HREF="whatever.html">SYSCAT.HIERARCHIES</A> |
| <BR><A NAME="ToC_689" HREF="whatever.html">SYSCAT.INDEXAUTH</A> |
| <BR><A NAME="ToC_690" HREF="whatever.html">SYSCAT.INDEXCOLUSE</A> |
| <BR><A NAME="ToC_691" HREF="whatever.html">SYSCAT.INDEXDEP</A> |
| <BR><A NAME="ToC_692" HREF="whatever.html">SYSCAT.INDEXES</A> |
| <BR><A NAME="ToC_693" HREF="whatever.html">SYSCAT.INDEXOPTIONS</A> |
| <BR><A NAME="ToC_694" HREF="whatever.html">SYSCAT.KEYCOLUSE</A> |
| <BR><A NAME="ToC_695" HREF="whatever.html">SYSCAT.NAMEMAPPINGS</A> |
| <BR><A NAME="ToC_696" HREF="whatever.html">SYSCAT.NODEGROUPDEF</A> |
| <BR><A NAME="ToC_697" HREF="whatever.html">SYSCAT.NODEGROUPS</A> |
| <BR><A NAME="ToC_698" HREF="whatever.html">SYSCAT.PACKAGEAUTH</A> |
| <BR><A NAME="ToC_699" HREF="whatever.html">SYSCAT.PACKAGEDEP</A> |
| <BR><A NAME="ToC_700" HREF="whatever.html">SYSCAT.PACKAGES</A> |
| <BR><A NAME="ToC_701" HREF="whatever.html">SYSCAT.PARTITIONMAPS</A> |
| <BR><A NAME="ToC_702" HREF="whatever.html">SYSCAT.PASSTHRUAUTH</A> |
| <BR><A NAME="ToC_703" HREF="whatever.html">SYSCAT.PROCEDURES</A> |
| <BR><A NAME="ToC_704" HREF="whatever.html">SYSCAT.PROCOPTIONS</A> |
| <BR><A NAME="ToC_705" HREF="whatever.html">SYSCAT.PROCPARMOPTIONS</A> |
| <BR><A NAME="ToC_706" HREF="whatever.html">SYSCAT.PROCPARMS</A> |
| <BR><A NAME="ToC_707" HREF="whatever.html">SYSCAT.REFERENCES</A> |
| <BR><A NAME="ToC_708" HREF="whatever.html">SYSCAT.REVTYPEMAPPINGS</A> |
| <BR><A NAME="ToC_709" HREF="whatever.html">SYSCAT.SCHEMAAUTH</A> |
| <BR><A NAME="ToC_710" HREF="whatever.html">SYSCAT.SCHEMATA</A> |
| <BR><A NAME="ToC_711" HREF="whatever.html">SYSCAT.SERVEROPTIONS</A> |
| <BR><A NAME="ToC_712" HREF="whatever.html">SYSCAT.SERVERS</A> |
| <BR><A NAME="ToC_713" HREF="whatever.html">SYSCAT.STATEMENTS</A> |
| <BR><A NAME="ToC_714" HREF="whatever.html">SYSCAT.TABAUTH</A> |
| <BR><A NAME="ToC_715" HREF="whatever.html">SYSCAT.TABCONST</A> |
| <BR><A NAME="ToC_716" HREF="whatever.html">SYSCAT.TABLES</A> |
| <BR><A NAME="ToC_717" HREF="whatever.html">SYSCAT.TABLESPACES</A> |
| <BR><A NAME="ToC_718" HREF="whatever.html">SYSCAT.TABOPTIONS</A> |
| <BR><A NAME="ToC_719" HREF="whatever.html">SYSCAT.TBSPACEAUTH</A> |
| <BR><A NAME="ToC_720" HREF="whatever.html">SYSCAT.TRIGDEP</A> |
| <BR><A NAME="ToC_721" HREF="whatever.html">SYSCAT.TRIGGERS</A> |
| <BR><A NAME="ToC_722" HREF="whatever.html">SYSCAT.TYPEMAPPINGS</A> |
| <BR><A NAME="ToC_723" HREF="whatever.html">SYSCAT.USEROPTIONS</A> |
| <BR><A NAME="ToC_724" HREF="whatever.html">SYSCAT.VIEWDEP</A> |
| <BR><A NAME="ToC_725" HREF="whatever.html">SYSCAT.VIEWS</A> |
| <BR><A NAME="ToC_726" HREF="whatever.html">SYSCAT.WRAPOPTIONS</A> |
| <BR><A NAME="ToC_727" HREF="whatever.html">SYSCAT.WRAPPERS</A> |
| <BR><A NAME="ToC_728" HREF="whatever.html">SYSSTAT.COLDIST</A> |
| <BR><A NAME="ToC_729" HREF="whatever.html">SYSSTAT.COLUMNS</A> |
| <BR><A NAME="ToC_730" HREF="whatever.html">SYSSTAT.FUNCTIONS</A> |
| <BR><A NAME="ToC_731" HREF="whatever.html">SYSSTAT.INDEXES</A> |
| <BR><A NAME="ToC_732" HREF="whatever.html">SYSSTAT.TABLES</A> |
| <P><B><A NAME="ToC_733" HREF="whatever.html">Appendix E. Catalog Views For Use With Structured Types</A></B><BR> |
| <BR><A NAME="ToC_734" HREF="whatever.html">'Roadmap' to Catalog Views</A> |
| <BR><A NAME="ToC_735" HREF="whatever.html">OBJCAT.INDEXES</A> |
| <BR><A NAME="ToC_736" HREF="whatever.html">OBJCAT.INDEXEXPLOITRULES</A> |
| <BR><A NAME="ToC_737" HREF="whatever.html">OBJCAT.INDEXEXTENSIONDEP</A> |
| <BR><A NAME="ToC_738" HREF="whatever.html">OBJCAT.INDEXEXTENSIONMETHODS</A> |
| <BR><A NAME="ToC_739" HREF="whatever.html">OBJCAT.INDEXEXTENSIONPARMS</A> |
| <BR><A NAME="ToC_740" HREF="whatever.html">OBJCAT.INDEXEXTENSIONS</A> |
| <BR><A NAME="ToC_741" HREF="whatever.html">OBJCAT.PREDICATESPECS</A> |
| <BR><A NAME="ToC_742" HREF="whatever.html">OBJCAT.TRANSFORMS</A> |
| <P><B><A NAME="ToC_743" HREF="whatever.html">Appendix F. Federated Systems</A></B><BR> |
| <BR><A NAME="ToC_744" HREF="whatever.html">Server Types</A> |
| <BR><A NAME="ToC_745" HREF="whatever.html">SQL Options for Federated Systems</A> |
| <BR><A NAME="ToC_746" HREF="whatever.html">Column Options</A> |
| <BR><A NAME="ToC_747" HREF="whatever.html">Function Mapping Options</A> |
| <BR><A NAME="ToC_748" HREF="whatever.html">Server Options</A> |
| <BR><A NAME="ToC_749" HREF="whatever.html">User Options</A> |
| <BR><A NAME="ToC_750" HREF="whatever.html">Default Data Type Mappings</A> |
| <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> |
| <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> |
| <BR><A NAME="ToC_753" HREF="whatever.html">Default Type Mappings between DB2 and Oracle Data Sources</A> |
| <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> |
| <BR><A NAME="ToC_755" HREF="whatever.html">Pass-Through Facility Processing</A> |
| <BR><A NAME="ToC_756" HREF="whatever.html">SQL Processing in Pass-Through Sessions</A> |
| <BR><A NAME="ToC_757" HREF="whatever.html">Considerations and Restrictions</A> |
| <P><B><A NAME="ToC_760" HREF="whatever.html">Appendix G. Sample Database Tables</A></B><BR> |
| <BR><A NAME="ToC_761" HREF="whatever.html">The Sample Database</A> |
| <BR><A NAME="ToC_762" HREF="whatever.html">To Create the Sample Database</A> |
| <BR><A NAME="ToC_763" HREF="whatever.html">To Erase the Sample Database</A> |
| <BR><A NAME="ToC_764" HREF="whatever.html">CL_SCHED Table</A> |
| <BR><A NAME="ToC_765" HREF="whatever.html">DEPARTMENT Table</A> |
| <BR><A NAME="ToC_766" HREF="whatever.html">EMPLOYEE Table</A> |
| <BR><A NAME="ToC_767" HREF="whatever.html">EMP_ACT Table</A> |
| <BR><A NAME="ToC_768" HREF="whatever.html">EMP_PHOTO Table</A> |
| <BR><A NAME="ToC_769" HREF="whatever.html">EMP_RESUME Table</A> |
| <BR><A NAME="ToC_770" HREF="whatever.html">IN_TRAY Table</A> |
| <BR><A NAME="ToC_771" HREF="whatever.html">ORG Table</A> |
| <BR><A NAME="ToC_772" HREF="whatever.html">PROJECT Table</A> |
| <BR><A NAME="ToC_773" HREF="whatever.html">SALES Table</A> |
| <BR><A NAME="ToC_774" HREF="whatever.html">STAFF Table</A> |
| <BR><A NAME="ToC_775" HREF="whatever.html">STAFFG Table</A> |
| <BR><A NAME="ToC_776" HREF="whatever.html">Sample Files with BLOB and CLOB Data Type</A> |
| <BR><A NAME="ToC_777" HREF="whatever.html">Quintana Photo</A> |
| <BR><A NAME="ToC_778" HREF="whatever.html">Quintana Resume</A> |
| <BR><A NAME="ToC_779" HREF="whatever.html">Nicholls Photo</A> |
| <BR><A NAME="ToC_780" HREF="whatever.html">Nicholls Resume</A> |
| <BR><A NAME="ToC_781" HREF="whatever.html">Adamson Photo</A> |
| <BR><A NAME="ToC_782" HREF="whatever.html">Adamson Resume</A> |
| <BR><A NAME="ToC_783" HREF="whatever.html">Walker Photo</A> |
| <BR><A NAME="ToC_784" HREF="whatever.html">Walker Resume</A> |
| <P><B><A NAME="ToC_785" HREF="whatever.html">Appendix H. Reserved Schema Names and Reserved Words</A></B><BR> |
| <BR><A NAME="ToC_786" HREF="whatever.html">Reserved Schemas</A> |
| <BR><A NAME="ToC_787" HREF="whatever.html">Reserved Words</A> |
| <BR><A NAME="ToC_788" HREF="whatever.html">IBM SQL Reserved Words</A> |
| <BR><A NAME="ToC_789" HREF="whatever.html">ISO/ANS SQL92 Reserved Words</A> |
| <P><B><A NAME="ToC_790" HREF="whatever.html">Appendix I. Comparison of Isolation Levels</A></B><BR> |
| <P><B><A NAME="ToC_791" HREF="whatever.html">Appendix J. Interaction of Triggers and Constraints</A></B><BR> |
| <P><B><A NAME="ToC_792" HREF="whatever.html">Appendix K. Explain Tables and Definitions</A></B><BR> |
| <BR><A NAME="ToC_793" HREF="whatever.html">EXPLAIN_ARGUMENT Table</A> |
| <BR><A NAME="ToC_794" HREF="whatever.html">EXPLAIN_INSTANCE Table</A> |
| <BR><A NAME="ToC_795" HREF="whatever.html">EXPLAIN_OBJECT Table</A> |
| <BR><A NAME="ToC_796" HREF="whatever.html">EXPLAIN_OPERATOR Table</A> |
| <BR><A NAME="ToC_797" HREF="whatever.html">EXPLAIN_PREDICATE Table</A> |
| <BR><A NAME="ToC_798" HREF="whatever.html">EXPLAIN_STATEMENT Table</A> |
| <BR><A NAME="ToC_799" HREF="whatever.html">EXPLAIN_STREAM Table</A> |
| <BR><A NAME="ToC_800" HREF="whatever.html">ADVISE_INDEX Table</A> |
| <BR><A NAME="ToC_801" HREF="whatever.html">ADVISE_WORKLOAD Table</A> |
| <BR><A NAME="ToC_802" HREF="whatever.html">Table Definitions for Explain Tables</A> |
| <BR><A NAME="ToC_803" HREF="whatever.html">EXPLAIN_ARGUMENT Table Definition</A> |
| <BR><A NAME="ToC_804" HREF="whatever.html">EXPLAIN_INSTANCE Table Definition</A> |
| <BR><A NAME="ToC_805" HREF="whatever.html">EXPLAIN_OBJECT Table Definition</A> |
| <BR><A NAME="ToC_806" HREF="whatever.html">EXPLAIN_OPERATOR Table Definition</A> |
| <BR><A NAME="ToC_807" HREF="whatever.html">EXPLAIN_PREDICATE Table Definition</A> |
| <BR><A NAME="ToC_808" HREF="whatever.html">EXPLAIN_STATEMENT Table Definition</A> |
| <BR><A NAME="ToC_809" HREF="whatever.html">EXPLAIN_STREAM Table Definition</A> |
| <BR><A NAME="ToC_810" HREF="whatever.html">ADVISE_INDEX Table Definition</A> |
| <BR><A NAME="ToC_811" HREF="whatever.html">ADVISE_WORKLOAD Table Definition</A> |
| <P><B><A NAME="ToC_812" HREF="whatever.html">Appendix L. Explain Register Values</A></B><BR> |
| <P><B><A NAME="ToC_813" HREF="whatever.html">Appendix M. Recursion Example: Bill of Materials</A></B><BR> |
| <BR><A NAME="ToC_814" HREF="whatever.html">Example 1: Single Level Explosion</A> |
| <BR><A NAME="ToC_815" HREF="whatever.html">Example 2: Summarized Explosion</A> |
| <BR><A NAME="ToC_816" HREF="whatever.html">Example 3: Controlling Depth</A> |
| <P><B><A NAME="ToC_817" HREF="whatever.html">Appendix N. Exception Tables</A></B><BR> |
| <BR><A NAME="ToC_818" HREF="whatever.html">Rules for Creating an Exception Table</A> |
| <BR><A NAME="ToC_819" HREF="whatever.html">Handling Rows in the Exception Tables</A> |
| <BR><A NAME="ToC_820" HREF="whatever.html">Querying the Exception Tables</A> |
| <P><B><A NAME="ToC_821" HREF="whatever.html">Appendix O. Japanese and Traditional-Chinese EUC Considerations</A></B><BR> |
| <BR><A NAME="ToC_822" HREF="whatever.html">Language Elements</A> |
| <BR><A NAME="ToC_823" HREF="whatever.html">Characters</A> |
| <BR><A NAME="ToC_824" HREF="whatever.html">Tokens</A> |
| <BR><A NAME="ToC_825" HREF="whatever.html">Identifiers</A> |
| <BR><A NAME="ToC_827" HREF="whatever.html">Data Types</A> |
| <BR><A NAME="ToC_830" HREF="whatever.html">Assignments and Comparisons</A> |
| <BR><A NAME="ToC_833" HREF="whatever.html">Rules for Result Data Types</A> |
| <BR><A NAME="ToC_834" HREF="whatever.html">Rules for String Conversions</A> |
| <BR><A NAME="ToC_835" HREF="whatever.html">Constants</A> |
| <BR><A NAME="ToC_837" HREF="whatever.html">Functions</A> |
| <BR><A NAME="ToC_838" HREF="whatever.html">Expressions</A> |
| <BR><A NAME="ToC_840" HREF="whatever.html">Predicates</A> |
| <BR><A NAME="ToC_842" HREF="whatever.html">Functions</A> |
| <BR><A NAME="ToC_843" HREF="whatever.html">LENGTH</A> |
| <BR><A NAME="ToC_844" HREF="whatever.html">SUBSTR</A> |
| <BR><A NAME="ToC_845" HREF="whatever.html">TRANSLATE</A> |
| <BR><A NAME="ToC_846" HREF="whatever.html">VARGRAPHIC</A> |
| <BR><A NAME="ToC_847" HREF="whatever.html">Statements</A> |
| <BR><A NAME="ToC_848" HREF="whatever.html">CONNECT</A> |
| <BR><A NAME="ToC_849" HREF="whatever.html">PREPARE</A> |
| <P><B><A NAME="ToC_850" HREF="whatever.html">Appendix P. BNF Specifications for DATALINKs</A></B><BR> |
| <P><B><A NAME="ToC_851" HREF="whatever.html">Appendix Q. Using the DB2 Library</A></B><BR> |
| <BR><A NAME="ToC_852" HREF="whatever.html">DB2 PDF Files and Printed Books</A> |
| <BR><A NAME="ToC_853" HREF="whatever.html">DB2 Information</A> |
| <BR><A NAME="ToC_854" HREF="whatever.html">Printing the PDF Books</A> |
| <BR><A NAME="ToC_855" HREF="whatever.html">Ordering the Printed Books</A> |
| <BR><A NAME="ToC_856" HREF="whatever.html">DB2 Online Documentation</A> |
| <BR><A NAME="ToC_857" HREF="whatever.html">Accessing Online Help</A> |
| <BR><A NAME="ToC_858" HREF="whatever.html">Viewing Information Online</A> |
| <BR><A NAME="ToC_861" HREF="whatever.html">Using DB2 Wizards</A> |
| <BR><A NAME="ToC_862" HREF="whatever.html">Setting Up a Document Server</A> |
| <BR><A NAME="ToC_863" HREF="whatever.html">Searching Information Online</A> |
| <P><B><A NAME="ToC_864" HREF="whatever.html">Appendix R. Notices</A></B><BR> |
| <BR><A NAME="ToC_865" HREF="whatever.html">Trademarks</A> |
| <P><B><A NAME="ToC_866" HREF="whatever.html">Index</A></B><BR> |
| <P><B><A NAME="ToC_867" HREF="whatever.html">Contacting IBM</A></B><BR> |
| <BR><A NAME="ToC_868" HREF="whatever.html">Product Information</A> |
| |
| <A NAME="Bot_Of_Page"></A> |
| |
| </tr> |
| <td>x</td> |
| <td>x</td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| </table> |
| </td> |
| </tr> |
| </table> |
| </body> |
| </html> |
| |
