docs.intersystems.com
InterSystems IRIS Data Platform 2019.2  /  InterSystems SQL Reference

InterSystems SQL Reference
Syntax Conventions Used in this Manual
Previous section          
InterSystems: The power behind what matters   
Search:  


Specifies conventions used in the InterSystems SQL Reference.
Description
The following are the format conventions used in this manual. Theseformat characters explain usage; they are not specifiedwhen coding an SQL program. For a table of the symbols that are used in SQLcoding, refer to the SQL Symbols table.
Symbol Meaning
[ nnnn ] An argument enclosed in square brackets is optional. Specify none or one.
{ nnnn }
An argument enclosed in curly braces is optional, and may be repeated multiple times. Specify none, one, or more than one.
Curly braces are also used as literal characters, for example in ODBC scalar functions with the form: {fn FUNCTION(arg)}
mmmm | nnnn A vertical bar means OR. Specify either one or the other.
. . . An ellipsis indicates an unspecified portion of a complete SQL statement. It can also be used to specify repetition: var1,var2,...
::= Is equivalent to.
If an argument appears as an "item-list", then theargument can consist of one or more of the particular itemsdelimited by a particular character. A cross-reference from an item-list pointsto the page for item itself.
If an argument appears as an "item-commalist", thenthe argument can consist of one or more of the particular itemsdelimited by a comma. A cross-reference from an item-commalist pointsto the page for item itself.
When an item is listed in bracketed parentheses, such as [(] identifier [)] thenthe pair of parentheses (as a unit) isoptional.


Previous section          
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-08-16 05:50:13