Kbase P18570: What are the rules to define Progress SQL identifiers ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/13/2003 |
|
Status: Unverified
GOAL:
What are the rules to define Progress SQL identifiers ?
FIX:
Conventional SQL identifiers must:
- Begin with an uppercase or lowercase letter.
- Contain only letters, digits, or the underscore character ( _ ).
- Not be reserved words.
- Use ASCII characters only.
SQL does not distinguish between uppercase and lowercase letters in SQL identifiers. It converts all names specified as conventional identifiers to uppercase, but statements can refer to the names in mixed case.