Keywords Category

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.

ConvertAnyToString Specifies a function to convert any type to a string.
ConvertDateToMonth, ConvertDateToQuarter, ConvertDateToYear Specifies a function to extract the relevant period from a date.

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).

StringConcatenationOperator Specifies the operator used to concatenate two strings.