2.3.13 Operands related to the SQL reserved word deletion facility
- 72) pd_delete_reserved_word_file = SQL-reserved-word-deletion-file-name-1[,SQL-reserved-word-deletion-file-name-2]...
<identifier of up to 8 characters>- To use the SQL reserved word deletion facility, specify this operand. For this operand, specify the name of an SQL reserved word deletion file. Create the SQL reserved word deletion file under %PDDIR%\conf\pdrsvwd. For details about the SQL reserved word deletion facility, see the HiRDB Version 8 UAP Development Guide.
- Operand rules
- For the name of the SQL reserved word deletion file, specify any alphanumeric character string (of up to 8 characters) that begins with a letter. The name is not case sensitive.
- You can specify a maximum of 16 SQL reserved word deletion file names.
- Format of the SQL reserved word deletion file
- reserved-word[,reserved-word...]
- When specifying multiple reserved words, use a comma (,) as the delimiter. Do not insert a space or tab before or after the comma.
- The maximum length of each definition line is 80 characters. If the definition exceeds 80 characters, use a line feed. However, do not use a line feed in the middle of a reserved word (keyword).
- You can use both lower- and upper-case letters to specify reserved words.
- For details about SQL reserved words, see the manual HiRDB Version 8 SQL Reference.
- Note
- If you delete a reserved word, you can no longer use an SQL function that uses that reserved word. For details about the reserved words that can be deleted using the reserved word deletion facility, see the manual HiRDB Version 8 SQL Reference.
- Relationship to client environment definition
- Specify any SQL reserved word deletion file that is used during UAP execution in the PDDELRSVWDFILE operand in the client environment definition. For details about the PDDELRSVWDFILE operand, see the HiRDB Version 8 UAP Development Guide.