![]() ![]() Used to enforce precedence in arithmetic operations: 3+(3*5)=18. Encloses the name of a predefined query used in a UNION.Įncloses host variable array subscripts. ![]() In a SELECT statement, encloses a subquery in the FROM clause. In a SELECT DISTINCT BY clause, encloses an item or comma-separated list of items used to select unique values. In most cases, the parentheses must be specified, even if no arguments or parameters are supplied. Encloses the parameter list for a procedure, method, or query. Parentheses (40,41): Encloses comma-separated lists. Single quote character (39): Encloses a string literal.ĭouble single quote characters: An empty string literal.Īn escape sequence for a literal single quote character within a string value. LIKE condition predicate multi-character wildcard.ĭouble percent sign: Prefix for the pseudo-field reference variable keywords: %%CLASSNAME, %%CLASSNAMEQ, %%ID, and %%TABLENAME, used in ObjectScript computed field code and trigger code.Īmpersand (38): AND logical operator in WHERE clause and other condition expressions.Įmbedded SQL invocation prefix: &sql( SQL commands). Percent sign (37): Valid first character for identifier names (first character only).įirst character of some InterSystems SQL extensions to the SQL standard, including string collation functions (%SQLUPPER), aggregate functions (%DLIST), and predicate conditions (%STARTSWITH).įirst character of %ID, %TABLENAME, and %CLASSNAME keywords in SELECT.įirst character of some privilege keywords (%CREATE_TABLE, %ALTER) and some role names (%All).įirst character of some Embedded SQL system variables (%ROWCOUNT, %msg).ĭata type max length indicator: CHAR(%24) For more details, see Function and Method Call Selection in the selectItem argument of the SELECT reference page. In SQL Shell the # command is used to recall statements from the SQL Shell history buffer.ĭollar sign (36): Valid identifier name character (not first character).įirst character of some InterSystems IRIS extension SQL functions.ĭouble dollar sign: used to call an ObjectScript user-defined function (also known as an extrinsic function). With spaces before and after, modulo arithmetic operator.įor Embedded SQL, ObjectScript macro preprocessor directive prefix. Pound sign (35): Valid identifier name character (not first character). Within a delimited identifier, an escape sequence for a literal quote character. Two quotes: By themselves, an invalid delimited identifier. In XMLELEMENT used to enclose a tag name string literal. ![]() For example, '3L1"L".L' (meaning 3 lowercase letters, followed by the capital letter “L”, followed by any number of lowercase letters). In %PATTERN used to enclose a literal value within a pattern string. 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. Quotes (34): Encloses a delimited identifier name. In SQL Shell, the ! command is used to issue an ObjectScript command line.Įxclamation mark/Equal sign: Is not equal to comparison condition. Used in the WHERE clause, the HAVING clause, and elsewhere. White space (Tab (9) or Space (32)): One or more whitespace characters between keywords, identifiers, and variables.Įxclamation mark (33): OR logical operator in between predicates in condition expressions. The name of each symbol is followed by its ASCII decimal code value. (This list does not include symbols indicating format conventions, which are not part of the language.) There is a separate table for symbols used in ObjectScript. The following are the literal symbols used in InterSystems SQL on InterSystems IRIS® data platform. A table of characters used in InterSystems SQL as operators, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |