- 论坛徽章:
- 0
|
db2为v8.2版本,os为rhel6
创建了2个库,curdb和hisdb。
hisdb创建了一个表mailbox。
在curdb中使用下面语句:
db2 "CREATE NICKNAME HISDB.MAILBOX FOR HISDB.TESTUSER.MAILBOX"
我在插入hisdb.mailbox提示下面错误:
db2 => INSERT INTO HISDB.MAILBOX VALUES(17, 3, '102308005000', '102308001017', '888888', '', '0','1', '20110629', '153809','0', '', '','1', '12345', '', '')
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL30090N Operation invalid for application execution environment. Reason
code = "21". SQLSTATE=25000
db2 =>
但是我用这样的方法插入hisdb的其他表却没问题,请问这是怎么回事啊?
mailbox的结构如下:
create table mailbox
(
mailid integer not null ,
svcclass integer not null,
sender char(12) not null ,
recver char(12) not null ,
writer char(6),
auditor char(6),
mailtype char(1) not null ,
sended char(1),
senddate char( ,
sendtime char(6),
readed char(1),
recvdate char( ,
recvtime char(6),
title char(80),
content long varchar,
recverlist long varchar,
unrecvered long varchar
); |
|