http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/d89f3e5d/docs/1.3.0/messages_guide/index.html ---------------------------------------------------------------------- diff --git a/docs/1.3.0/messages_guide/index.html b/docs/1.3.0/messages_guide/index.html new file mode 100644 index 0000000..3254a36 --- /dev/null +++ b/docs/1.3.0/messages_guide/index.html @@ -0,0 +1,25887 @@ +<!DOCTYPE html> +<html lang="en"> +<head> +<meta charset="UTF-8"> +<!--[if IE]><meta http-equiv="X-UA-Compatible" content="IE=edge"><![endif]--> +<meta name="viewport" content="width=device-width, initial-scale=1.0"> +<meta name="generator" content="Asciidoctor 1.5.3"> +<meta name="author" content="Version 1.3.0, January 2016"> +<title>Trafodion Messages Guide</title> +<style> +/** +* @@@ START COPYRIGHT @@@ +* +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, +* software distributed under the License is distributed on an +* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +* KIND, either express or implied. See the License for the +* specific language governing permissions and limitations +* under the License. +* +* @@@ END COPYRIGHT @@@ + */ +/* Asciidoctor default stylesheet | MIT License | http://asciidoctor.org */ +/* Remove the comments around the @import statement below when using this as a custom stylesheet */ +/*@import "https://fonts.googleapis.com/css?family=Open+Sans:300,300italic,400,400italic,600,600italic%7CNoto+Serif:400,400italic,700,700italic%7CDroid+Sans+Mono:400";*/ +article,aside,details,figcaption,figure,footer,header,hgroup,main,nav,section,summary{display:block} +audio,canvas,video{display:inline-block} +audio:not([controls]){display:none;height:0} +[hidden],template{display:none} +script{display:none!important} +html{font-family:sans-serif;-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%} +body{margin:0} +a{background:transparent} +a:focus{outline:thin dotted} +a:active,a:hover{outline:0} +h1{font-size:2em;margin:.67em 0} +abbr[title]{border-bottom:1px dotted} +b,strong{font-weight:bold} +dfn{font-style:italic} +hr{-moz-box-sizing:content-box;box-sizing:content-box;height:0} +mark{background:#ff0;color:#000} +code,kbd,pre,samp{font-family:monospace;font-size:1em} +pre{white-space:pre-wrap} +q{quotes:"\201C" "\201D" "\2018" "\2019"} +small{font-size:80%} +sub,sup{font-size:75%;line-height:0;position:relative;vertical-align:baseline} +sup{top:-.5em} +sub{bottom:-.25em} +img{border:0} +svg:not(:root){overflow:hidden} +figure{margin:0} +fieldset{border:1px solid silver;margin:0 2px;padding:.35em .625em .75em} +legend{border:0;padding:0} +button,input,select,textarea{font-family:inherit;font-size:100%;margin:0} +button,input{line-height:normal} +button,select{text-transform:none} +button,html input[type="button"],input[type="reset"],input[type="submit"]{-webkit-appearance:button;cursor:pointer} +button[disabled],html input[disabled]{cursor:default} +input[type="checkbox"],input[type="radio"]{box-sizing:border-box;padding:0} +input[type="search"]{-webkit-appearance:textfield;-moz-box-sizing:content-box;-webkit-box-sizing:content-box;box-sizing:content-box} +input[type="search"]::-webkit-search-cancel-button,input[type="search"]::-webkit-search-decoration{-webkit-appearance:none} +button::-moz-focus-inner,input::-moz-focus-inner{border:0;padding:0} +textarea{overflow:auto;vertical-align:top} +table{border-collapse:collapse;border-spacing:0} +*,*:before,*:after{-moz-box-sizing:border-box;-webkit-box-sizing:border-box;box-sizing:border-box} +html,body{font-size:100%} +body{background:#fff;color:rgba(0,0,0,.8);padding:0;margin:0;font-family:"Helvetica Neue",Helvetica,Arial,sans-serif,serif;font-weight:400;font-style:normal;line-height:1;position:relative;cursor:auto} +a:hover{cursor:pointer} +img,object,embed{max-width:100%;height:auto} +object,embed{height:100%} +img{-ms-interpolation-mode:bicubic} +#map_canvas img,#map_canvas embed,#map_canvas object,.map_canvas img,.map_canvas embed,.map_canvas object{max-width:none!important} +.left{float:left!important} +.right{float:right!important} +.text-left{text-align:left!important} +.text-right{text-align:right!important} +.text-center{text-align:center!important} +.text-justify{text-align:justify!important} +.hide{display:none} +.antialiased,body{-webkit-font-smoothing:antialiased} +img{display:inline-block;vertical-align:middle} +textarea{height:auto;min-height:50px} +select{width:100%} +p.lead,.paragraph.lead>p,#preamble>.sectionbody>.paragraph:first-of-type p{font-size:1.21875em;line-height:1.6} +.subheader,.admonitionblock td.content>.title,.audioblock>.title,.exampleblock>.title,.imageblock>.title,.listingblock>.title,.literalblock>.title,.stemblock>.title,.openblock>.title,.paragraph>.title,.quoteblock>.title,table.tableblock>.title,.verseblock>.title,.videoblock>.title,.dlist>.title,.olist>.title,.ulist>.title,.qlist>.title,.hdlist>.title{line-height:1.45;color:#3188ac;font-weight:400;margin-top:0;margin-bottom:.25em} +div,dl,dt,dd,ul,ol,li,h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6,pre,form,p,blockquote,th,td{margin:0;padding:0;direction:ltr} +a{color:#2156a5;text-decoration:underline;line-height:inherit} +a:hover,a:focus{color:#1d4b8f} +a img{border:none} +p{font-family:inherit;font-weight:400;font-size:1em;line-height:1.6;margin-bottom:1.25em;text-rendering:optimizeLegibility} +p aside{font-size:.875em;line-height:1.35;font-style:italic} +/* Defines headings */ +h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-weight:bold;font-style:normal;color:#3188ac;text-rendering:optimizeLegibility;margin-top:1em;margin-bottom:.5em;line-height:1.0125em} +h1 small,h2 small,h3 small,#toctitle small,.sidebarblock>.content>.title small,h4 small,h5 small,h6 small{font-size:60%;color:#e99b8f;line-height:0} +h1{font-size:2.125em} +h2{font-size:1.6875em} +h3,#toctitle,.sidebarblock>.content>.title{font-size:1.375em} +h4,h5{font-size:1.125em} +h6{font-size:1em} +hr{border:solid #ddddd8;border-width:1px 0 0;clear:both;margin:1.25em 0 1.1875em;height:0} +em,i{font-style:italic;line-height:inherit} +strong,b{font-weight:bold;line-height:inherit} +small{font-size:60%;line-height:inherit} +/* Defines the `text` (passthru) format */ +code{font-family:"Droid Sans Mono","DejaVu Sans Mono",monospace;font-weight:bold;color:#3188ac} +ul,ol,dl{font-size:1em;line-height:1.6;margin-bottom:1.25em;list-style-position:outside;font-family:inherit} +ul,ol,ul.no-bullet,ol.no-bullet{margin-left:1.5em} +ul li ul,ul li ol{margin-left:1.25em;margin-bottom:0;font-size:1em} +ul.square li ul,ul.circle li ul,ul.disc li ul{list-style:inherit} +ul.square{list-style-type:square} +ul.circle{list-style-type:circle} +ul.disc{list-style-type:disc} +ul.no-bullet{list-style:none} +ol li ul,ol li ol{margin-left:1.25em;margin-bottom:0} +dl dt{margin-bottom:.3125em;font-weight:bold} +dl dd{margin-bottom:1.25em} +abbr,acronym{text-transform:uppercase;font-size:90%;color:rgba(0,0,0,.8);border-bottom:1px dotted #ddd;cursor:help} +abbr{text-transform:none} +blockquote{margin:0 0 1.25em;padding:.5625em 1.25em 0 1.1875em;border-left:1px solid #ddd} +blockquote cite{display:block;font-size:.9375em;color:rgba(0,0,0,.6)} +blockquote cite:before{content:"\2014 \0020"} +blockquote cite a,blockquote cite a:visited{color:rgba(0,0,0,.6)} +blockquote,blockquote p{line-height:1.6;color:rgba(0,0,0,.85)} +@media only screen and (min-width:768px){h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{line-height:1.2} +h1{font-size:2.75em} +h2{font-size:2.3125em} +h3,#toctitle,.sidebarblock>.content>.title{font-size:1.6875em} +h4{font-size:1.4375em}}table{background:#fff;margin-bottom:1.25em;border:solid 1px #dedede} +table thead,table tfoot{background:#f7f8f7;font-weight:bold} +table thead tr th,table thead tr td,table tfoot tr th,table tfoot tr td{padding:.5em .625em .625em;font-size:inherit;color:rgba(0,0,0,.8);text-align:left} +table tr th,table tr td{padding:.5625em .625em;font-size:inherit;color:rgba(0,0,0,.8)} +table tr.even,table tr.alt,table tr:nth-of-type(even){background:#f8f8f7} +table thead tr th,table tfoot tr th,table tbody tr td,table tr td,table tfoot tr td{display:table-cell;line-height:1.6} +h1,h2,h3,#toctitle,.sidebarblock>.content>.title,h4,h5,h6{line-height:1.2;word-spacing:-.05em} +h1 strong,h2 strong,h3 strong,#toctitle strong,.sidebarblock>.content>.title strong,h4 strong,h5 strong,h6 strong{font-weight:400} +.clearfix:before,.clearfix:after,.float-group:before,.float-group:after{content:" ";display:table} +.clearfix:after,.float-group:after{clear:both} +*:not(pre)>code{font-size:1.0em;font-style:normal!important;letter-spacing:0;padding:.1em .5ex;word-spacing:-.15em;-webkit-border-radius:4px;border-radius:4px;line-height:1.45;text-rendering:optimizeSpeed} +/**:not(pre)>code{font-size:.9375em;font-style:normal!important;letter-spacing:0;padding:.1em .5ex;word-spacing:-.15em;background-color:#f7f7f8;-webkit-border-radius:4px;border-radius:4px;line-height:1.45;text-rendering:optimizeSpeed}*/ +pre,pre>code{line-height:1.45;color:rgba(0,0,0,.9);font-family:"Droid Sans Mono","DejaVu Sans Mono",monospace;font-weight:400;text-rendering:optimizeSpeed} +.keyseq{color:rgba(51,51,51,.8)} +kbd{display:inline-block;color:rgba(0,0,0,.8);font-size:.75em;line-height:1.4;background-color:#f7f7f7;border:1px solid #ccc;-webkit-border-radius:3px;border-radius:3px;-webkit-box-shadow:0 1px 0 rgba(0,0,0,.2),0 0 0 .1em white inset;box-shadow:0 1px 0 rgba(0,0,0,.2),0 0 0 .1em #fff inset;margin:-.15em .15em 0 .15em;padding:.2em .6em .2em .5em;vertical-align:middle;white-space:nowrap} +.keyseq kbd:first-child{margin-left:0} +.keyseq kbd:last-child{margin-right:0} +.menuseq,.menu{color:rgba(0,0,0,.8)} +b.button:before,b.button:after{position:relative;top:-1px;font-weight:400} +b.button:before{content:"[";padding:0 3px 0 2px} +b.button:after{content:"]";padding:0 2px 0 3px} +p a>code:hover{color:rgba(0,0,0,.9)} +#header,#content,#footnotes,#footer{width:100%;margin-left:auto;margin-right:auto;margin-top:0;margin-bottom:0;max-width:62.5em;*zoom:1;position:relative;padding-left:.9375em;padding-right:.9375em} +#header:before,#header:after,#content:before,#content:after,#footnotes:before,#footnotes:after,#footer:before,#footer:after{content:" ";display:table} +#header:after,#content:after,#footnotes:after,#footer:after{clear:both} +#content{margin-top:1.25em} +#content:before{content:none} +/* #header>h1:first-child{color:rgba(0,0,0,.85);margin-top:2.25rem;margin-bottom:0} */ +#header>h1:first-child{color:#3188ac;margin-top:2.25rem;margin-bottom:0} +#header>h1:first-child+#toc{margin-top:8px;border-top:1px solid #ddddd8} +#header>h1:only-child,body.toc2 #header>h1:nth-last-child(2){border-bottom:1px solid #ddddd8;padding-bottom:8px} +#header .details{border-bottom:1px solid #ddddd8;line-height:1.45;padding-top:.25em;padding-bottom:.25em;padding-left:.25em;color:rgba(0,0,0,.6);display:-ms-flexbox;display:-webkit-flex;display:flex;-ms-flex-flow:row wrap;-webkit-flex-flow:row wrap;flex-flow:row wrap} +#header .details span:first-child{margin-left:-.125em} +#header .details span.email a{color:rgba(0,0,0,.85)} +#header .details br{display:none} +#header .details br+span:before{content:"\00a0\2013\00a0"} +#header .details br+span.author:before{content:"\00a0\22c5\00a0";color:rgba(0,0,0,.85)} +#header .details br+span#revremark:before{content:"\00a0|\00a0"} +#header #revnumber{text-transform:capitalize} +#header #revnumber:after{content:"\00a0"} +#content>h1:first-child:not([class]){color:rgba(0,0,0,.85);border-bottom:1px solid #ddddd8;padding-bottom:8px;margin-top:0;padding-top:1rem;margin-bottom:1.25rem} +#toc{border-bottom:1px solid #efefed;padding-bottom:.5em} +#toc>ul{margin-left:.125em} +#toc ul.sectlevel0>li>a{font-style:italic} +#toc ul.sectlevel0 ul.sectlevel1{margin:.5em 0} +#toc ul{font-family:"Open Sans","DejaVu Sans",sans-serif;list-style-type:none} +#toc a{text-decoration:none} +#toc a:active{text-decoration:underline} +#toctitle{color:#3188ac;font-size:1.2em} +@media only screen and (min-width:768px){#toctitle{font-size:1.375em} +body.toc2{padding-left:15em;padding-right:0} +#toc.toc2{margin-top:0!important;background-color:#f8f8f7;position:fixed;width:15em;left:0;top:0;border-right:1px solid #efefed;border-top-width:0!important;border-bottom-width:0!important;z-index:1000;padding:1.25em 1em;height:100%;overflow:auto} +#toc.toc2 #toctitle{margin-top:0;font-size:1.2em} +#toc.toc2>ul{font-size:.9em;margin-bottom:0} +#toc.toc2 ul ul{margin-left:0;padding-left:1em} +#toc.toc2 ul.sectlevel0 ul.sectlevel1{padding-left:0;margin-top:.5em;margin-bottom:.5em} +body.toc2.toc-right{padding-left:0;padding-right:15em} +body.toc2.toc-right #toc.toc2{border-right-width:0;border-left:1px solid #efefed;left:auto;right:0}}@media only screen and (min-width:1280px){body.toc2{padding-left:20em;padding-right:0} +/* Controls width of panel */ +#toc.toc2{width:25em} +#toc.toc2 #toctitle{font-size:1.375em} +#toc.toc2>ul{font-size:.95em} +#toc.toc2 ul ul{padding-left:1.25em} +body.toc2.toc-right{padding-left:0;padding-right:20em}}#content #toc{border-style:solid;border-width:1px;border-color:#e0e0dc;margin-bottom:1.25em;padding:1.25em;background:#f8f8f7;-webkit-border-radius:4px;border-radius:4px} +#content #toc>:first-child{margin-top:0} +#content #toc>:last-child{margin-bottom:0} +#footer{max-width:100%;background-color:rgba(0,0,0,.8);padding:1.25em} +#footer-text,#footer_nav{color:rgba(255,255,255,.8);line-height:1.44} +#footer a{color: #990000} +.sect1{padding-bottom:.625em} +@media only screen and (min-width:768px){.sect1{padding-bottom:1.25em}}.sect1+.sect1{border-top:1px solid #efefed} +#content h1>a.anchor,h2>a.anchor,h3>a.anchor,#toctitle>a.anchor,.sidebarblock>.content>.title>a.anchor,h4>a.anchor,h5>a.anchor,h6>a.anchor{position:absolute;z-index:1001;width:1.5ex;margin-left:-1.5ex;display:block;text-decoration:none!important;visibility:hidden;text-align:center;font-weight:400} +#content h1>a.anchor:before,h2>a.anchor:before,h3>a.anchor:before,#toctitle>a.anchor:before,.sidebarblock>.content>.title>a.anchor:before,h4>a.anchor:before,h5>a.anchor:before,h6>a.anchor:before{content:"\00A7";font-size:.85em;display:block;padding-top:.1em} +#content h1:hover>a.anchor,#content h1>a.anchor:hover,h2:hover>a.anchor,h2>a.anchor:hover,h3:hover>a.anchor,#toctitle:hover>a.anchor,.sidebarblock>.content>.title:hover>a.anchor,h3>a.anchor:hover,#toctitle>a.anchor:hover,.sidebarblock>.content>.title>a.anchor:hover,h4:hover>a.anchor,h4>a.anchor:hover,h5:hover>a.anchor,h5>a.anchor:hover,h6:hover>a.anchor,h6>a.anchor:hover{visibility:visible} +#content h1>a.link,h2>a.link,h3>a.link,#toctitle>a.link,.sidebarblock>.content>.title>a.link,h4>a.link,h5>a.link,h6>a.link{color:#990000;text-decoration:none} +#content h1>a.link:hover,h2>a.link:hover,h3>a.link:hover,#toctitle>a.link:hover,.sidebarblock>.content>.title>a.link:hover,h4>a.link:hover,h5>a.link:hover,h6>a.link:hover{color:#a53221} +.audioblock,.imageblock,.literalblock,.listingblock,.stemblock,.videoblock{margin-bottom:1.25em} +.admonitionblock td.content>.title,.audioblock>.title,.exampleblock>.title,.imageblock>.title,.listingblock>.title,.literalblock>.title,.stemblock>.title,.openblock>.title,.paragraph>.title,.quoteblock>.title,table.tableblock>.title,.verseblock>.title,.videoblock>.title,.dlist>.title,.olist>.title,.ulist>.title,.qlist>.title,.hdlist>.title{text-rendering:optimizeLegibility;text-align:left;font-family:"Helvetica Neue",Helvetica,Arial,sans-serif,serif;font-size:1rem;font-weight:bold} +/* Here */ +table.tableblock>caption.title{white-space:nowrap;overflow:visible;max-width:0} +.paragraph.lead>p,#preamble>.sectionbody>.paragraph:first-of-type p{color:rgba(0,0,0,.85)} +table.tableblock #preamble>.sectionbody>.paragraph:first-of-type p{font-size:inherit} +.admonitionblock>table{border-collapse:separate;border:0;background:none;width:100%} +.admonitionblock>table td.icon{text-align:center;width:80px} +.admonitionblock>table td.icon img{max-width:none} +.admonitionblock>table td.icon .title{font-weight:bold;font-family:"Open Sans","DejaVu Sans",sans-serif;text-transform:uppercase} +.admonitionblock>table td.content{padding-left:1.125em;padding-right:1.25em;border-left:1px solid #ddddd8;color:rgba(0,0,0,.6)} +.admonitionblock>table td.content>:last-child>:last-child{margin-bottom:0} +.exampleblock>.content{border-style:solid;border-width:1px;border-color:#e6e6e6;margin-bottom:1.25em;padding:1.25em;background:#fff;-webkit-border-radius:4px;border-radius:4px} +.exampleblock>.content>:first-child{margin-top:0} +.exampleblock>.content>:last-child{margin-bottom:0} +.sidebarblock{border-style:solid;border-width:1px;border-color:#e0e0dc;margin-bottom:1.25em;padding:1.25em;background:#f8f8f7;-webkit-border-radius:4px;border-radius:4px} +.sidebarblock>:first-child{margin-top:0} +.sidebarblock>:last-child{margin-bottom:0} +.sidebarblock>.content>.title{color:#7a2518;margin-top:0;text-align:center} +.exampleblock>.content>:last-child>:last-child,.exampleblock>.content .olist>ol>li:last-child>:last-child,.exampleblock>.content .ulist>ul>li:last-child>:last-child,.exampleblock>.content .qlist>ol>li:last-child>:last-child,.sidebarblock>.content>:last-child>:last-child,.sidebarblock>.content .olist>ol>li:last-child>:last-child,.sidebarblock>.content .ulist>ul>li:last-child>:last-child,.sidebarblock>.content .qlist>ol>li:last-child>:last-child{margin-bottom:0} +.literalblock pre,.listingblock pre:not(.highlight),.listingblock pre[class="highlight"],.listingblock pre[class^="highlight "],.listingblock pre.CodeRay,.listingblock pre.prettyprint{background:#f7f7f8} +.sidebarblock .literalblock pre,.sidebarblock .listingblock pre:not(.highlight),.sidebarblock .listingblock pre[class="highlight"],.sidebarblock .listingblock pre[class^="highlight "],.sidebarblock .listingblock pre.CodeRay,.sidebarblock .listingblock pre.prettyprint{background:#f2f1f1} +.literalblock pre,.literalblock pre[class],.listingblock pre,.listingblock pre[class]{-webkit-border-radius:4px;border-radius:4px;word-wrap:break-word;padding:1em;font-size:.8125em} +.literalblock pre.nowrap,.literalblock pre[class].nowrap,.listingblock pre.nowrap,.listingblock pre[class].nowrap{overflow-x:auto;white-space:pre;word-wrap:normal} +@media only screen and (min-width:768px){.literalblock pre,.literalblock pre[class],.listingblock pre,.listingblock pre[class]{font-size:.90625em}}@media only screen and (min-width:1280px){.literalblock pre,.literalblock pre[class],.listingblock pre,.listingblock pre[class]{font-size:1em}}.literalblock.output pre{color:#f7f7f8;background-color:rgba(0,0,0,.9)} +.listingblock pre.highlightjs{padding:0} +.listingblock pre.highlightjs>code{padding:1em;-webkit-border-radius:4px;border-radius:4px} +.listingblock pre.prettyprint{border-width:0} +.listingblock>.content{position:relative} +.listingblock code[data-lang]:before{display:none;content:attr(data-lang);position:absolute;font-size:.75em;top:.425rem;right:.5rem;line-height:1;text-transform:uppercase;color:#999} +.listingblock:hover code[data-lang]:before{display:block} +.listingblock.terminal pre .command:before{content:attr(data-prompt);padding-right:.5em;color:#999} +.listingblock.terminal pre .command:not([data-prompt]):before{content:"$"} +table.pyhltable{border-collapse:separate;border:0;margin-bottom:0;background:none} +table.pyhltable td{vertical-align:top;padding-top:0;padding-bottom:0} +table.pyhltable td.code{padding-left:.75em;padding-right:0} +pre.pygments .lineno,table.pyhltable td:not(.code){color:#999;padding-left:0;padding-right:.5em;border-right:1px solid #ddddd8} +pre.pygments .lineno{display:inline-block;margin-right:.25em} +table.pyhltable .linenodiv{background:none!important;padding-right:0!important} +.quoteblock{margin:0 1em 1.25em 1.5em;display:table} +.quoteblock>.title{margin-left:-1.5em;margin-bottom:.75em} +.quoteblock blockquote,.quoteblock blockquote p{color:rgba(0,0,0,.85);font-size:1.15rem;line-height:1.75;word-spacing:.1em;letter-spacing:0;font-style:italic;text-align:justify} +.quoteblock blockquote{margin:0;padding:0;border:0} +.quoteblock blockquote:before{content:"\201c";float:left;font-size:2.75em;font-weight:bold;line-height:.6em;margin-left:-.6em;color:#7a2518;text-shadow:0 1px 2px rgba(0,0,0,.1)} +.quoteblock blockquote>.paragraph:last-child p{margin-bottom:0} +.quoteblock .attribution{margin-top:.5em;margin-right:.5ex;text-align:right} +.quoteblock .quoteblock{margin-left:0;margin-right:0;padding:.5em 0;border-left:3px solid rgba(0,0,0,.6)} +.quoteblock .quoteblock blockquote{padding:0 0 0 .75em} +.quoteblock .quoteblock blockquote:before{display:none} +.verseblock{margin:0 1em 1.25em 1em} +.verseblock pre{font-family:"Open Sans","DejaVu Sans",sans;font-size:1.15rem;color:rgba(0,0,0,.85);font-weight:300;text-rendering:optimizeLegibility} +.verseblock pre strong{font-weight:400} +.verseblock .attribution{margin-top:1.25rem;margin-left:.5ex} +.quoteblock .attribution,.verseblock .attribution{font-size:.9375em;line-height:1.45;font-style:italic} +.quoteblock .attribution br,.verseblock .attribution br{display:none} +.quoteblock .attribution cite,.verseblock .attribution cite{display:block;letter-spacing:-.05em;color:rgba(0,0,0,.6)} +.quoteblock.abstract{margin:0 0 1.25em 0;display:block} +.quoteblock.abstract blockquote,.quoteblock.abstract blockquote p{text-align:left;word-spacing:0} +.quoteblock.abstract blockquote:before,.quoteblock.abstract blockquote p:first-of-type:before{display:none} +table.tableblock{max-width:100%;border-collapse:separate} +table.tableblock td>.paragraph:last-child p>p:last-child,table.tableblock th>p:last-child,table.tableblock td>p:last-child{margin-bottom:0} +table.spread{width:100%} +table.tableblock,th.tableblock,td.tableblock{border:0 solid #dedede} +table.grid-all th.tableblock,table.grid-all td.tableblock{border-width:0 1px 1px 0} +table.grid-all tfoot>tr>th.tableblock,table.grid-all tfoot>tr>td.tableblock{border-width:1px 1px 0 0} +table.grid-cols th.tableblock,table.grid-cols td.tableblock{border-width:0 1px 0 0} +table.grid-all *>tr>.tableblock:last-child,table.grid-cols *>tr>.tableblock:last-child{border-right-width:0} +table.grid-rows th.tableblock,table.grid-rows td.tableblock{border-width:0 0 1px 0} +table.grid-all tbody>tr:last-child>th.tableblock,table.grid-all tbody>tr:last-child>td.tableblock,table.grid-all thead:last-child>tr>th.tableblock,table.grid-rows tbody>tr:last-child>th.tableblock,table.grid-rows tbody>tr:last-child>td.tableblock,table.grid-rows thead:last-child>tr>th.tableblock{border-bottom-width:0} +table.grid-rows tfoot>tr>th.tableblock,table.grid-rows tfoot>tr>td.tableblock{border-width:1px 0 0 0} +table.frame-all{border-width:1px} +table.frame-sides{border-width:0 1px} +table.frame-topbot{border-width:1px 0} +th.halign-left,td.halign-left{text-align:left} +th.halign-right,td.halign-right{text-align:right} +th.halign-center,td.halign-center{text-align:center} +th.valign-top,td.valign-top{vertical-align:top} +th.valign-bottom,td.valign-bottom{vertical-align:bottom} +th.valign-middle,td.valign-middle{vertical-align:middle} +table thead th,table tfoot th{font-weight:bold} +tbody tr th{display:table-cell;line-height:1.6;background:#f7f8f7} +tbody tr th,tbody tr th p,tfoot tr th,tfoot tr th p{color:rgba(0,0,0,.8);font-weight:bold} +p.tableblock>code:only-child{background:none;padding:0} +p.tableblock{font-size:1em} +td>div.verse{white-space:pre} +ol{margin-left:1.75em} +ul li ol{margin-left:1.5em} +dl dd{margin-left:1.125em} +dl dd:last-child,dl dd:last-child>:last-child{margin-bottom:0} +ol>li p,ul>li p,ul dd,ol dd,.olist .olist,.ulist .ulist,.ulist .olist,.olist .ulist{margin-bottom:.625em} +ul.unstyled,ol.unnumbered,ul.checklist,ul.none{list-style-type:none} +ul.unstyled,ol.unnumbered,ul.checklist{margin-left:.625em} +ul.checklist li>p:first-child>.fa-square-o:first-child,ul.checklist li>p:first-child>.fa-check-square-o:first-child{width:1em;font-size:.85em} +ul.checklist li>p:first-child>input[type="checkbox"]:first-child{width:1em;position:relative;top:1px} +ul.inline{margin:0 auto .625em auto;margin-left:-1.375em;margin-right:0;padding:0;list-style:none;overflow:hidden} +ul.inline>li{list-style:none;float:left;margin-left:1.375em;display:block} +ul.inline>li>*{display:block} +.unstyled dl dt{font-weight:400;font-style:normal} +ol.arabic{list-style-type:decimal} +ol.decimal{list-style-type:decimal-leading-zero} +ol.loweralpha{list-style-type:lower-alpha} +ol.upperalpha{list-style-type:upper-alpha} +ol.lowerroman{list-style-type:lower-roman} +ol.upperroman{list-style-type:upper-roman} +ol.lowergreek{list-style-type:lower-greek} +.hdlist>table,.colist>table{border:0;background:none} +.hdlist>table>tbody>tr,.colist>table>tbody>tr{background:none} +td.hdlist1{padding-right:.75em;font-weight:bold} +td.hdlist1,td.hdlist2{vertical-align:top} +.literalblock+.colist,.listingblock+.colist{margin-top:-.5em} +.colist>table tr>td:first-of-type{padding:0 .75em;line-height:1} +.colist>table tr>td:last-of-type{padding:.25em 0} +.thumb,.th{line-height:0;display:inline-block;border:solid 4px #fff;-webkit-box-shadow:0 0 0 1px #ddd;box-shadow:0 0 0 1px #ddd} +.imageblock.left,.imageblock[style*="float: left"]{margin:.25em .625em 1.25em 0} +.imageblock.right,.imageblock[style*="float: right"]{margin:.25em 0 1.25em .625em} +.imageblock>.title{margin-bottom:0} +.imageblock.thumb,.imageblock.th{border-width:6px} +.imageblock.thumb>.title,.imageblock.th>.title{padding:0 .125em} +.image.left,.image.right{margin-top:.25em;margin-bottom:.25em;display:inline-block;line-height:0} +.image.left{margin-right:.625em} +.image.right{margin-left:.625em} +a.image{text-decoration:none} +span.footnote,span.footnoteref{vertical-align:super;font-size:.875em} +span.footnote a,span.footnoteref a{text-decoration:none} +span.footnote a:active,span.footnoteref a:active{text-decoration:underline} +#footnotes{padding-top:.75em;padding-bottom:.75em;margin-bottom:.625em} +#footnotes hr{width:20%;min-width:6.25em;margin:-.25em 0 .75em 0;border-width:1px 0 0 0} +#footnotes .footnote{padding:0 .375em;line-height:1.3;font-size:.875em;margin-left:1.2em;text-indent:-1.2em;margin-bottom:.2em} +#footnotes .footnote a:first-of-type{font-weight:bold;text-decoration:none} +#footnotes .footnote:last-of-type{margin-bottom:0} +#content #footnotes{margin-top:-.625em;margin-bottom:0;padding:.75em 0} +.gist .file-data>table{border:0;background:#fff;width:100%;margin-bottom:0} +.gist .file-data>table td.line-data{width:99%} +div.unbreakable{page-break-inside:avoid} +.big{font-size:larger} +.small{font-size:smaller} +.underline{text-decoration:underline} +.overline{text-decoration:overline} +.line-through{text-decoration:line-through} +.aqua{color:#00bfbf} +.aqua-background{background-color:#00fafa} +.black{color:#000} +.black-background{background-color:#000} +.blue{color:#0000bf} +.blue-background{background-color:#0000fa} +.fuchsia{color:#bf00bf} +.fuchsia-background{background-color:#fa00fa} +.gray{color:#606060} +.gray-background{background-color:#7d7d7d} +.green{color:#006000} +.green-background{background-color:#007d00} +.lime{color:#00bf00} +.lime-background{background-color:#00fa00} +.maroon{color:#600000} +.maroon-background{background-color:#7d0000} +.navy{color:#000060} +.navy-background{background-color:#00007d} +.olive{color:#606000} +.olive-background{background-color:#7d7d00} +.purple{color:#600060} +.purple-background{background-color:#7d007d} +.red{color:#bf0000} +.red-background{background-color:#fa0000} +.silver{color:#909090} +.silver-background{background-color:#bcbcbc} +.teal{color:#006060} +.teal-background{background-color:#007d7d} +.white{color:#bfbfbf} +.white-background{background-color:#fafafa} +.yellow{color:#bfbf00} +.yellow-background{background-color:#fafa00} +span.icon>.fa{cursor:default} +.admonitionblock td.icon [class^="fa icon-"]{font-size:2.5em;text-shadow:1px 1px 2px rgba(0,0,0,.5);cursor:default} +.admonitionblock td.icon .icon-note:before{content:"\f05a";color:#19407c} +.admonitionblock td.icon .icon-tip:before{content:"\f0eb";text-shadow:1px 1px 2px rgba(155,155,0,.8);color:#111} +.admonitionblock td.icon .icon-warning:before{content:"\f071";color:#bf6900} +.admonitionblock td.icon .icon-caution:before{content:"\f06d";color:#bf3400} +.admonitionblock td.icon .icon-important:before{content:"\f06a";color:#bf0000} +.conum[data-value]{display:inline-block;color:#fff!important;background-color:rgba(0,0,0,.8);-webkit-border-radius:100px;border-radius:100px;text-align:center;font-size:.75em;width:1.67em;height:1.67em;line-height:1.67em;font-family:"Open Sans","DejaVu Sans",sans-serif;font-style:normal;font-weight:bold} +.conum[data-value] *{color:#fff!important} +.conum[data-value]+b{display:none} +.conum[data-value]:after{content:attr(data-value)} +pre .conum[data-value]{position:relative;top:-.125em} +b.conum *{color:inherit!important} +.conum:not([data-value]):empty{display:none} +h1,h2{letter-spacing:-.01em} +dt,th.tableblock,td.content{text-rendering:optimizeLegibility} +p,td.content{letter-spacing:-.01em} +p strong,td.content strong{letter-spacing:-.005em} +p,blockquote,dt,td.content{font-size:1.0625rem} +p{margin-bottom:1.25rem} +.sidebarblock p,.sidebarblock dt,.sidebarblock td.content,p.tableblock{font-size:1em} +.exampleblock>.content{background-color:#fffef7;border-color:#e0e0dc;-webkit-box-shadow:0 1px 4px #e0e0dc;box-shadow:0 1px 4px #e0e0dc} +.print-only{display:none!important} +@media print{@page{margin:1.25cm .75cm} +*{-webkit-box-shadow:none!important;box-shadow:none!important;text-shadow:none!important} +a{color:inherit!important;text-decoration:underline!important} +a.bare,a[href^="#"],a[href^="mailto:"]{text-decoration:none!important} +a[href^="http:"]:not(.bare):after,a[href^="https:"]:not(.bare):after{content:"(" attr(href) ")";display:inline-block;font-size:.875em;padding-left:.25em} +abbr[title]:after{content:" (" attr(title) ")"} +pre,blockquote,tr,img{page-break-inside:avoid} +thead{display:table-header-group} +img{max-width:100%!important} +p,blockquote,dt,td.content{font-size:1em;orphans:3;widows:3} +h2,h3,#toctitle,.sidebarblock>.content>.title{page-break-after:avoid} +#toc,.sidebarblock,.exampleblock>.content{background:none!important} +#toc{border-bottom:1px solid #ddddd8!important;padding-bottom:0!important} +.sect1{padding-bottom:0!important} +.sect1+.sect1{border:0!important} +#header>h1:first-child{margin-top:1.25rem} +body.book #header{text-align:center} +body.book #header>h1:first-child{border:0!important;margin:2.5em 0 1em 0} +body.book #header .details{border:0!important;display:block;padding:0!important} +body.book #header .details span:first-child{margin-left:0!important} +body.book #header .details br{display:block} +body.book #header .details br+span:before{content:none!important} +body.book #toc{border:0!important;text-align:left!important;padding:0!important;margin:0!important} +body.book #toc,body.book #preamble,body.book h1.sect0,body.book .sect1>h2{page-break-before:always} +.listingblock code[data-lang]:before{display:block} +#footer{background:none!important;padding:0 .9375em} +#footer-text{color:rgba(0,0,0,.6)!important;font-size:.9em} +.hide-on-print{display:none!important} +.print-only{display:block!important} +.hide-for-print{display:none!important} +.show-for-print{display:inherit!important}} +div.paragraph.indented p {padding-left: 3em;} +div.paragraph.indented2 p {padding-left: 6em;} +div.paragraph.indented3 p {padding-left: 9em;} + +</style> +<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.4.0/css/font-awesome.min.css";> +<style> +/* Stylesheet for CodeRay to match GitHub theme | MIT License | http://foundation.zurb.com */ +/*pre.CodeRay {background-color:#f7f7f8;}*/ +.CodeRay .line-numbers{border-right:1px solid #d8d8d8;padding:0 0.5em 0 .25em} +.CodeRay span.line-numbers{display:inline-block;margin-right:.5em;color:rgba(0,0,0,.3)} +.CodeRay .line-numbers strong{color:rgba(0,0,0,.4)} +table.CodeRay{border-collapse:separate;border-spacing:0;margin-bottom:0;border:0;background:none} +table.CodeRay td{vertical-align: top;line-height:1.45} +table.CodeRay td.line-numbers{text-align:right} +table.CodeRay td.line-numbers>pre{padding:0;color:rgba(0,0,0,.3)} +table.CodeRay td.code{padding:0 0 0 .5em} +table.CodeRay td.code>pre{padding:0} +.CodeRay .debug{color:#fff !important;background:#000080 !important} +.CodeRay .annotation{color:#007} +.CodeRay .attribute-name{color:#000080} +.CodeRay .attribute-value{color:#700} +.CodeRay .binary{color:#509} +.CodeRay .comment{color:#998;font-style:italic} +.CodeRay .char{color:#04d} +.CodeRay .char .content{color:#04d} +.CodeRay .char .delimiter{color:#039} +.CodeRay .class{color:#458;font-weight:bold} +.CodeRay .complex{color:#a08} +.CodeRay .constant,.CodeRay .predefined-constant{color:#008080} +.CodeRay .color{color:#099} +.CodeRay .class-variable{color:#369} +.CodeRay .decorator{color:#b0b} +.CodeRay .definition{color:#099} +.CodeRay .delimiter{color:#000} +.CodeRay .doc{color:#970} +.CodeRay .doctype{color:#34b} +.CodeRay .doc-string{color:#d42} +.CodeRay .escape{color:#666} +.CodeRay .entity{color:#800} +.CodeRay .error{color:#808} +.CodeRay .exception{color:inherit} +.CodeRay .filename{color:#099} +.CodeRay .function{color:#900;font-weight:bold} +.CodeRay .global-variable{color:#008080} +.CodeRay .hex{color:#058} +.CodeRay .integer,.CodeRay .float{color:#099} +.CodeRay .include{color:#555} +.CodeRay .inline{color:#000} +.CodeRay .inline .inline{background:#ccc} +.CodeRay .inline .inline .inline{background:#bbb} +.CodeRay .inline .inline-delimiter{color:#d14} +.CodeRay .inline-delimiter{color:#d14} +.CodeRay .important{color:#555;font-weight:bold} +.CodeRay .interpreted{color:#b2b} +.CodeRay .instance-variable{color:#008080} +.CodeRay .label{color:#970} +.CodeRay .local-variable{color:#963} +.CodeRay .octal{color:#40e} +.CodeRay .predefined{color:#369} +.CodeRay .preprocessor{color:#579} +.CodeRay .pseudo-class{color:#555} +.CodeRay .directive{font-weight:bold} +.CodeRay .type{font-weight:bold} +.CodeRay .predefined-type{color:inherit} +.CodeRay .reserved,.CodeRay .keyword {color:#000;font-weight:bold} +.CodeRay .key{color:#808} +.CodeRay .key .delimiter{color:#606} +.CodeRay .key .char{color:#80f} +.CodeRay .value{color:#088} +.CodeRay .regexp .delimiter{color:#808} +.CodeRay .regexp .content{color:#808} +.CodeRay .regexp .modifier{color:#808} +.CodeRay .regexp .char{color:#d14} +.CodeRay .regexp .function{color:#404;font-weight:bold} +.CodeRay .string{color:#d20} +.CodeRay .string .string .string{background:#ffd0d0} +.CodeRay .string .content{color:#d14} +.CodeRay .string .char{color:#d14} +.CodeRay .string .delimiter{color:#d14} +.CodeRay .shell{color:#d14} +.CodeRay .shell .delimiter{color:#d14} +.CodeRay .symbol{color:#990073} +.CodeRay .symbol .content{color:#a60} +.CodeRay .symbol .delimiter{color:#630} +.CodeRay .tag{color:#008080} +.CodeRay .tag-special{color:#d70} +.CodeRay .variable{color:#036} +.CodeRay .insert{background:#afa} +.CodeRay .delete{background:#faa} +.CodeRay .change{color:#aaf;background:#007} +.CodeRay .head{color:#f8f;background:#505} +.CodeRay .insert .insert{color:#080} +.CodeRay .delete .delete{color:#800} +.CodeRay .change .change{color:#66f} +.CodeRay .head .head{color:#f4f} +</style> +</head> +<body class="book toc2 toc-left"> +<div id="header"> +<h1>Trafodion Messages Guide</h1> +<div class="details"> +<span id="author" class="author">Version 1.3.0, January 2016</span><br> +</div> +<div id="toc" class="toc2"> +<div id="toctitle">Table of Contents</div> +<ul class="sectlevel1"> +<li><a href="#_about_this_document">1. About This Document</a> +<ul class="sectlevel2"> +<li><a href="#_intended_audience">1.1. Intended Audience</a></li> +<li><a href="#_new_and_changed_information">1.2. New and Changed Information</a></li> +<li><a href="#_notation_conventions">1.3. Notation Conventions</a></li> +<li><a href="#_publishing_history">1.4. Publishing History</a></li> +<li><a href="#_comments_encouraged">1.5. Comments Encouraged</a></li> +</ul> +</li> +<li><a href="#_introduction">2. Introduction</a> +<ul class="sectlevel2"> +<li><a href="#_message_handling">2.1. Message Handling</a></li> +<li><a href="#viewing-trafodion-database-messages">2.2. Viewing Trafodion Database Messages</a></li> +<li><a href="#sqlstate-and-sqlcode">2.3. SQLSTATE and SQLCODE</a></li> +<li><a href="#getting-help">2.4. Getting Help</a></li> +</ul> +</li> +<li><a href="#data-definition-language-messages">3. Data Definition Language (DDL) Messages (1000 through 1999)</a> +<ul class="sectlevel2"> +<li><a href="#SQL-1002">3.1. SQL 1002</a></li> +<li><a href="#SQL-1003">3.2. SQL 1003</a></li> +<li><a href="#SQL-1004">3.3. SQL 1004</a></li> +<li><a href="#SQL-1005">3.4. SQL 1005</a></li> +<li><a href="#SQL-1006">3.5. SQL 1006</a></li> +<li><a href="#SQL-1008">3.6. SQL 1008</a></li> +<li><a href="#SQL-1009">3.7. SQL 1009</a></li> +<li><a href="#SQL-1010">3.8. SQL 1010</a></li> +<li><a href="#SQL-1012">3.9. SQL 1012</a></li> +<li><a href="#SQL-1013">3.10. SQL 1013</a></li> +<li><a href="#SQL-1014">3.11. SQL 1014</a></li> +<li><a href="#SQL-1015">3.12. SQL 1015</a></li> +<li><a href="#SQL-1016">3.13. SQL 1016</a></li> +<li><a href="#SQL-1017">3.14. SQL 1017</a></li> +<li><a href="#SQL-1020">3.15. SQL 1020</a></li> +<li><a href="#SQL-1021">3.16. SQL 1021</a></li> +<li><a href="#SQL-1022">3.17. SQL 1022</a></li> +<li><a href="#SQL-1023">3.18. SQL 1023</a></li> +<li><a href="#SQL-1024">3.19. SQL 1024</a></li> +<li><a href="#SQL-1025">3.20. SQL 1025</a></li> +<li><a href="#SQL-1026">3.21. SQL 1026</a></li> +<li><a href="#SQL-1027">3.22. SQL 1027</a></li> +<li><a href="#SQL-1028">3.23. SQL 1028</a></li> +<li><a href="#SQL-1029">3.24. SQL 1029</a></li> +<li><a href="#SQL-1030">3.25. SQL 1030</a></li> +<li><a href="#SQL-1031">3.26. SQL 1031</a></li> +<li><a href="#SQL-1035">3.27. SQL 1035</a></li> +<li><a href="#SQL-1036">3.28. SQL 1036</a></li> +<li><a href="#SQL-1037">3.29. SQL 1037</a></li> +<li><a href="#SQL-1038">3.30. SQL 1038</a></li> +<li><a href="#SQL-1039">3.31. SQL 1039</a></li> +<li><a href="#SQL-1040">3.32. SQL 1040</a></li> +<li><a href="#SQL-1041">3.33. SQL 1041</a></li> +<li><a href="#SQL-1042">3.34. SQL 1042</a></li> +<li><a href="#SQL-1043">3.35. SQL 1043</a></li> +<li><a href="#SQL-1044">3.36. SQL 1044</a></li> +<li><a href="#SQL-1045">3.37. SQL 1045</a></li> +<li><a href="#SQL-1046">3.38. SQL 1046</a></li> +<li><a href="#SQL-1047">3.39. SQL 1047</a></li> +<li><a href="#SQL-1048">3.40. SQL 1048</a></li> +<li><a href="#SQL-1049">3.41. SQL 1049</a></li> +<li><a href="#SQL-1050">3.42. SQL 1050</a></li> +<li><a href="#SQL-1051">3.43. SQL 1051</a></li> +<li><a href="#SQL-1053">3.44. SQL 1053</a></li> +<li><a href="#SQL-1057">3.45. SQL 1057</a></li> +<li><a href="#SQL-1058">3.46. SQL 1058</a></li> +<li><a href="#SQL-1059">3.47. SQL 1059</a></li> +<li><a href="#SQL-1061">3.48. SQL 1061</a></li> +<li><a href="#SQL-1062">3.49. SQL 1062</a></li> +<li><a href="#SQL-1063">3.50. SQL 1063</a></li> +<li><a href="#SQL-1064">3.51. SQL 1064</a></li> +<li><a href="#SQL-1065">3.52. SQL 1065</a></li> +<li><a href="#SQL-1066">3.53. SQL 1066</a></li> +<li><a href="#SQL-1069">3.54. SQL 1069</a></li> +<li><a href="#SQL-1070">3.55. SQL 1070</a></li> +<li><a href="#SQL-1071">3.56. SQL 1071</a></li> +<li><a href="#SQL-1072">3.57. SQL 1072</a></li> +<li><a href="#SQL-1073">3.58. SQL 1073</a></li> +<li><a href="#SQL-1075">3.59. SQL 1075</a></li> +<li><a href="#SQL-1078">3.60. SQL 1078</a></li> +<li><a href="#SQL-1079">3.61. SQL 1079</a></li> +<li><a href="#SQL-1080">3.62. SQL 1080</a></li> +<li><a href="#SQL-1081">3.63. SQL 1081</a></li> +<li><a href="#SQL-1082">3.64. SQL 1082</a></li> +<li><a href="#SQL-1083">3.65. SQL 1083</a></li> +<li><a href="#SQL-1084">3.66. SQL 1084</a></li> +<li><a href="#SQL-1085">3.67. SQL 1085</a></li> +<li><a href="#SQL-1086">3.68. SQL 1086</a></li> +<li><a href="#SQL-1087">3.69. SQL 1087</a></li> +<li><a href="#SQL-1088">3.70. SQL 1088</a></li> +<li><a href="#SQL-1089">3.71. SQL 1089</a></li> +<li><a href="#SQL-1090">3.72. SQL 1090</a></li> +<li><a href="#SQL-1094">3.73. SQL 1094</a></li> +<li><a href="#SQL-1095">3.74. SQL 1095</a></li> +<li><a href="#SQL-1098">3.75. SQL 1098</a></li> +<li><a href="#SQL-1099">3.76. SQL 1099</a></li> +<li><a href="#SQL-1104">3.77. SQL 1104</a></li> +<li><a href="#SQL-1105">3.78. SQL 1105</a></li> +<li><a href="#SQL-1106">3.79. SQL 1106</a></li> +<li><a href="#SQL-1108">3.80. SQL 1108</a></li> +<li><a href="#SQL-1109">3.81. SQL 1109</a></li> +<li><a href="#SQL-1112">3.82. SQL 1112</a></li> +<li><a href="#SQL-1114">3.83. SQL 1114</a></li> +<li><a href="#SQL-1115">3.84. SQL 1115</a></li> +<li><a href="#SQL-1116">3.85. SQL 1116</a></li> +<li><a href="#SQL-1117">3.86. SQL 1117</a></li> +<li><a href="#SQL-1118">3.87. SQL 1118</a></li> +<li><a href="#SQL-1119">3.88. SQL 1119</a></li> +<li><a href="#SQL-1120">3.89. SQL 1120</a></li> +<li><a href="#SQL-1121">3.90. SQL 1121</a></li> +<li><a href="#SQL-1122">3.91. SQL 1122</a></li> +<li><a href="#SQL-1123">3.92. SQL 1123</a></li> +<li><a href="#SQL-1124">3.93. SQL 1124</a></li> +<li><a href="#SQL-1127">3.94. SQL 1127</a></li> +<li><a href="#SQL-1130">3.95. SQL 1130</a></li> +<li><a href="#SQL-1132">3.96. SQL 1132</a></li> +<li><a href="#SQL-1133">3.97. SQL 1133</a></li> +<li><a href="#SQL-1134">3.98. SQL 1134</a></li> +<li><a href="#SQL-1135">3.99. SQL 1135</a></li> +<li><a href="#SQL-1136">3.100. SQL 1136</a></li> +<li><a href="#SQL-1139">3.101. SQL 1139</a></li> +<li><a href="#SQL-1140">3.102. SQL 1140</a></li> +<li><a href="#SQL-1141">3.103. SQL 1141</a></li> +<li><a href="#SQL-1142">3.104. SQL 1142</a></li> +<li><a href="#SQL-1143">3.105. SQL 1143</a></li> +<li><a href="#SQL-1144">3.106. SQL 1144</a></li> +<li><a href="#SQL-1145">3.107. SQL 1145</a></li> +<li><a href="#SQL-1146">3.108. SQL 1146</a></li> +<li><a href="#SQL-1147">3.109. SQL 1147</a></li> +<li><a href="#SQL-1148">3.110. SQL 1148</a></li> +<li><a href="#SQL-1150">3.111. SQL 1150</a></li> +<li><a href="#SQL-1151">3.112. SQL 1151</a></li> +<li><a href="#SQL-1154">3.113. SQL 1154</a></li> +<li><a href="#SQL-1155">3.114. SQL 1155</a></li> +<li><a href="#SQL-1156">3.115. SQL 1156</a></li> +<li><a href="#SQL-1157">3.116. SQL 1157</a></li> +<li><a href="#SQL-1158">3.117. SQL 1158</a></li> +<li><a href="#SQL-1159">3.118. SQL 1159</a></li> +<li><a href="#SQL-1160">3.119. SQL 1160</a></li> +<li><a href="#SQL-1161">3.120. SQL 1161</a></li> +<li><a href="#SQL-1180">3.121. SQL 1180</a></li> +<li><a href="#SQL-1181">3.122. SQL 1181</a></li> +<li><a href="#SQL-1182">3.123. SQL 1182</a></li> +<li><a href="#SQL-1183">3.124. SQL 1183</a></li> +<li><a href="#SQL-1184">3.125. SQL 1184</a></li> +<li><a href="#SQL-1185">3.126. SQL 1185</a></li> +<li><a href="#SQL-1186">3.127. SQL 1186</a></li> +<li><a href="#SQL-1187">3.128. SQL 1187</a></li> +<li><a href="#SQL-1188">3.129. SQL 1188</a></li> +<li><a href="#SQL-1224">3.130. SQL 1224</a></li> +<li><a href="#SQL-1225">3.131. SQL 1225</a></li> +<li><a href="#SQL-1226">3.132. SQL 1226</a></li> +<li><a href="#SQL-1231">3.133. SQL 1231</a></li> +<li><a href="#SQL-1232">3.134. SQL 1232</a></li> +<li><a href="#SQL-1233">3.135. SQL 1233</a></li> +<li><a href="#SQL-1235">3.136. SQL 1235</a></li> +<li><a href="#SQL-1236">3.137. SQL 1236</a></li> +<li><a href="#SQL-1238">3.138. SQL 1238</a></li> +<li><a href="#SQL-1239">3.139. SQL 1239</a></li> +<li><a href="#SQL-1240">3.140. SQL 1240</a></li> +<li><a href="#SQL-1241">3.141. SQL 1241</a></li> +<li><a href="#SQL-1242">3.142. SQL 1242</a></li> +<li><a href="#SQL-1243">3.143. SQL 1243</a></li> +<li><a href="#SQL-1245">3.144. SQL 1245</a></li> +<li><a href="#SQL-1246">3.145. SQL 1246</a></li> +<li><a href="#SQL-1248">3.146. SQL 1248</a></li> +<li><a href="#SQL-1250">3.147. SQL 1250</a></li> +<li><a href="#SQL-1251">3.148. SQL 1251</a></li> +<li><a href="#SQL-1252">3.149. SQL 1252</a></li> +<li><a href="#SQL-1254">3.150. SQL 1254</a></li> +<li><a href="#SQL-1262">3.151. SQL 1262</a></li> +<li><a href="#SQL-1263">3.152. SQL 1263</a></li> +<li><a href="#SQL-1264">3.153. SQL 1264</a></li> +<li><a href="#SQL-1265">3.154. SQL 1265</a></li> +<li><a href="#SQL-1266">3.155. SQL 1266</a></li> +<li><a href="#SQL-1267">3.156. SQL 1267</a></li> +<li><a href="#SQL-1268">3.157. SQL 1268</a></li> +<li><a href="#SQL-1270">3.158. SQL 1270</a></li> +<li><a href="#SQL-1271">3.159. SQL 1271</a></li> +<li><a href="#SQL-1273">3.160. SQL 1273</a></li> +<li><a href="#SQL-1274">3.161. SQL 1274</a></li> +<li><a href="#SQL-1275">3.162. SQL 1275</a></li> +<li><a href="#SQL-1277">3.163. SQL 1277</a></li> +<li><a href="#SQL-1278">3.164. SQL 1278</a></li> +<li><a href="#SQL-1301">3.165. SQL 1301</a></li> +<li><a href="#SQL-1302">3.166. SQL 1302</a></li> +<li><a href="#SQL-1305">3.167. SQL 1305</a></li> +<li><a href="#SQL-1307">3.168. SQL 1307</a></li> +<li><a href="#SQL-1309">3.169. SQL 1309</a></li> +<li><a href="#SQL-1310">3.170. SQL 1310</a></li> +</ul> +</li> +<li><a href="#trafodion-compiler-messages">4. Trafodion Compiler Messages (2000 through 2999)</a> +<ul class="sectlevel2"> +<li><a href="#SQL-2004">4.1. SQL 2004</a></li> +<li><a href="#SQL-2009">4.2. SQL 2009</a></li> +<li><a href="#SQL-2011">4.3. SQL 2011</a></li> +<li><a href="#SQL-2012">4.4. SQL 2012</a></li> +<li><a href="#SQL-2013">4.5. SQL 2013</a></li> +<li><a href="#SQL-2014">4.6. SQL 2014</a></li> +<li><a href="#SQL-2020">4.7. SQL 2020</a></li> +<li><a href="#SQL-2029">4.8. SQL 2029</a></li> +<li><a href="#SQL-2030">4.9. SQL 2030</a></li> +<li><a href="#SQL-2033">4.10. SQL 2033</a></li> +<li><a href="#SQL-2034">4.11. SQL 2034</a></li> +<li><a href="#SQL-2035">4.12. SQL 2035</a></li> +<li><a href="#SQL-2038">4.13. SQL 2038</a></li> +<li><a href="#SQL-2050">4.14. SQL 2050</a></li> +<li><a href="#SQL-2051">4.15. SQL 2051</a></li> +<li><a href="#SQL-2053">4.16. SQL 2053</a></li> +<li><a href="#SQL-2054">4.17. SQL 2054</a></li> +<li><a href="#SQL-2055">4.18. SQL 2055</a></li> +<li><a href="#SQL-2056">4.19. SQL 2056</a></li> +<li><a href="#SQL-2057">4.20. SQL 2057</a></li> +<li><a href="#SQL-2058">4.21. SQL 2058</a></li> +<li><a href="#SQL-2059">4.22. SQL 2059</a></li> +<li><a href="#SQL-2060">4.23. SQL 2060</a></li> +<li><a href="#SQL-2061">4.24. SQL 2061</a></li> +<li><a href="#SQL-2062">4.25. SQL 2062</a></li> +<li><a href="#SQL-2063">4.26. SQL 2063</a></li> +<li><a href="#SQL-2064">4.27. SQL 2064</a></li> +<li><a href="#SQL-2065">4.28. SQL 2065</a></li> +<li><a href="#SQL-2066">4.29. SQL 2066</a></li> +<li><a href="#SQL-2067">4.30. SQL 2067</a></li> +<li><a href="#SQL-2068">4.31. SQL 2068</a></li> +<li><a href="#SQL-2069">4.32. SQL 2069</a></li> +<li><a href="#SQL-2070">4.33. SQL 2070</a></li> +<li><a href="#SQL-2071">4.34. SQL 2071</a></li> +<li><a href="#SQL-2072">4.35. SQL 2072</a></li> +<li><a href="#SQL-2073">4.36. SQL 2073</a></li> +<li><a href="#SQL-2074">4.37. SQL 2074</a></li> +<li><a href="#SQL-2075">4.38. SQL 2075</a></li> +<li><a href="#SQL-2076">4.39. SQL 2076</a></li> +<li><a href="#SQL-2080">4.40. SQL 2080</a></li> +<li><a href="#SQL-2081">4.41. SQL 2081</a></li> +<li><a href="#SQL-2082">4.42. SQL 2082</a></li> +<li><a href="#SQL-2083">4.43. SQL 2083</a></li> +<li><a href="#SQL-2084">4.44. SQL 2084</a></li> +<li><a href="#SQL-2085">4.45. SQL 2085</a></li> +<li><a href="#SQL-2086">4.46. SQL 2086</a></li> +<li><a href="#SQL-2090">4.47. SQL 2090</a></li> +<li><a href="#SQL-2091">4.48. SQL 2091</a></li> +<li><a href="#SQL-2092">4.49. SQL 2092</a></li> +<li><a href="#SQL-2093">4.50. SQL 2093</a></li> +<li><a href="#SQL-2094">4.51. SQL 2094</a></li> +<li><a href="#SQL-2095">4.52. SQL 2095</a></li> +<li><a href="#SQL-2096">4.53. SQL 2096</a></li> +<li><a href="#SQL-2097">4.54. SQL 2097</a></li> +<li><a href="#SQL-2098">4.55. SQL 2098</a></li> +<li><a href="#SQL-2099">4.56. SQL 2099</a></li> +<li><a href="#SQL-2100">4.57. SQL 2100</a></li> +<li><a href="#SQL-2102">4.58. SQL 2102</a></li> +<li><a href="#SQL-2103">4.59. SQL 2103</a></li> +<li><a href="#SQL-2104">4.60. SQL 2104</a></li> +<li><a href="#SQL-2105">4.61. SQL 2105</a></li> +<li><a href="#SQL-2106">4.62. SQL 2106</a></li> +<li><a href="#SQL-2107">4.63. SQL 2107</a></li> +<li><a href="#SQL-2108">4.64. SQL 2108</a></li> +<li><a href="#SQL-2200">4.65. SQL 2200</a></li> +<li><a href="#SQL-2201">4.66. SQL 2201</a></li> +<li><a href="#SQL-2202">4.67. SQL 2202</a></li> +<li><a href="#SQL-2203">4.68. SQL 2203</a></li> +<li><a href="#SQL-2204">4.69. SQL 2204</a></li> +<li><a href="#SQL-2205">4.70. SQL 2205</a></li> +<li><a href="#SQL-2206">4.71. SQL 2206</a></li> +<li><a href="#SQL-2207">4.72. SQL 2207</a></li> +<li><a href="#SQL-2208">4.73. SQL 2208</a></li> +<li><a href="#SQL-2209">4.74. SQL 2209</a></li> +<li><a href="#SQL-2210">4.75. SQL 2210</a></li> +<li><a href="#SQL-2211">4.76. SQL 2211</a></li> +<li><a href="#SQL-2212">4.77. SQL 2212</a></li> +<li><a href="#SQL-2213">4.78. SQL 2213</a></li> +<li><a href="#SQL-2214">4.79. SQL 2214</a></li> +<li><a href="#SQL-2215">4.80. SQL 2215</a></li> +<li><a href="#SQL-2220">4.81. SQL 2220</a></li> +<li><a href="#SQL-2221">4.82. SQL 2221</a></li> +<li><a href="#SQL-2222">4.83. SQL 2222</a></li> +<li><a href="#SQL-2223">4.84. SQL 2223</a></li> +<li><a href="#SQL-2233">4.85. SQL 2233</a></li> +<li><a href="#SQL-2900">4.86. SQL 2900</a></li> +</ul> +</li> +<li><a href="#parser-and-compilation-messages">5. Parser and Compilation Messages (3000 through 3999)</a> +<ul class="sectlevel2"> +<li><a href="#SQL-3001">5.1. SQL 3001</a></li> +<li><a href="#SQL-3002">5.2. SQL 3002</a></li> +<li><a href="#SQL-3003">5.3. SQL 3003</a></li> +<li><a href="#SQL-3004">5.4. SQL 3004</a></li> +<li><a href="#SQL-3005">5.5. SQL 3005</a></li> +<li><a href="#SQL-3006">5.6. SQL 3006</a></li> +<li><a href="#SQL-3007">5.7. SQL 3007</a></li> +<li><a href="#SQL-3008">5.8. SQL 3008</a></li> +<li><a href="#SQL-3009">5.9. SQL 3009</a></li> +<li><a href="#SQL-3010">5.10. SQL 3010</a></li> +<li><a href="#SQL-3011">5.11. SQL 3011</a></li> +<li><a href="#SQL-3012">5.12. SQL 3012</a></li> +<li><a href="#SQL-3013">5.13. SQL 3013</a></li> +<li><a href="#SQL-3014">5.14. SQL 3014</a></li> +<li><a href="#SQL-3015">5.15. SQL 3015</a></li> +<li><a href="#SQL-3016">5.16. SQL 3016</a></li> +<li><a href="#SQL-3017">5.17. SQL 3017</a></li> +<li><a href="#SQL-3018">5.18. SQL 3018</a></li> +<li><a href="#SQL-3019">5.19. SQL 3019</a></li> +<li><a href="#SQL-3020">5.20. SQL 3020</a></li> +<li><a href="#SQL-3021">5.21. SQL 3021</a></li> +<li><a href="#SQL-3022">5.22. SQL 3022</a></li> +<li><a href="#SQL-3023">5.23. SQL 3023</a></li> +<li><a href="#SQL-3024">5.24. SQL 3024</a></li> +<li><a href="#SQL-3025">5.25. SQL 3025</a></li> +<li><a href="#SQL-3026">5.26. SQL 3026</a></li> +<li><a href="#SQL-3027">5.27. SQL 3027</a></li> +<li><a href="#SQL-3028">5.28. SQL 3028</a></li> +<li><a href="#SQL-3029">5.29. SQL 3029</a></li> +<li><a href="#SQL-3030">5.30. SQL 3030</a></li> +<li><a href="#SQL-3031">5.31. SQL 3031</a></li> +<li><a href="#SQL-3032">5.32. SQL 3032</a></li> +<li><a href="#SQL-3033-">5.33. SQL 3033</a></li> +<li><a href="#SQL-3034-">5.34. SQL 3034</a></li> +<li><a href="#SQL-3035-">5.35. SQL 3035</a></li> +<li><a href="#SQL-3036">5.36. SQL 3036</a></li> +<li><a href="#SQL-3037">5.37. SQL 3037</a></li> +<li><a href="#SQL-3038">5.38. SQL 3038</a></li> +<li><a href="#SQL-3039">5.39. SQL 3039</a></li> +<li><a href="#SQL-3040">5.40. SQL 3040</a></li> +<li><a href="#SQL-3041">5.41. SQL 3041</a></li> +<li><a href="#SQL-3042">5.42. SQL 3042</a></li> +<li><a href="#SQL-3043">5.43. SQL 3043</a></li> +<li><a href="#SQL-3044">5.44. SQL 3044</a></li> +<li><a href="#SQL-3045">5.45. SQL 3045</a></li> +<li><a href="#SQL-3046">5.46. SQL 3046</a></li> +<li><a href="#SQL-3047">5.47. SQL 3047</a></li> +<li><a href="#SQL-3048">5.48. SQL 3048</a></li> +<li><a href="#SQL-3049">5.49. SQL 3049</a></li> +<li><a href="#SQL-3050">5.50. SQL 3050</a></li> +<li><a href="#SQL-3051">5.51. SQL 3051</a></li> +<li><a href="#SQL-3052">5.52. SQL 3052</a></li> +<li><a href="#SQL-3053">5.53. SQL 3053</a></li> +<li><a href="#SQL-3054">5.54. SQL 3054</a></li> +<li><a href="#SQL-3055">5.55. SQL 3055</a></li> +<li><a href="#SQL-3056">5.56. SQL 3056</a></li> +<li><a href="#SQL-3057">5.57. SQL 3057</a></li> +<li><a href="#SQL-3058">5.58. SQL 3058</a></li> +<li><a href="#SQL-3059">5.59. SQL 3059</a></li> +<li><a href="#SQL-3060">5.60. SQL 3060</a></li> +<li><a href="#SQL-3061">5.61. SQL 3061</a></li> +<li><a href="#SQL-3062">5.62. SQL 3062</a></li> +<li><a href="#SQL-3063">5.63. SQL 3063</a></li> +<li><a href="#SQL-3064">5.64. SQL 3064</a></li> +<li><a href="#SQL-3065">5.65. SQL 3065</a></li> +<li><a href="#SQL-3067">5.66. SQL 3067</a></li> +<li><a href="#SQL-3068">5.67. SQL 3068</a></li> +<li><a href="#SQL-3070">5.68. SQL 3070</a></li> +<li><a href="#SQL-3071">5.69. SQL 3071</a></li> +<li><a href="#SQL-3072">5.70. SQL 3072</a></li> +<li><a href="#SQL-3073">5.71. SQL 3073</a></li> +<li><a href="#SQL-3074">5.72. SQL 3074</a></li> +<li><a href="#SQL-3075">5.73. SQL 3075</a></li> +<li><a href="#SQL-3076">5.74. SQL 3076</a></li> +<li><a href="#SQL-3077">5.75. SQL 3077</a></li> +<li><a href="#SQL-3078">5.76. SQL 3078</a></li> +<li><a href="#SQL-3079">5.77. SQL 3079</a></li> +<li><a href="#SQL-3080">5.78. SQL 3080</a></li> +<li><a href="#SQL-3081">5.79. SQL 3081</a></li> +<li><a href="#SQL-3082">5.80. SQL 3082</a></li> +<li><a href="#SQL-3083">5.81. SQL 3083</a></li> +<li><a href="#SQL-3084">5.82. SQL 3084</a></li> +<li><a href="#SQL-3085">5.83. SQL 3085</a></li> +<li><a href="#SQL-3086">5.84. SQL 3086</a></li> +<li><a href="#SQL-3087">5.85. SQL 3087</a></li> +<li><a href="#SQL-3088">5.86. SQL 3088</a></li> +<li><a href="#SQL-3089">5.87. SQL 3089</a></li> +<li><a href="#SQL-3090">5.88. SQL 3090</a></li> +<li><a href="#SQL-3091">5.89. SQL 3091</a></li> +<li><a href="#SQL-3092">5.90. SQL 3092</a></li> +<li><a href="#SQL-3093">5.91. SQL 3093</a></li> +<li><a href="#SQL-3094">5.92. SQL 3094</a></li> +<li><a href="#SQL-3095">5.93. SQL 3095</a></li> +<li><a href="#SQL-3096">5.94. SQL 3096</a></li> +<li><a href="#SQL-3097">5.95. SQL 3097</a></li> +<li><a href="#SQL-3098">5.96. SQL 3098</a></li> +<li><a href="#SQL-3099">5.97. SQL 3099</a></li> +<li><a href="#SQL-3100">5.98. SQL 3100</a></li> +<li><a href="#SQL-3101">5.99. SQL 3101</a></li> +<li><a href="#SQL-3102">5.100. SQL 3102</a></li> +<li><a href="#SQL-3103">5.101. SQL 3103</a></li> +<li><a href="#SQL-3104">5.102. SQL 3104</a></li> +<li><a href="#SQL-3105">5.103. SQL 3105</a></li> +<li><a href="#SQL-3106">5.104. SQL 3106</a></li> +<li><a href="#SQL-3107">5.105. SQL 3107</a></li> +<li><a href="#SQL-3108">5.106. SQL 3108</a></li> +<li><a href="#SQL-3109">5.107. SQL 3109</a></li> +<li><a href="#SQL-3110">5.108. SQL 3110</a></li> +<li><a href="#SQL-3111">5.109. SQL 3111</a></li> +<li><a href="#SQL-3112">5.110. SQL 3112</a></li> +<li><a href="#SQL-3113">5.111. SQL 3113</a></li> +<li><a href="#SQL-3114">5.112. SQL 3114</a></li> +<li><a href="#SQL-3115">5.113. SQL 3115</a></li> +<li><a href="#SQL-3116">5.114. SQL 3116</a></li> +<li><a href="#SQL-3117">5.115. SQL 3117</a></li> +<li><a href="#SQL-3118">5.116. SQL 3118</a></li> +<li><a href="#SQL-3119">5.117. SQL 3119</a></li> +<li><a href="#SQL-3120">5.118. SQL 3120</a></li> +<li><a href="#SQL-3122">5.119. SQL 3122</a></li> +<li><a href="#SQL-3123">5.120. SQL 3123</a></li> +<li><a href="#SQL-3127">5.121. SQL 3127</a></li> +<li><a href="#SQL-3128">5.122. SQL 3128</a></li> +<li><a href="#SQL-3129">5.123. SQL 3129</a></li> +<li><a href="#SQL-3130">5.124. SQL 3130</a></li> +<li><a href="#SQL-3131">5.125. SQL 3131</a></li> +<li><a href="#SQL-3132">5.126. SQL 3132</a></li> +<li><a href="#SQL-3133">5.127. SQL 3133</a></li> +<li><a href="#SQL-3134">5.128. SQL 3134</a></li> +<li><a href="#SQL-3135">5.129. SQL 3135</a></li> +<li><a href="#SQL-3136">5.130. SQL 3136</a></li> +<li><a href="#SQL-3137">5.131. SQL 3137</a></li> +<li><a href="#SQL-3138">5.132. SQL 3138</a></li> +<li><a href="#SQL-3139">5.133. SQL 3139</a></li> +<li><a href="#SQL-3140">5.134. SQL 3140</a></li> +<li><a href="#SQL-3141">5.135. SQL 3141</a></li> +<li><a href="#SQL-3142">5.136. SQL 3142</a></li> +<li><a href="#SQL-3143">5.137. SQL 3143</a></li> +<li><a href="#SQL-3145">5.138. SQL 3145</a></li> +<li><a href="#SQL-3147">5.139. SQL 3147</a></li> +<li><a href="#SQL-3148">5.140. SQL 3148</a></li> +<li><a href="#SQL-3149">5.141. SQL 3149</a></li> +<li><a href="#SQL-3150">5.142. SQL 3150</a></li> +<li><a href="#SQL-3151">5.143. SQL 3151</a></li> +<li><a href="#SQL-3153">5.144. SQL 3153</a></li> +<li><a href="#SQL-3155">5.145. SQL 3155</a></li> +<li><a href="#SQL-3157">5.146. SQL 3157</a></li> +<li><a href="#SQL-3158">5.147. SQL 3158</a></li> +<li><a href="#SQL-3159">5.148. SQL 3159</a></li> +<li><a href="#SQL-3160">5.149. SQL 3160</a></li> +<li><a href="#SQL-3161">5.150. SQL 3161</a></li> +<li><a href="#SQL-3162">5.151. SQL 3162</a></li> +<li><a href="#SQL-3163">5.152. SQL 3163</a></li> +<li><a href="#SQL-3164">5.153. SQL 3164</a></li> +<li><a href="#SQL-3165">5.154. SQL 3165</a></li> +<li><a href="#SQL-3166">5.155. SQL 3166</a></li> +<li><a href="#SQL-3167">5.156. SQL 3167</a></li> +<li><a href="#SQL-3168">5.157. SQL 3168</a></li> +<li><a href="#SQL-3169">5.158. SQL 3169</a></li> +<li><a href="#SQL-3171">5.159. SQL 3171</a></li> +<li><a href="#SQL-3172">5.160. SQL 3172</a></li> +<li><a href="#SQL-3173">5.161. SQL 3173</a></li> +<li><a href="#SQL-3174">5.162. SQL 3174</a></li> +<li><a href="#SQL-3175">5.163. SQL 3175</a></li> +<li><a href="#SQL-3176">5.164. SQL 3176</a></li> +<li><a href="#SQL-3177">5.165. SQL 3177</a></li> +<li><a href="#SQL-3178">5.166. SQL 3178</a></li> +<li><a href="#SQL-3179">5.167. SQL 3179</a></li> +<li><a href="#SQL-3180">5.168. SQL 3180</a></li> +<li><a href="#SQL-3181">5.169. SQL 3181</a></li> +<li><a href="#SQL-3182">5.170. SQL 3182</a></li> +<li><a href="#SQL-3183">5.171. SQL 3183</a></li> +<li><a href="#SQL-3184">5.172. SQL 3184</a></li> +<li><a href="#SQL-3185">5.173. SQL 3185</a></li> +<li><a href="#SQL-3186">5.174. SQL 3186</a></li> +<li><a href="#SQL-3187">5.175. SQL 3187</a></li> +<li><a href="#SQL-3188">5.176. SQL 3188</a></li> +<li><a href="#SQL-3189">5.177. SQL 3189</a></li> +<li><a href="#SQL-3192">5.178. SQL 3192</a></li> +<li><a href="#SQL-3193">5.179. SQL 3193</a></li> +<li><a href="#SQL-3195">5.180. SQL 3195</a></li> +<li><a href="#SQL-3196">5.181. SQL 3196</a></li> +<li><a href="#SQL-3197">5.182. SQL 3197</a></li> +<li><a href="#SQL-3199">5.183. SQL 3199</a></li> +<li><a href="#SQL-3201">5.184. SQL 3201</a></li> +<li><a href="#SQL-3202">5.185. SQL 3202</a></li> +<li><a href="#SQL-3203">5.186. SQL 3203</a></li> +<li><a href="#SQL-3204">5.187. SQL 3204</a></li> +<li><a href="#SQL-3205">5.188. SQL 3205</a></li> +<li><a href="#SQL-3206">5.189. SQL 3206</a></li> +<li><a href="#SQL-3207">5.190. SQL 3207</a></li> +<li><a href="#SQL-3208">5.191. SQL 3208</a></li> +<li><a href="#SQL-3209">5.192. SQL 3209</a></li> +<li><a href="#SQL-3210">5.193. SQL 3210</a></li> +<li><a href="#SQL-3211">5.194. SQL 3211</a></li> +<li><a href="#SQL-3212">5.195. SQL 3212</a></li> +<li><a href="#SQL-3213">5.196. SQL 3213</a></li> +<li><a href="#SQL-3214">5.197. SQL 3214</a></li> +<li><a href="#SQL-3215">5.198. SQL 3215</a></li> +<li><a href="#SQL-3216">5.199. SQL 3216</a></li> +<li><a href="#SQL-3217">5.200. SQL 3217</a></li> +<li><a href="#SQL-3218">5.201. SQL 3218</a></li> +<li><a href="#SQL-3220">5.202. SQL 3220</a></li> +<li><a href="#SQL-3225">5.203. SQL 3225</a></li> +<li><a href="#SQL-3226">5.204. SQL 3226</a></li> +<li><a href="#SQL-3228">5.205. SQL 3228</a></li> +<li><a href="#SQL-3229">5.206. SQL 3229</a></li> +<li><a href="#SQL-3230">5.207. SQL 3230</a></li> +<li><a href="#SQL-3400">5.208. SQL 3400</a></li> +<li><a href="#SQL-3401">5.209. SQL 3401</a></li> +<li><a href="#SQL-3402">5.210. SQL 3402</a></li> +<li><a href="#SQL-3403">5.211. SQL 3403</a></li> +<li><a href="#SQL-3404">5.212. SQL 3404</a></li> +<li><a href="#SQL-3405">5.213. SQL 3405</a></li> +<li><a href="#SQL-3406">5.214. SQL 3406</a></li> +<li><a href="#SQL-3411">5.215. SQL 3411</a></li> +<li><a href="#SQL-3412">5.216. SQL 3412</a></li> +<li><a href="#SQL-3413">5.217. SQL 3413</a></li> +<li><a href="#SQL-3414">5.218. SQL 3414</a></li> +</ul> +</li> +<li><a href="#optimizer-messages">6. Optimizer Messages (6000 through 6999)</a> +<ul class="sectlevel2"> +<li><a href="#SQL-6001">6.1. SQL 6001</a></li> +<li><a href="#SQL-6002">6.2. SQL 6002</a></li> +<li><a href="#SQL-6003">6.3. SQL 6003</a></li> +<li><a href="#SQL-6007">6.4. SQL 6007</a></li> +<li><a href="#SQL-6008">6.5. SQL 6008</a></li> +</ul> +</li> +<li><a href="#generator-messages">7. Generator Messages (7000 through 7999)</a> +<ul class="sectlevel2"> +<li><a href="#SQL-7001">7.1. SQL 7001</a></li> +<li><a href="#SQL-7003">7.2. SQL 7003</a></li> +</ul> +</li> +<li><a href="#executor-messages">8. Executor Messages (8000 through 8999)</a> +<ul class="sectlevel2"> +<li><a href="#SQL-8006">8.1. SQL 8006</a></li> +<li><a href="#SQL-8007">8.2. SQL 8007</a></li> +<li><a href="#SQL-8012">8.3. SQL 8012</a></li> +<li><a href="#SQL-8016">8.4. SQL 8016</a></li> +<li><a href="#SQL-8017">8.5. SQL 8017</a></li> +<li><a href="#SQL-8101">8.6. SQL 8101</a></li> +<li><a href="#SQL-8102">8.7. SQL 8102</a></li> +<li><a href="#SQL-8103">8.8. SQL 8103</a></li> +<li><a href="#SQL-8104">8.9. SQL 8104</a></li> +<li><a href="#SQL-8105">8.10. SQL 8105</a></li> +<li><a href="#SQL-8302">8.11. SQL 8302</a></li> +<li><a href="#SQL-8553">8.12. SQL 8553</a></li> +<li><a href="#SQL-8573">8.13. SQL 8573</a></li> +<li><a href="#SQL-8576">8.14. SQL 8576</a></li> +<li><a href="#SQL-8577">8.15. SQL 8577</a></li> +<li><a href="#SQL-8578">8.16. SQL 8578</a></li> +<li><a href="#SQL-8579">8.17. SQL 8579</a></li> +<li><a href="#SQL-8604">8.18. SQL 8604</a></li> +<li><a href="#SQL-8605">8.19. SQL 8605</a></li> +<li><a href="#SQL-8606">8.20. SQL 8606</a></li> +<li><a href="#SQL-8607">8.21. SQL 8607</a></li> +<li><a href="#SQL-8608">8.22. SQL 8608</a></li> +<li><a href="#SQL-8609">8.23. SQL 8609</a></li> +<li><a href="#SQL-8610">8.24. SQL 8610</a></li> +<li><a href="#SQL-8612">8.25. SQL 8612</a></li> +<li><a href="#SQL-8613">8.26. SQL 8613</a></li> +<li><a href="#SQL-8808">8.27. SQL 8808</a></li> +<li><a href="#SQL-8809">8.28. SQL 8809</a></li> +<li><a href="#SQL-8819">8.29. SQL 8819</a></li> +<li><a href="#SQL-8820">8.30. SQL 8820</a></li> +<li><a href="#SQL-8821">8.31. SQL 8821</a></li> +<li><a href="#SQL-8824">8.32. SQL 8824</a></li> +<li><a href="#SQL-8826">8.33. SQL 8826</a></li> +<li><a href="#SQL-8827">8.34. SQL 8827</a></li> +<li><a href="#SQL-8832">8.35. SQL 8832</a></li> +<li><a href="#SQL-8833">8.36. SQL 8833</a></li> +<li><a href="#SQL-8834">8.37. SQL 8834</a></li> +<li><a href="#SQL-8836">8.38. SQL 8836</a></li> +<li><a href="#SQL-8837">8.39. SQL 8837</a></li> +<li><a href="#SQL-8840">8.40. SQL 8840</a></li> +<li><a href="#SQL-8841">8.41. SQL 8841</a></li> +<li><a href="#SQL-8842">8.42. SQL 8842</a></li> +<li><a href="#SQL-8846">8.43. SQL 8846</a></li> +<li><a href="#SQL-8850">8.44. SQL 8850</a></li> +<li><a href="#SQL-8860">8.45. SQL 8860</a></li> +<li><a href="#SQL-8861">8.46. SQL 8861</a></li> +<li><a href="#SQL-8862">8.47. SQL 8862</a></li> +<li><a href="#SQL-8863">8.48. SQL 8863</a></li> +<li><a href="#SQL-8864">8.49. SQL 8864</a></li> +<li><a href="#SQL-8865">8.50. SQL 8865</a></li> +<li><a href="#SQL-8866">8.51. SQL 8866</a></li> +<li><a href="#SQL-8867">8.52. SQL 8867</a></li> +<li><a href="#SQL-8882">8.53. SQL 8882</a></li> +<li><a href="#SQL-8888">8.54. SQL 8888</a></li> +<li><a href="#SQL-8890">8.55. SQL 8890</a></li> +<li><a href="#SQL-8901">8.56. SQL 8901</a></li> +<li><a href="#SQL-8904">8.57. SQL 8904</a></li> +</ul> +</li> +<li><a href="#sort-messages">9. Sort Messages (9200 through 10049)</a> +<ul class="sectlevel2"> +<li><a href="#SQL-9200">9.1. SQL 9200</a></li> +<li><a href="#SQL-9201">9.2. SQL 9201</a></li> +<li><a href="#SQL-9202">9.3. SQL 9202</a></li> +<li><a href="#SQL-9203">9.4. SQL 9203</a></li> +<li><a href="#SQL-9204">9.5. SQL 9204</a></li> +<li><a href="#SQL-9205">9.6. SQL 9205</a></li> +<li><a href="#SQL-9206">9.7. SQL 9206</a></li> +<li><a href="#SQL-9207">9.8. SQL 9207</a></li> +<li><a href="#SQL-9208">9.9. SQL 9208</a></li> +<li><a href="#SQL-9209">9.10. SQL 9209</a></li> +<li><a href="#SQL-9210">9.11. SQL 9210</a></li> +<li><a href="#SQL-9212">9.12. SQL 9212</a></li> +<li><a href="#SQL-9213">9.13. SQL 9213</a></li> +<li><a href="#SQL-9214">9.14. SQL 9214</a></li> +<li><a href="#SQL-10007-">9.15. SQL 10007</a></li> +<li><a href="#SQL-10011-">9.16. SQL 10011</a></li> +<li><a href="#SQL-10013-">9.17. SQL 10013</a></li> +<li><a href="#SQL-10014-">9.18. SQL 10014</a></li> +<li><a href="#SQL-10015-">9.19. SQL 10015</a></li> +<li><a href="#SQL-10016-">9.20. SQL 10016</a></li> +<li><a href="#SQL-10017-">9.21. SQL 10017</a></li> +<li><a href="#SQL-10018-">9.22. SQL 10018</a></li> +<li><a href="#SQL-10019-">9.23. SQL 10019</a></li> +<li><a href="#SQL-10020-">9.24. SQL 10020</a></li> +<li><a href="#SQL-10021-">9.25. SQL 10021</a></li> +<li><a href="#SQL-10022-">9.26. SQL 10022</a></li> +<li><a href="#SQL-10023-">9.27. SQL 10023</a></li> +<li><a href="#SQL-10024-">9.28. SQL 10024</a></li> +<li><a href="#SQL-10027-">9.29. SQL 10027</a></li> +<li><a href="#SQL-10028-">9.30. SQL 10028</a></li> +<li><a href="#SQL-10029-">9.31. SQL 10029</a></li> +<li><a href="#SQL-10047-">9.32. SQL 10047</a></li> +<li><a href="#SQL-10048-">9.33. SQL 10048</a></li> +</ul> +</li> +<li><a href="#udr-server-and-language-manager-messages">10. UDR Server and Language Manager Messages (11000 through 11399)</a> +<ul class="sectlevel2"> +<li><a href="#SQL-11108">10.1. SQL 11108</a></li> +<li><a href="#SQL-11201">10.2. SQL 11201</a></li> +<li><a href="#SQL-11202">10.3. SQL 11202</a></li> +<li><a href="#SQL-11221">10.4. SQL 11221</a></li> +<li><a href="#SQL-11222">10.5. SQL 11222</a></li> +</ul> +</li> +<li><a href="#sqlstate">11. SQLSTATE</a> +<ul class="sectlevel2"> +<li><a href="#sqlstate-and-sqlcode-considerations">11.1. SQLSTATE and SQLCODE Considerations</a></li> +<li><a href="#sqlstate-values">11.2. SQLSTATE Values</a></li> +</ul> +</li> +<li><a href="#file-system-errors">12. File-System Errors</a></li> +</ul> +</div> +</div> +<div id="content"> +<div id="preamble"> +<div class="sectionbody"> +<div class="paragraph"> +<p><strong>License Statement</strong></p> +</div> +<div class="paragraph"> +<p>Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file +distributed with this work for additional information regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with +the License. You may obtain a copy of the License at <a href="http://www.apache.org/licenses/LICENSE-2.0"; class="bare">http://www.apache.org/licenses/LICENSE-2.0</a></p> +</div> +<div class="paragraph"> +<p>Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the +specific language governing permissions and limitations under the License.</p> +</div> +<table class="tableblock frame-all grid-all spread"> +<colgroup> +<col style="width: 50%;"> +<col style="width: 50%;"> +</colgroup> +<thead> +<tr> +<th class="tableblock halign-left valign-top">Version</th> +<th class="tableblock halign-left valign-top">Date</th> +</tr> +</thead> +<tbody> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">1.3.0</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">January, 2016</p></td> +</tr> +</tbody> +</table> +</div> +</div> +<div class="sect1"> +<h2 id="_about_this_document">1. About This Document</h2> +<div class="sectionbody"> +<div class="paragraph"> +<p>Trafodion is a relational database management system based on +ANSI SQL. It uses the industry standard Structured Query Language +(SQL) to define and manipulate data. This manual describes messages +produced by the Trafodion SQL engine and its associated +components.</p> +</div> +<div class="sect2"> +<h3 id="_intended_audience">1.1. Intended Audience</h3> +<div class="paragraph"> +<p>This manual was written for Trafodion database administrators and +programmers who use the Trafodion database software conversational or +programmatic interface.</p> +</div> +</div> +<div class="sect2"> +<h3 id="_new_and_changed_information">1.2. New and Changed Information</h3> +<div class="paragraph"> +<p>This is a new manual.</p> +</div> +</div> +<div class="sect2"> +<h3 id="_notation_conventions">1.3. Notation Conventions</h3> +<div class="paragraph"> +<p>This list summarizes the notation conventions for syntax presentation in this manual.</p> +</div> +<div class="ulist"> +<ul> +<li> +<p>UPPERCASE LETTERS</p> +<div class="paragraph"> +<p>Uppercase letters indicate keywords and reserved words. Type these items exactly as shown. Items not enclosed in brackets are required.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">SELECT</code></pre> +</div> +</div> +</li> +<li> +<p>lowercase letters</p> +<div class="paragraph"> +<p>Lowercase letters, regardless of font, indicate variable items that you supply. Items not enclosed in brackets are required.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">file-name</code></pre> +</div> +</div> +</li> +</ul> +</div> +<div style="page-break-after: always;"></div> +<div class="ulist"> +<ul> +<li> +<p>[ ] Brackets</p> +<div class="paragraph"> +<p>Brackets enclose optional syntax items.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">DATETIME [start-field TO] end-field</code></pre> +</div> +</div> +<div class="paragraph"> +<p>A group of items enclosed in brackets is a list from which you can choose one item or none.</p> +</div> +<div class="paragraph"> +<p>The items in the list can be arranged either vertically, with aligned brackets on each side of the list, or horizontally, enclosed in a pair of brackets and separated by vertical lines.</p> +</div> +<div class="paragraph"> +<p>For example:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">DROP SCHEMA schema [CASCADE] +DROP SCHEMA schema [ CASCADE | RESTRICT ]</code></pre> +</div> +</div> +</li> +<li> +<p>{ } Braces</p> +<div class="paragraph"> +<p>Braces enclose required syntax items.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">FROM { grantee [, grantee ] ... }</code></pre> +</div> +</div> +<div class="paragraph"> +<p>A group of items enclosed in braces is a list from which you are required to choose one item.</p> +</div> +<div class="paragraph"> +<p>The items in the list can be arranged either vertically, with aligned braces on each side of the list, or horizontally, enclosed in a pair of braces and separated by vertical lines.</p> +</div> +<div class="paragraph"> +<p>For example:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">INTERVAL { start-field TO end-field } +{ single-field } +INTERVAL { start-field TO end-field | single-field }</code></pre> +</div> +</div> +</li> +<li> +<p>| Vertical Line</p> +<div class="paragraph"> +<p>A vertical line separates alternatives in a horizontal list that is enclosed in brackets or braces.</p> +</div> +</li> +</ul> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">{expression | NULL}</code></pre> +</div> +</div> +<div style="page-break-after: always;"></div> +<div class="ulist"> +<ul> +<li> +<p>… Ellipsis</p> +<div class="paragraph"> +<p>An ellipsis immediately following a pair of brackets or braces indicates that you can repeat the enclosed sequence of syntax items any number of times.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">ATTRIBUTE[S] attribute [, attribute] ... +{, sql-expression } ...</code></pre> +</div> +</div> +<div class="paragraph"> +<p>An ellipsis immediately following a single syntax item indicates that you can repeat that syntax item any number of times.</p> +</div> +<div class="paragraph"> +<p>For example:</p> +</div> +</li> +</ul> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">expression-n ...</code></pre> +</div> +</div> +<div class="ulist"> +<ul> +<li> +<p>Punctuation</p> +<div class="paragraph"> +<p>Parentheses, commas, semicolons, and other symbols not previously described must be typed as shown.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">DAY (datetime-expression) +@script-file</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Quotation marks around a symbol such as a bracket or brace indicate the symbol is a required character that you must type as shown.</p> +</div> +<div class="paragraph"> +<p>For example:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">"{" module-name [, module-name] ... "}"</code></pre> +</div> +</div> +</li> +</ul> +</div> +<div style="page-break-after: always;"></div> +<div class="ulist"> +<ul> +<li> +<p>Item Spacing</p> +<div class="paragraph"> +<p>Spaces shown between items are required unless one of the items is a punctuation symbol such as a parenthesis or a comma.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">DAY (datetime-expression) DAY(datetime-expression)</code></pre> +</div> +</div> +<div class="paragraph"> +<p>If there is no space between two items, spaces are not permitted. In this example, no spaces are permitted between the period and any other items:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">myfile.sh</code></pre> +</div> +</div> +</li> +<li> +<p>Line Spacing</p> +<div class="paragraph"> +<p>If the syntax of a command is too long to fit on a single line, each continuation line is indented three spaces and is separated from the preceding line by a blank line.</p> +</div> +<div class="paragraph"> +<p>This spacing distinguishes items in a continuation line from items in a vertical list of selections.</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">match-value [NOT] LIKE _pattern + [ESCAPE esc-char-expression]</code></pre> +</div> +</div> +</li> +</ul> +</div> +</div> +<div class="sect2"> +<h3 id="_publishing_history">1.4. Publishing History</h3> +<table class="tableblock frame-all grid-all spread"> +<colgroup> +<col style="width: 50%;"> +<col style="width: 50%;"> +</colgroup> +<thead> +<tr> +<th class="tableblock halign-left valign-top">Product Version</th> +<th class="tableblock halign-left valign-top">Publication Date</th> +</tr> +</thead> +<tbody> +<tr> +<td class="tableblock halign-left valign-top"><p class="tableblock">Trafodion Release 1.3.0</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">To be announced.</p></td> +</tr> +</tbody> +</table> +</div> +<div class="sect2"> +<h3 id="_comments_encouraged">1.5. Comments Encouraged</h3> +<div class="paragraph"> +<p>The Trafodion community encourages your comments concerning this document. We are committed to providing documentation that meets your +needs. Send any errors found, suggestions for improvement, or compliments to:</p> +</div> +<div class="paragraph"> +<p><a href="mailto:[email protected]";>[email protected]</a></p> +</div> +<div class="paragraph"> +<p>Include the document title and any comment, error found, or suggestion for improvement you have concerning this document.</p> +</div> +</div> +</div> +</div> +<div class="sect1"> +<h2 id="_introduction">2. Introduction</h2> +<div class="sectionbody"> +<div class="sect2"> +<h3 id="_message_handling">2.1. Message Handling</h3> +<div class="paragraph"> +<p>Trafodion reports exception condition messages at a Trafodion Database +Connectivity Service conversational interface (DCS) window and in the +Trafodion Command Interface (TrafCI).</p> +</div> +<div class="paragraph"> +<p>Most Trafodion exception condition messages describe error conditions +for which recovery action is required. Some messages are warnings that +provide information for which no action is required.</p> +</div> +<div class="paragraph"> +<p>Error messages that appear in response to SQL commands are logged to the +DCS application’s log file if you have used the LOG command to request +them.</p> +</div> +<div class="paragraph"> +<p>The format of a Trafodion error is "<strong>*</strong> ERROR" followed by the error number +in brackets, and the descriptive text. Use the error number shown to find +information about a particular error in this manual. For example, information +for Trafodion error 1125 can be found under "SQL 1125."</p> +</div> +<div class="paragraph"> +<p>Messages are listed in this manual in numeric order, broken down by the component +that produced them.</p> +</div> +</div> +<div class="sect2"> +<h3 id="viewing-trafodion-database-messages">2.2. Viewing Trafodion Database Messages</h3> +<div class="paragraph"> +<p>The message key is a sequential SQL message number that is returned +automatically by Trafodion when an exception condition +occurs. For example, the following message might be displayed within +your application development tool while you prepare an embedded SQL +program:</p> +</div> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">*** ERROR[1000] A syntax error occurred.</code></pre> +</div> +</div> +<div style="page-break-after: always;"></div> +<div class="paragraph"> +<p>This message number is the SQLCODE value (without the sign). In this +manual, you will find the following message information for ERROR[1000]:</p> +</div> +<div class="exampleblock"> +<div class="content"> +<div class="paragraph"> +<p><strong>SQL 1000</strong></p> +</div> +<div class="paragraph"> +<p>1000 A syntax error occurred.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You specified a statement with incorrect syntax.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The Trafodion statement fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Correct the syntax and resubmit.</p> +</div> +</div> +</div> +</div> +<div class="sect2"> +<h3 id="sqlstate-and-sqlcode">2.3. SQLSTATE and SQLCODE</h3> +<div class="paragraph"> +<p>SQLSTATE and SQLCODE status codes are returned to indicate either that +an SQL statement completed successfully or that an exception condition +was raised during execution of an SQL statement.</p> +</div> +<div class="paragraph"> +<p>The ANSI SQL SQLSTATE variable is a five-character string with a +two-character class code followed by a three-character subclass code. An +SQLSTATE value of 00000 indicates successful completion.</p> +</div> +<div class="paragraph"> +<p>Trafodion extends the ANSI SQL SQLSTATE values to include other situations +not described by the ANSI values. If an ANSI SQL SQLSTATE value exists for +an error condition, the Trafodion database software returns that value. +Otherwise, Trafodion returns an SQLSTATE value that is defined by the Trafodion +database software.</p> +</div> +<div class="paragraph"> +<p>Trafodion also returns a numeric SQLCODE value after SQL statement execution. +SQLCODE values with negative numbers signify errors.</p> +</div> +<div class="paragraph"> +<p>SQLCODE values with positive numbers other than 0 (successful completion) or 100 +(no data was found) signify warning messages. Trafodion identifies all messages +by their unsigned SQLCODE value and their calculated SQLSTATE value. The SQLCODE +is used to calculate the SQLSTATE value for all Trafodion messages other than +those for which an ANSI SQL SQLSTATE value exists.</p> +</div> +<div class="paragraph"> +<p>The SQLCODE parameter is a deprecated feature that is supported to +maintain compatibility with earlier versions of the American standard.</p> +</div> +<div class="paragraph"> +<p><a href="#sqlstate-values"><em>SQLSTATE Values</em></a> identifies the equivalent SQLSTATE and +SQLCODE values for Trafodion warning and error messages.</p> +</div> +</div> +<div class="sect2"> +<h3 id="getting-help">2.4. Getting Help</h3> +<div class="paragraph"> +<p>Some messages have no recovery and you will be instructed to contact the +mailt:[email protected][Trafodion user mailing list].</p> +</div> +</div> +</div> +</div> +<div class="sect1"> +<h2 id="data-definition-language-messages">3. Data Definition Language (DDL) Messages (1000 through 1999)</h2> +<div class="sectionbody"> +<div class="sect2"> +<h3 id="SQL-1002">3.1. SQL 1002</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Catalog <catalog> does not exist or has not been registered on node <node>.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <catalog> is the ANSI name of the target catalog.</p> +</div> +<div class="paragraph"> +<p>Where <node> is the node where the process executes.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> The catalog is not visible on the local node, either because it +does not exist or because it exists elsewhere on the network but has not +been registered on the local node.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Enter a valid catalog name (or register the catalog on the +node indicated) and resubmit.</p> +</div> +</div> +<div class="sect2"> +<h3 id="SQL-1003">3.2. SQL 1003</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Schema <schema> does not exist.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <schema> is the ANSI name of the affected schema.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> In a replication context: a REPLICATION SCHEMA operation +specified a schema that does not exist.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Check that a schema named <schema> does exist and resubmit.</p> +</div> +<div style="page-break-after: always;"></div> +</div> +<div class="sect2"> +<h3 id="SQL-1004">3.3. SQL 1004</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Table, view, or stored procedure <object-name> does not exist or object type is invalid for the current operation.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <object-name> is the name of a Trafodion database object.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted an operation on an object that does not exist.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Check that an object named <object-name> does exist. If you +did not fully qualify the name, check that the defaults generate the +correct fully qualified name and resubmit.</p> +</div> +</div> +<div class="sect2"> +<h3 id="SQL-1005">3.4. SQL 1005</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Constraint <constraint-name> does not exist.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <constraint-name> is the name of a column constraint or table +constraint.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> The ALTER TABLE statement you attempted requires the existence +of a constraint named <constraint-name>.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Check that a constraint named <constraint-name> exists for +the table specified. You can use the SHOWDDL command to find the names +of the constraints that exist on a table.</p> +</div> +<div style="page-break-after: always;"></div> +</div> +<div class="sect2"> +<h3 id="SQL-1006">3.5. SQL 1006</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Index <index-name> does not exist.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <index-name> is a Trafodion database object name.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> The operation you attempted requires the existence of an index +named <index-name>.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Check that an index named <index-name> does exist. If you +did not fully qualify the name, check that the defaults generate the +correct qualified name.</p> +</div> +</div> +<div class="sect2"> +<h3 id="SQL-1008">3.6. SQL 1008</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">User name <user-name> does not exist.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <user-name> is a Trafodion platform user name.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> The user name specified in a GRANT or REVOKE statement, or the +authorization ID in a CREATE SCHEMA statement, does not represent a +valid Trafodion platform user.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Correct the user name and resubmit.</p> +</div> +<div style="page-break-after: always;"></div> +</div> +<div class="sect2"> +<h3 id="SQL-1009">3.7. SQL 1009</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Column <column-name> does not exist in the specified table.</code></pre> +</div> +</div> +<div class="paragraph"> +<p>Where <column-name> is an SQL identifier.</p> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> The table that is referenced does not have a column with this +name.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Replace either the name of the table or the name of the +column (whichever is incorrect) and resubmit.</p> +</div> +</div> +<div class="sect2"> +<h3 id="SQL-1010">3.8. SQL 1010</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">The statement just specified is currently not supported.</code></pre> +</div> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> The statement that you specified is not available for use.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> The operation fails.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> Do not attempt to use this Trafodion database statement.</p> +</div> +<div style="page-break-after: always;"></div> +</div> +<div class="sect2"> +<h3 id="SQL-1012">3.9. SQL 1012</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">No privileges were granted. You lack grant option on the specified privileges.</code></pre> +</div> +</div> +<div class="paragraph"> +<p><strong>Cause:</strong> You attempted to grant privileges for which you do not have +grant options.</p> +</div> +<div class="paragraph"> +<p><strong>Effect:</strong> No privileges are granted.</p> +</div> +<div class="paragraph"> +<p><strong>Recovery:</strong> You must have grant options for privileges to grant them.</p> +</div> +</div> +<div class="sect2"> +<h3 id="SQL-1013">3.10. SQL 1013</h3> +<div class="listingblock"> +<div class="content"> +<pre class="CodeRay highlight"><code data-lang="text">Not all privileges were granted. You lack grant option on some of the speci
<TRUNCATED>
