Oninit cdi / Archive
Talk to an expert →

SQL Error -1831 with the LVARCHAR sql fields

Posted in 2011

Topics: SQL Development & Query Writing, Data Types & Schema Design, Versions, Editions & End-of-Life

Franck THOMAS — — source: IIUG Forums & Mailing Lists

Hi all, We are working with Business Objects 5 and Informix version 11.50 FC4. We use the Client-SDK 3.50 TC8. When we run the following sql query with the Business Objects software, we have the error :*"Combination of FetArrSize Deferred-PREPARE and OPTOFC is not supported.-1831"* "SELECT *materiel.mat_lremarque, * materiel.mat_lcontratma FROM materiel" The data type of the field "mat_lremarque" of the table "materiel" is LVARCHAR(2500). We have only the error -1831 when we use the datatype LVARCHAR. We found a temporary solution, we must cast LVARCHAR(2500) to CHAR(2500). Indeed, with the following sql query , we have no longer the error -1831 : "SELECT *materiel.mat_lremarque::char(2500), * materiel.mat_lcontratma FROM materiel" Do you know a better solution ? Best Regards, -- Franck Thomas ConsultiX franck.thomas@consult-ix.fr Téléphone : 33 (0) 1 39 12 18 00 Mobile : 33 (0) 6 78 81 09 33 Fax : 33 (0) 1 39 12 18 18

↪ replying to Franck THOMAS
Art Kagel — — source: IIUG Forums & Mailing Lists

There is a bug in the CSDK 3.50 and 3.70 that returns this error for LVARCHAR with fetch array coding. I reported it in Dec. You should open a PMR also so we get a fix faster. Art On Jan 27, 2011 5:29 AM, "Franck THOMAS" <franck.thomas@consult-ix.fr> wrote: > Hi all, > > We are working with Business Objects 5 and Informix version 11.50 FC4. > We use the Client-SDK 3.50 TC8. > > When we run the following sql query with the Business Objects software, > we have the error :*"Combination of FetArrSize Deferred-PREPARE and > OPTOFC is not supported.-1831"* > "SELECT > *materiel.mat_lremarque, * > materiel.mat_lcontratma > FROM materiel" > > The data type of the field "mat_lremarque" of the table "materiel" is > LVARCHAR(2500). > We have only the error -1831 when we use the datatype LVARCHAR. > > We found a temporary solution, we must cast LVARCHAR(2500) to CHAR(2500). > > Indeed, with the following sql query , we have no longer the error -1831 : > "SELECT *materiel.mat_lremarque::char(2500), * > materiel.mat_lcontratma > FROM materiel" > > Do you know a better solution ? > > Best Regards, > > -- > Franck Thomas > ConsultiX > franck.thomas@consult-ix.fr > Téléphone : 33 (0) 1 39 12 18 00 > Mobile : 33 (0) 6 78 81 09 33 > Fax : 33 (0) 1 39 12 18 18 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --20cf3054a54759ac3a049ad4854c

↪ replying to Art Kagel
Franck THOMAS — — source: IIUG Forums & Mailing Lists

Thanks Art. Do you know if there is the same bug with the older version of CSDK (for example 2.70) ? Regards. Le 27/01/2011 15:11, Art Kagel a écrit : > There is a bug in the CSDK 3.50 and 3.70 that returns this error for > LVARCHAR with fetch array coding. I reported it in Dec. You should open a > PMR also so we get a fix faster. > > Art > On Jan 27, 2011 5:29 AM, "Franck THOMAS"<franck.thomas@consult-ix.fr> > wrote: >> Hi all, >> >> We are working with Business Objects 5 and Informix version 11.50 FC4. >> We use the Client-SDK 3.50 TC8. >> >> When we run the following sql query with the Business Objects software, >> we have the error :*"Combination of FetArrSize Deferred-PREPARE and >> OPTOFC is not supported.-1831"* >> "SELECT >> *materiel.mat_lremarque, * >> materiel.mat_lcontratma >> FROM materiel" >> >> The data type of the field "mat_lremarque" of the table "materiel" is >> LVARCHAR(2500). >> We have only the error -1831 when we use the datatype LVARCHAR. >> >> We found a temporary solution, we must cast LVARCHAR(2500) to CHAR(2500). >> >> Indeed, with the following sql query , we have no longer the error -1831 : >> "SELECT *materiel.mat_lremarque::char(2500), * >> materiel.mat_lcontratma >> FROM materiel" >> >> Do you know a better solution ? >> >> Best Regards, >> >> -- >> Franck Thomas >> ConsultiX >> franck.thomas@consult-ix.fr >> Téléphone : 33 (0) 1 39 12 18 00 >> Mobile : 33 (0) 6 78 81 09 33 >> Fax : 33 (0) 1 39 12 18 18 >> >> >> > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > --20cf3054a54759ac3a049ad4854c > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Franck Thomas ConsultiX franck.thomas@consult-ix.fr Téléphone : 33 (0) 1 39 12 18 00 Mobile : 33 (0) 6 78 81 09 33 Fax : 33 (0) 1 39 12 18 18

Related threads