db2插入表的问题
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', '', '')
DB21034EThe command was processed as an SQL statement because it was not a
valid Command Line Processor command.During SQL processing it returned:
SQL30090NOperation 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(8),
sendtime char(6),
readed char(1),
recvdate char(8),
recvtime char(6),
title char(80),
content long varchar,
recverlist long varchar,
unrecvered long varchar
);
页:
[1]