Caché SQL Reference
Symbols Used in Caché SQL
|
|
|
Symbol | Name and Usage |
---|---|
[space] or [tab] | |
! | |
!= | |
" | Encloses a string literal (not recommended, use single quotes instead). In Dynamic SQL used to enclose literal values for class method arguments, such as SQL code as a string argument for the %Prepare() method, or input parameters as string arguments for the %Execute() method. In %PATTERN used to enclose a literal value within a pattern string. For example, In XMLELEMENT used to enclose a tag name string literal. |
"" | |
# | With spaces before and after, modulo arithmetic operator. For Embedded SQL, ObjectScript macro preprocessor directive prefix. For example, |
$ | First character of some Caché extension SQL functions. |
$$ | |
% | First character of some Caché SQL extensions to the SQL standard, including string collation functions (%SQLUPPER), aggregate functions (%DLIST), and predicate conditions (%STARTSWITH). First character of %ID, %TABLENAME, and %CLASSNAME keywords in SELECT. First character of some privilege keywords (%CREATE_TABLE, %ALTER) and some role names (%All). First character of some Embedded SQL system variables (%ROWCOUNT, %msg). Data type max length indicator: CHAR(%24) LIKE condition predicate multi-character wildcard. |
%% | |
& | $BITLOGIC bitstring And operator. |
' | |
'' | |
( ) | In a In a Encloses host variable array subscripts. For example, Encloses embedded SQL code: &sql( code ) Used to enforce precedence in arithmetic operations: 3+(3*5)=18. Used to group predicates: WHERE NOT (Age<20 AND Age>12). |
(( )) | |
* | In %MATCHES pattern string a multi-character wildcard. Multiplication arithmetic operator. |
*/ | |
*= | |
+ | |
, | In data size definition: NUMERIC (precision,scale). |
| SQLCODE error code prefix: 304. |
| |
> | |
. | Decimal point in numeric literals. Prefixed to a variable or array name, specifies passing by reference: %PATTERN pattern string multi-character wildcard. |
/ | |
/* | |
: | In trigger code a prefix indicating a ObjectScript label line. In |
:: | |
; | |
< | |
<= | |
<> | |
= | In WHERE clause, an Inner Join. |
=* | |
> | |
>= | |
? | In %MATCHES pattern string a single-character wildcard. |
@ | |
E, e | %PATTERN code specifying any printable character. |
[ | |
[ ] | |
\ | In %MATCHES pattern string an escape character. |
] | |
^ | |
_ | Used in multipart column names to represent embedded serial class data: SELECT Home_State, where Home is a serial container field. LIKE condition predicate single-character wildcard. |
{ } | |
|| | Compound ID indicator. Used by Caché as a delimiter between multiple properties in a generated compound object ID (a concatenated ID). This can be either an IDKey index defined on multiple properties ( |
Copyright © 1997-2018, InterSystems Corporation
|
Content for this page loaded from RSQL_symbols.xml on 2017-09-29 10:49:50
|