View source for ODBC: Supported SQL Grammar

From Recital Documentation Wiki

← ODBC: Supported SQL Grammar

You do not have permission to edit this page, for the following reason:

---

You can view and copy the source of this page:

The grammar declarations are described with these notations: {| class="wikitable" !Notation||Description |- |<blank>||No qualifier is required |- |<command> | <command>||Use one of the specified commands |- |[qualifier]||Optional qualifier, may be omitted |- |(paramval)||Required parameter value |- |expression||Numeric or string calculation |- |} ==statement== statement::= ALTER [[#alter|alter]] | CREATE [[#create|create]] | DELETE [[#delete|delete]] | DROP [[#drop|drop]] | INSERT [[#insert|insert]] | GRANT [[#grant|grant]] | RECITAL [[#recital|recital]] | REVOKE [[#revoke|revoke]] | SELECT [[#select|select]] | UPDATE [[#update|update]] ====aggterm==== COUNT (*) | AVG ([[#expression|expression]]) | MAX ([[#expression|expression]]) | MIN ([[#expression|expression]]) | MIN ([[#expression|expression]]) | SUM ([[#expression|expression]]) ====alias==== AS [[#aliasname|aliasname]] ====aliasname==== [[#identifier|identifier]] ====alter==== TABLE [[#tablename|tablename]] ADD ([[#createcols|createcols]]) ====and==== [[#not|not]] | [[#not|not]] AND [[#and|and]] ====asc==== <blank> | ASC | DESC ====boolean==== <blank> [[#and|and]] | [[#and|and]] OR [[#boolean|boolean]] ====coldesc==== <blank> | DESCRIPTION [[#string|string]] ====colref==== [[#aliasname|aliasname]].[[#columnname|columnname]] | [[#columnname|columnname]] ====column==== [[#columnname|columnname]] ====columnlist==== [[#identifier|identifier]], [[#identifier|identifier]] | [[#identifier|identifier]] ====columnname==== [[#identifier|identifier]] ====comparison==== ([[#boolean|boolean]]) | [[#colref|colref]] IS NULL | [[#colref|colref]] IS NOT NULL | [[#expression|expression]] LIKE [[#pattern|pattern]] | [[#expression|expression]] NOT LIKE [[#pattern|pattern]] | [[#expression|expression]] IN {[[#valuelist|valuelist]]} | [[#expression|expression]] NOT IN {[[#valuelist|valuelist]]} | [[#expression|expression]] [[#op|op]] [[#expression|expression]] ====create==== TABLE [[#tablename|tablename]] ([[#createcols|createcols]]) | 0 [UNIQUE] INDEX [[#indexname|indexname]] ON [[#tablename|tablename]] ([[#indexcols|indexcols]]) ====createcol==== [[#columnname|columnname]] [[#datatype|datatype]] [[#coldesc|coldesc]] | [[#columnname|columnname]] [[#datatype|datatype]] ([[#integer|integer]]) [[#coldesc|coldesc]] | [[#columnname|columnname]] [[#datatype|datatype]] ([[#integer|integer]], [[#integer|integer]]) [[#coldesc|coldesc]] ====createcols==== [[#createcol|createcol]], [[#createcols|createcols]] | [[#createcol|createcol]] ====cursorname==== [[#identifier|identifier]] ====datatype==== CHAR | VARCHAR | LONG VARCHAR | DECIMAL | NUMERIC | SMALLINT | INTEGER | REAL | FLOAT | DOUBLE PRECISION | BIT | TINYINT | SHORT | DATE | LOGICAL | MEMO | BYTE | CURRENCY | DATETIME | LONG VARBINARY | ZONED ====date==== a date in ODBC escape clause format (for example, {d'1996-04-04'} or --(*vendor(Microsoft), product(ODBC)d'1996-04-04'*)-- ====delete==== FROM [[#tablename|tablename]] [[#where|where]] ====drop==== TABLE [[#tablename|tablename]] | INDEX [[#indexname|indexname]] ====expression==== [[#expression|expression]] + [[#times|times]] | [[#expression|expression]] - [[#times|times]] | [[#times|times]] ====forupdate==== <blank> | FOR UPDATE | FOR UPDATE OF [[#columnlist|columnlist]] ====grant==== [[#privilege|privilege]] ON [[#tablename|tablename]] TO [[#usergroups|usergroups]] ====groupby==== GROUP BY [[#groupbyterms|groupbyterms]] ====groupbyterms==== [[#colref|colref]] | [[#colref|colref]], [[#groupbyterms|groupbyterms]] ====groups==== [[#integer|integer]], [[#groups|groups]] | [[#integer|integer]] | [[#integer|integer]] – [[#integer|integer]], [[#groups|groups]] | [[#integer|integer]] – [[#integer|integer]] | * ====having==== <blank> | HAVING [[#boolean|boolean]] ====identifier==== an identifier (identifiers containing spaces must be enclosed in double quotes) ====indexcols==== [[#columnname|columnname]] [ASC | DESC] | [[#indexcols|indexcols]], [[#indexcols|indexcols]] ====indexname==== [[#identifier|identifier]] ====insert==== INTO [[#tablename|tablename]] [[#insertvals|insertvals]] ====insertvals==== ([[#columnlist|columnlist]]) VALUES ([[#valuelist|valuelist]]) | VALUES ([[#valuelist|valuelist]]) ====integer==== a non-negative integer ====join==== INNER JOIN | OUTER JOIN | LEFT [OUTER] JOIN | RIGHT [OUTER] JOIN | CROSS JOIN [[#tableref|tableref]] ON [[#table|table]].[[#column|column]] = [[#table|table]].[[#column|column]] ====neg==== [#term|term]] | + [#term|term]] | - [#term|term]] ====not==== [#comparison|comparison]] | NOT [#comparison|comparison]] ====op==== > | >= | < | <= | = | <> ====orderby==== <blank> | ORDER BY [[#orderbyterms|orderbyterms]] ====orderbyterm==== [[#colref|colref]] [asc]] | [[#integer|integer]] [asc]] ====orderbyterms==== [[#orderbyterm|orderbyterm]] | [[#orderbyterm|orderbyterm]], [[#orderbyterms|orderbyterms]] ====pattern==== [#string|string]] | ? | USER ====privilege==== ALL | ALTER | DELETE | INSERT | READ ONLY [[#columnlist|columnlist]] | SELECT [[#columnlist|columnlist]] | UPDATE [[#columnlist|columnlist]] ====realnumber==== a non-negative real number ====recital==== any recital command excluding user interface commands ====revoke==== [[#privilege|privilege]] ON [[#tablename|tablename]] FROM [[#usergroups|usergroups]] ====select==== [[#selectcols|selectcols]] FROM [[#tablelist|tablelist]] [[#where|where]] [[#groupby|groupby]] [[#having|having]] [[#orderby|orderby]] [[#forupdate|forupdate]] ====selectallcols==== <blank>| ALL | DISTINCT ====selectcols==== [[#selectallcols|selectallcols]] * | [[#selectallcols|selectallcols]] [[#selectlist|selectlist]] ====selectlist==== [[#expression|expression]], [[#selectlist|selectlist]] | [[#expression|expression]] ====set==== [[#column|column]] = NULL | [[#column|column]] = [[#simpleterm|simpleterm]] ====setlist==== [[#set|set]] | [[#setlist|setlist]], [[#set|set]] ====simpleterm==== [[#string|string]] | [[#realnumber|realnumber]] | ? | USER | [[#date|date]] | [[#time|time]] | [[#timestamp|timestamp]] ====string==== a string (enclosed in single quotes) ====table==== [[#tablename|tablename]] | [[#aliasname|aliasname]] ====tablelist==== [[#tableref|tableref]], [[#tablelist|tablelist]] | [[#tableref|tableref]] | [[#tableref|tableref]] [[#join|join] | [[#viewname|viewname]] ====tablename==== [[#identifier|identifier]] ====tableref==== [[#tablename|tablename]] | [[#tablename|tablename]] [[#alias|alias]] ====term==== ([[#expression|expression]]) | [[#colref|colref]] | [[#simpleterm|simpleterm]] | [[#aggterm|aggterm]] ====time==== a time in ODBC escape clause format (for example,{t'10:19:48'} or --(*vendor(Microsoft), product(ODBC)t'10:19:48'*)-- ====times==== [[#times|times]] * [[#neg|neg]] | [[#times|times]] / [[#neg|neg]] | [[#neg|neg]] ====timestamp==== a timestamp in ODBC escape clause format (for example, {ts'1996-04-04 10:19:48.529'} or --(*vendor(Microsoft), product(ODBC)ts'1996-04-04 10:19:54.529'*) ====update==== [[#tablename|tablename]] SET [[#setlist|setlist]] [[#where|where]] ====usergroup==== user and group access control string in the format '[users,groups]' ====usergroups==== [[#usergroup|usergroup]], [[#usergroups|usergroups]] | PUBLIC ====users==== [[#integer|integer]], [[#users|users]] | [[#integer|integer]] | [[#integer|integer]] – [[#integer|integer]] , [[#users|users]] | [[#integer|integer]] – [[#integer|integer]] | * ====valuelist==== NULL, [[#valuelist|valuelist]] | [[#expression|expression]], [[#valuelist|valuelist]] | [[#expression|expression]] | NULL ====viewname==== [[#identifier|identifier]] ====where==== <blank> | WHERE [[#boolean|boolean]] | WHERE CURRENT OF [[#cursorname|cursorname]] [[Category:Documentation]] [[Category:Reference]] [[Category:ODBC|SQL Grammar]] [[Category:SQL]]

Return to ODBC: Supported SQL Grammar.