见表报如下错误:
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文件中一起执行。