INGRES REPORT Copyright (c) 1981, 1998 Computer Associates Intl, Inc.
Reading report specifications and preparing query . . .
E_OP03A2 consistency check
- histogram on mat_monthly attribute monthly_cb_qty is not
monotonically
increasing
(Mon Jan 5 16:46:25 2004)

E_RW1019 Either you had errors in the .QUERY command, or you didn't
specify either a .QUERY or .DATA command. Processing stops.

E_RW100A 1 error(s) have occurred in setting up the report. No report will
be written. Correct errors and rerun.


what would be the possible error as query is running fine through isql , pl
help
AJAY CHADHA
ENGINEER (IT)
IT DEPARTMENT ,NTPC TTPS
------------------------------------------------------------------------------
"Speed & Quality is essence of IT"

I got this before on OpenIngres 2.0 on AIX. The avoidance was to drop the
statistics on the
column.
James Keane
Irish Revenue


*****************************
This message has been delivered to the internet by the Revenue internet mail service.
*****************************

At 4:28 PM +0500 1/5/04, <ajay_chadha (AT) ttps (DOT) ntpc.co.in> wrote:
Drop and re-create the statistics on that column. What version,
patch level, platform? This problem used to occur occasionally with
dates, but as far as I know it's been fixed for quite some time.

Karl

Dear Sir,

I see your company motto is

"Speed & Quality is essence of IT"

perhaps you need to hire some Ingres professionals for this to mean something.

Best wishes
Anando Patel

Hi karl,

I am getting the same error on our person records, can you please send
me some ionstructions on how you would go about re-creating stats as i
am new to ingres and have very low knowledage on where to go and find
things. I can see it in VDBA just dont know how to re-create it.

thanks in advance
kam


--
kamini

On Mar 24, 2010, at 11:37 AM, Ingres Forums wrote:

I don't know how to do anything in VDBA. I think there is a "drop
statistics" and "create statistics" menu item somewhere.

At the command line, what you woud do is

statdump -zdl databasename -rtablename -acolumn1 -acolumn2 ...

optimizedb -zv database -rtablename -acolumn1 -acolumn2

The statdump -zdl drops statistics. It's not really necessary, as
the optimizedb will overwrite any old histograms, but it is a
"feel good". The optimizedb command regenerates the
histograms. The -zv option simply tells optimizedb to output
a bit of info when it's done, and can be omitted.

Karl