Chapter 3 DBMS Resource File Reference
The Keywords category is located in the Root→Script→SQL category, and contains the following items that reserve keywords.
The lists of SQL functions and operators are used to populate the PowerDesigner SQL editor to propose lists of available functions to help in entering SQL code.
| Item | Description |
|---|---|
| CharFunc | Specifies a list of SQL functions to use with characters and strings.
Example: char() charindex() char_length() etc |
| Commit | Specifies a statement for validating the transaction by live connection. |
| ConvertFunc | Specifies a list of SQL functions to use when converting values between hex and integer and handling strings.
Example: convert() hextoint() inttohex() etc |
| DateFunc | Specifies a list of SQL functions to use with dates.
Example: dateadd() datediff() datename() etc |
| GroupFunc | Specifies a list of SQL functions to use with group keywords.
Example: avg() count() max() etc |
| ListOperators | Specifies a list of SQL operators to use when comparing values, boolean, and various semantic operators.
Example: = != not like etc |
| NumberFunc | Specifies a list of SQL functions to use with numbers.
Example: abs() acos() asin() etc |
| OtherFunc | Specifies a list of SQL functions to use when estimating, concatenating and SQL checks.
Example: db_id() db_name() host_id() etc |
| Reserved Default |
Specifies a list of keywords that may be used as default values. If a reserved word is used as a default value, it will not be enquoted.
Example (SQL Anywhere 10) - USER is a reserved default value: Create table CUSTOMER ( Username varchar(30) default USER ) When you run this script, CURRENT DATE is recognized as a reserved default value. |
| ReservedWord | Specifies a list of reserved keywords. If a reserved word is used as an object code, it is enquoted during generation (using quotes only in DBMS → Script → SQL → Syntax →→Quote). |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |