Move padding/margin/offset writing mode logic from RenderStyle to LengthBox
[WebKit-https.git] / 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