当前位置: 代码迷 >> DB2 >> DB2数据库建表报错,请,该如何解决才好,
  详细解决方案

DB2数据库建表报错,请,该如何解决才好,

热度:9773   发布时间:2013-02-26 00:00:00.0
DB2数据库建表报错,请高手指点,该怎么解决才好,急急急!
见表报如下错误:
DB21034E The command was processed as an SQL statement because it was not a 
valid Command Line Processor command. During SQL processing it returned:
SQL1024N A database connection does not exist. SQLSTATE=08003

见表语句如下:
create table TF_CMS_PRODUCTSETMEAL
(
  DATA_CODE NUM not null generated by default as identity,
  SET_NAME VARCHAR(100),
  SETNAME_TYPE VARCHAR(100),
  THE_LIMIT VARCHAR(100),
  BRAND_TYPE VARCHAR(50),
  CITY_NAME VARCHAR(20),
  BUSINESS_NAME VARCHAR(50),
  BUSINESS_KEYCODE VARCHAR(500),
  PRODUCT_FEATURE VARCHAR(200),
  CONSUL_DEAIL VARCHAR(120),
  HANDLE_TYPE VARCHAR(200),
  ESPECIALL_DES VARCHAR(1000),
  PROVINCE_NAME VARCHAR(20),
  RSRV_STR1 VARCHAR(20),
  RSRV_STR2 VARCHAR(50),
  RSRV_STR3 VARCHAR(100),
  constraint "P_Key_2" primary key (DATA_CODE),
  constraint "A_Key_1" unique (DATA_CODE)
) IN TBS_CEN_DUEC INDEX IN TBS_CEN_IUEC;

------解决方案--------------------------------------------------------
示例:
创建用的脚本testTRI.sql:
create trigger testTRIGGER after update on test
referencing old as OR new as NR 
for each row 
mode DB2SQL
when (OR.id<>NR.id) 
BEGIN ATOMIC
update test set CODE = '3' WHERE ID = NR.ID;
END@
创建用的命令:db2 -td@ -f /workspace/test/testTRI.sql

将你上述代码存为SQL文件,再用db2 -td@ -f /workspace/test/testTRI.sql导入
------解决方案--------------------------------------------------------
你先连接数据库

db2 connect to 数据库名 user 用户名 using 密码
------解决方案--------------------------------------------------------
你是在命令行下输入代码 ?连接数据库没有?
------解决方案--------------------------------------------------------
SQL1024N A database connection does not exist --这个错误,就是你没有先链接数据库

可以先链接一次,然后执行你的sql文件,或者把链接数据库的语句放到sql文件中一起执行。
  相关解决方案