Number of rows i systables

We have developed an alternativ to DBaccess and during testing we discovered that the information in systables.numrow differs from the actual number of rows for some of our tables - not all tables. Is there another way of obtaining the number of rows in a table except count (*) ? TIA Jan Nilsson pro IT jan@proitkarlstad.se

Nils Larsson <nla@tek.pliktverket.se> wrote in message news:8dguqt$osp1@www.informix.com... > We have developed an alternativ to DBaccess and during testing we discovered > that the information in systables.numrow differs from the actual number of > rows for some of our tables - not all tables. > Is there another way of obtaining the number of rows in a table except count > (*) ? You can look into the systabinfo table, field ti_nrows. Information in systables will be updated with UPDATE STATISTICS. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > TIA > > Jan Nilsson > pro IT > > jan@proitkarlstad.se > > >

On Tue, 18 Apr 2000 08:17:25 +0200, "Nils Larsson" <nla@tek.pliktverket.se> wrote: >We have developed an alternativ to DBaccess and during testing we discovered >that the information in systables.numrow differs from the actual number of >rows for some of our tables - not all tables. >Is there another way of obtaining the number of rows in a table except count >(*) ? update statistics and then select again. -- Jiří Lisický ČD DATIS Olomouce-mail: lisicky@datis.cdrail.cz Nerudova 1 phone: +420-068-472-5496 Olomouc, Czech Republic >>> čeština ISO-8859-2 Compatible <<<

Nils Larsson wrote: > We have developed an alternativ to DBaccess and during testing we discovered > that the information in systables.numrow differs from the actual number of > rows for some of our tables - not all tables. > Is there another way of obtaining the number of rows in a table except count > (*) ? In the sysmaster SMI database the sysptnhdr table is a window into the table's header information on disk. The row count there is accurate all the time. It is keyed by partnum to the sysmaster:systabnames table or the corresponding systables or sysfragments record in the database catalog. Art S. Kagel