Error (-881) : Resulting string length must be less than or equal to 255.
--0-1497539964-1113405371=:67179
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Hello,
I'm trying delete a row, but i get a following error :
-----------------------------------------------------------------------
delete from tbperposhist where phicdcip ="00003566";SQL Error (-881) : Resulting string length must be less than or equal to 255.
CREATE TABLE "informix".tbpersancjun
(
sajcdcip character(8) NOT NULL,
sajfcinicio date NOT NULL,
sajidmotivo smallint,
sajcddepsolicit integer,
sajidnrodocini integer,
sajcdjtasancion smallint,
sajcadiadurasj smallint,
sajfcdictamen date,
sajcdnrodictam character(20),
sajtxjuntaopina character(600) DEFAULT NULL,
sajcdsancionin smallint,
sajcadiadurain smallint,
sajfcdictamenin date,
sajcdnrodictain character(20),
sajtxopinajunin character(1000),
sajtxlegalopina character(1000),
sajtxtenor character(1000),
sajidresolucion integer,
sajidstsjunta smallint DEFAULT 0,
sajidestado smallint DEFAULT 1,
sajcdusuario varchar(20,0),
sajfcactualiza datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND
)
EXTENT SIZE 10000 NEXT SIZE 3000
LOCK MODE ROW;
-- Creating primary key constraint
ALTER TABLE "informix".tbpersancjun
ADD CONSTRAINT PRIMARY KEY
(
sajcdcip,
sajfcinicio
)
CONSTRAINT "informix".pksancjun;
Others rows was deleted succesfully in other tables, example :
------------------------------------------------------------------------------------------
delete from tbpersancjun where sajcdcip =00003566;
delete from tbperimagen where imgcdcip ='00003566';
Why?
Appreciate any help on this issue.
Thanks
Regards,
Omar.
Omar LUQUE Valdivia
Informix Database Administrator
Direcci'n de Telem'tica - Marina de Guerra del Per'
Av. La Marina Cdra. 36 s/n, La Perla - Callao, Lima - Peru
Telf : (511) 614-2900 (511) 562-3900 Ext. 2277 2265
E-mail : Luque001@marina.mil.pe
Cel. 9 639-7201
---------------------------------
Do You Yahoo!?
Todo lo que quieres saber de Estados Unidos, Am'rica Latina y el resto del Mundo.
Vis'ta Yahoo! Noticias.
--0-1497539964-1113405371=:67179
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
<DIV>Hello,</DIV>
<DIV> </DIV>
<DIV>I'm trying delete a row, but i get a following error :</DIV>
<DIV>-----------------------------------------------------------------------</DIV>
<DIV>delete from tbperposhist where phicdcip ="00003566";</DIV>
<DIV>SQL Error (-881) : Resulting string length must be less than or equal to 255.</DIV>
<DIV> </DIV>
<DIV>CREATE TABLE "informix".tbpersancjun<BR> (<BR> sajcdcip character(8) NOT NULL,<BR> sajfcinicio date NOT NULL,<BR> sajidmotivo smallint,<BR> sajcddepsolicit integer,<BR> sajidnrodocini integer,<BR> sajcdjtasancion smallint,<BR> sajcadiadurasj smallint,<BR> sajfcdictamen date,<BR> sajcdnrodictam character(20),<BR> sajtxjuntaopina character(600) DEFAULT NULL,<BR> sajcdsancionin smallint,<BR> sajcadiadurain smallint,<BR> sajfcdictamenin date,<BR> sajcdnrodictain character(20),<BR> sajtxopinajunin character(1000),<BR> sajtxlegalopina character(1000),<BR> sajtxtenor character(1000),<BR> sajidresolucion integer,<BR> sajidstsjunta smallint DEFAULT 0,<BR> sajidestado smallint DEFAULT 1,<BR> sajcdusuario varchar(20,0),<BR> sajfcactualiza datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND<BR> )<BR> EXTENT SIZE 10000 NEXT SIZE 3000<BR> LOCK MODE ROW;</DIV>
<DIV>-- Creating primary key constraint<BR>ALTER TABLE "informix".tbpersancjun<BR> ADD CONSTRAINT PRIMARY KEY<BR> (<BR> sajcdcip,<BR> sajfcinicio<BR> )<BR> CONSTRAINT "informix".pksancjun;<BR></DIV>
<DIV> </DIV>
<DIV>Others rows was deleted succesfully in other tables, example :</DIV>
<DIV>------------------------------------------------------------------------------------------</DIV>
<DIV>delete from tbpersancjun where sajcdcip =00003566;<BR>delete from tbperimagen where imgcdcip ='00003566';<BR></DIV>
<DIV>Why?</DIV>
<DIV> </DIV>
<DIV>Appreciate any help on this issue.<BR>Thanks <BR>Regards,</DIV>
<DIV> </DIV>
<DIV>Omar.</DIV>
<DIV> </DIV><BR><BR><DIV>
<DIV><FONT face=verdana color=#800000><STRONG>Omar LUQUE Valdivia <BR>Informix Database Administrator</STRONG></FONT></DIV>
<DIV><FONT face=verdana color=#800000><STRONG>Direcci'n de Telem'tica - Marina de Guerra del Per' <BR>Av. La Marina Cdra. 36 s/n, La Perla - Callao, Lima - Peru <BR>Telf : (511) 614-2900 (511) 562-3900 Ext. 2277 2265 <BR>E-mail : Luque001@marina.mil.pe <BR>Cel. 9 639-7201</STRONG></FONT></DIV></DIV>
<DIV>
<DIV>
<DIV> </DIV></DIV></DIV><p><br><hr size=1 noshade><b>Do You Yahoo!?</b><br>
<a href=http://espanol.yahoo.com/mail_tagline/*http://espanol.news.yahoo.com><img src="http://us.i1.yimg.com/us.yimg.com/i/not/dailynews.gif"; width=30 height=26 border=0 align=left></a>
Todo lo que quieres saber de Estados Unidos, Am'rica Latina y el resto del Mundo.<br>
Vis'ta <a href=http://espanol.yahoo.com/mail_tagline/*http://espanol.news.yahoo.com>Yahoo! Noticias</a>.<br>
--0-1497539964-1113405371=:67179--
sending to informix-list