linux db2密码特殊字符,DB2 创建包含特殊字符/小写字符的表名/列名

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博客 ” ，链接：http://blog.itpub.net/11976525/viewspace-676676/，如需转载，请注明出处，否则将追究法律责任。