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