Correction: Error (-881) : Resulting string length must be less than or equal to 255.
--0-661897800-1113408592=:5461
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".tbperposhist
(
phicdcip character(8) NOT NULL,
phiidptoingreso smallint NOT NULL,
phiacingreso date NOT NULL,
phicdpostula character(10) NOT NULL,
phicdespecial smallint,
phiidflgsexo character(1),
phiidtipdoc smallint DEFAULT 0,
phiiddocumento character(15) DEFAULT '',
phinoapepaterno varchar(30,0) DEFAULT 'NULL',
phinoapematerno varchar(30,0) DEFAULT 'NULL',
phinoprimero varchar(30,0) DEFAULT 'NULL',
phinosegundo varchar(30,0) DEFAULT 'NULL',
phifcnacimiento date,
phicdnacionalid character(6) DEFAULT '',
phicddomicilio character(6) DEFAULT '',
phitxresidencia varchar(100,0) DEFAULT 'NULL',
phinocalle character(100) DEFAULT '',
phiidtipocalle character(20) DEFAULT '',
phitxurbaniza varchar(50,0) DEFAULT 'NULL',
phitxreferencia varchar(100,0) DEFAULT 'NULL',
phiidinstruccio smallint DEFAULT 0,
phiididioma character(4) DEFAULT '',
phicaescrito decimal(3,0) DEFAULT 0,
phicahablado decimal(3,0) DEFAULT 0,
phicaentiende decimal(3,0) DEFAULT 0,
phiidreligion character(4) DEFAULT '',
phiidgrpsanguin character(4) DEFAULT '',
phiidflginelegi character(1) DEFAULT 'N',
phiidflgvacante character(1) DEFAULT 'N',
phiidflgprocmil character(1),
phicdgrdpostula smallint,
phiidestado smallint DEFAULT 1,
phicdusuario varchar(20,0),
phifcactualiza datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND
)
EXTENT SIZE 2000 NEXT SIZE 600
LOCK MODE ROW;
-- Creating primary key constraint
ALTER TABLE "informix".tbperposhist
ADD CONSTRAINT PRIMARY KEY
(
phicdcip,
phiidptoingreso,
phiacingreso
)
CONSTRAINT "informix".ct_tbperposhist1;
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-661897800-1113408592=:5461
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
<DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">
<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".tbperposhist<BR> (<BR> phicdcip character(8) NOT NULL,<BR> phiidptoingreso smallint NOT NULL,<BR> phiacingreso date NOT NULL,<BR> phicdpostula character(10) NOT NULL,<BR> phicdespecial smallint,<BR> phiidflgsexo character(1),<BR> phiidtipdoc smallint DEFAULT 0,<BR> phiiddocumento character(15) DEFAULT '',<BR> phinoapepaterno varchar(30,0) DEFAULT 'NULL',<BR> phinoapematerno varchar(30,0) DEFAULT 'NULL',<BR> phinoprimero varchar(30,0) DEFAULT 'NULL',<BR> phinosegundo varchar(30,0) DEFAULT 'NULL',<BR> phifcnacimiento date,<BR> phicdnacionalid character(6) DEFAULT '',<BR> phicddomicilio character(6) DEFAULT '',<BR> phitxresidencia varchar(100,0) DEFAULT 'NULL',<BR> phinocalle character(100) DEFAULT '',<BR> phiidtipocalle character(20) DEFAULT '',<BR> phitxurbaniza varchar(50,0) DEFAULT 'NULL',<BR> phitxreferencia varchar(100,0) DEFAULT
'NULL',<BR> phiidinstruccio smallint DEFAULT 0,<BR> phiididioma character(4) DEFAULT '',<BR> phicaescrito decimal(3,0) DEFAULT 0,<BR> phicahablado decimal(3,0) DEFAULT 0,<BR> phicaentiende decimal(3,0) DEFAULT 0,<BR> phiidreligion character(4) DEFAULT '',<BR> phiidgrpsanguin character(4) DEFAULT '',<BR> phiidflginelegi character(1) DEFAULT 'N',<BR> phiidflgvacante character(1) DEFAULT 'N',<BR> phiidflgprocmil character(1),<BR> phicdgrdpostula smallint,<BR> phiidestado smallint DEFAULT 1,<BR> phicdusuario varchar(20,0),<BR> phifcactualiza datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND<BR> )<BR> EXTENT SIZE 2000 NEXT SIZE 600<BR> LOCK MODE ROW;</DIV>
<DIV>-- Creating primary key constraint<BR>ALTER TABLE "informix".tbperposhist<BR> ADD CONSTRAINT PRIMARY KEY<BR> (<BR> phicdcip,<BR> phiidptoingreso,<BR> phiacingreso<BR> )<BR> CONSTRAINT "informix".ct_tbperposhist1;<BR></DIV>
<DIV></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></BLOCKQUOTE></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-661897800-1113408592=:5461--
sending to informix-list
Omar,
IDS version 9 gives the following full description for error -881:
"Resulting string length from TRIM must range from 1 character to 255
characters.
The TRIM function returned a string whose length did not span a range from 1 to
255 characters. The TRIM function returns a VARCHAR string. A VARCHAR string
must have a length that ranges from 1 character to 255 characters. Check that
the TRIM function returns strings whose length is within that range."
I suspect that you have a trigger on your table which uses TRIM (or calls a
stored procedure which does). Use "dbschema -d <database> -t <table>" to find
out if this is the case. You could temporarily suspend the trigger using the SQL
statement "SET TRIGGERS FOR <table> DISABLED" before you run the delete.
--
Regards,
Doug Lawry
www.douglawry.webhop.org
"Omar Luque Valdivia" <omaluva@yahoo.com> wrote in message
news:1113417552.4661c630ef8b9d2f0552e496239b9f1f@teranews...
>
> 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".tbperposhist
> (
> phicdcip character(8) NOT NULL,
> phiidptoingreso smallint NOT NULL,
> phiacingreso date NOT NULL,
> phicdpostula character(10) NOT NULL,
> phicdespecial smallint,
> phiidflgsexo character(1),
> phiidtipdoc smallint DEFAULT 0,
> phiiddocumento character(15) DEFAULT '',
> phinoapepaterno varchar(30,0) DEFAULT 'NULL',
> phinoapematerno varchar(30,0) DEFAULT 'NULL',
> phinoprimero varchar(30,0) DEFAULT 'NULL',
> phinosegundo varchar(30,0) DEFAULT 'NULL',
> phifcnacimiento date,
> phicdnacionalid character(6) DEFAULT '',
> phicddomicilio character(6) DEFAULT '',
> phitxresidencia varchar(100,0) DEFAULT 'NULL',
> phinocalle character(100) DEFAULT '',
> phiidtipocalle character(20) DEFAULT '',
> phitxurbaniza varchar(50,0) DEFAULT 'NULL',
> phitxreferencia varchar(100,0) DEFAULT 'NULL',
> phiidinstruccio smallint DEFAULT 0,
> phiididioma character(4) DEFAULT '',
> phicaescrito decimal(3,0) DEFAULT 0,
> phicahablado decimal(3,0) DEFAULT 0,
> phicaentiende decimal(3,0) DEFAULT 0,
> phiidreligion character(4) DEFAULT '',
> phiidgrpsanguin character(4) DEFAULT '',
> phiidflginelegi character(1) DEFAULT 'N',
> phiidflgvacante character(1) DEFAULT 'N',
> phiidflgprocmil character(1),
> phicdgrdpostula smallint,
> phiidestado smallint DEFAULT 1,
> phicdusuario varchar(20,0),
> phifcactualiza datetime YEAR TO SECOND DEFAULT CURRENT YEAR TO SECOND
> )
> EXTENT SIZE 2000 NEXT SIZE 600
> LOCK MODE ROW;
> -- Creating primary key constraint
> ALTER TABLE "informix".tbperposhist
> ADD CONSTRAINT PRIMARY KEY
> (
> phicdcip,
> phiidptoingreso,
> phiacingreso
> )
> CONSTRAINT "informix".ct_tbperposhist1;
>
> 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