Error in load count

Posted in 1999

Navdeep Virk — Thu, 02 Dec 1999 16:17:41 -0500 — source: Informix-list mailing list archive (1991-1998)

This is a multi-part message in MIME format. --------------BF95F24794D30F3D12DBF2A9 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit We are having a problem with sqlca.sqlerrd[3] record. We have a temp table ,and load data into it , When we get the value of sqlca.sqlerrd[3] after the load it is showing a diff of 5 records i.e. it is showing 5 more records ,we confirmed it by using a cursor and doing a count . we are using Informix Dynamic Server Version 7.31.UC4. Is this a bug or are we missing something ? Navdeep --------------BF95F24794D30F3D12DBF2A9 Content-Type: text/x-vcard; charset=us-ascii; name="NVIRK.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Navdeep Singh Virk Content-Disposition: attachment; filename="NVIRK.vcf" begin:vcard n:Virk;Navdeep tel;home:(248)427-0785 tel;work:(734)524-5600 Extn. 6594 x-mozilla-html:FALSE adr:;;;;;; version:2.1 fn:Navdeep Virk end:vcard --------------BF95F24794D30F3D12DBF2A9--

↪ replying to Navdeep Virk

mars1972@my-deja.com — Fri, 03 Dec 1999 12:34:57 GMT — source: Informix-list mailing list archive (1991-1998)

> We are having a problem with sqlca.sqlerrd[3] record. > We have a temp table ,and load data into it , > When we get the value of sqlca.sqlerrd[3] after the load it is showing a > diff of 5 records i.e. it is showing 5 more records ,we confirmed it by > using a cursor and doing a count . > we are using Informix Dynamic Server Version 7.31.UC4. > Is this a bug or are we missing something ? > Navdeep My documentation is a little out of date, but it says that sqlerrd[3] holds the following: Following a successful PREPARE statement for a SELECT, UPDATE, INSERT, or DELETE statement, or after a select cursor has been opened, this field contains the estimated weighted sum of disk accesses and total rows processed. If you look at sqexplain.out (after doing an set sql explain;), You will see these two values (disk access and rows processed, both estimated). There is no guarantee, even implication, that they will be exactly correct. Maybe what you're looking for is sqlerrd[2], which holds the count of rows processed after a successful multi-row insert, update or delete. -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.