C:\Documents and Settings\Administrator>db2 CREATE TABLE "DDS "."EMPLOYEE_HI
STORY_T" ("WEEK_ENDING_DATE" DATE NOT NULL ,"S/N" CHAR(6) ,"NOTES_ID" VARCHAR(1
00) ,"ENGLISH_NAME" VARCHAR(100) ,"TEAM" VARCHAR(100) ,"ON_BOARD_ATE" DATE ,"BAN
D" VARCHAR(10) ,"LOCATION" VARCHAR(20) ,"REPORTING_MANAGER" VARCHAR(100) ,"SERVI
CE_AREA" VARCHAR(100) ,"JOB_ROLE" VARCHAR(100) ,"LANGUAGE" VARCHAR(100) ,"CELL_N
UMBER" VARCHAR(100) ,"FIXED_LINE" VARCHAR(100) ,"PROJECT_NAME" VARCHAR(100) ,"PM
_NAME" VARCHAR(100) ,"PM_NOTES_ID" VARCHAR(100) ,"ACCOUNT_MANAGER" VARCHAR(100)
,"IOT_STATUS" VARCHAR(100) ) IN "USERSPACE1"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "/N" was found following "ATE DATE NOT NULL ,S".
Expected tokens may include: "". SQLSTATE=42601

C:\Documents and Settings\Administrator>db2 ? 42601

SQLSTATE 42601: A character, token, or clause is invalid or missing.

C:\Documents and Settings\Administrator>

C:\Documents and Settings\Administrator>db2 CREATE TABLE "DDS "."EMPLOYEE_HI
STORY_T" ("WEEK_ENDING_DATE" DATE NOT NULL ,\"S/N\" CHAR(6) ,"NOTES_ID" VARCHAR
(100) ,"ENGLISH_NAME" VARCHAR(100) ,"TEAM" VARCHAR(100) ,"ON_BOARD_ATE" DATE ,"B
AND" VARCHAR(10) ,"LOCATION" VARCHAR(20) ,"REPORTING_MANAGER" VARCHAR(100) ,"SER
VICE_AREA" VARCHAR(100) ,"JOB_ROLE" VARCHAR(100) ,"LANGUAGE" VARCHAR(100) ,"CELL
_NUMBER" VARCHAR(100) ,"FIXED_LINE" VARCHAR(100) ,"PROJECT_NAME" VARCHAR(100) ,"
PM_NAME" VARCHAR(100) ,"PM_NOTES_ID" VARCHAR(100) ,"ACCOUNT_MANAGER" VARCHAR(100
) ,"IOT_STATUS" VARCHAR(100) ) IN "USERSPACE1"
DB20000I The SQL command completed successfully.

C:\Documents and Settings\Administrator>

在 DB2 UDB 中除非另外指定，否则，所有名称都可包括下列字符：

　　·A 到 Z。当在大多数名称中使用时，字符 A 到 Z 将从小写形式转换为大写形式。

　　·0 到 9

　　·@、#、$ 和 _（下划线）

　　·名称不能以数字或下划线字符开始。

1，作为数据库对象的表，其命名同样遵循上述规则，因此即使用户创建表时使用的名称是小写的，DB2 仍会自动将其转化为大写的形式。

2，如果需要创建含小写英文字符的 DB2 表/列，应使用双引号将表名括起来，为避免双引号被转义，需在双引号前加上转义字符“\”。

3，如果需要创建含特殊英文字符的 DB2 表/列，需在特殊字符前加上转义字符“\”。

ITPub博客

DB2 创建包含特殊字符/小写字符的表名/列名

最新文章