Topic group Related topics
This section describes the naming conventions for tables and columns in local SQL.
Local SQL supports full file and path specifications for table names. Table names with a path, spaces, or other special characters in their names must be enclosed in single or double quotation marks. You may use forward slashes instead of backslashes. For example,
SELECT * FROM PARTS.DB // Simple name with extension; no quotes required
SELECT * FROM "AIRCRAFT PARTS.DB" // Name has space; quotes needed
SELECT * FROM "C:\SAMPLE\PARTS.DB" // Filename with path
SELECT * FROM "C:/SAMPLE/PARTS.DB" // Forward slash instead of backslash
Local SQL also supports BDE aliases for table names. For example,
SELECT * FROM :IBAPPS:KBCAT
If you omit the file extension for a local table name, the table is assumed to be the table type specified the current setting of SET DBTYPE.
Finally, local SQL permits table names to duplicate SQL keywords as long as those table names are enclosed in single or double quotation marks. For example,
SELECT PASSID FROM "PASSWORD"
Local SQL supports multi-word column names and column names that duplicate SQL keywords as long as those column names are
Enclosed in single or double quotation marks
Prefaced with an SQL table name or table correlation name
For example, the following column name is two words:
SELECT E."Emp Id" FROM EMPLOYEE E
In the next example, the column name duplicates the SQL DATE keyword:
SELECT DATELOG."DATE" FROM DATELOG