1232 lines
149 KiB
HTML
1232 lines
149 KiB
HTML
<?xml version="1.0" encoding="utf-8"?>
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
|
|
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
|
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-us">
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
|
<meta name="dc.language" scheme="rfc1766" content="en-us" />
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
|
<!-- US Government Users Restricted Rights -->
|
|
<!-- Use, duplication or disclosure restricted by -->
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
|
<meta name="dc.date" scheme="iso8601" content="2005-09-19" />
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
|
<meta name="security" content="public" />
|
|
<meta name="Robots" content="index,follow"/>
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
|
<title>Contents</title>
|
|
<link rel="stylesheet" type="text/css" href="ibmidwb.css" />
|
|
<link rel="stylesheet" type="text/css" href="ic.css" />
|
|
</head>
|
|
<body>
|
|
<a id="Top_Of_Page" name="Top_Of_Page"></a><!-- Java sync-link -->
|
|
<script language = "Javascript" src = "../rzahg/synch.js" type="text/javascript"></script>
|
|
|
|
|
|
<a name="wq1"></a>
|
|
<div id="wq1">
|
|
<h1><a href="rbafzmst02.htm#ToC_1">Contents</a></h1>
|
|
<div class="head1"><a id="ToC_2" name="ToC_2" href="rbafzmstabout.htm#about" class="toclink">About DB2 UDB for iSeries SQL Reference</a></div>
|
|
<div class="head2"><a id="ToC_3" name="ToC_3" href="rbafzmststandardcomp.htm#standardcomp" class="toclink">Standards compliance</a></div>
|
|
<div class="head2"><a id="ToC_4" name="ToC_4" href="rbafzmstsqlrwho.htm#sqlrwho" class="toclink">Who should read the SQL Reference</a></div>
|
|
<div class="head2"><a id="ToC_5" name="ToC_5" href="rbafzmsthowtous.htm#howtouse" class="toclink">How to use this book</a></div>
|
|
<div class="head3"><a id="ToC_6" name="ToC_6" href="rbafzmsthowtous.htm#sqlrassume" class="toclink">Assumptions relating to examples of SQL statements</a></div>
|
|
<div class="head3"><a id="ToC_8" name="ToC_8" href="rbafzmsthowtous.htm#sqlrsyntax" class="toclink">How to read the syntax diagrams</a></div>
|
|
<div class="head3"><a id="ToC_9" name="ToC_9" href="rbafzmsthowtous.htm#wq2" class="toclink">Conventions used in this book</a></div>
|
|
<div class="head3"><a id="ToC_12" name="ToC_12" href="rbafzmsthowtous.htm#accessibility" class="toclink">SQL accessibility</a></div>
|
|
<div class="head2"><a id="ToC_13" name="ToC_13" href="rbafzmstprintthis.htm#printthis" class="toclink">Printable PDFs</a></div>
|
|
<div class="head2"><a id="ToC_14" name="ToC_14" href="rbafzmstwhatsnew.htm#whatsnew" class="toclink">What's new for V5R4</a></div>
|
|
<div class="head1"><a id="ToC_15" name="ToC_15" href="rbafzmstconcept.htm#concept" class="toclink">Concepts</a></div>
|
|
<div class="head2"><a id="ToC_16" name="ToC_16" href="rbafzmstrelationaldb.htm#relationaldb" class="toclink">Relational database</a></div>
|
|
<div class="head2"><a id="ToC_17" name="ToC_17" href="rbafzmstsqlcon.htm#sqlcon" class="toclink">Structured Query Language</a></div>
|
|
<div class="head3"><a id="ToC_18" name="ToC_18" href="rbafzmstsqlcon.htm#staticsql" class="toclink">Static SQL</a></div>
|
|
<div class="head3"><a id="ToC_19" name="ToC_19" href="rbafzmstsqlcon.htm#dynamicsql" class="toclink">Dynamic SQL</a></div>
|
|
<div class="head3"><a id="ToC_20" name="ToC_20" href="rbafzmstsqlcon.htm#exdynamicsql" class="toclink">Extended Dynamic SQL</a></div>
|
|
<div class="head3"><a id="ToC_21" name="ToC_21" href="rbafzmstsqlcon.htm#intsql" class="toclink">Interactive SQL</a></div>
|
|
<div class="head3"><a id="ToC_22" name="ToC_22" href="rbafzmstsqlcon.htm#cliodbc" class="toclink">SQL Call Level Interface (CLI) and Open Database Connectivity (ODBC)</a></div>
|
|
<div class="head3"><a id="ToC_23" name="ToC_23" href="rbafzmstsqlcon.htm#jdbcsqlj" class="toclink">Java DataBase Connectivity (JDBC) and embedded SQL for Java (SQLJ) programs</a></div>
|
|
<div class="head3"><a id="ToC_24" name="ToC_24" href="rbafzmstsqlcon.htm#oledb" class="toclink">OLE DB and ADO (ActiveX Data Object)</a></div>
|
|
<div class="head3"><a id="ToC_25" name="ToC_25" href="rbafzmstsqlcon.htm#dotnet" class="toclink">.NET</a></div>
|
|
<div class="head2"><a id="ToC_26" name="ToC_26" href="rbafzmstcollex.htm#collex" class="toclink">Schemas</a></div>
|
|
<div class="head2"><a id="ToC_27" name="ToC_27" href="rbafzmstch1table.htm#ch1table" class="toclink">Tables</a></div>
|
|
<div class="head3"><a id="ToC_28" name="ToC_28" href="rbafzmstch1table.htm#sqlkey" class="toclink">Keys</a></div>
|
|
<div class="head3"><a id="ToC_29" name="ToC_29" href="rbafzmstch1table.htm#wq8" class="toclink">Constraints</a></div>
|
|
<div class="head3"><a id="ToC_33" name="ToC_33" href="rbafzmstch1table.htm#ch1index" class="toclink">Indexes</a></div>
|
|
<div class="head3"><a id="ToC_34" name="ToC_34" href="rbafzmstch1table.htm#trigex" class="toclink">Triggers</a></div>
|
|
<div class="head2"><a id="ToC_35" name="ToC_35" href="rbafzmstviewdef.htm#viewdef" class="toclink">Views</a></div>
|
|
<div class="head2"><a id="ToC_36" name="ToC_36" href="rbafzmstudtdef.htm#udtdef" class="toclink">User-defined types</a></div>
|
|
<div class="head2"><a id="ToC_37" name="ToC_37" href="rbafzmstali.htm#ali" class="toclink">Aliases</a></div>
|
|
<div class="head2"><a id="ToC_38" name="ToC_38" href="rbafzmstpackageap.htm#packageap" class="toclink">Packages and access plans</a></div>
|
|
<div class="head2"><a id="ToC_39" name="ToC_39" href="rbafzmstch1routines.htm#ch1routines" class="toclink">Routines</a></div>
|
|
<div class="head3"><a id="ToC_40" name="ToC_40" href="rbafzmstch1routines.htm#wq15" class="toclink">Functions</a></div>
|
|
<div class="head3"><a id="ToC_41" name="ToC_41" href="rbafzmstch1routines.htm#ch1proc" class="toclink">Procedures</a></div>
|
|
<div class="head2"><a id="ToC_42" name="ToC_42" href="rbafzmstsequences.htm#sequences" class="toclink">Sequences</a></div>
|
|
<div class="head2"><a id="ToC_43" name="ToC_43" href="rbafzmstauthown.htm#authown" class="toclink">Authorization, privileges and object ownership</a></div>
|
|
<div class="head2"><a id="ToC_44" name="ToC_44" href="rbafzmstcatalogdef.htm#catalogdef" class="toclink">Catalog</a></div>
|
|
<div class="head2"><a id="ToC_45" name="ToC_45" href="rbafzmstappproc.htm#appproc" class="toclink">Application processes, concurrency, and recovery</a></div>
|
|
<div class="head3"><a id="ToC_46" name="ToC_46" href="rbafzmstappproc.htm#wq16" class="toclink">Locking, commit, and rollback</a></div>
|
|
<div class="head3"><a id="ToC_47" name="ToC_47" href="rbafzmstappproc.htm#wq17" class="toclink">Unit of work</a></div>
|
|
<div class="head3"><a id="ToC_48" name="ToC_48" href="rbafzmstappproc.htm#wq19" class="toclink">Rolling back work</a></div>
|
|
<div class="head3"><a id="ToC_51" name="ToC_51" href="rbafzmstthreads.htm#threads" class="toclink">Threads</a></div>
|
|
<div class="head2"><a id="ToC_52" name="ToC_52" href="rbafzmstisol.htm#isol" class="toclink">Isolation level</a></div>
|
|
<div class="head3"><a id="ToC_53" name="ToC_53" href="rbafzmstisol.htm#wq24" class="toclink">Repeatable read</a></div>
|
|
<div class="head3"><a id="ToC_54" name="ToC_54" href="rbafzmstisol.htm#wq25" class="toclink">Read stability</a></div>
|
|
<div class="head3"><a id="ToC_55" name="ToC_55" href="rbafzmstisol.htm#wq27" class="toclink">Cursor stability</a></div>
|
|
<div class="head3"><a id="ToC_56" name="ToC_56" href="rbafzmstisol.htm#ur" class="toclink">Uncommitted read</a></div>
|
|
<div class="head3"><a id="ToC_57" name="ToC_57" href="rbafzmstisol.htm#wq28" class="toclink">No commit</a></div>
|
|
<div class="head3"><a id="ToC_58" name="ToC_58" href="rbafzmstisol.htm#isollevel" class="toclink">Comparison of isolation levels</a></div>
|
|
<div class="head2"><a id="ToC_59" name="ToC_59" href="rbafzmststoragestruc.htm#storagestruc" class="toclink">Storage Structures</a></div>
|
|
<div class="head2"><a id="ToC_60" name="ToC_60" href="rbafzmstccseta.htm#ccseta" class="toclink">Character conversion</a></div>
|
|
<div class="head3"><a id="ToC_61" name="ToC_61" href="rbafzmstccseta.htm#wq47" class="toclink">Character sets and code pages</a></div>
|
|
<div class="head3"><a id="ToC_62" name="ToC_62" href="rbafzmstccseta.htm#conccsid" class="toclink">Coded character sets and CCSIDs</a></div>
|
|
<div class="head3"><a id="ToC_63" name="ToC_63" href="rbafzmstccseta.htm#wq49" class="toclink">Default CCSID</a></div>
|
|
<div class="head2"><a id="ToC_64" name="ToC_64" href="rbafzmstsortsequence.htm#sortsequence" class="toclink">Sort sequence</a></div>
|
|
<div class="head2"><a id="ToC_65" name="ToC_65" href="rbafzmstch2drda.htm#ch1drda" class="toclink">Distributed relational database</a></div>
|
|
<div class="head3"><a id="ToC_66" name="ToC_66" href="rbafzmstch2drda.htm#wq52" class="toclink">Application servers</a></div>
|
|
<div class="head3"><a id="ToC_67" name="ToC_67" href="rbafzmstch2drda.htm#con2j" class="toclink">CONNECT (Type 1) and CONNECT (Type 2)</a></div>
|
|
<div class="head3"><a id="ToC_68" name="ToC_68" href="rbafzmstch2drda.htm#cmrwj" class="toclink">Remote unit of work</a></div>
|
|
<div class="head3"><a id="ToC_73" name="ToC_73" href="rbafzmstch2drda.htm#adduwmg" class="toclink">Application-directed distributed unit of work</a></div>
|
|
<div class="head3"><a id="ToC_79" name="ToC_79" href="rbafzmstch2drda.htm#drconsider" class="toclink">Data representation considerations</a></div>
|
|
<div class="head1"><a id="ToC_80" name="ToC_80" href="rbafzmstsqlelem.htm#sqlelem" class="toclink">Language elements</a></div>
|
|
<div class="head2"><a id="ToC_81" name="ToC_81" href="rbafzmstch2char.htm#ch2char" class="toclink">Characters</a></div>
|
|
<div class="head2"><a id="ToC_82" name="ToC_82" href="rbafzmstch2tok.htm#ch2tok" class="toclink">Tokens</a></div>
|
|
<div class="head2"><a id="ToC_83" name="ToC_83" href="rbafzmstch2iden.htm#ch2iden" class="toclink">Identifiers</a></div>
|
|
<div class="head3"><a id="ToC_84" name="ToC_84" href="rbafzmstch2iden.htm#sqlidts" class="toclink">SQL identifiers</a></div>
|
|
<div class="head3"><a id="ToC_85" name="ToC_85" href="rbafzmstch2iden.htm#ch2sysident" class="toclink">System identifiers</a></div>
|
|
<div class="head3"><a id="ToC_87" name="ToC_87" href="rbafzmstch2iden.htm#ch2hostiden" class="toclink">Host identifiers</a></div>
|
|
<div class="head2"><a id="ToC_88" name="ToC_88" href="rbafzmstch2nam.htm#ch2nam" class="toclink">Naming conventions</a></div>
|
|
<div class="head3"><a id="ToC_89" name="ToC_89" href="rbafzmstch2nam.htm#path" class="toclink">SQL path</a></div>
|
|
<div class="head3"><a id="ToC_90" name="ToC_90" href="rbafzmstch2nam.htm#qualun" class="toclink">Qualification of unqualified object names</a></div>
|
|
<div class="head3"><a id="ToC_93" name="ToC_93" href="rbafzmstch2nam.htm#wq73" class="toclink">SQL names and system names: special considerations</a></div>
|
|
<div class="head2"><a id="ToC_94" name="ToC_94" href="rbafzmstch2alias.htm#ch2alias" class="toclink">Aliases</a></div>
|
|
<div class="head2"><a id="ToC_95" name="ToC_95" href="rbafzmstch2auth.htm#ch2auth" class="toclink">Authorization IDs and authorization names</a></div>
|
|
<div class="head3"><a id="ToC_96" name="ToC_96" href="rbafzmstch2auth.htm#wq74" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_97" name="ToC_97" href="rbafzmstch2data.htm#ch2data" class="toclink">Data types</a></div>
|
|
<div class="head3"><a id="ToC_98" name="ToC_98" href="rbafzmstch2data.htm#wq76" class="toclink">Nulls</a></div>
|
|
<div class="head3"><a id="ToC_99" name="ToC_99" href="rbafzmstch2data.htm#ch2num" class="toclink">Numbers</a></div>
|
|
<div class="head3"><a id="ToC_107" name="ToC_107" href="rbafzmstch2data.htm#charstrg" class="toclink">Character strings</a></div>
|
|
<div class="head3"><a id="ToC_111" name="ToC_111" href="rbafzmstch2data.htm#charsubtype" class="toclink">Character encoding schemes</a></div>
|
|
<div class="head3"><a id="ToC_112" name="ToC_112" href="rbafzmstch2data.htm#graphicstrg" class="toclink">Graphic strings</a></div>
|
|
<div class="head3"><a id="ToC_116" name="ToC_116" href="rbafzmstch2data.htm#graphicsubtype" class="toclink">Graphic encoding schemes</a></div>
|
|
<div class="head3"><a id="ToC_117" name="ToC_117" href="rbafzmstch2data.htm#binarystrg" class="toclink">Binary strings</a></div>
|
|
<div class="head3"><a id="ToC_121" name="ToC_121" href="rbafzmstch2data.htm#lobs" class="toclink">Large objects</a></div>
|
|
<div class="head3"><a id="ToC_123" name="ToC_123" href="rbafzmstch2data.htm#limstr" class="toclink">Limitations on use of strings</a></div>
|
|
<div class="head3"><a id="ToC_124" name="ToC_124" href="rbafzmstch2data.htm#ch2datetime" class="toclink">Datetime values</a></div>
|
|
<div class="head3"><a id="ToC_133" name="ToC_133" href="rbafzmstch2data.htm#ch2datalink" class="toclink">DataLink values</a></div>
|
|
<div class="head3"><a id="ToC_134" name="ToC_134" href="rbafzmstch2data.htm#ch2rowid" class="toclink">Row ID values</a></div>
|
|
<div class="head3"><a id="ToC_135" name="ToC_135" href="rbafzmstch2data.htm#ch2udf" class="toclink">User-defined types</a></div>
|
|
<div class="head2"><a id="ToC_137" name="ToC_137" href="rbafzmstpromo.htm#promo" class="toclink">Promotion of data types</a></div>
|
|
<div class="head2"><a id="ToC_138" name="ToC_138" href="rbafzmstcastdt.htm#castdt" class="toclink">Casting between data types</a></div>
|
|
<div class="head2"><a id="ToC_139" name="ToC_139" href="rbafzmstch2bas.htm#ch2bas" class="toclink">Assignments and comparisons</a></div>
|
|
<div class="head3"><a id="ToC_140" name="ToC_140" href="rbafzmstch2bas.htm#numass" class="toclink">Numeric assignments</a></div>
|
|
<div class="head3"><a id="ToC_148" name="ToC_148" href="rbafzmstch2bas.htm#charas" class="toclink">String assignments</a></div>
|
|
<div class="head3"><a id="ToC_159" name="ToC_159" href="rbafzmstch2bas.htm#dta" class="toclink">Datetime assignments</a></div>
|
|
<div class="head3"><a id="ToC_160" name="ToC_160" href="rbafzmstch2bas.htm#wq180" class="toclink">DataLink assignments</a></div>
|
|
<div class="head3"><a id="ToC_161" name="ToC_161" href="rbafzmstch2bas.htm#wq183" class="toclink">Row ID assignments</a></div>
|
|
<div class="head3"><a id="ToC_162" name="ToC_162" href="rbafzmstch2bas.htm#udtasgn" class="toclink">Distinct type assignments</a></div>
|
|
<div class="head3"><a id="ToC_165" name="ToC_165" href="rbafzmstch2bas.htm#wq190" class="toclink">Assignments to LOB locators</a></div>
|
|
<div class="head3"><a id="ToC_166" name="ToC_166" href="rbafzmstch2bas.htm#wq191" class="toclink">Numeric comparisons</a></div>
|
|
<div class="head3"><a id="ToC_167" name="ToC_167" href="rbafzmstch2bas.htm#wq192" class="toclink">String comparisons</a></div>
|
|
<div class="head3"><a id="ToC_171" name="ToC_171" href="rbafzmstch2bas.htm#wq215" class="toclink">Datetime comparisons</a></div>
|
|
<div class="head3"><a id="ToC_172" name="ToC_172" href="rbafzmstch2bas.htm#wq216" class="toclink">DataLink comparisons</a></div>
|
|
<div class="head3"><a id="ToC_173" name="ToC_173" href="rbafzmstch2bas.htm#wq217" class="toclink">Row ID comparisons</a></div>
|
|
<div class="head3"><a id="ToC_174" name="ToC_174" href="rbafzmstch2bas.htm#wq218" class="toclink">Distinct type comparisons</a></div>
|
|
<div class="head2"><a id="ToC_175" name="ToC_175" href="rbafzmstopcomb.htm#opcomb" class="toclink">Rules for result data types</a></div>
|
|
<div class="head3"><a id="ToC_176" name="ToC_176" href="rbafzmstopcomb.htm#wq219" class="toclink">Numeric operands</a></div>
|
|
<div class="head3"><a id="ToC_177" name="ToC_177" href="rbafzmstopcomb.htm#wq226" class="toclink">Character and graphic string operands</a></div>
|
|
<div class="head3"><a id="ToC_178" name="ToC_178" href="rbafzmstopcomb.htm#wq231" class="toclink">Binary string operands</a></div>
|
|
<div class="head3"><a id="ToC_179" name="ToC_179" href="rbafzmstopcomb.htm#wq236" class="toclink">Datetime operands</a></div>
|
|
<div class="head3"><a id="ToC_180" name="ToC_180" href="rbafzmstopcomb.htm#wq241" class="toclink">DataLink operands</a></div>
|
|
<div class="head3"><a id="ToC_181" name="ToC_181" href="rbafzmstopcomb.htm#wq246" class="toclink">ROWID operands</a></div>
|
|
<div class="head3"><a id="ToC_182" name="ToC_182" href="rbafzmstopcomb.htm#wq247" class="toclink">Distinct type operands</a></div>
|
|
<div class="head2"><a id="ToC_183" name="ToC_183" href="rbafzmstuuall.htm#uuall" class="toclink">Conversion rules for operations that combine strings</a></div>
|
|
<div class="head2"><a id="ToC_184" name="ToC_184" href="rbafzmstch2cons.htm#ch2cons" class="toclink">Constants</a></div>
|
|
<div class="head3"><a id="ToC_185" name="ToC_185" href="rbafzmstch2cons.htm#wq270" class="toclink">Integer constants</a></div>
|
|
<div class="head3"><a id="ToC_187" name="ToC_187" href="rbafzmstch2cons.htm#wq272" class="toclink">Floating-point constants</a></div>
|
|
<div class="head3"><a id="ToC_189" name="ToC_189" href="rbafzmstch2cons.htm#wq274" class="toclink">Decimal constants</a></div>
|
|
<div class="head3"><a id="ToC_191" name="ToC_191" href="rbafzmstch2cons.htm#wq276" class="toclink">Character-string constants</a></div>
|
|
<div class="head3"><a id="ToC_193" name="ToC_193" href="rbafzmstch2cons.htm#wq278" class="toclink">Graphic-string constants</a></div>
|
|
<div class="head3"><a id="ToC_196" name="ToC_196" href="rbafzmstch2cons.htm#wq282" class="toclink">Binary-string constants</a></div>
|
|
<div class="head3"><a id="ToC_198" name="ToC_198" href="rbafzmstch2cons.htm#wq284" class="toclink">Datetime constants</a></div>
|
|
<div class="head3"><a id="ToC_200" name="ToC_200" href="rbafzmstch2cons.htm#datsep" class="toclink">Decimal point</a></div>
|
|
<div class="head3"><a id="ToC_201" name="ToC_201" href="rbafzmstch2cons.htm#wq288" class="toclink">Delimiters</a></div>
|
|
<div class="head2"><a id="ToC_202" name="ToC_202" href="rbafzmstspecreg.htm#specreg" class="toclink">Special registers</a></div>
|
|
<div class="head3"><a id="ToC_203" name="ToC_203" href="rbafzmstspecreg.htm#c2curdt" class="toclink">CURRENT DATE</a></div>
|
|
<div class="head3"><a id="ToC_205" name="ToC_205" href="rbafzmstspecreg.htm#c2curdbg" class="toclink">CURRENT DEBUG MODE</a></div>
|
|
<div class="head3"><a id="ToC_207" name="ToC_207" href="rbafzmstspecreg.htm#c2curdg" class="toclink">CURRENT DEGREE</a></div>
|
|
<div class="head3"><a id="ToC_209" name="ToC_209" href="rbafzmstspecreg.htm#curpath" class="toclink">CURRENT PATH</a></div>
|
|
<div class="head3"><a id="ToC_211" name="ToC_211" href="rbafzmstspecreg.htm#cursch" class="toclink">CURRENT SCHEMA</a></div>
|
|
<div class="head3"><a id="ToC_213" name="ToC_213" href="rbafzmstspecreg.htm#cursrv" class="toclink">CURRENT SERVER</a></div>
|
|
<div class="head3"><a id="ToC_215" name="ToC_215" href="rbafzmstspecreg.htm#c2curtm" class="toclink">CURRENT TIME</a></div>
|
|
<div class="head3"><a id="ToC_217" name="ToC_217" href="rbafzmstspecreg.htm#c2curts" class="toclink">CURRENT TIMESTAMP</a></div>
|
|
<div class="head3"><a id="ToC_219" name="ToC_219" href="rbafzmstspecreg.htm#c2curtz" class="toclink">CURRENT TIMEZONE</a></div>
|
|
<div class="head3"><a id="ToC_221" name="ToC_221" href="rbafzmstspecreg.htm#ch2sesuser" class="toclink">SESSION_USER</a></div>
|
|
<div class="head3"><a id="ToC_223" name="ToC_223" href="rbafzmstspecreg.htm#ch2sysuser" class="toclink">SYSTEM_USER</a></div>
|
|
<div class="head3"><a id="ToC_225" name="ToC_225" href="rbafzmstspecreg.htm#ch2user" class="toclink">USER</a></div>
|
|
<div class="head2"><a id="ToC_227" name="ToC_227" href="rbafzmstch2col.htm#ch2col" class="toclink">Column names</a></div>
|
|
<div class="head3"><a id="ToC_228" name="ToC_228" href="rbafzmstch2col.htm#cnqua" class="toclink">Qualified column names</a></div>
|
|
<div class="head3"><a id="ToC_229" name="ToC_229" href="rbafzmstch2col.htm#c2cornm" class="toclink">Correlation names</a></div>
|
|
<div class="head3"><a id="ToC_230" name="ToC_230" href="rbafzmstch2col.htm#qcn1" class="toclink">Column name qualifiers to avoid ambiguity</a></div>
|
|
<div class="head3"><a id="ToC_233" name="ToC_233" href="rbafzmstch2col.htm#c2corr" class="toclink">Column name qualifiers in correlated references</a></div>
|
|
<div class="head3"><a id="ToC_234" name="ToC_234" href="rbafzmstch2col.htm#wq316" class="toclink">Unqualified column names in correlated references</a></div>
|
|
<div class="head2"><a id="ToC_235" name="ToC_235" href="rbafzmstch2refvar.htm#ch2refvar" class="toclink">References to variables</a></div>
|
|
<div class="head3"><a id="ToC_236" name="ToC_236" href="rbafzmstch2refvar.htm#ch2host" class="toclink">References to host variables</a></div>
|
|
<div class="head3"><a id="ToC_238" name="ToC_238" href="rbafzmstch2refvar.htm#wq321" class="toclink">Variables in dynamic SQL</a></div>
|
|
<div class="head3"><a id="ToC_239" name="ToC_239" href="rbafzmstch2refvar.htm#wq322" class="toclink">References to LOB variables</a></div>
|
|
<div class="head3"><a id="ToC_240" name="ToC_240" href="rbafzmstch2refvar.htm#rlobloc" class="toclink">References to LOB locator variables</a></div>
|
|
<div class="head3"><a id="ToC_241" name="ToC_241" href="rbafzmstch2refvar.htm#rlobref" class="toclink">References to LOB file reference variables</a></div>
|
|
<div class="head3"><a id="ToC_242" name="ToC_242" href="rbafzmstch2refvar.htm#hscpcj" class="toclink">Host structures</a></div>
|
|
<div class="head3"><a id="ToC_243" name="ToC_243" href="rbafzmstch2refvar.htm#array" class="toclink">Host structure arrays</a></div>
|
|
<div class="head2"><a id="ToC_244" name="ToC_244" href="rbafzmstch2function.htm#ch2function" class="toclink">Functions</a></div>
|
|
<div class="head3"><a id="ToC_245" name="ToC_245" href="rbafzmstch2function.htm#wq325" class="toclink">Types of functions</a></div>
|
|
<div class="head3"><a id="ToC_246" name="ToC_246" href="rbafzmstch2function.htm#funinv2" class="toclink">Function invocation</a></div>
|
|
<div class="head3"><a id="ToC_247" name="ToC_247" href="rbafzmstch2function.htm#funcres" class="toclink">Function resolution</a></div>
|
|
<div class="head3"><a id="ToC_248" name="ToC_248" href="rbafzmstch2function.htm#bestfit" class="toclink">Determining the best fit</a></div>
|
|
<div class="head3"><a id="ToC_249" name="ToC_249" href="rbafzmstch2function.htm#funinv" class="toclink">Best fit considerations</a></div>
|
|
<div class="head2"><a id="ToC_250" name="ToC_250" href="rbafzmstch2expr.htm#ch2expr" class="toclink">Expressions</a></div>
|
|
<div class="head3"><a id="ToC_251" name="ToC_251" href="rbafzmstch2expr.htm#synexpressions" class="toclink">Without operators</a></div>
|
|
<div class="head3"><a id="ToC_253" name="ToC_253" href="rbafzmstch2expr.htm#wq337" class="toclink">With arithmetic operators</a></div>
|
|
<div class="head3"><a id="ToC_263" name="ToC_263" href="rbafzmstch2expr.htm#wtco" class="toclink">With the concatenation operator</a></div>
|
|
<div class="head3"><a id="ToC_265" name="ToC_265" href="rbafzmstch2expr.htm#scalarsubs" class="toclink">Scalar fullselect</a></div>
|
|
<div class="head3"><a id="ToC_266" name="ToC_266" href="rbafzmstch2expr.htm#dtdur" class="toclink">Datetime operands and durations</a></div>
|
|
<div class="head3"><a id="ToC_267" name="ToC_267" href="rbafzmstdatetimearith.htm#datetimearith" class="toclink">Datetime arithmetic in SQL</a></div>
|
|
<div class="head3"><a id="ToC_277" name="ToC_277" href="rbafzmstdatetimearith.htm#wq371" class="toclink">Precedence of operations</a></div>
|
|
<div class="head3"><a id="ToC_278" name="ToC_278" href="rbafzmstdatetimearith.htm#caseexp" class="toclink">CASE expressions</a></div>
|
|
<div class="head3"><a id="ToC_280" name="ToC_280" href="rbafzmstdatetimearith.htm#cast" class="toclink">CAST specification</a></div>
|
|
<div class="head3"><a id="ToC_282" name="ToC_282" href="rbafzmstdatetimearith.htm#olapexp" class="toclink">OLAP specifications</a></div>
|
|
<div class="head3"><a id="ToC_285" name="ToC_285" href="rbafzmstdatetimearith.htm#seqref" class="toclink">Sequence reference</a></div>
|
|
<div class="head2"><a id="ToC_288" name="ToC_288" href="rbafzmstch2pred.htm#ch2pred" class="toclink">Predicates</a></div>
|
|
<div class="head3"><a id="ToC_289" name="ToC_289" href="rbafzmstch2pred.htm#baspred" class="toclink">Basic predicate</a></div>
|
|
<div class="head3"><a id="ToC_291" name="ToC_291" href="rbafzmstch2pred.htm#wq392" class="toclink">Quantified predicate</a></div>
|
|
<div class="head3"><a id="ToC_293" name="ToC_293" href="rbafzmstch2pred.htm#wq397" class="toclink">BETWEEN predicate</a></div>
|
|
<div class="head3"><a id="ToC_295" name="ToC_295" href="rbafzmstch2pred.htm#wq400" class="toclink">DISTINCT predicate</a></div>
|
|
<div class="head3"><a id="ToC_297" name="ToC_297" href="rbafzmstch2pred.htm#wq411" class="toclink">EXISTS predicate</a></div>
|
|
<div class="head3"><a id="ToC_299" name="ToC_299" href="rbafzmstch2pred.htm#wq414" class="toclink">IN predicate</a></div>
|
|
<div class="head3"><a id="ToC_301" name="ToC_301" href="rbafzmstch2pred.htm#ch2like" class="toclink">LIKE predicate</a></div>
|
|
<div class="head3"><a id="ToC_309" name="ToC_309" href="rbafzmstch2pred.htm#wq440" class="toclink">NULL predicate</a></div>
|
|
<div class="head2"><a id="ToC_311" name="ToC_311" href="rbafzmstch2srch.htm#ch2srch" class="toclink">Search conditions</a></div>
|
|
<div class="head3"><a id="ToC_312" name="ToC_312" href="rbafzmstch2srch.htm#wq448" class="toclink">Examples</a></div>
|
|
<div class="head1"><a id="ToC_315" name="ToC_315" href="rbafzmstch2func.htm#ch2func" class="toclink">Built-in functions</a></div>
|
|
<div class="head2"><a id="ToC_316" name="ToC_316" href="rbafzmstcolfunc.htm#colfunc" class="toclink">Aggregate functions</a></div>
|
|
<div class="head3"><a id="ToC_317" name="ToC_317" href="rbafzmstcolfunc.htm#avg" class="toclink">AVG</a></div>
|
|
<div class="head3"><a id="ToC_319" name="ToC_319" href="rbafzmstcolfunc.htm#count" class="toclink">COUNT</a></div>
|
|
<div class="head3"><a id="ToC_321" name="ToC_321" href="rbafzmstcolfunc.htm#countbig" class="toclink">COUNT_BIG</a></div>
|
|
<div class="head3"><a id="ToC_323" name="ToC_323" href="rbafzmstcolfunc.htm#colmax" class="toclink">MAX</a></div>
|
|
<div class="head3"><a id="ToC_325" name="ToC_325" href="rbafzmstcolfunc.htm#colmin" class="toclink">MIN</a></div>
|
|
<div class="head3"><a id="ToC_327" name="ToC_327" href="rbafzmstcolfunc.htm#colstddev" class="toclink">STDDEV_POP or STDDEV</a></div>
|
|
<div class="head3"><a id="ToC_330" name="ToC_330" href="rbafzmstcolfunc.htm#colstddevsamp" class="toclink">STDDEV_SAMP</a></div>
|
|
<div class="head3"><a id="ToC_332" name="ToC_332" href="rbafzmstcolfunc.htm#colsum" class="toclink">SUM</a></div>
|
|
<div class="head3"><a id="ToC_334" name="ToC_334" href="rbafzmstcolfunc.htm#colvar" class="toclink">VAR_POP or VARIANCE or VAR</a></div>
|
|
<div class="head3"><a id="ToC_337" name="ToC_337" href="rbafzmstcolfunc.htm#colvarsamp" class="toclink">VARIANCE_SAMP or VAR_SAMP</a></div>
|
|
<div class="head2"><a id="ToC_340" name="ToC_340" href="rbafzmstscale.htm#scale" class="toclink">Scalar functions</a></div>
|
|
<div class="head3"><a id="ToC_341" name="ToC_341" href="rbafzmstscale.htm#wq506" class="toclink">Example</a></div>
|
|
<div class="head3"><a id="ToC_342" name="ToC_342" href="rbafzmstscale.htm#scaabs" class="toclink">ABS</a></div>
|
|
<div class="head3"><a id="ToC_345" name="ToC_345" href="rbafzmstscale.htm#scaacos" class="toclink">ACOS</a></div>
|
|
<div class="head3"><a id="ToC_347" name="ToC_347" href="rbafzmstscale.htm#scaaddmonths" class="toclink">ADD_MONTHS</a></div>
|
|
<div class="head3"><a id="ToC_349" name="ToC_349" href="rbafzmstscale.htm#scaantilog" class="toclink">ANTILOG</a></div>
|
|
<div class="head3"><a id="ToC_351" name="ToC_351" href="rbafzmstscale.htm#scaasin" class="toclink">ASIN</a></div>
|
|
<div class="head3"><a id="ToC_353" name="ToC_353" href="rbafzmstscale.htm#scaatan" class="toclink">ATAN</a></div>
|
|
<div class="head3"><a id="ToC_355" name="ToC_355" href="rbafzmstscale.htm#scaatanh" class="toclink">ATANH</a></div>
|
|
<div class="head3"><a id="ToC_357" name="ToC_357" href="rbafzmstscale.htm#scaatan2" class="toclink">ATAN2</a></div>
|
|
<div class="head3"><a id="ToC_359" name="ToC_359" href="rbafzmstscale.htm#bigfunc" class="toclink">BIGINT</a></div>
|
|
<div class="head3"><a id="ToC_362" name="ToC_362" href="rbafzmstscale.htm#scabinary" class="toclink">BINARY</a></div>
|
|
<div class="head3"><a id="ToC_365" name="ToC_365" href="rbafzmstscale.htm#scabitlen" class="toclink">BIT_LENGTH</a></div>
|
|
<div class="head3"><a id="ToC_367" name="ToC_367" href="rbafzmstscale.htm#scablob" class="toclink">BLOB</a></div>
|
|
<div class="head3"><a id="ToC_370" name="ToC_370" href="rbafzmstscale.htm#scaceiling" class="toclink">CEILING</a></div>
|
|
<div class="head3"><a id="ToC_372" name="ToC_372" href="rbafzmstscale.htm#scachar" class="toclink">CHAR</a></div>
|
|
<div class="head3"><a id="ToC_375" name="ToC_375" href="rbafzmstscale.htm#charlenf" class="toclink">CHARACTER_LENGTH</a></div>
|
|
<div class="head3"><a id="ToC_377" name="ToC_377" href="rbafzmstscale.htm#scaclob" class="toclink">CLOB</a></div>
|
|
<div class="head3"><a id="ToC_380" name="ToC_380" href="rbafzmstscale.htm#scacoales" class="toclink">COALESCE</a></div>
|
|
<div class="head3"><a id="ToC_382" name="ToC_382" href="rbafzmstscale.htm#scaconcat" class="toclink">CONCAT</a></div>
|
|
<div class="head3"><a id="ToC_385" name="ToC_385" href="rbafzmstscale.htm#scacos" class="toclink">COS</a></div>
|
|
<div class="head3"><a id="ToC_387" name="ToC_387" href="rbafzmstscale.htm#scacosh" class="toclink">COSH</a></div>
|
|
<div class="head3"><a id="ToC_389" name="ToC_389" href="rbafzmstscale.htm#scacot" class="toclink">COT</a></div>
|
|
<div class="head3"><a id="ToC_391" name="ToC_391" href="rbafzmstscale.htm#scacurdate" class="toclink">CURDATE</a></div>
|
|
<div class="head3"><a id="ToC_394" name="ToC_394" href="rbafzmstscale.htm#scacurtime" class="toclink">CURTIME</a></div>
|
|
<div class="head3"><a id="ToC_397" name="ToC_397" href="rbafzmstscale.htm#scadatabase" class="toclink">DATABASE</a></div>
|
|
<div class="head3"><a id="ToC_400" name="ToC_400" href="rbafzmstscale.htm#scadataname" class="toclink">DATAPARTITIONNAME</a></div>
|
|
<div class="head3"><a id="ToC_402" name="ToC_402" href="rbafzmstscale.htm#scadatanumb" class="toclink">DATAPARTITIONNUM</a></div>
|
|
<div class="head3"><a id="ToC_404" name="ToC_404" href="rbafzmstscale.htm#scadate" class="toclink">DATE</a></div>
|
|
<div class="head3"><a id="ToC_407" name="ToC_407" href="rbafzmstscale.htm#dayfunc" class="toclink">DAY</a></div>
|
|
<div class="head3"><a id="ToC_409" name="ToC_409" href="rbafzmstscale.htm#scadayname" class="toclink">DAYNAME</a></div>
|
|
<div class="head3"><a id="ToC_412" name="ToC_412" href="rbafzmstscale.htm#scadofmonth" class="toclink">DAYOFMONTH</a></div>
|
|
<div class="head3"><a id="ToC_414" name="ToC_414" href="rbafzmstscale.htm#scadofweek" class="toclink">DAYOFWEEK</a></div>
|
|
<div class="head3"><a id="ToC_416" name="ToC_416" href="rbafzmstscale.htm#scaisodweek" class="toclink">DAYOFWEEK_ISO</a></div>
|
|
<div class="head3"><a id="ToC_418" name="ToC_418" href="rbafzmstscale.htm#scadofyear" class="toclink">DAYOFYEAR</a></div>
|
|
<div class="head3"><a id="ToC_420" name="ToC_420" href="rbafzmstscale.htm#scadays" class="toclink">DAYS</a></div>
|
|
<div class="head3"><a id="ToC_422" name="ToC_422" href="rbafzmstscale.htm#scadbclob" class="toclink">DBCLOB</a></div>
|
|
<div class="head3"><a id="ToC_425" name="ToC_425" href="rbafzmstscale.htm#scanodename" class="toclink">DBPARTITIONNAME</a></div>
|
|
<div class="head3"><a id="ToC_428" name="ToC_428" href="rbafzmstscale.htm#scandnumb" class="toclink">DBPARTITIONNUM</a></div>
|
|
<div class="head3"><a id="ToC_431" name="ToC_431" href="rbafzmstscale.htm#scadec" class="toclink">DECIMAL or DEC</a></div>
|
|
<div class="head3"><a id="ToC_434" name="ToC_434" href="rbafzmstscale.htm#scadecrypt" class="toclink">DECRYPT_BIT, DECRYPT_BINARY, DECRYPT_CHAR and DECRYPT_DB</a></div>
|
|
<div class="head3"><a id="ToC_437" name="ToC_437" href="rbafzmstscale.htm#scadegree" class="toclink">DEGREES</a></div>
|
|
<div class="head3"><a id="ToC_439" name="ToC_439" href="rbafzmstscale.htm#difffun" class="toclink">DIFFERENCE</a></div>
|
|
<div class="head3"><a id="ToC_441" name="ToC_441" href="rbafzmstscale.htm#scadigits" class="toclink">DIGITS</a></div>
|
|
<div class="head3"><a id="ToC_443" name="ToC_443" href="rbafzmstscale.htm#scadlcomment" class="toclink">DLCOMMENT</a></div>
|
|
<div class="head3"><a id="ToC_445" name="ToC_445" href="rbafzmstscale.htm#scadllktype" class="toclink">DLLINKTYPE</a></div>
|
|
<div class="head3"><a id="ToC_447" name="ToC_447" href="rbafzmstscale.htm#scadlurlcomp" class="toclink">DLURLCOMPLETE</a></div>
|
|
<div class="head3"><a id="ToC_449" name="ToC_449" href="rbafzmstscale.htm#scadlurlpath" class="toclink">DLURLPATH</a></div>
|
|
<div class="head3"><a id="ToC_451" name="ToC_451" href="rbafzmstscale.htm#scadlurlponly" class="toclink">DLURLPATHONLY</a></div>
|
|
<div class="head3"><a id="ToC_453" name="ToC_453" href="rbafzmstscale.htm#scadlurlschem" class="toclink">DLURLSCHEME</a></div>
|
|
<div class="head3"><a id="ToC_455" name="ToC_455" href="rbafzmstscale.htm#scadlserver" class="toclink">DLURLSERVER</a></div>
|
|
<div class="head3"><a id="ToC_457" name="ToC_457" href="rbafzmstscale.htm#scadlvalue" class="toclink">DLVALUE</a></div>
|
|
<div class="head3"><a id="ToC_459" name="ToC_459" href="rbafzmstscale.htm#dblprc" class="toclink">DOUBLE_PRECISION or DOUBLE</a></div>
|
|
<div class="head3"><a id="ToC_462" name="ToC_462" href="rbafzmstscale.htm#scaencrypt" class="toclink">ENCRYPT_RC2</a></div>
|
|
<div class="head3"><a id="ToC_465" name="ToC_465" href="rbafzmstscale.htm#scaencrypttdes" class="toclink">ENCRYPT_TDES</a></div>
|
|
<div class="head3"><a id="ToC_468" name="ToC_468" href="rbafzmstscale.htm#scaexp" class="toclink">EXP</a></div>
|
|
<div class="head3"><a id="ToC_470" name="ToC_470" href="rbafzmstscale.htm#scaextract" class="toclink">EXTRACT</a></div>
|
|
<div class="head3"><a id="ToC_472" name="ToC_472" href="rbafzmstscale.htm#fltfunc" class="toclink">FLOAT</a></div>
|
|
<div class="head3"><a id="ToC_473" name="ToC_473" href="rbafzmstscale.htm#scafloor" class="toclink">FLOOR</a></div>
|
|
<div class="head3"><a id="ToC_475" name="ToC_475" href="rbafzmstscale.htm#scagenerateunique" class="toclink">GENERATE_UNIQUE</a></div>
|
|
<div class="head3"><a id="ToC_477" name="ToC_477" href="rbafzmstscale.htm#scagethint" class="toclink">GETHINT</a></div>
|
|
<div class="head3"><a id="ToC_479" name="ToC_479" href="rbafzmstscale.htm#scagraphic" class="toclink">GRAPHIC</a></div>
|
|
<div class="head3"><a id="ToC_482" name="ToC_482" href="rbafzmstscale.htm#scahash" class="toclink">HASH</a></div>
|
|
<div class="head3"><a id="ToC_484" name="ToC_484" href="rbafzmstscale.htm#scapartition" class="toclink">HASHED_VALUE</a></div>
|
|
<div class="head3"><a id="ToC_487" name="ToC_487" href="rbafzmstscale.htm#scahex" class="toclink">HEX</a></div>
|
|
<div class="head3"><a id="ToC_489" name="ToC_489" href="rbafzmstscale.htm#scahour" class="toclink">HOUR</a></div>
|
|
<div class="head3"><a id="ToC_491" name="ToC_491" href="rbafzmstscale.htm#scaidentity" class="toclink">IDENTITY_VAL_LOCAL</a></div>
|
|
<div class="head3"><a id="ToC_494" name="ToC_494" href="rbafzmstscale.htm#scaifnull" class="toclink">IFNULL</a></div>
|
|
<div class="head3"><a id="ToC_496" name="ToC_496" href="rbafzmstscale.htm#scainsert" class="toclink">INSERT</a></div>
|
|
<div class="head3"><a id="ToC_498" name="ToC_498" href="rbafzmstscale.htm#intfunc" class="toclink">INTEGER or INT</a></div>
|
|
<div class="head3"><a id="ToC_501" name="ToC_501" href="rbafzmstscale.htm#scajulian" class="toclink">JULIAN_DAY</a></div>
|
|
<div class="head3"><a id="ToC_503" name="ToC_503" href="rbafzmstscale.htm#scaland" class="toclink">LAND</a></div>
|
|
<div class="head3"><a id="ToC_505" name="ToC_505" href="rbafzmstscale.htm#scalastday" class="toclink">LAST_DAY</a></div>
|
|
<div class="head3"><a id="ToC_507" name="ToC_507" href="rbafzmstscale.htm#scalcase" class="toclink">LCASE</a></div>
|
|
<div class="head3"><a id="ToC_508" name="ToC_508" href="rbafzmstscale.htm#scaleft" class="toclink">LEFT</a></div>
|
|
<div class="head3"><a id="ToC_510" name="ToC_510" href="rbafzmstscale.htm#scalength" class="toclink">LENGTH</a></div>
|
|
<div class="head3"><a id="ToC_512" name="ToC_512" href="rbafzmstscale.htm#scaln" class="toclink">LN</a></div>
|
|
<div class="head3"><a id="ToC_514" name="ToC_514" href="rbafzmstscale.htm#scalnot" class="toclink">LNOT</a></div>
|
|
<div class="head3"><a id="ToC_516" name="ToC_516" href="rbafzmstscale.htm#locate" class="toclink">LOCATE</a></div>
|
|
<div class="head3"><a id="ToC_518" name="ToC_518" href="rbafzmstscale.htm#scalog" class="toclink">LOG10</a></div>
|
|
<div class="head3"><a id="ToC_521" name="ToC_521" href="rbafzmstscale.htm#scalor" class="toclink">LOR</a></div>
|
|
<div class="head3"><a id="ToC_523" name="ToC_523" href="rbafzmstscale.htm#scalower" class="toclink">LOWER</a></div>
|
|
<div class="head3"><a id="ToC_526" name="ToC_526" href="rbafzmstscale.htm#scaltrim" class="toclink">LTRIM</a></div>
|
|
<div class="head3"><a id="ToC_528" name="ToC_528" href="rbafzmstscale.htm#scamax" class="toclink">MAX</a></div>
|
|
<div class="head3"><a id="ToC_530" name="ToC_530" href="rbafzmstscale.htm#scamicro" class="toclink">MICROSECOND</a></div>
|
|
<div class="head3"><a id="ToC_532" name="ToC_532" href="rbafzmstscale.htm#scamidnight" class="toclink">MIDNIGHT_SECONDS</a></div>
|
|
<div class="head3"><a id="ToC_534" name="ToC_534" href="rbafzmstscale.htm#scamin" class="toclink">MIN</a></div>
|
|
<div class="head3"><a id="ToC_536" name="ToC_536" href="rbafzmstscale.htm#scaminute" class="toclink">MINUTE</a></div>
|
|
<div class="head3"><a id="ToC_538" name="ToC_538" href="rbafzmstscale.htm#scamod" class="toclink">MOD</a></div>
|
|
<div class="head3"><a id="ToC_540" name="ToC_540" href="rbafzmstscale.htm#scamonth" class="toclink">MONTH</a></div>
|
|
<div class="head3"><a id="ToC_542" name="ToC_542" href="rbafzmstscale.htm#scamname" class="toclink">MONTHNAME</a></div>
|
|
<div class="head3"><a id="ToC_545" name="ToC_545" href="rbafzmstscale.htm#scamultalt" class="toclink">MULTIPLY_ALT</a></div>
|
|
<div class="head3"><a id="ToC_547" name="ToC_547" href="rbafzmstscale.htm#scanextday" class="toclink">NEXT_DAY</a></div>
|
|
<div class="head3"><a id="ToC_550" name="ToC_550" href="rbafzmstscale.htm#scanow" class="toclink">NOW</a></div>
|
|
<div class="head3"><a id="ToC_553" name="ToC_553" href="rbafzmstscale.htm#nullif" class="toclink">NULLIF</a></div>
|
|
<div class="head3"><a id="ToC_555" name="ToC_555" href="rbafzmstscale.htm#scaoctetlen" class="toclink">OCTET_LENGTH</a></div>
|
|
<div class="head3"><a id="ToC_557" name="ToC_557" href="rbafzmstscale.htm#scapi" class="toclink">PI</a></div>
|
|
<div class="head3"><a id="ToC_559" name="ToC_559" href="rbafzmstscale.htm#posstr" class="toclink">POSITION or POSSTR</a></div>
|
|
<div class="head3"><a id="ToC_561" name="ToC_561" href="rbafzmstscale.htm#scapower" class="toclink">POWER</a></div>
|
|
<div class="head3"><a id="ToC_563" name="ToC_563" href="rbafzmstscale.htm#scaquarter" class="toclink">QUARTER</a></div>
|
|
<div class="head3"><a id="ToC_565" name="ToC_565" href="rbafzmstscale.htm#scaradians" class="toclink">RADIANS</a></div>
|
|
<div class="head3"><a id="ToC_567" name="ToC_567" href="rbafzmstscale.htm#scaraiseerror" class="toclink">RAISE_ERROR</a></div>
|
|
<div class="head3"><a id="ToC_569" name="ToC_569" href="rbafzmstscale.htm#scarand" class="toclink">RAND</a></div>
|
|
<div class="head3"><a id="ToC_571" name="ToC_571" href="rbafzmstscale.htm#realfun" class="toclink">REAL</a></div>
|
|
<div class="head3"><a id="ToC_574" name="ToC_574" href="rbafzmstscale.htm#scarepeat" class="toclink">REPEAT</a></div>
|
|
<div class="head3"><a id="ToC_576" name="ToC_576" href="rbafzmstscale.htm#scareplace" class="toclink">REPLACE</a></div>
|
|
<div class="head3"><a id="ToC_578" name="ToC_578" href="rbafzmstscale.htm#scaright" class="toclink">RIGHT</a></div>
|
|
<div class="head3"><a id="ToC_580" name="ToC_580" href="rbafzmstscale.htm#scaround" class="toclink">ROUND</a></div>
|
|
<div class="head3"><a id="ToC_582" name="ToC_582" href="rbafzmstscale.htm#scarowid" class="toclink">ROWID</a></div>
|
|
<div class="head3"><a id="ToC_585" name="ToC_585" href="rbafzmstscale.htm#scarrn" class="toclink">RRN</a></div>
|
|
<div class="head3"><a id="ToC_587" name="ToC_587" href="rbafzmstscale.htm#scartrim" class="toclink">RTRIM</a></div>
|
|
<div class="head3"><a id="ToC_589" name="ToC_589" href="rbafzmstscale.htm#scasec" class="toclink">SECOND</a></div>
|
|
<div class="head3"><a id="ToC_591" name="ToC_591" href="rbafzmstscale.htm#scasign" class="toclink">SIGN</a></div>
|
|
<div class="head3"><a id="ToC_593" name="ToC_593" href="rbafzmstscale.htm#scasin" class="toclink">SIN</a></div>
|
|
<div class="head3"><a id="ToC_595" name="ToC_595" href="rbafzmstscale.htm#scasinh" class="toclink">SINH</a></div>
|
|
<div class="head3"><a id="ToC_597" name="ToC_597" href="rbafzmstscale.htm#smifunc" class="toclink">SMALLINT</a></div>
|
|
<div class="head3"><a id="ToC_600" name="ToC_600" href="rbafzmstscale.htm#scasound" class="toclink">SOUNDEX</a></div>
|
|
<div class="head3"><a id="ToC_602" name="ToC_602" href="rbafzmstscale.htm#scaspace" class="toclink">SPACE</a></div>
|
|
<div class="head3"><a id="ToC_604" name="ToC_604" href="rbafzmstscale.htm#scasqrt" class="toclink">SQRT</a></div>
|
|
<div class="head3"><a id="ToC_606" name="ToC_606" href="rbafzmstscale.htm#strpfun" class="toclink">STRIP</a></div>
|
|
<div class="head3"><a id="ToC_607" name="ToC_607" href="rbafzmstscale.htm#scasubstr" class="toclink">SUBSTRING or SUBSTR</a></div>
|
|
<div class="head3"><a id="ToC_609" name="ToC_609" href="rbafzmstscale.htm#scatan" class="toclink">TAN</a></div>
|
|
<div class="head3"><a id="ToC_611" name="ToC_611" href="rbafzmstscale.htm#scatanh" class="toclink">TANH</a></div>
|
|
<div class="head3"><a id="ToC_613" name="ToC_613" href="rbafzmstscale.htm#scatime" class="toclink">TIME</a></div>
|
|
<div class="head3"><a id="ToC_616" name="ToC_616" href="rbafzmstscale.htm#scatimestamp" class="toclink">TIMESTAMP</a></div>
|
|
<div class="head3"><a id="ToC_619" name="ToC_619" href="rbafzmstscale.htm#scaisotmsp" class="toclink">TIMESTAMP_ISO</a></div>
|
|
<div class="head3"><a id="ToC_622" name="ToC_622" href="rbafzmstscale.htm#scatimedifstmp" class="toclink">TIMESTAMPDIFF</a></div>
|
|
<div class="head3"><a id="ToC_624" name="ToC_624" href="rbafzmstscale.htm#scatrans" class="toclink">TRANSLATE</a></div>
|
|
<div class="head3"><a id="ToC_626" name="ToC_626" href="rbafzmstscale.htm#trimfun" class="toclink">TRIM</a></div>
|
|
<div class="head3"><a id="ToC_628" name="ToC_628" href="rbafzmstscale.htm#scatrunc" class="toclink">TRUNCATE or TRUNC</a></div>
|
|
<div class="head3"><a id="ToC_630" name="ToC_630" href="rbafzmstscale.htm#scaucase" class="toclink">UCASE</a></div>
|
|
<div class="head3"><a id="ToC_631" name="ToC_631" href="rbafzmstscale.htm#scaupper" class="toclink">UPPER</a></div>
|
|
<div class="head3"><a id="ToC_634" name="ToC_634" href="rbafzmstscale.htm#scavalue" class="toclink">VALUE</a></div>
|
|
<div class="head3"><a id="ToC_636" name="ToC_636" href="rbafzmstscale.htm#scavarbinary" class="toclink">VARBINARY</a></div>
|
|
<div class="head3"><a id="ToC_639" name="ToC_639" href="rbafzmstscale.htm#scavarchar" class="toclink">VARCHAR</a></div>
|
|
<div class="head3"><a id="ToC_642" name="ToC_642" href="rbafzmstscale.htm#scavarcharformat" class="toclink">VARCHAR_FORMAT</a></div>
|
|
<div class="head3"><a id="ToC_645" name="ToC_645" href="rbafzmstscale.htm#scavargraph" class="toclink">VARGRAPHIC</a></div>
|
|
<div class="head3"><a id="ToC_648" name="ToC_648" href="rbafzmstscale.htm#scaweek" class="toclink">WEEK</a></div>
|
|
<div class="head3"><a id="ToC_650" name="ToC_650" href="rbafzmstscale.htm#scaisoweek" class="toclink">WEEK_ISO</a></div>
|
|
<div class="head3"><a id="ToC_652" name="ToC_652" href="rbafzmstscale.htm#scaxor" class="toclink">XOR</a></div>
|
|
<div class="head3"><a id="ToC_654" name="ToC_654" href="rbafzmstscale.htm#scayear" class="toclink">YEAR</a></div>
|
|
<div class="head3"><a id="ToC_656" name="ToC_656" href="rbafzmstscale.htm#scazoned" class="toclink">ZONED</a></div>
|
|
<div class="head1"><a id="ToC_659" name="ToC_659" href="rbafzmstsubsel.htm#subsel" class="toclink">Queries</a></div>
|
|
<div class="head2"><a id="ToC_660" name="ToC_660" href="rbafzmstqueryauth1.htm#queryauth1" class="toclink">Authorization</a></div>
|
|
<div class="head2"><a id="ToC_661" name="ToC_661" href="rbafzmstsubselect.htm#subselect" class="toclink">subselect</a></div>
|
|
<div class="head3"><a id="ToC_662" name="ToC_662" href="rbafzmstsubselect.htm#wq923" class="toclink">select-clause</a></div>
|
|
<div class="head3"><a id="ToC_670" name="ToC_670" href="rbafzmstsubselect.htm#fromclause" class="toclink">from-clause</a></div>
|
|
<div class="head3"><a id="ToC_679" name="ToC_679" href="rbafzmstsubselect.htm#wq941" class="toclink">where-clause</a></div>
|
|
<div class="head3"><a id="ToC_680" name="ToC_680" href="rbafzmstsubselect.htm#wq943" class="toclink">group-by-clause</a></div>
|
|
<div class="head3"><a id="ToC_681" name="ToC_681" href="rbafzmstsubselect.htm#havecl" class="toclink">having-clause</a></div>
|
|
<div class="head3"><a id="ToC_682" name="ToC_682" href="rbafzmstsubselect.htm#selctex" class="toclink">Examples of a subselect</a></div>
|
|
<div class="head2"><a id="ToC_691" name="ToC_691" href="rbafzmstmark.htm#mark" class="toclink">fullselect</a></div>
|
|
<div class="head3"><a id="ToC_692" name="ToC_692" href="rbafzmstmark.htm#irfrcol" class="toclink">Rules for columns</a></div>
|
|
<div class="head3"><a id="ToC_693" name="ToC_693" href="rbafzmstmark.htm#wq964" class="toclink">Examples of a fullselect</a></div>
|
|
<div class="head2"><a id="ToC_700" name="ToC_700" href="rbafzmstintsel.htm#intsel" class="toclink">select-statement</a></div>
|
|
<div class="head3"><a id="ToC_701" name="ToC_701" href="rbafzmstintsel.htm#comtexp" class="toclink">common-table-expression</a></div>
|
|
<div class="head3"><a id="ToC_706" name="ToC_706" href="rbafzmstintsel.htm#orderby" class="toclink">order-by-clause</a></div>
|
|
<div class="head3"><a id="ToC_707" name="ToC_707" href="rbafzmstintsel.htm#fetchfirst" class="toclink">fetch-first-clause</a></div>
|
|
<div class="head3"><a id="ToC_708" name="ToC_708" href="rbafzmstintsel.htm#updateclause" class="toclink">update-clause</a></div>
|
|
<div class="head3"><a id="ToC_709" name="ToC_709" href="rbafzmstintsel.htm#readonly" class="toclink">read-only-clause</a></div>
|
|
<div class="head3"><a id="ToC_710" name="ToC_710" href="rbafzmstintsel.htm#optimize" class="toclink">optimize-clause</a></div>
|
|
<div class="head3"><a id="ToC_711" name="ToC_711" href="rbafzmstintsel.htm#isocl" class="toclink">isolation-clause</a></div>
|
|
<div class="head3"><a id="ToC_712" name="ToC_712" href="rbafzmstintsel.htm#wq984" class="toclink">Examples of a select-statement</a></div>
|
|
<div class="head1"><a id="ToC_721" name="ToC_721" href="rbafzmststates.htm#states" class="toclink">Statements</a></div>
|
|
<div class="head2"><a id="ToC_722" name="ToC_722" href="rbafzmsthowsql.htm#howsql" class="toclink">How SQL statements are invoked</a></div>
|
|
<div class="head3"><a id="ToC_723" name="ToC_723" href="rbafzmsthowsql.htm#wq1021" class="toclink">Embedding a statement in an application program</a></div>
|
|
<div class="head3"><a id="ToC_726" name="ToC_726" href="rbafzmsthowsql.htm#wq1024" class="toclink">Dynamic preparation and execution</a></div>
|
|
<div class="head3"><a id="ToC_727" name="ToC_727" href="rbafzmsthowsql.htm#wq1025" class="toclink">Static invocation of a select-statement</a></div>
|
|
<div class="head3"><a id="ToC_728" name="ToC_728" href="rbafzmsthowsql.htm#wq1026" class="toclink">Dynamic invocation of a select-statement</a></div>
|
|
<div class="head3"><a id="ToC_729" name="ToC_729" href="rbafzmsthowsql.htm#wq1027" class="toclink">Interactive invocation</a></div>
|
|
<div class="head2"><a id="ToC_730" name="ToC_730" href="rbafzmstcksql.htm#cksql" class="toclink">SQL return codes</a></div>
|
|
<div class="head3"><a id="ToC_731" name="ToC_731" href="rbafzmstcksql.htm#wq1028" class="toclink">SQLSTATE</a></div>
|
|
<div class="head3"><a id="ToC_732" name="ToC_732" href="rbafzmstcksql.htm#wq1029" class="toclink">SQLCODE</a></div>
|
|
<div class="head2"><a id="ToC_733" name="ToC_733" href="rbafzmstsqcomm.htm#sqcomm" class="toclink">SQL comments</a></div>
|
|
<div class="head2"><a id="ToC_734" name="ToC_734" href="rbafzallocatedescr.htm#allocatedescr" class="toclink">ALLOCATE DESCRIPTOR</a></div>
|
|
<div class="head3"><a id="ToC_735" name="ToC_735" href="rbafzallocatedescr.htm#wq1030" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_736" name="ToC_736" href="rbafzallocatedescr.htm#wq1031" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_737" name="ToC_737" href="rbafzallocatedescr.htm#wq1032" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_738" name="ToC_738" href="rbafzallocatedescr.htm#synallocatedescr" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_739" name="ToC_739" href="rbafzallocatedescr.htm#wq1033" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_740" name="ToC_740" href="rbafzallocatedescr.htm#wq1034" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_741" name="ToC_741" href="rbafzmstaproceduree.htm#aproceduree" class="toclink">ALTER PROCEDURE (External)</a></div>
|
|
<div class="head3"><a id="ToC_742" name="ToC_742" href="rbafzmstaproceduree.htm#wq1035" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_743" name="ToC_743" href="rbafzmstaproceduree.htm#wq1036" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_744" name="ToC_744" href="rbafzmstaproceduree.htm#wq1037" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_745" name="ToC_745" href="rbafzmstaproceduree.htm#synaeprocedure" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_746" name="ToC_746" href="rbafzmstaproceduree.htm#wq1045" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_747" name="ToC_747" href="rbafzmstaproceduree.htm#wq1046" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_748" name="ToC_748" href="rbafzmstaprocedures.htm#aprocedures" class="toclink">ALTER PROCEDURE (SQL)</a></div>
|
|
<div class="head3"><a id="ToC_749" name="ToC_749" href="rbafzmstaprocedures.htm#wq1047" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_750" name="ToC_750" href="rbafzmstaprocedures.htm#wq1048" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_751" name="ToC_751" href="rbafzmstaprocedures.htm#wq1049" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_752" name="ToC_752" href="rbafzmstaprocedures.htm#synasprocedure" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_753" name="ToC_753" href="rbafzmstaprocedures.htm#wq1054" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_754" name="ToC_754" href="rbafzmstaprocedures.htm#wq1055" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_755" name="ToC_755" href="rbafzmstasequence.htm#asequence" class="toclink">ALTER SEQUENCE</a></div>
|
|
<div class="head3"><a id="ToC_756" name="ToC_756" href="rbafzmstasequence.htm#wq1056" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_757" name="ToC_757" href="rbafzmstasequence.htm#wq1057" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_758" name="ToC_758" href="rbafzmstasequence.htm#wq1058" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_759" name="ToC_759" href="rbafzmstasequence.htm#synasequence" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_760" name="ToC_760" href="rbafzmstasequence.htm#wq1063" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_761" name="ToC_761" href="rbafzmstasequence.htm#wq1064" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_762" name="ToC_762" href="rbafzmstatabl.htm#atabl" class="toclink">ALTER TABLE</a></div>
|
|
<div class="head3"><a id="ToC_763" name="ToC_763" href="rbafzmstatabl.htm#wq1065" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_764" name="ToC_764" href="rbafzmstatabl.htm#wq1066" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_765" name="ToC_765" href="rbafzmstatabl.htm#wq1067" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_766" name="ToC_766" href="rbafzmstatabl.htm#synsalter" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_767" name="ToC_767" href="rbafzmstatabl.htm#wq1089" class="toclink">ADD COLUMN <span><var class="pv">column-definition</var></span></a></div>
|
|
<div class="head3"><a id="ToC_768" name="ToC_768" href="rbafzmstatabl.htm#wq1094" class="toclink">ALTER COLUMN <span><var class="pv">column-alteration</var></span></a></div>
|
|
<div class="head3"><a id="ToC_769" name="ToC_769" href="rbafzmstatabl.htm#wq1095" class="toclink">DROP COLUMN</a></div>
|
|
<div class="head3"><a id="ToC_770" name="ToC_770" href="rbafzmstatabl.htm#wq1096" class="toclink">ADD unique-constraint</a></div>
|
|
<div class="head3"><a id="ToC_771" name="ToC_771" href="rbafzmstatabl.htm#wq1097" class="toclink">ADD referential-constraint</a></div>
|
|
<div class="head3"><a id="ToC_772" name="ToC_772" href="rbafzmstatabl.htm#atcheckcst" class="toclink">ADD check-constraint</a></div>
|
|
<div class="head3"><a id="ToC_773" name="ToC_773" href="rbafzmstatabl.htm#wq1098" class="toclink">DROP</a></div>
|
|
<div class="head3"><a id="ToC_774" name="ToC_774" href="rbafzmstatabl.htm#wq1099" class="toclink">ADD partitioning-clause</a></div>
|
|
<div class="head3"><a id="ToC_775" name="ToC_775" href="rbafzmstatabl.htm#wq1100" class="toclink">DROP PARTITIONING</a></div>
|
|
<div class="head3"><a id="ToC_776" name="ToC_776" href="rbafzmstatabl.htm#wq1101" class="toclink">ADD PARTITION</a></div>
|
|
<div class="head3"><a id="ToC_777" name="ToC_777" href="rbafzmstatabl.htm#wq1102" class="toclink">ALTER PARTITION</a></div>
|
|
<div class="head3"><a id="ToC_778" name="ToC_778" href="rbafzmstatabl.htm#wq1103" class="toclink">DROP PARTITION</a></div>
|
|
<div class="head3"><a id="ToC_779" name="ToC_779" href="rbafzmstatabl.htm#wq1104" class="toclink">ADD MATERIALIZED QUERY materialized-query-definition</a></div>
|
|
<div class="head3"><a id="ToC_780" name="ToC_780" href="rbafzmstatabl.htm#wq1105" class="toclink">ALTER MATERIALIZED QUERY materialized-query-table-alteration</a></div>
|
|
<div class="head3"><a id="ToC_781" name="ToC_781" href="rbafzmstatabl.htm#wq1106" class="toclink">DROP MATERIALIZED QUERY</a></div>
|
|
<div class="head3"><a id="ToC_782" name="ToC_782" href="rbafzmstatabl.htm#wq1107" class="toclink">ACTIVATE NOT LOGGED INITIALLY</a></div>
|
|
<div class="head3"><a id="ToC_783" name="ToC_783" href="rbafzmstatabl.htm#wq1108" class="toclink">VOLATILE or NOT VOLATILE</a></div>
|
|
<div class="head3"><a id="ToC_784" name="ToC_784" href="rbafzmstatabl.htm#wq1109" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_785" name="ToC_785" href="rbafzmstatabl.htm#wq1114" class="toclink">Cascaded Effects</a></div>
|
|
<div class="head3"><a id="ToC_786" name="ToC_786" href="rbafzmstatabl.htm#wq1120" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_787" name="ToC_787" href="rbafzmstbegdcl.htm#begdcl" class="toclink">BEGIN DECLARE SECTION</a></div>
|
|
<div class="head3"><a id="ToC_788" name="ToC_788" href="rbafzmstbegdcl.htm#wq1121" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_789" name="ToC_789" href="rbafzmstbegdcl.htm#wq1122" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_790" name="ToC_790" href="rbafzmstbegdcl.htm#wq1123" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_791" name="ToC_791" href="rbafzmstbegdcl.htm#synsbegind" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_792" name="ToC_792" href="rbafzmstbegdcl.htm#wq1124" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_793" name="ToC_793" href="rbafzmstcallsta.htm#callsta" class="toclink">CALL</a></div>
|
|
<div class="head3"><a id="ToC_794" name="ToC_794" href="rbafzmstcallsta.htm#wq1125" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_795" name="ToC_795" href="rbafzmstcallsta.htm#wq1126" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_796" name="ToC_796" href="rbafzmstcallsta.htm#wq1127" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_797" name="ToC_797" href="rbafzmstcallsta.htm#synscall" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_798" name="ToC_798" href="rbafzmstcallsta.htm#wq1136" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_799" name="ToC_799" href="rbafzmstcallsta.htm#wq1137" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_800" name="ToC_800" href="rbafzmstclosst.htm#closst" class="toclink">CLOSE</a></div>
|
|
<div class="head3"><a id="ToC_801" name="ToC_801" href="rbafzmstclosst.htm#wq1138" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_802" name="ToC_802" href="rbafzmstclosst.htm#wq1139" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_803" name="ToC_803" href="rbafzmstclosst.htm#wq1140" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_804" name="ToC_804" href="rbafzmstclosst.htm#synsclose" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_805" name="ToC_805" href="rbafzmstclosst.htm#wq1141" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_806" name="ToC_806" href="rbafzmstclosst.htm#wq1143" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_807" name="ToC_807" href="rbafzmstcomnt.htm#xcomnt" class="toclink">COMMENT</a></div>
|
|
<div class="head3"><a id="ToC_808" name="ToC_808" href="rbafzmstcomnt.htm#wq1144" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_809" name="ToC_809" href="rbafzmstcomnt.htm#wq1145" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_810" name="ToC_810" href="rbafzmstcomnt.htm#wq1146" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_811" name="ToC_811" href="rbafzmstcomnt.htm#aliasdes" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_814" name="ToC_814" href="rbafzmstcomnt.htm#wq1154" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_815" name="ToC_815" href="rbafzmstcomnt.htm#wq1155" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_816" name="ToC_816" href="rbafzmstc4comit.htm#c4comit" class="toclink">COMMIT</a></div>
|
|
<div class="head3"><a id="ToC_817" name="ToC_817" href="rbafzmstc4comit.htm#wq1156" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_818" name="ToC_818" href="rbafzmstc4comit.htm#wq1157" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_819" name="ToC_819" href="rbafzmstc4comit.htm#wq1158" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_820" name="ToC_820" href="rbafzmstc4comit.htm#descomj" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_821" name="ToC_821" href="rbafzmstc4comit.htm#macomm" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_822" name="ToC_822" href="rbafzmstc4comit.htm#commitexamp" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_823" name="ToC_823" href="rbafzmstconj1.htm#conj1" class="toclink">CONNECT (Type 1)</a></div>
|
|
<div class="head3"><a id="ToC_824" name="ToC_824" href="rbafzmstconj1.htm#wq1159" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_825" name="ToC_825" href="rbafzmstconj1.htm#wq1160" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_826" name="ToC_826" href="rbafzmstconj1.htm#wq1161" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_827" name="ToC_827" href="rbafzmstconj1.htm#synsconct" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_828" name="ToC_828" href="rbafzmstconj1.htm#wq1162" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_829" name="ToC_829" href="rbafzmstconj1.htm#wq1164" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_830" name="ToC_830" href="rbafzmstcon2t.htm#con2t" class="toclink">CONNECT (Type 2)</a></div>
|
|
<div class="head3"><a id="ToC_831" name="ToC_831" href="rbafzmstcon2t.htm#wq1165" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_832" name="ToC_832" href="rbafzmstcon2t.htm#wq1166" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_833" name="ToC_833" href="rbafzmstcon2t.htm#wq1167" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_834" name="ToC_834" href="rbafzmstcon2t.htm#synscnct2" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_835" name="ToC_835" href="rbafzmstcon2t.htm#wq1168" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_836" name="ToC_836" href="rbafzmstcon2t.htm#wq1169" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_837" name="ToC_837" href="rbafzmsthcalias.htm#hcalias" class="toclink">CREATE ALIAS</a></div>
|
|
<div class="head3"><a id="ToC_838" name="ToC_838" href="rbafzmsthcalias.htm#wq1170" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_839" name="ToC_839" href="rbafzmsthcalias.htm#wq1171" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_840" name="ToC_840" href="rbafzmsthcalias.htm#wq1172" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_841" name="ToC_841" href="rbafzmsthcalias.htm#synscrtalias" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_842" name="ToC_842" href="rbafzmsthcalias.htm#wq1173" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_843" name="ToC_843" href="rbafzmsthcalias.htm#wq1174" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_844" name="ToC_844" href="rbafzmstcrtudt.htm#crtudt" class="toclink">CREATE DISTINCT TYPE</a></div>
|
|
<div class="head3"><a id="ToC_845" name="ToC_845" href="rbafzmstcrtudt.htm#wq1175" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_846" name="ToC_846" href="rbafzmstcrtudt.htm#wq1176" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_847" name="ToC_847" href="rbafzmstcrtudt.htm#wq1177" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_848" name="ToC_848" href="rbafzmstcrtudt.htm#synscrtdt" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_849" name="ToC_849" href="rbafzmstcrtudt.htm#wq1182" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_850" name="ToC_850" href="rbafzmstcrtudt.htm#wq1187" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_851" name="ToC_851" href="rbafzmstcreatef.htm#createf" class="toclink">CREATE FUNCTION</a></div>
|
|
<div class="head3"><a id="ToC_852" name="ToC_852" href="rbafzmstcreatef.htm#wq1188" class="toclink">Notes</a></div>
|
|
<div class="head2"><a id="ToC_853" name="ToC_853" href="rbafzmstcfsce.htm#cfsce" class="toclink">CREATE FUNCTION (External Scalar)</a></div>
|
|
<div class="head3"><a id="ToC_854" name="ToC_854" href="rbafzmstcfsce.htm#wq1190" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_855" name="ToC_855" href="rbafzmstcfsce.htm#wq1191" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_856" name="ToC_856" href="rbafzmstcfsce.htm#wq1194" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_857" name="ToC_857" href="rbafzmstcfsce.htm#synscrtfunes" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_858" name="ToC_858" href="rbafzmstcfsce.htm#wq1204" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_859" name="ToC_859" href="rbafzmstcfsce.htm#wq1205" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_860" name="ToC_860" href="rbafzmstcftbe.htm#cftbe" class="toclink">CREATE FUNCTION (External Table)</a></div>
|
|
<div class="head3"><a id="ToC_861" name="ToC_861" href="rbafzmstcftbe.htm#wq1206" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_862" name="ToC_862" href="rbafzmstcftbe.htm#wq1207" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_863" name="ToC_863" href="rbafzmstcftbe.htm#wq1208" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_864" name="ToC_864" href="rbafzmstcftbe.htm#synscrtfunet" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_865" name="ToC_865" href="rbafzmstcftbe.htm#wq1218" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_866" name="ToC_866" href="rbafzmstcftbe.htm#wq1219" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_867" name="ToC_867" href="rbafzmstcfso.htm#cfso" class="toclink">CREATE FUNCTION (Sourced)</a></div>
|
|
<div class="head3"><a id="ToC_868" name="ToC_868" href="rbafzmstcfso.htm#wq1220" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_869" name="ToC_869" href="rbafzmstcfso.htm#wq1221" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_870" name="ToC_870" href="rbafzmstcfso.htm#wq1222" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_871" name="ToC_871" href="rbafzmstcfso.htm#synscrtfuns" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_872" name="ToC_872" href="rbafzmstcfso.htm#wq1227" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_873" name="ToC_873" href="rbafzmstcfso.htm#wq1228" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_874" name="ToC_874" href="rbafzmstcfsc.htm#cfsc" class="toclink">CREATE FUNCTION (SQL Scalar)</a></div>
|
|
<div class="head3"><a id="ToC_875" name="ToC_875" href="rbafzmstcfsc.htm#wq1229" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_876" name="ToC_876" href="rbafzmstcfsc.htm#wq1230" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_877" name="ToC_877" href="rbafzmstcfsc.htm#wq1231" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_878" name="ToC_878" href="rbafzmstcfsc.htm#synscrtfunss" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_879" name="ToC_879" href="rbafzmstcfsc.htm#wq1236" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_880" name="ToC_880" href="rbafzmstcfsc.htm#wq1237" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_881" name="ToC_881" href="rbafzmstcftb.htm#cftb" class="toclink">CREATE FUNCTION (SQL Table)</a></div>
|
|
<div class="head3"><a id="ToC_882" name="ToC_882" href="rbafzmstcftb.htm#wq1238" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_883" name="ToC_883" href="rbafzmstcftb.htm#wq1239" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_884" name="ToC_884" href="rbafzmstcftb.htm#wq1240" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_885" name="ToC_885" href="rbafzmstcftb.htm#synscrtfunst" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_886" name="ToC_886" href="rbafzmstcftb.htm#wq1247" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_887" name="ToC_887" href="rbafzmstcftb.htm#wq1248" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_888" name="ToC_888" href="rbafzmstxcindx.htm#xcindx" class="toclink">CREATE INDEX</a></div>
|
|
<div class="head3"><a id="ToC_889" name="ToC_889" href="rbafzmstxcindx.htm#wq1249" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_890" name="ToC_890" href="rbafzmstxcindx.htm#wq1250" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_891" name="ToC_891" href="rbafzmstxcindx.htm#wq1251" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_892" name="ToC_892" href="rbafzmstxcindx.htm#synscrtidx" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_893" name="ToC_893" href="rbafzmstxcindx.htm#wq1254" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_894" name="ToC_894" href="rbafzmstxcindx.htm#wq1255" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_895" name="ToC_895" href="rbafzmstcreatep.htm#createp" class="toclink">CREATE PROCEDURE</a></div>
|
|
<div class="head3"><a id="ToC_896" name="ToC_896" href="rbafzmstcreatep.htm#wq1256" class="toclink">Notes</a></div>
|
|
<div class="head2"><a id="ToC_897" name="ToC_897" href="rbafzmstcrtpef.htm#crtpef" class="toclink">CREATE PROCEDURE (External)</a></div>
|
|
<div class="head3"><a id="ToC_898" name="ToC_898" href="rbafzmstcrtpef.htm#wq1257" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_899" name="ToC_899" href="rbafzmstcrtpef.htm#wq1258" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_900" name="ToC_900" href="rbafzmstcrtpef.htm#wq1259" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_901" name="ToC_901" href="rbafzmstcrtpef.htm#synscrtproc" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_902" name="ToC_902" href="rbafzmstcrtpef.htm#wq1271" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_903" name="ToC_903" href="rbafzmstcrtpef.htm#wq1272" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_904" name="ToC_904" href="rbafzmstcrtpsf.htm#crtpsf" class="toclink">CREATE PROCEDURE (SQL)</a></div>
|
|
<div class="head3"><a id="ToC_905" name="ToC_905" href="rbafzmstcrtpsf.htm#wq1273" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_906" name="ToC_906" href="rbafzmstcrtpsf.htm#wq1274" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_907" name="ToC_907" href="rbafzmstcrtpsf.htm#wq1275" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_908" name="ToC_908" href="rbafzmstcrtpsf.htm#synscrtprocs" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_909" name="ToC_909" href="rbafzmstcrtpsf.htm#wq1283" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_910" name="ToC_910" href="rbafzmstcrtpsf.htm#wq1284" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_911" name="ToC_911" href="rbafzmstxcschema.htm#xcschema" class="toclink">CREATE SCHEMA</a></div>
|
|
<div class="head3"><a id="ToC_912" name="ToC_912" href="rbafzmstxcschema.htm#wq1285" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_913" name="ToC_913" href="rbafzmstxcschema.htm#wq1286" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_914" name="ToC_914" href="rbafzmstxcschema.htm#wq1287" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_915" name="ToC_915" href="rbafzmstxcschema.htm#synscrtschema" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_916" name="ToC_916" href="rbafzmstxcschema.htm#wq1290" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_917" name="ToC_917" href="rbafzmstxcschema.htm#wq1291" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_918" name="ToC_918" href="rbafzmstcsequence.htm#csequence" class="toclink">CREATE SEQUENCE</a></div>
|
|
<div class="head3"><a id="ToC_919" name="ToC_919" href="rbafzmstcsequence.htm#wq1292" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_920" name="ToC_920" href="rbafzmstcsequence.htm#wq1293" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_921" name="ToC_921" href="rbafzmstcsequence.htm#wq1294" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_922" name="ToC_922" href="rbafzmstcsequence.htm#synscsequence" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_923" name="ToC_923" href="rbafzmstcsequence.htm#wq1298" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_924" name="ToC_924" href="rbafzmstcsequence.htm#wq1299" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_925" name="ToC_925" href="rbafzmsthctabl.htm#hctabl" class="toclink">CREATE TABLE</a></div>
|
|
<div class="head3"><a id="ToC_926" name="ToC_926" href="rbafzmsthctabl.htm#wq1300" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_927" name="ToC_927" href="rbafzmsthctabl.htm#wq1301" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_928" name="ToC_928" href="rbafzmsthctabl.htm#cr8tbl" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_929" name="ToC_929" href="rbafzmsthctabl.htm#ctbldes" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_930" name="ToC_930" href="rbafzmsthctabl.htm#wq1320" class="toclink">column-definition</a></div>
|
|
<div class="head3"><a id="ToC_931" name="ToC_931" href="rbafzmsthctabl.htm#wq1328" class="toclink">LIKE</a></div>
|
|
<div class="head3"><a id="ToC_932" name="ToC_932" href="rbafzmsthctabl.htm#wq1329" class="toclink">as-subquery-clause</a></div>
|
|
<div class="head3"><a id="ToC_933" name="ToC_933" href="rbafzmsthctabl.htm#wq1330" class="toclink">copy-options</a></div>
|
|
<div class="head3"><a id="ToC_934" name="ToC_934" href="rbafzmsthctabl.htm#wq1334" class="toclink">unique-constraint</a></div>
|
|
<div class="head3"><a id="ToC_935" name="ToC_935" href="rbafzmsthctabl.htm#wq1335" class="toclink">referential-constraint</a></div>
|
|
<div class="head3"><a id="ToC_936" name="ToC_936" href="rbafzmsthctabl.htm#ctcheckcst" class="toclink">check-constraint</a></div>
|
|
<div class="head3"><a id="ToC_937" name="ToC_937" href="rbafzmsthctabl.htm#wq1336" class="toclink">NOT LOGGED INITIALLY</a></div>
|
|
<div class="head3"><a id="ToC_938" name="ToC_938" href="rbafzmsthctabl.htm#wq1337" class="toclink">VOLATILE or NOT VOLATILE</a></div>
|
|
<div class="head3"><a id="ToC_939" name="ToC_939" href="rbafzmsthctabl.htm#wq1338" class="toclink">distribution-clause</a></div>
|
|
<div class="head3"><a id="ToC_940" name="ToC_940" href="rbafzmsthctabl.htm#wq1339" class="toclink">partitioning-clause</a></div>
|
|
<div class="head3"><a id="ToC_941" name="ToC_941" href="rbafzmsthctabl.htm#unctabl" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_945" name="ToC_945" href="rbafzmsthctabl.htm#ctsysrl" class="toclink">Rules for System Name Generation</a></div>
|
|
<div class="head3"><a id="ToC_948" name="ToC_948" href="rbafzmsthctabl.htm#wq1345" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_949" name="ToC_949" href="rbafzmsthctrigger.htm#hctrigger" class="toclink">CREATE TRIGGER</a></div>
|
|
<div class="head3"><a id="ToC_950" name="ToC_950" href="rbafzmsthctrigger.htm#itrig" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_951" name="ToC_951" href="rbafzmsthctrigger.htm#wq1346" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_952" name="ToC_952" href="rbafzmsthctrigger.htm#wq1347" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_953" name="ToC_953" href="rbafzmsthctrigger.htm#synscrttrig" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_954" name="ToC_954" href="rbafzmsthctrigger.htm#dtrig" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_955" name="ToC_955" href="rbafzmsthctrigger.htm#wq1364" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_956" name="ToC_956" href="rbafzmsthcview.htm#hcview" class="toclink">CREATE VIEW</a></div>
|
|
<div class="head3"><a id="ToC_957" name="ToC_957" href="rbafzmsthcview.htm#wq1365" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_958" name="ToC_958" href="rbafzmsthcview.htm#wq1366" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_959" name="ToC_959" href="rbafzmsthcview.htm#wq1367" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_960" name="ToC_960" href="rbafzmsthcview.htm#synscrtview" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_961" name="ToC_961" href="rbafzmsthcview.htm#cvrdon" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_962" name="ToC_962" href="rbafzmsthcview.htm#wq1376" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_963" name="ToC_963" href="rbafzdeallocatedescr.htm#deallocatedescr" class="toclink">DEALLOCATE DESCRIPTOR</a></div>
|
|
<div class="head3"><a id="ToC_964" name="ToC_964" href="rbafzdeallocatedescr.htm#wq1378" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_965" name="ToC_965" href="rbafzdeallocatedescr.htm#wq1379" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_966" name="ToC_966" href="rbafzdeallocatedescr.htm#wq1380" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_967" name="ToC_967" href="rbafzdeallocatedescr.htm#syndeallocatedescr" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_968" name="ToC_968" href="rbafzdeallocatedescr.htm#wq1381" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_969" name="ToC_969" href="rbafzdeallocatedescr.htm#wq1382" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_970" name="ToC_970" href="rbafzmsth2clcu.htm#h2dclcu" class="toclink">DECLARE CURSOR</a></div>
|
|
<div class="head3"><a id="ToC_971" name="ToC_971" href="rbafzmsth2clcu.htm#wq1383" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_972" name="ToC_972" href="rbafzmsth2clcu.htm#wq1384" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_973" name="ToC_973" href="rbafzmsth2clcu.htm#wq1385" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_974" name="ToC_974" href="rbafzmsth2clcu.htm#deccur" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_975" name="ToC_975" href="rbafzmsth2clcu.htm#wq1388" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_976" name="ToC_976" href="rbafzmsth2clcu.htm#wq1389" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_977" name="ToC_977" href="rbafzmstdgtt.htm#dgtt" class="toclink">DECLARE GLOBAL TEMPORARY TABLE</a></div>
|
|
<div class="head3"><a id="ToC_978" name="ToC_978" href="rbafzmstdgtt.htm#wq1390" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_979" name="ToC_979" href="rbafzmstdgtt.htm#wq1391" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_980" name="ToC_980" href="rbafzmstdgtt.htm#wq1392" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_981" name="ToC_981" href="rbafzmstdgtt.htm#synsdgtt" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_982" name="ToC_982" href="rbafzmstdgtt.htm#wq1403" class="toclink">column-definition</a></div>
|
|
<div class="head3"><a id="ToC_983" name="ToC_983" href="rbafzmstdgtt.htm#wq1411" class="toclink">LIKE</a></div>
|
|
<div class="head3"><a id="ToC_984" name="ToC_984" href="rbafzmstdgtt.htm#wq1412" class="toclink">as-subquery-clause</a></div>
|
|
<div class="head3"><a id="ToC_985" name="ToC_985" href="rbafzmstdgtt.htm#wq1413" class="toclink">copy-options</a></div>
|
|
<div class="head3"><a id="ToC_986" name="ToC_986" href="rbafzmstdgtt.htm#wq1417" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_987" name="ToC_987" href="rbafzmstdgtt.htm#wq1418" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_988" name="ToC_988" href="rbafzmstdclpef.htm#dclpef" class="toclink">DECLARE PROCEDURE</a></div>
|
|
<div class="head3"><a id="ToC_989" name="ToC_989" href="rbafzmstdclpef.htm#wq1419" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_990" name="ToC_990" href="rbafzmstdclpef.htm#wq1420" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_991" name="ToC_991" href="rbafzmstdclpef.htm#wq1421" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_992" name="ToC_992" href="rbafzmstdclpef.htm#synsdp" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_993" name="ToC_993" href="rbafzmstdclpef.htm#wq1433" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_994" name="ToC_994" href="rbafzmstdclpef.htm#wq1434" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_995" name="ToC_995" href="rbafzmstdclst.htm#dclst" class="toclink">DECLARE STATEMENT</a></div>
|
|
<div class="head3"><a id="ToC_996" name="ToC_996" href="rbafzmstdclst.htm#wq1435" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_997" name="ToC_997" href="rbafzmstdclst.htm#wq1436" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_998" name="ToC_998" href="rbafzmstdclst.htm#wq1437" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_999" name="ToC_999" href="rbafzmstdclst.htm#synsdstmt" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1000" name="ToC_1000" href="rbafzmstdclst.htm#wq1438" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1001" name="ToC_1001" href="rbafzmstdeclvar.htm#declvar" class="toclink">DECLARE VARIABLE</a></div>
|
|
<div class="head3"><a id="ToC_1002" name="ToC_1002" href="rbafzmstdeclvar.htm#wq1439" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1003" name="ToC_1003" href="rbafzmstdeclvar.htm#wq1440" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1004" name="ToC_1004" href="rbafzmstdeclvar.htm#wq1441" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1005" name="ToC_1005" href="rbafzmstdeclvar.htm#synsdvar" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1006" name="ToC_1006" href="rbafzmstdeclvar.htm#wq1442" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1007" name="ToC_1007" href="rbafzmstdeclvar.htm#wq1443" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1008" name="ToC_1008" href="rbafzmstdelst.htm#delst" class="toclink">DELETE</a></div>
|
|
<div class="head3"><a id="ToC_1009" name="ToC_1009" href="rbafzmstdelst.htm#wq1444" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1010" name="ToC_1010" href="rbafzmstdelst.htm#wq1445" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1011" name="ToC_1011" href="rbafzmstdelst.htm#wq1446" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1012" name="ToC_1012" href="rbafzmstdelst.htm#synsdelete" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1013" name="ToC_1013" href="rbafzmstdelst.htm#wq1447" class="toclink">DELETE Rules</a></div>
|
|
<div class="head3"><a id="ToC_1014" name="ToC_1014" href="rbafzmstdelst.htm#wq1448" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1015" name="ToC_1015" href="rbafzmstdelst.htm#wq1449" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1016" name="ToC_1016" href="rbafzmstdescr.htm#descr" class="toclink">DESCRIBE</a></div>
|
|
<div class="head3"><a id="ToC_1017" name="ToC_1017" href="rbafzmstdescr.htm#wq1450" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1018" name="ToC_1018" href="rbafzmstdescr.htm#wq1451" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1019" name="ToC_1019" href="rbafzmstdescr.htm#wq1452" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1020" name="ToC_1020" href="rbafzmstdescr.htm#synsdesc" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1021" name="ToC_1021" href="rbafzmstdescr.htm#wq1453" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1022" name="ToC_1022" href="rbafzmstdescr.htm#wq1455" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1023" name="ToC_1023" href="rbafzdescrinput.htm#descrinput" class="toclink">DESCRIBE INPUT</a></div>
|
|
<div class="head3"><a id="ToC_1024" name="ToC_1024" href="rbafzdescrinput.htm#wq1456" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1025" name="ToC_1025" href="rbafzdescrinput.htm#wq1457" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1026" name="ToC_1026" href="rbafzdescrinput.htm#wq1458" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1027" name="ToC_1027" href="rbafzdescrinput.htm#synsdinput" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1028" name="ToC_1028" href="rbafzdescrinput.htm#wq1459" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1029" name="ToC_1029" href="rbafzdescrinput.htm#wq1460" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1030" name="ToC_1030" href="rbafzmstdescrtb.htm#descrtb" class="toclink">DESCRIBE TABLE</a></div>
|
|
<div class="head3"><a id="ToC_1031" name="ToC_1031" href="rbafzmstdescrtb.htm#wq1461" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1032" name="ToC_1032" href="rbafzmstdescrtb.htm#wq1462" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1033" name="ToC_1033" href="rbafzmstdescrtb.htm#wq1463" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1034" name="ToC_1034" href="rbafzmstdescrtb.htm#synsdtbl" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1035" name="ToC_1035" href="rbafzmstdescrtb.htm#wq1464" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1036" name="ToC_1036" href="rbafzmstdescrtb.htm#wq1465" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1037" name="ToC_1037" href="rbafzmstdiscon.htm#discon" class="toclink">DISCONNECT</a></div>
|
|
<div class="head3"><a id="ToC_1038" name="ToC_1038" href="rbafzmstdiscon.htm#wq1466" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1039" name="ToC_1039" href="rbafzmstdiscon.htm#wq1467" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1040" name="ToC_1040" href="rbafzmstdiscon.htm#wq1468" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1041" name="ToC_1041" href="rbafzmstdiscon.htm#synsdisconnect" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1042" name="ToC_1042" href="rbafzmstdiscon.htm#wq1469" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1043" name="ToC_1043" href="rbafzmstdiscon.htm#wq1470" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1044" name="ToC_1044" href="rbafzmstdropst.htm#dropst" class="toclink">DROP</a></div>
|
|
<div class="head3"><a id="ToC_1045" name="ToC_1045" href="rbafzmstdropst.htm#wq1471" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1046" name="ToC_1046" href="rbafzmstdropst.htm#wq1472" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1047" name="ToC_1047" href="rbafzmstdropst.htm#wq1473" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1048" name="ToC_1048" href="rbafzmstdropst.htm#synsdrop" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1049" name="ToC_1049" href="rbafzmstdropst.htm#wq1478" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1050" name="ToC_1050" href="rbafzmstdropst.htm#wq1479" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1051" name="ToC_1051" href="rbafzmsteds.htm#eds" class="toclink">END DECLARE SECTION</a></div>
|
|
<div class="head3"><a id="ToC_1052" name="ToC_1052" href="rbafzmsteds.htm#wq1480" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1053" name="ToC_1053" href="rbafzmsteds.htm#wq1481" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1054" name="ToC_1054" href="rbafzmsteds.htm#wq1482" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1055" name="ToC_1055" href="rbafzmsteds.htm#synseds" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1056" name="ToC_1056" href="rbafzmsteds.htm#wq1483" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1057" name="ToC_1057" href="rbafzmsthexeqt.htm#hexeqt" class="toclink">EXECUTE</a></div>
|
|
<div class="head3"><a id="ToC_1058" name="ToC_1058" href="rbafzmsthexeqt.htm#wq1484" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1059" name="ToC_1059" href="rbafzmsthexeqt.htm#wq1485" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1060" name="ToC_1060" href="rbafzmsthexeqt.htm#wq1486" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1061" name="ToC_1061" href="rbafzmsthexeqt.htm#synsexecute" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1062" name="ToC_1062" href="rbafzmsthexeqt.htm#wq1489" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1063" name="ToC_1063" href="rbafzmsthexeqt.htm#wq1490" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1064" name="ToC_1064" href="rbafzmstexim.htm#exim" class="toclink">EXECUTE IMMEDIATE</a></div>
|
|
<div class="head3"><a id="ToC_1065" name="ToC_1065" href="rbafzmstexim.htm#wq1491" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1066" name="ToC_1066" href="rbafzmstexim.htm#wq1492" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1067" name="ToC_1067" href="rbafzmstexim.htm#wq1493" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1068" name="ToC_1068" href="rbafzmstexim.htm#synsexeimm" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1069" name="ToC_1069" href="rbafzmstexim.htm#wq1497" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1070" name="ToC_1070" href="rbafzmstexim.htm#wq1498" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1071" name="ToC_1071" href="rbafzmstfets.htm#fets" class="toclink">FETCH</a></div>
|
|
<div class="head3"><a id="ToC_1072" name="ToC_1072" href="rbafzmstfets.htm#wq1499" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1073" name="ToC_1073" href="rbafzmstfets.htm#wq1500" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1074" name="ToC_1074" href="rbafzmstfets.htm#wq1501" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1075" name="ToC_1075" href="rbafzmstfets.htm#refresh" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1076" name="ToC_1076" href="rbafzmstfets.htm#wq1506" class="toclink">single-fetch</a></div>
|
|
<div class="head3"><a id="ToC_1077" name="ToC_1077" href="rbafzmstfets.htm#multiplerowfetch" class="toclink">multiple-row-fetch</a></div>
|
|
<div class="head3"><a id="ToC_1078" name="ToC_1078" href="rbafzmstfets.htm#wq1509" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1079" name="ToC_1079" href="rbafzmstfets.htm#wq1510" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1080" name="ToC_1080" href="rbafzmstfreeloc.htm#freeloc" class="toclink">FREE LOCATOR</a></div>
|
|
<div class="head3"><a id="ToC_1081" name="ToC_1081" href="rbafzmstfreeloc.htm#wq1511" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1082" name="ToC_1082" href="rbafzmstfreeloc.htm#wq1512" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1083" name="ToC_1083" href="rbafzmstfreeloc.htm#wq1513" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1084" name="ToC_1084" href="rbafzmstfreeloc.htm#synsfl" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1085" name="ToC_1085" href="rbafzmstfreeloc.htm#wq1514" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1086" name="ToC_1086" href="rbafzgetdescr.htm#getdescr" class="toclink">GET DESCRIPTOR</a></div>
|
|
<div class="head3"><a id="ToC_1087" name="ToC_1087" href="rbafzgetdescr.htm#wq1515" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1088" name="ToC_1088" href="rbafzgetdescr.htm#wq1516" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1089" name="ToC_1089" href="rbafzgetdescr.htm#wq1517" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1090" name="ToC_1090" href="rbafzgetdescr.htm#syngetdescr" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1093" name="ToC_1093" href="rbafzgetdescr.htm#wq1520" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1094" name="ToC_1094" href="rbafzgetdescr.htm#wq1527" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1095" name="ToC_1095" href="rbafzmstgetdiag.htm#getdiag" class="toclink">GET DIAGNOSTICS</a></div>
|
|
<div class="head3"><a id="ToC_1096" name="ToC_1096" href="rbafzmstgetdiag.htm#wq1528" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1097" name="ToC_1097" href="rbafzmstgetdiag.htm#wq1529" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1098" name="ToC_1098" href="rbafzmstgetdiag.htm#wq1530" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1099" name="ToC_1099" href="rbafzmstgetdiag.htm#syncdiagnostics" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1103" name="ToC_1103" href="rbafzmstgetdiag.htm#wq1536" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1104" name="ToC_1104" href="rbafzmstgetdiag.htm#wq1542" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1105" name="ToC_1105" href="rbafzmstgntudtp.htm#gntudtp" class="toclink">GRANT (Distinct Type Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1106" name="ToC_1106" href="rbafzmstgntudtp.htm#wq1543" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1107" name="ToC_1107" href="rbafzmstgntudtp.htm#wq1544" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1108" name="ToC_1108" href="rbafzmstgntudtp.htm#wq1545" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1109" name="ToC_1109" href="rbafzmstgntudtp.htm#synsgrantt" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1110" name="ToC_1110" href="rbafzmstgntudtp.htm#wq1546" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1111" name="ToC_1111" href="rbafzmstgntudtp.htm#wq1553" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1112" name="ToC_1112" href="rbafzmstgntprc.htm#gntprc" class="toclink">GRANT (Function or Procedure Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1113" name="ToC_1113" href="rbafzmstgntprc.htm#wq1554" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1114" name="ToC_1114" href="rbafzmstgntprc.htm#wq1555" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1115" name="ToC_1115" href="rbafzmstgntprc.htm#wq1556" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1116" name="ToC_1116" href="rbafzmstgntprc.htm#synsgrantf" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1117" name="ToC_1117" href="rbafzmstgntprc.htm#wq1561" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1118" name="ToC_1118" href="rbafzmstgntprc.htm#wq1576" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1119" name="ToC_1119" href="rbafzmstgntpp.htm#gntpp" class="toclink">GRANT (Package Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1120" name="ToC_1120" href="rbafzmstgntpp.htm#wq1577" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1121" name="ToC_1121" href="rbafzmstgntpp.htm#wq1578" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1122" name="ToC_1122" href="rbafzmstgntpp.htm#wq1579" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1123" name="ToC_1123" href="rbafzmstgntpp.htm#synsgrantp" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1124" name="ToC_1124" href="rbafzmstgntpp.htm#wq1580" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1125" name="ToC_1125" href="rbafzmstgntpp.htm#wq1587" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1126" name="ToC_1126" href="rbafzmstgntseqp.htm#gntseqp" class="toclink">GRANT (Sequence Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1127" name="ToC_1127" href="rbafzmstgntseqp.htm#wq1588" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1128" name="ToC_1128" href="rbafzmstgntseqp.htm#wq1589" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1129" name="ToC_1129" href="rbafzmstgntseqp.htm#wq1590" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1130" name="ToC_1130" href="rbafzmstgntseqp.htm#synsgrants" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1131" name="ToC_1131" href="rbafzmstgntseqp.htm#wq1591" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1132" name="ToC_1132" href="rbafzmstgntseqp.htm#wq1598" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1133" name="ToC_1133" href="rbafzmstgnt.htm#gnt" class="toclink">GRANT (Table or View Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1134" name="ToC_1134" href="rbafzmstgnt.htm#wq1599" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1135" name="ToC_1135" href="rbafzmstgnt.htm#wq1600" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1136" name="ToC_1136" href="rbafzmstgnt.htm#wq1601" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1137" name="ToC_1137" href="rbafzmstgnt.htm#synsgranttbl" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1138" name="ToC_1138" href="rbafzmstgnt.htm#nominds" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1139" name="ToC_1139" href="rbafzmstgnt.htm#wq1613" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1140" name="ToC_1140" href="rbafzmstholdloc.htm#holdloc" class="toclink">HOLD LOCATOR</a></div>
|
|
<div class="head3"><a id="ToC_1141" name="ToC_1141" href="rbafzmstholdloc.htm#wq1614" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1142" name="ToC_1142" href="rbafzmstholdloc.htm#wq1615" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1143" name="ToC_1143" href="rbafzmstholdloc.htm#wq1616" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1144" name="ToC_1144" href="rbafzmstholdloc.htm#synshl" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1145" name="ToC_1145" href="rbafzmstholdloc.htm#wq1617" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1146" name="ToC_1146" href="rbafzmstholdloc.htm#wq1618" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1147" name="ToC_1147" href="rbafzmstclucu.htm#clucu" class="toclink">INCLUDE</a></div>
|
|
<div class="head3"><a id="ToC_1148" name="ToC_1148" href="rbafzmstclucu.htm#wq1619" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1149" name="ToC_1149" href="rbafzmstclucu.htm#wq1620" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1150" name="ToC_1150" href="rbafzmstclucu.htm#wq1621" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1151" name="ToC_1151" href="rbafzmstclucu.htm#synsinclude" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1152" name="ToC_1152" href="rbafzmstclucu.htm#wq1622" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1153" name="ToC_1153" href="rbafzmstclucu.htm#wq1623" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1154" name="ToC_1154" href="rbafzmstbackup.htm#backup" class="toclink">INSERT</a></div>
|
|
<div class="head3"><a id="ToC_1155" name="ToC_1155" href="rbafzmstbackup.htm#wq1624" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1156" name="ToC_1156" href="rbafzmstbackup.htm#wq1625" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1157" name="ToC_1157" href="rbafzmstbackup.htm#wq1626" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1158" name="ToC_1158" href="rbafzmstbackup.htm#synsinsert" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1159" name="ToC_1159" href="rbafzmstbackup.htm#wq1628" class="toclink">insert-multiple-rows</a></div>
|
|
<div class="head3"><a id="ToC_1160" name="ToC_1160" href="rbafzmstbackup.htm#insert" class="toclink">INSERT Rules</a></div>
|
|
<div class="head3"><a id="ToC_1161" name="ToC_1161" href="rbafzmstbackup.htm#wq1629" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1162" name="ToC_1162" href="rbafzmstbackup.htm#wq1630" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1163" name="ToC_1163" href="rbafzmstlabelon.htm#labelon" class="toclink">LABEL</a></div>
|
|
<div class="head3"><a id="ToC_1164" name="ToC_1164" href="rbafzmstlabelon.htm#wq1631" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1165" name="ToC_1165" href="rbafzmstlabelon.htm#wq1632" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1166" name="ToC_1166" href="rbafzmstlabelon.htm#wq1633" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1167" name="ToC_1167" href="rbafzmstlabelon.htm#synslabel" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1168" name="ToC_1168" href="rbafzmstlabelon.htm#wq1635" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1169" name="ToC_1169" href="rbafzmstlabelon.htm#wq1636" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1170" name="ToC_1170" href="rbafzmsth2lockt.htm#h2lockt" class="toclink">LOCK TABLE</a></div>
|
|
<div class="head3"><a id="ToC_1171" name="ToC_1171" href="rbafzmsth2lockt.htm#wq1637" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1172" name="ToC_1172" href="rbafzmsth2lockt.htm#wq1638" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1173" name="ToC_1173" href="rbafzmsth2lockt.htm#wq1639" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1174" name="ToC_1174" href="rbafzmsth2lockt.htm#deslocj" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1175" name="ToC_1175" href="rbafzmsth2lockt.htm#wq1640" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1176" name="ToC_1176" href="rbafzmsth2lockt.htm#wq1641" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1177" name="ToC_1177" href="rbafzmsthopen.htm#hopen" class="toclink">OPEN</a></div>
|
|
<div class="head3"><a id="ToC_1178" name="ToC_1178" href="rbafzmsthopen.htm#wq1642" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1179" name="ToC_1179" href="rbafzmsthopen.htm#wq1643" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1180" name="ToC_1180" href="rbafzmsthopen.htm#wq1644" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1181" name="ToC_1181" href="rbafzmsthopen.htm#synsopen" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1182" name="ToC_1182" href="rbafzmsthopen.htm#wq1645" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1183" name="ToC_1183" href="rbafzmsthopen.htm#wq1646" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1184" name="ToC_1184" href="rbafzmstpreph2.htm#preph2" class="toclink">PREPARE</a></div>
|
|
<div class="head3"><a id="ToC_1185" name="ToC_1185" href="rbafzmstpreph2.htm#wq1648" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1186" name="ToC_1186" href="rbafzmstpreph2.htm#wq1649" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1187" name="ToC_1187" href="rbafzmstpreph2.htm#wq1650" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1188" name="ToC_1188" href="rbafzmstpreph2.htm#synsprepare" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1189" name="ToC_1189" href="rbafzmstpreph2.htm#wq1656" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1190" name="ToC_1190" href="rbafzmstpreph2.htm#wq1661" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1191" name="ToC_1191" href="rbafzmsthrefresh.htm#hrefresh" class="toclink">REFRESH TABLE</a></div>
|
|
<div class="head3"><a id="ToC_1192" name="ToC_1192" href="rbafzmsthrefresh.htm#wq1662" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1193" name="ToC_1193" href="rbafzmsthrefresh.htm#wq1663" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1194" name="ToC_1194" href="rbafzmsthrefresh.htm#wq1664" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1195" name="ToC_1195" href="rbafzmsthrefresh.htm#synrefresh" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1196" name="ToC_1196" href="rbafzmsthrefresh.htm#wq1665" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1197" name="ToC_1197" href="rbafzmsthrefresh.htm#wq1666" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1198" name="ToC_1198" href="rbafzmstrele.htm#rele" class="toclink">RELEASE (Connection)</a></div>
|
|
<div class="head3"><a id="ToC_1199" name="ToC_1199" href="rbafzmstrele.htm#wq1667" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1200" name="ToC_1200" href="rbafzmstrele.htm#wq1668" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1201" name="ToC_1201" href="rbafzmstrele.htm#wq1669" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1202" name="ToC_1202" href="rbafzmstrele.htm#synsrelease" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1203" name="ToC_1203" href="rbafzmstrele.htm#wq1670" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1204" name="ToC_1204" href="rbafzmstrele.htm#wq1671" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1205" name="ToC_1205" href="rbafzmstrlssvpt.htm#rlssvpt" class="toclink">RELEASE SAVEPOINT</a></div>
|
|
<div class="head3"><a id="ToC_1206" name="ToC_1206" href="rbafzmstrlssvpt.htm#wq1672" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1207" name="ToC_1207" href="rbafzmstrlssvpt.htm#wq1673" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1208" name="ToC_1208" href="rbafzmstrlssvpt.htm#wq1674" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1209" name="ToC_1209" href="rbafzmstrlssvpt.htm#synsreleases" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1210" name="ToC_1210" href="rbafzmstrlssvpt.htm#wq1675" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1211" name="ToC_1211" href="rbafzmstrlssvpt.htm#wq1676" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1212" name="ToC_1212" href="rbafzmstrena.htm#rena" class="toclink">RENAME</a></div>
|
|
<div class="head3"><a id="ToC_1213" name="ToC_1213" href="rbafzmstrena.htm#wq1677" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1214" name="ToC_1214" href="rbafzmstrena.htm#wq1678" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1215" name="ToC_1215" href="rbafzmstrena.htm#wq1679" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1216" name="ToC_1216" href="rbafzmstrena.htm#synsrename" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1217" name="ToC_1217" href="rbafzmstrena.htm#wq1680" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1218" name="ToC_1218" href="rbafzmstrena.htm#wq1681" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1219" name="ToC_1219" href="rbafzmstrudtp.htm#rudtp" class="toclink">REVOKE (Distinct Type Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1220" name="ToC_1220" href="rbafzmstrudtp.htm#wq1682" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1221" name="ToC_1221" href="rbafzmstrudtp.htm#wq1683" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1222" name="ToC_1222" href="rbafzmstrudtp.htm#wq1684" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1223" name="ToC_1223" href="rbafzmstrudtp.htm#synsrevoket" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1224" name="ToC_1224" href="rbafzmstrudtp.htm#wq1685" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1225" name="ToC_1225" href="rbafzmstrudtp.htm#wq1686" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1226" name="ToC_1226" href="rbafzmstrppro.htm#rppro" class="toclink">REVOKE (Function or Procedure Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1227" name="ToC_1227" href="rbafzmstrppro.htm#wq1687" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1228" name="ToC_1228" href="rbafzmstrppro.htm#wq1688" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1229" name="ToC_1229" href="rbafzmstrppro.htm#wq1689" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1230" name="ToC_1230" href="rbafzmstrppro.htm#synsrevokef" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1231" name="ToC_1231" href="rbafzmstrppro.htm#wq1694" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1232" name="ToC_1232" href="rbafzmstrppro.htm#wq1695" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1233" name="ToC_1233" href="rbafzmstrppriv.htm#rppriv" class="toclink">REVOKE (Package Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1234" name="ToC_1234" href="rbafzmstrppriv.htm#wq1696" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1235" name="ToC_1235" href="rbafzmstrppriv.htm#wq1697" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1236" name="ToC_1236" href="rbafzmstrppriv.htm#wq1698" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1237" name="ToC_1237" href="rbafzmstrppriv.htm#synsrevokep" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1238" name="ToC_1238" href="rbafzmstrppriv.htm#wq1699" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1239" name="ToC_1239" href="rbafzmstrppriv.htm#wq1700" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1240" name="ToC_1240" href="rbafzmstrspriv.htm#rspriv" class="toclink">REVOKE (Sequence Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1241" name="ToC_1241" href="rbafzmstrspriv.htm#wq1701" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1242" name="ToC_1242" href="rbafzmstrspriv.htm#wq1702" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1243" name="ToC_1243" href="rbafzmstrspriv.htm#wq1703" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1244" name="ToC_1244" href="rbafzmstrspriv.htm#synsrevokes" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1245" name="ToC_1245" href="rbafzmstrspriv.htm#wq1704" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1246" name="ToC_1246" href="rbafzmstrspriv.htm#wq1705" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1247" name="ToC_1247" href="rbafzmstrevoket.htm#revoket" class="toclink">REVOKE (Table or View Privileges)</a></div>
|
|
<div class="head3"><a id="ToC_1248" name="ToC_1248" href="rbafzmstrevoket.htm#wq1706" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1249" name="ToC_1249" href="rbafzmstrevoket.htm#wq1707" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1250" name="ToC_1250" href="rbafzmstrevoket.htm#wq1708" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1251" name="ToC_1251" href="rbafzmstrevoket.htm#synsrevoketbl" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1252" name="ToC_1252" href="rbafzmstrevoket.htm#wq1709" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1253" name="ToC_1253" href="rbafzmstrevoket.htm#wq1710" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1254" name="ToC_1254" href="rbafzmstrollbac.htm#rollbac" class="toclink">ROLLBACK</a></div>
|
|
<div class="head3"><a id="ToC_1255" name="ToC_1255" href="rbafzmstrollbac.htm#wq1711" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1256" name="ToC_1256" href="rbafzmstrollbac.htm#wq1712" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1257" name="ToC_1257" href="rbafzmstrollbac.htm#wq1713" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1258" name="ToC_1258" href="rbafzmstrollbac.htm#desrolj" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1259" name="ToC_1259" href="rbafzmstrollbac.htm#wq1714" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1260" name="ToC_1260" href="rbafzmstrollbac.htm#wq1718" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1261" name="ToC_1261" href="rbafzmstsvpt.htm#svpt" class="toclink">SAVEPOINT</a></div>
|
|
<div class="head3"><a id="ToC_1262" name="ToC_1262" href="rbafzmstsvpt.htm#wq1719" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1263" name="ToC_1263" href="rbafzmstsvpt.htm#wq1720" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1264" name="ToC_1264" href="rbafzmstsvpt.htm#wq1721" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1265" name="ToC_1265" href="rbafzmstsvpt.htm#synssavep" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1266" name="ToC_1266" href="rbafzmstsvpt.htm#wq1724" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1267" name="ToC_1267" href="rbafzmstsvpt.htm#wq1725" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1268" name="ToC_1268" href="rbafzmsthselectstmt.htm#hselectstmt" class="toclink">SELECT</a></div>
|
|
<div class="head2"><a id="ToC_1269" name="ToC_1269" href="rbafzmsthselin.htm#hselin" class="toclink">SELECT INTO</a></div>
|
|
<div class="head3"><a id="ToC_1270" name="ToC_1270" href="rbafzmsthselin.htm#wq1726" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1271" name="ToC_1271" href="rbafzmsthselin.htm#wq1727" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1272" name="ToC_1272" href="rbafzmsthselin.htm#wq1728" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1273" name="ToC_1273" href="rbafzmsthselin.htm#synselectinto" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1274" name="ToC_1274" href="rbafzmsthselin.htm#wq1731" class="toclink">Note</a></div>
|
|
<div class="head3"><a id="ToC_1275" name="ToC_1275" href="rbafzmsthselin.htm#wq1732" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1276" name="ToC_1276" href="rbafzmstetconj.htm#etconj" class="toclink">SET CONNECTION</a></div>
|
|
<div class="head3"><a id="ToC_1277" name="ToC_1277" href="rbafzmstetconj.htm#wq1733" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1278" name="ToC_1278" href="rbafzmstetconj.htm#wq1734" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1279" name="ToC_1279" href="rbafzmstetconj.htm#wq1735" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1280" name="ToC_1280" href="rbafzmstetconj.htm#synssc" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1281" name="ToC_1281" href="rbafzmstetconj.htm#wq1736" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1282" name="ToC_1282" href="rbafzmstetconj.htm#wq1737" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1283" name="ToC_1283" href="rbafzmstsetdebug.htm#setdebug" class="toclink">SET CURRENT DEBUG MODE</a></div>
|
|
<div class="head3"><a id="ToC_1284" name="ToC_1284" href="rbafzmstsetdebug.htm#wq1738" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1285" name="ToC_1285" href="rbafzmstsetdebug.htm#wq1739" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1286" name="ToC_1286" href="rbafzmstsetdebug.htm#wq1740" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1287" name="ToC_1287" href="rbafzmstsetdebug.htm#synsetdebug" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1288" name="ToC_1288" href="rbafzmstsetdebug.htm#wq1741" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1289" name="ToC_1289" href="rbafzmstsetdebug.htm#wq1742" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1290" name="ToC_1290" href="rbafzsetdegree.htm#setdegree" class="toclink">SET CURRENT DEGREE</a></div>
|
|
<div class="head3"><a id="ToC_1291" name="ToC_1291" href="rbafzsetdegree.htm#wq1743" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1292" name="ToC_1292" href="rbafzsetdegree.htm#wq1744" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1293" name="ToC_1293" href="rbafzsetdegree.htm#wq1745" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1294" name="ToC_1294" href="rbafzsetdegree.htm#synsetdegree" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1295" name="ToC_1295" href="rbafzsetdegree.htm#wq1746" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1296" name="ToC_1296" href="rbafzsetdegree.htm#wq1747" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1297" name="ToC_1297" href="rbafzsetdescr.htm#setdescr" class="toclink">SET DESCRIPTOR</a></div>
|
|
<div class="head3"><a id="ToC_1298" name="ToC_1298" href="rbafzsetdescr.htm#wq1748" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1299" name="ToC_1299" href="rbafzsetdescr.htm#wq1749" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1300" name="ToC_1300" href="rbafzsetdescr.htm#wq1750" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1301" name="ToC_1301" href="rbafzsetdescr.htm#synsetdescr" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1304" name="ToC_1304" href="rbafzsetdescr.htm#wq1753" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1305" name="ToC_1305" href="rbafzsetdescr.htm#wq1758" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1306" name="ToC_1306" href="rbafzmstsetep.htm#setep" class="toclink">SET ENCRYPTION PASSWORD</a></div>
|
|
<div class="head3"><a id="ToC_1307" name="ToC_1307" href="rbafzmstsetep.htm#wq1759" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1308" name="ToC_1308" href="rbafzmstsetep.htm#wq1760" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1309" name="ToC_1309" href="rbafzmstsetep.htm#wq1761" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1310" name="ToC_1310" href="rbafzmstsetep.htm#synsetep" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1311" name="ToC_1311" href="rbafzmstsetep.htm#wq1762" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1312" name="ToC_1312" href="rbafzmstsetep.htm#wq1763" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1313" name="ToC_1313" href="rbafzmstsoption.htm#soption" class="toclink">SET OPTION</a></div>
|
|
<div class="head3"><a id="ToC_1314" name="ToC_1314" href="rbafzmstsoption.htm#wq1764" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1315" name="ToC_1315" href="rbafzmstsoption.htm#wq1765" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1316" name="ToC_1316" href="rbafzmstsoption.htm#wq1766" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1317" name="ToC_1317" href="rbafzmstsoption.htm#synsso" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1318" name="ToC_1318" href="rbafzmstsoption.htm#wq1773" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1319" name="ToC_1319" href="rbafzmstsoption.htm#wq1774" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1320" name="ToC_1320" href="rbafzmstsetpath.htm#setpath" class="toclink">SET PATH</a></div>
|
|
<div class="head3"><a id="ToC_1321" name="ToC_1321" href="rbafzmstsetpath.htm#wq1775" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1322" name="ToC_1322" href="rbafzmstsetpath.htm#wq1776" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1323" name="ToC_1323" href="rbafzmstsetpath.htm#wq1777" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1324" name="ToC_1324" href="rbafzmstsetpath.htm#synssp" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1325" name="ToC_1325" href="rbafzmstsetpath.htm#wq1778" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1326" name="ToC_1326" href="rbafzmstsetpath.htm#wq1779" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1327" name="ToC_1327" href="rbafzmsthsetrs.htm#hsetrs" class="toclink">SET RESULT SETS</a></div>
|
|
<div class="head3"><a id="ToC_1328" name="ToC_1328" href="rbafzmsthsetrs.htm#wq1780" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1329" name="ToC_1329" href="rbafzmsthsetrs.htm#wq1781" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1330" name="ToC_1330" href="rbafzmsthsetrs.htm#wq1782" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1331" name="ToC_1331" href="rbafzmsthsetrs.htm#setres" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1332" name="ToC_1332" href="rbafzmsthsetrs.htm#wq1783" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1333" name="ToC_1333" href="rbafzmsthsetrs.htm#wq1784" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1334" name="ToC_1334" href="rbafzmstsetschema.htm#setschema" class="toclink">SET SCHEMA</a></div>
|
|
<div class="head3"><a id="ToC_1335" name="ToC_1335" href="rbafzmstsetschema.htm#wq1785" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1336" name="ToC_1336" href="rbafzmstsetschema.htm#wq1786" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1337" name="ToC_1337" href="rbafzmstsetschema.htm#wq1787" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1338" name="ToC_1338" href="rbafzmstsetschema.htm#synsss" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1339" name="ToC_1339" href="rbafzmstsetschema.htm#wq1788" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1340" name="ToC_1340" href="rbafzmstsetschema.htm#wq1789" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1341" name="ToC_1341" href="rbafzsetsessionauth.htm#setsessionauth" class="toclink">SET SESSION AUTHORIZATION</a></div>
|
|
<div class="head3"><a id="ToC_1342" name="ToC_1342" href="rbafzsetsessionauth.htm#wq1790" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1343" name="ToC_1343" href="rbafzsetsessionauth.htm#wq1791" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1344" name="ToC_1344" href="rbafzsetsessionauth.htm#wq1792" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1345" name="ToC_1345" href="rbafzsetsessionauth.htm#synssa" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1346" name="ToC_1346" href="rbafzsetsessionauth.htm#wq1793" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1347" name="ToC_1347" href="rbafzsetsessionauth.htm#wq1794" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1348" name="ToC_1348" href="rbafzmstsettraj.htm#settraj" class="toclink">SET TRANSACTION</a></div>
|
|
<div class="head3"><a id="ToC_1349" name="ToC_1349" href="rbafzmstsettraj.htm#wq1795" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1350" name="ToC_1350" href="rbafzmstsettraj.htm#wq1796" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1351" name="ToC_1351" href="rbafzmstsettraj.htm#wq1797" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1352" name="ToC_1352" href="rbafzmstsettraj.htm#synsst" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1353" name="ToC_1353" href="rbafzmstsettraj.htm#wq1802" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1354" name="ToC_1354" href="rbafzmstsettraj.htm#wq1803" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1355" name="ToC_1355" href="rbafzmstsettranv.htm#settranv" class="toclink">SET transition-variable</a></div>
|
|
<div class="head3"><a id="ToC_1356" name="ToC_1356" href="rbafzmstsettranv.htm#wq1804" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1357" name="ToC_1357" href="rbafzmstsettranv.htm#wq1805" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1358" name="ToC_1358" href="rbafzmstsettranv.htm#wq1806" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1359" name="ToC_1359" href="rbafzmstsettranv.htm#synsstv" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1360" name="ToC_1360" href="rbafzmstsettranv.htm#wq1810" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1361" name="ToC_1361" href="rbafzmstsettranv.htm#wq1811" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1362" name="ToC_1362" href="rbafzmstsetinto.htm#setinto" class="toclink">SET variable</a></div>
|
|
<div class="head3"><a id="ToC_1363" name="ToC_1363" href="rbafzmstsetinto.htm#wq1812" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1364" name="ToC_1364" href="rbafzmstsetinto.htm#wq1813" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1365" name="ToC_1365" href="rbafzmstsetinto.htm#wq1814" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1366" name="ToC_1366" href="rbafzmstsetinto.htm#synssv" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1367" name="ToC_1367" href="rbafzmstsetinto.htm#wq1816" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1368" name="ToC_1368" href="rbafzmstsetinto.htm#wq1817" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1369" name="ToC_1369" href="rbafzmstsignal.htm#signal" class="toclink">SIGNAL</a></div>
|
|
<div class="head3"><a id="ToC_1370" name="ToC_1370" href="rbafzmstsignal.htm#wq1818" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1371" name="ToC_1371" href="rbafzmstsignal.htm#wq1819" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1372" name="ToC_1372" href="rbafzmstsignal.htm#wq1820" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1373" name="ToC_1373" href="rbafzmstsignal.htm#synsignal" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1374" name="ToC_1374" href="rbafzmstsignal.htm#wq1822" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1375" name="ToC_1375" href="rbafzmstsignal.htm#wq1823" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1376" name="ToC_1376" href="rbafzmstupdt.htm#updt" class="toclink">UPDATE</a></div>
|
|
<div class="head3"><a id="ToC_1377" name="ToC_1377" href="rbafzmstupdt.htm#wq1824" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1378" name="ToC_1378" href="rbafzmstupdt.htm#wq1825" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1379" name="ToC_1379" href="rbafzmstupdt.htm#wq1826" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1380" name="ToC_1380" href="rbafzmstupdt.htm#synsupdate" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1381" name="ToC_1381" href="rbafzmstupdt.htm#wq1827" class="toclink">UPDATE Rules</a></div>
|
|
<div class="head3"><a id="ToC_1382" name="ToC_1382" href="rbafzmstupdt.htm#wq1828" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1383" name="ToC_1383" href="rbafzmstupdt.htm#wq1829" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1384" name="ToC_1384" href="rbafzmstvaluestmt.htm#valuestmt" class="toclink">VALUES</a></div>
|
|
<div class="head3"><a id="ToC_1385" name="ToC_1385" href="rbafzmstvaluestmt.htm#wq1830" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1386" name="ToC_1386" href="rbafzmstvaluestmt.htm#wq1831" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1387" name="ToC_1387" href="rbafzmstvaluestmt.htm#wq1832" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1388" name="ToC_1388" href="rbafzmstvaluestmt.htm#synsvalues" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1389" name="ToC_1389" href="rbafzmstvaluestmt.htm#wq1833" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1390" name="ToC_1390" href="rbafzmstvaluestmt.htm#wq1834" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1391" name="ToC_1391" href="rbafzmstvalinto.htm#valinto" class="toclink">VALUES INTO</a></div>
|
|
<div class="head3"><a id="ToC_1392" name="ToC_1392" href="rbafzmstvalinto.htm#wq1835" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1393" name="ToC_1393" href="rbafzmstvalinto.htm#wq1836" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1394" name="ToC_1394" href="rbafzmstvalinto.htm#wq1837" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1395" name="ToC_1395" href="rbafzmstvalinto.htm#synsvinto" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1396" name="ToC_1396" href="rbafzmstvalinto.htm#wq1838" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1397" name="ToC_1397" href="rbafzmstvalinto.htm#wq1839" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1398" name="ToC_1398" href="rbafzmstwvrr.htm#wvrr" class="toclink">WHENEVER</a></div>
|
|
<div class="head3"><a id="ToC_1399" name="ToC_1399" href="rbafzmstwvrr.htm#wq1840" class="toclink">Invocation</a></div>
|
|
<div class="head3"><a id="ToC_1400" name="ToC_1400" href="rbafzmstwvrr.htm#wq1841" class="toclink">Authorization</a></div>
|
|
<div class="head3"><a id="ToC_1401" name="ToC_1401" href="rbafzmstwvrr.htm#wq1842" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1402" name="ToC_1402" href="rbafzmstwvrr.htm#synswhenever" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1403" name="ToC_1403" href="rbafzmstwvrr.htm#wq1843" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1404" name="ToC_1404" href="rbafzmstwvrr.htm#wq1844" class="toclink">Example</a></div>
|
|
<div class="head1"><a id="ToC_1405" name="ToC_1405" href="rbafzmstsqlcontstmts.htm#sqlcontstmts" class="toclink">SQL control statements</a></div>
|
|
<div class="head2"><a id="ToC_1406" name="ToC_1406" href="rbafzmstrefsqlv.htm#refsqlv" class="toclink">References to SQL parameters and SQL variables</a></div>
|
|
<div class="head2"><a id="ToC_1407" name="ToC_1407" href="rbafzmstsqlprocstmt.htm#sqlprocstmt" class="toclink">SQL-procedure-statement</a></div>
|
|
<div class="head3"><a id="ToC_1408" name="ToC_1408" href="rbafzmstsqlprocstmt.htm#wq1845" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1409" name="ToC_1409" href="rbafzmstsqlprocstmt.htm#wq1848" class="toclink">Notes</a></div>
|
|
<div class="head2"><a id="ToC_1410" name="ToC_1410" href="rbafzmstassignstmt.htm#assignstmt" class="toclink">assignment-statement</a></div>
|
|
<div class="head3"><a id="ToC_1411" name="ToC_1411" href="rbafzmstassignstmt.htm#wq1849" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1412" name="ToC_1412" href="rbafzmstassignstmt.htm#synassignment" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1413" name="ToC_1413" href="rbafzmstassignstmt.htm#wq1851" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1414" name="ToC_1414" href="rbafzmstassignstmt.htm#wq1852" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1415" name="ToC_1415" href="rbafzmstcallstmt.htm#callstmt" class="toclink">CALL statement</a></div>
|
|
<div class="head3"><a id="ToC_1416" name="ToC_1416" href="rbafzmstcallstmt.htm#wq1853" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1417" name="ToC_1417" href="rbafzmstcallstmt.htm#synccall" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1418" name="ToC_1418" href="rbafzmstcallstmt.htm#wq1858" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1419" name="ToC_1419" href="rbafzmstcallstmt.htm#wq1859" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1420" name="ToC_1420" href="rbafzmstcasestmt.htm#casestmt" class="toclink">CASE statement</a></div>
|
|
<div class="head3"><a id="ToC_1421" name="ToC_1421" href="rbafzmstcasestmt.htm#wq1860" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1422" name="ToC_1422" href="rbafzmstcasestmt.htm#synccase" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1423" name="ToC_1423" href="rbafzmstcasestmt.htm#wq1861" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1424" name="ToC_1424" href="rbafzmstcasestmt.htm#wq1862" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1425" name="ToC_1425" href="rbafzmstcompoundstmt.htm#compoundstmt" class="toclink">compound-statement</a></div>
|
|
<div class="head3"><a id="ToC_1426" name="ToC_1426" href="rbafzmstcompoundstmt.htm#wq1863" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1427" name="ToC_1427" href="rbafzmstcompoundstmt.htm#synccompound" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1428" name="ToC_1428" href="rbafzmstcompoundstmt.htm#wq1867" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1429" name="ToC_1429" href="rbafzmstcompoundstmt.htm#wq1868" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1430" name="ToC_1430" href="rbafzmstforstmt.htm#forstmt" class="toclink">FOR statement</a></div>
|
|
<div class="head3"><a id="ToC_1431" name="ToC_1431" href="rbafzmstforstmt.htm#wq1870" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1432" name="ToC_1432" href="rbafzmstforstmt.htm#syncfor" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1433" name="ToC_1433" href="rbafzmstforstmt.htm#wq1871" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1434" name="ToC_1434" href="rbafzmstforstmt.htm#wq1872" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1435" name="ToC_1435" href="rbafzmstgetdiag2.htm#getdiag2" class="toclink">GET DIAGNOSTICS statement</a></div>
|
|
<div class="head3"><a id="ToC_1436" name="ToC_1436" href="rbafzmstgetdiag2.htm#wq1873" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1437" name="ToC_1437" href="rbafzmstgetdiag2.htm#syncdiagnostics2" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1438" name="ToC_1438" href="rbafzmstgetdiag2.htm#wq1879" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1439" name="ToC_1439" href="rbafzmstgetdiag2.htm#wq1880" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1440" name="ToC_1440" href="rbafzmstgotostmt.htm#gotostmt" class="toclink">GOTO statement</a></div>
|
|
<div class="head3"><a id="ToC_1441" name="ToC_1441" href="rbafzmstgotostmt.htm#wq1881" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1442" name="ToC_1442" href="rbafzmstgotostmt.htm#syncgoto" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1443" name="ToC_1443" href="rbafzmstgotostmt.htm#wq1882" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1444" name="ToC_1444" href="rbafzmstgotostmt.htm#wq1883" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1445" name="ToC_1445" href="rbafzmstifstmt.htm#ifstmt" class="toclink">IF statement</a></div>
|
|
<div class="head3"><a id="ToC_1446" name="ToC_1446" href="rbafzmstifstmt.htm#wq1884" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1447" name="ToC_1447" href="rbafzmstifstmt.htm#syncif" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1448" name="ToC_1448" href="rbafzmstifstmt.htm#wq1885" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1449" name="ToC_1449" href="rbafzmstiteratestmt.htm#iteratestmt" class="toclink">ITERATE statement</a></div>
|
|
<div class="head3"><a id="ToC_1450" name="ToC_1450" href="rbafzmstiteratestmt.htm#wq1886" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1451" name="ToC_1451" href="rbafzmstiteratestmt.htm#synciterate" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1452" name="ToC_1452" href="rbafzmstiteratestmt.htm#wq1887" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1453" name="ToC_1453" href="rbafzmstleavestmt.htm#leavestmt" class="toclink">LEAVE statement</a></div>
|
|
<div class="head3"><a id="ToC_1454" name="ToC_1454" href="rbafzmstleavestmt.htm#wq1888" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1455" name="ToC_1455" href="rbafzmstleavestmt.htm#syncleave" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1456" name="ToC_1456" href="rbafzmstleavestmt.htm#wq1889" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1457" name="ToC_1457" href="rbafzmstleavestmt.htm#wq1890" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1458" name="ToC_1458" href="rbafzmstloopstmt.htm#loopstmt" class="toclink">LOOP statement</a></div>
|
|
<div class="head3"><a id="ToC_1459" name="ToC_1459" href="rbafzmstloopstmt.htm#wq1891" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1460" name="ToC_1460" href="rbafzmstloopstmt.htm#syncloop" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1461" name="ToC_1461" href="rbafzmstloopstmt.htm#wq1892" class="toclink">Examples</a></div>
|
|
<div class="head2"><a id="ToC_1462" name="ToC_1462" href="rbafzmstrepeatstmt.htm#repeatstmt" class="toclink">REPEAT statement</a></div>
|
|
<div class="head3"><a id="ToC_1463" name="ToC_1463" href="rbafzmstrepeatstmt.htm#wq1893" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1464" name="ToC_1464" href="rbafzmstrepeatstmt.htm#syncrepeat" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1465" name="ToC_1465" href="rbafzmstrepeatstmt.htm#wq1894" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1466" name="ToC_1466" href="rbafzmstresignalstmt.htm#resignalstmt" class="toclink">RESIGNAL statement</a></div>
|
|
<div class="head3"><a id="ToC_1467" name="ToC_1467" href="rbafzmstresignalstmt.htm#wq1895" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1468" name="ToC_1468" href="rbafzmstresignalstmt.htm#syncresignal" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1469" name="ToC_1469" href="rbafzmstresignalstmt.htm#wq1896" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1470" name="ToC_1470" href="rbafzmstresignalstmt.htm#wq1897" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1471" name="ToC_1471" href="rbafzmstreturnstmt.htm#returnstmt" class="toclink">RETURN statement</a></div>
|
|
<div class="head3"><a id="ToC_1472" name="ToC_1472" href="rbafzmstreturnstmt.htm#wq1898" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1473" name="ToC_1473" href="rbafzmstreturnstmt.htm#syncreturn" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1474" name="ToC_1474" href="rbafzmstreturnstmt.htm#wq1899" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1475" name="ToC_1475" href="rbafzmstreturnstmt.htm#wq1900" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1476" name="ToC_1476" href="rbafzmstsignalstmt.htm#signalstmt" class="toclink">SIGNAL statement</a></div>
|
|
<div class="head3"><a id="ToC_1477" name="ToC_1477" href="rbafzmstsignalstmt.htm#wq1901" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1478" name="ToC_1478" href="rbafzmstsignalstmt.htm#syncsignal" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1479" name="ToC_1479" href="rbafzmstsignalstmt.htm#wq1902" class="toclink">Notes</a></div>
|
|
<div class="head3"><a id="ToC_1480" name="ToC_1480" href="rbafzmstsignalstmt.htm#wq1903" class="toclink">Example</a></div>
|
|
<div class="head2"><a id="ToC_1481" name="ToC_1481" href="rbafzmstwhilestmt.htm#whilestmt" class="toclink">WHILE statement</a></div>
|
|
<div class="head3"><a id="ToC_1482" name="ToC_1482" href="rbafzmstwhilestmt.htm#wq1904" class="toclink">Syntax</a></div>
|
|
<div class="head3"><a id="ToC_1483" name="ToC_1483" href="rbafzmstwhilestmt.htm#syncwhile" class="toclink">Description</a></div>
|
|
<div class="head3"><a id="ToC_1484" name="ToC_1484" href="rbafzmstwhilestmt.htm#wq1905" class="toclink">Example</a></div>
|
|
<div class="head1"><a id="ToC_1485" name="ToC_1485" href="rbafzmstlimtabs.htm#limtabs" class="toclink">Appendix A. SQL limits</a></div>
|
|
<div class="head1"><a id="ToC_1486" name="ToC_1486" href="rbafzmstdiftab.htm#diftab" class="toclink">Appendix B. Characteristics of SQL statements</a></div>
|
|
<div class="head2"><a id="ToC_1487" name="ToC_1487" href="rbafzmstactallow.htm#actallow" class="toclink">Actions allowed on SQL statements</a></div>
|
|
<div class="head2"><a id="ToC_1488" name="ToC_1488" href="rbafzmstaccind.htm#accind" class="toclink">SQL statement data access indication in routines</a></div>
|
|
<div class="head2"><a id="ToC_1489" name="ToC_1489" href="rbafzmstdiftab2.htm#diftab2" class="toclink">Considerations for using distributed relational database</a></div>
|
|
<div class="head3"><a id="ToC_1490" name="ToC_1490" href="rbafzmstdiftab2.htm#rcncdif" class="toclink">CONNECT (Type 1) and CONNECT (Type 2) differences</a></div>
|
|
<div class="head1"><a id="ToC_1493" name="ToC_1493" href="rbafzmstsqlcca.htm#sqlcca" class="toclink">Appendix C. SQLCA (SQL communication area)</a></div>
|
|
<div class="head2"><a id="ToC_1494" name="ToC_1494" href="rbafzmstfielddescsqlca.htm#fielddescsqlca" class="toclink">Field descriptions</a></div>
|
|
<div class="head2"><a id="ToC_1495" name="ToC_1495" href="rbafzmstincludesqlca.htm#includesqlca" class="toclink">INCLUDE SQLCA declarations</a></div>
|
|
<div class="head1"><a id="ToC_1496" name="ToC_1496" href="rbafzmstsqldda.htm#sqldda" class="toclink">Appendix D. SQLDA (SQL descriptor area)</a></div>
|
|
<div class="head2"><a id="ToC_1497" name="ToC_1497" href="rbafzmstfielddescsqlda.htm#fielddescsqlda" class="toclink">Field descriptions in an SQLDA header</a></div>
|
|
<div class="head3"><a id="ToC_1498" name="ToC_1498" href="rbafzmstfielddescsqlda.htm#howmany" class="toclink">Determining how many SQLVAR occurrences are needed</a></div>
|
|
<div class="head2"><a id="ToC_1499" name="ToC_1499" href="rbafzmstsqlvaroc.htm#sqlvaroc" class="toclink">Field descriptions in an occurrence of SQLVAR</a></div>
|
|
<div class="head3"><a id="ToC_1500" name="ToC_1500" href="rbafzmstsqlvaroc.htm#wq2001" class="toclink">Fields in an occurrence of a base SQLVAR</a></div>
|
|
<div class="head3"><a id="ToC_1501" name="ToC_1501" href="rbafzmstsqlvaroc.htm#wq2006" class="toclink">Fields in an occurrence of a secondary SQLVAR</a></div>
|
|
<div class="head2"><a id="ToC_1502" name="ToC_1502" href="rbafzmstsqltc.htm#sqltc" class="toclink">SQLTYPE and SQLLEN</a></div>
|
|
<div class="head2"><a id="ToC_1503" name="ToC_1503" href="rbafzmstsname.htm#sname" class="toclink">CCSID values in SQLDATA or SQLNAME</a></div>
|
|
<div class="head2"><a id="ToC_1504" name="ToC_1504" href="rbafzmstsqldaunrec.htm#sqldaunrec" class="toclink">Unrecognized and unsupported SQLTYPES</a></div>
|
|
<div class="head2"><a id="ToC_1505" name="ToC_1505" href="rbafzmstincludesqlda.htm#includesqlda" class="toclink">INCLUDE SQLDA declarations</a></div>
|
|
<div class="head3"><a id="ToC_1506" name="ToC_1506" href="rbafzmstincludesqlda.htm#wq2025" class="toclink">For C and C++</a></div>
|
|
<div class="head3"><a id="ToC_1507" name="ToC_1507" href="rbafzmstincludesqlda.htm#wq2027" class="toclink">For COBOL</a></div>
|
|
<div class="head3"><a id="ToC_1508" name="ToC_1508" href="rbafzmstincludesqlda.htm#wq2029" class="toclink">For ILE COBOL</a></div>
|
|
<div class="head3"><a id="ToC_1509" name="ToC_1509" href="rbafzmstincludesqlda.htm#wq2031" class="toclink">For PL/I</a></div>
|
|
<div class="head3"><a id="ToC_1510" name="ToC_1510" href="rbafzmstincludesqlda.htm#wq2033" class="toclink">For ILE RPG</a></div>
|
|
<div class="head1"><a id="ToC_1511" name="ToC_1511" href="rbafzmstsidvals.htm#sidvals" class="toclink">Appendix E. CCSID values</a></div>
|
|
<div class="head1"><a id="ToC_1512" name="ToC_1512" href="rbafzmstcatalog.htm#catalog" class="toclink">Appendix F. DB2 UDB for iSeries catalog views</a></div>
|
|
<div class="head2"><a id="ToC_1513" name="ToC_1513" href="rbafzmstcatalognotes.htm#catalognotes" class="toclink">Notes</a></div>
|
|
<div class="head2"><a id="ToC_1514" name="ToC_1514" href="rbafzmstcatalogtbls.htm#catalogtbls" class="toclink">iSeries catalog tables and views</a></div>
|
|
<div class="head3"><a id="ToC_1515" name="ToC_1515" href="rbafzmstcatalogtbls.htm#catsyscatalog" class="toclink">SYSCATALOGS</a></div>
|
|
<div class="head3"><a id="ToC_1516" name="ToC_1516" href="rbafzmstcatalogtbls.htm#catsyschk" class="toclink">SYSCHKCST</a></div>
|
|
<div class="head3"><a id="ToC_1517" name="ToC_1517" href="rbafzmstcatalogtbls.htm#catsyscol" class="toclink">SYSCOLUMNS</a></div>
|
|
<div class="head3"><a id="ToC_1518" name="ToC_1518" href="rbafzmstcatalogtbls.htm#catsyscst" class="toclink">SYSCST</a></div>
|
|
<div class="head3"><a id="ToC_1519" name="ToC_1519" href="rbafzmstcatalogtbls.htm#catsyscstcol" class="toclink">SYSCSTCOL</a></div>
|
|
<div class="head3"><a id="ToC_1520" name="ToC_1520" href="rbafzmstcatalogtbls.htm#catsyscstdep" class="toclink">SYSCSTDEP</a></div>
|
|
<div class="head3"><a id="ToC_1521" name="ToC_1521" href="rbafzmstcatalogtbls.htm#catsysfunc" class="toclink">SYSFUNCS</a></div>
|
|
<div class="head3"><a id="ToC_1522" name="ToC_1522" href="rbafzmstcatalogtbls.htm#catsysindex" class="toclink">SYSINDEXES</a></div>
|
|
<div class="head3"><a id="ToC_1523" name="ToC_1523" href="rbafzmstcatalogtbls.htm#catsysjarcont" class="toclink">SYSJARCONTENTS</a></div>
|
|
<div class="head3"><a id="ToC_1524" name="ToC_1524" href="rbafzmstcatalogtbls.htm#catjarobj" class="toclink">SYSJAROBJECTS</a></div>
|
|
<div class="head3"><a id="ToC_1525" name="ToC_1525" href="rbafzmstcatalogtbls.htm#catkeycst" class="toclink">SYSKEYCST</a></div>
|
|
<div class="head3"><a id="ToC_1526" name="ToC_1526" href="rbafzmstcatalogtbls.htm#catsyskeys" class="toclink">SYSKEYS</a></div>
|
|
<div class="head3"><a id="ToC_1527" name="ToC_1527" href="rbafzmstcatalogtbls.htm#catsyspack" class="toclink">SYSPACKAGE</a></div>
|
|
<div class="head3"><a id="ToC_1528" name="ToC_1528" href="rbafzmstcatalogtbls.htm#catsysparms" class="toclink">SYSPARMS</a></div>
|
|
<div class="head3"><a id="ToC_1529" name="ToC_1529" href="rbafzmstcatalogtbls.htm#catsysprocs" class="toclink">SYSPROCS</a></div>
|
|
<div class="head3"><a id="ToC_1530" name="ToC_1530" href="rbafzmstcatalogtbls.htm#catsysrefcst" class="toclink">SYSREFCST</a></div>
|
|
<div class="head3"><a id="ToC_1531" name="ToC_1531" href="rbafzmstcatalogtbls.htm#catsysrdep" class="toclink">SYSROUTINEDEP</a></div>
|
|
<div class="head3"><a id="ToC_1532" name="ToC_1532" href="rbafzmstcatalogtbls.htm#catsysrout" class="toclink">SYSROUTINES</a></div>
|
|
<div class="head3"><a id="ToC_1533" name="ToC_1533" href="rbafzmstcatalogtbls.htm#catsysseq" class="toclink">SYSSEQUENCES</a></div>
|
|
<div class="head3"><a id="ToC_1534" name="ToC_1534" href="rbafzmstcatalogtbls.htm#catsystdep" class="toclink">SYSTABLEDEP</a></div>
|
|
<div class="head3"><a id="ToC_1535" name="ToC_1535" href="rbafzmstcatalogtbls.htm#catsystbls" class="toclink">SYSTABLES</a></div>
|
|
<div class="head3"><a id="ToC_1536" name="ToC_1536" href="rbafzmstcatalogtbls.htm#catsystrigcol" class="toclink">SYSTRIGCOL</a></div>
|
|
<div class="head3"><a id="ToC_1537" name="ToC_1537" href="rbafzmstcatalogtbls.htm#catsystrigdep" class="toclink">SYSTRIGDEP</a></div>
|
|
<div class="head3"><a id="ToC_1538" name="ToC_1538" href="rbafzmstcatalogtbls.htm#catsystrigger" class="toclink">SYSTRIGGERS</a></div>
|
|
<div class="head3"><a id="ToC_1539" name="ToC_1539" href="rbafzmstcatalogtbls.htm#catsystrigupd" class="toclink">SYSTRIGUPD</a></div>
|
|
<div class="head3"><a id="ToC_1540" name="ToC_1540" href="rbafzmstcatalogtbls.htm#catsystypes" class="toclink">SYSTYPES</a></div>
|
|
<div class="head3"><a id="ToC_1541" name="ToC_1541" href="rbafzmstcatalogtbls.htm#catsysviewdep" class="toclink">SYSVIEWDEP</a></div>
|
|
<div class="head3"><a id="ToC_1542" name="ToC_1542" href="rbafzmstcatalogtbls.htm#catsysviews" class="toclink">SYSVIEWS</a></div>
|
|
<div class="head2"><a id="ToC_1543" name="ToC_1543" href="rbafzmstcatalogodbc.htm#catalogodbc" class="toclink">ODBC and JDBC catalog views</a></div>
|
|
<div class="head3"><a id="ToC_1544" name="ToC_1544" href="rbafzmstcatalogodbc.htm#catsqlcolprivileges" class="toclink">SQLCOLPRIVILEGES</a></div>
|
|
<div class="head3"><a id="ToC_1545" name="ToC_1545" href="rbafzmstcatalogodbc.htm#catsqlcolumns" class="toclink">SQLCOLUMNS</a></div>
|
|
<div class="head3"><a id="ToC_1546" name="ToC_1546" href="rbafzmstcatalogodbc.htm#catsqlforeignkeys" class="toclink">SQLFOREIGNKEYS</a></div>
|
|
<div class="head3"><a id="ToC_1547" name="ToC_1547" href="rbafzmstcatalogodbc.htm#catsqlprimarykeys" class="toclink">SQLPRIMARYKEYS</a></div>
|
|
<div class="head3"><a id="ToC_1548" name="ToC_1548" href="rbafzmstcatalogodbc.htm#catsqlprocedurecols" class="toclink">SQLPROCEDURECOLS</a></div>
|
|
<div class="head3"><a id="ToC_1549" name="ToC_1549" href="rbafzmstcatalogodbc.htm#catsqlprocedures" class="toclink">SQLPROCEDURES</a></div>
|
|
<div class="head3"><a id="ToC_1550" name="ToC_1550" href="rbafzmstcatalogodbc.htm#catsqlschemas" class="toclink">SQLSCHEMAS</a></div>
|
|
<div class="head3"><a id="ToC_1551" name="ToC_1551" href="rbafzmstcatalogodbc.htm#catsqlspecialcolumns" class="toclink">SQLSPECIALCOLUMNS</a></div>
|
|
<div class="head3"><a id="ToC_1552" name="ToC_1552" href="rbafzmstcatalogodbc.htm#catsqlstatistics" class="toclink">SQLSTATISTICS</a></div>
|
|
<div class="head3"><a id="ToC_1553" name="ToC_1553" href="rbafzmstcatalogodbc.htm#catsqltableprivileges" class="toclink">SQLTABLEPRIVILEGES</a></div>
|
|
<div class="head3"><a id="ToC_1554" name="ToC_1554" href="rbafzmstcatalogodbc.htm#catsqltables" class="toclink">SQLTABLES</a></div>
|
|
<div class="head3"><a id="ToC_1555" name="ToC_1555" href="rbafzmstcatalogodbc.htm#catsqltypeinfo" class="toclink">SQLTYPEINFO</a></div>
|
|
<div class="head3"><a id="ToC_1556" name="ToC_1556" href="rbafzmstcatalogodbc.htm#catsqludts" class="toclink">SQLUDTS</a></div>
|
|
<div class="head2"><a id="ToC_1557" name="ToC_1557" href="rbafzmstcatalogans.htm#catalogans" class="toclink">ANS and ISO catalog views</a></div>
|
|
<div class="head3"><a id="ToC_1558" name="ToC_1558" href="rbafzmstcatalogans.htm#catcharacter_sets" class="toclink">CHARACTER_SETS</a></div>
|
|
<div class="head3"><a id="ToC_1559" name="ToC_1559" href="rbafzmstcatalogans.htm#catcheck_constraints" class="toclink">CHECK_CONSTRAINTS</a></div>
|
|
<div class="head3"><a id="ToC_1560" name="ToC_1560" href="rbafzmstcatalogans.htm#catcolumns" class="toclink">COLUMNS</a></div>
|
|
<div class="head3"><a id="ToC_1561" name="ToC_1561" href="rbafzmstcatalogans.htm#catinfoschema_catalog" class="toclink">INFORMATION_SCHEMA_CATALOG_NAME</a></div>
|
|
<div class="head3"><a id="ToC_1562" name="ToC_1562" href="rbafzmstcatalogans.htm#catparameters" class="toclink">PARAMETERS</a></div>
|
|
<div class="head3"><a id="ToC_1563" name="ToC_1563" href="rbafzmstcatalogans.htm#catreferential_constraints" class="toclink">REFERENTIAL_CONSTRAINTS</a></div>
|
|
<div class="head3"><a id="ToC_1564" name="ToC_1564" href="rbafzmstcatalogans.htm#catroutines" class="toclink">ROUTINES</a></div>
|
|
<div class="head3"><a id="ToC_1565" name="ToC_1565" href="rbafzmstcatalogans.htm#catschemata" class="toclink">SCHEMATA</a></div>
|
|
<div class="head3"><a id="ToC_1566" name="ToC_1566" href="rbafzmstcatalogans.htm#catsql_features" class="toclink">SQL_FEATURES</a></div>
|
|
<div class="head3"><a id="ToC_1567" name="ToC_1567" href="rbafzmstcatalogans.htm#catsql_lang" class="toclink">SQL_LANGUAGES</a></div>
|
|
<div class="head3"><a id="ToC_1568" name="ToC_1568" href="rbafzmstcatalogans.htm#catsql_sizing" class="toclink">SQL_SIZING</a></div>
|
|
<div class="head3"><a id="ToC_1569" name="ToC_1569" href="rbafzmstcatalogans.htm#cattable_constraints" class="toclink">TABLE_CONSTRAINTS</a></div>
|
|
<div class="head3"><a id="ToC_1570" name="ToC_1570" href="rbafzmstcatalogans.htm#cattables" class="toclink">TABLES</a></div>
|
|
<div class="head3"><a id="ToC_1571" name="ToC_1571" href="rbafzmstcatalogans.htm#catuser_defined_types" class="toclink">USER_DEFINED_TYPES</a></div>
|
|
<div class="head3"><a id="ToC_1572" name="ToC_1572" href="rbafzmstcatalogans.htm#catviews" class="toclink">VIEWS</a></div>
|
|
<div class="head1"><a id="ToC_1573" name="ToC_1573" href="rbafzmstterminology.htm#terminology" class="toclink">Appendix G. Terminology differences</a></div>
|
|
<div class="head1"><a id="ToC_1574" name="ToC_1574" href="rbafzmstresword.htm#resword" class="toclink">Appendix H. Reserved schema names and reserved words</a></div>
|
|
<div class="head2"><a id="ToC_1575" name="ToC_1575" href="rbafzmstresschem.htm#resschem" class="toclink">Reserved schema names</a></div>
|
|
<div class="head2"><a id="ToC_1576" name="ToC_1576" href="rbafzmstwordsre.htm#wordsre" class="toclink">Reserved words</a></div>
|
|
<div class="head1"><a id="ToC_1581" name="ToC_1581" href="rbafzmstbiblio.htm#biblio" class="toclink">Related information</a></div>
|
|
<div class="head1"><a id="ToC_1582" name="ToC_1582" href="rbafzmstindex.htm#index" class="toclink">Index</a></div>
|
|
</div>
|
|
<hr /><br />
|
|
[ <a href="#Top_Of_Page">Top of Page</a> | <a href="rbafzmst.htm">Previous Page</a> | <a href="rbafzmstabout.htm">Next Page</a> | <a href="rbafzmst02.htm#wq1">Contents</a> |
|
|
<a href="rbafzmstindex.htm#index">Index</a> ]
|
|
|
|
<a id="Bot_Of_Page" name="Bot_Of_Page"></a>
|
|
</body>
|
|
</html>
|