[Info-ingres] Update rule also triggered when inserting rows?

[Adrian Williamson]

Hi,

What kind of application is sending the insert and update SQL statements to
the DBMS for the table 'bi_date_asqenh'?

I would start with this application and issue the 'set printrules' in the
DBMS session this creates to run the insert and update SQL statements.

You can do that by modifying the software which connects to the DBMS but you
can also use the environment variables such as ING_SET  ( I thought you
could use II_EMBED_SET but the 10.2 documentation doesn't mention
PRINTRULES).

These will affect all software launched from that environment.

The other part you need is to tell it where to write the output, there are
various Ingres LOG variables for this dependent on what software you are
using e.g. II_GCD_LOG for data access server.

I just spoke to a friend and he pointed me in the direction of the 'set
TRACE OUPUT FILENAME' from the SQL reference manual - you can set this in
the ING_SET environment variable  (I think).

Good luck.

Adrian


-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of
nksvg1 at gmail.com
Sent: 22 February 2018 10:34
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Update rule also triggered when inserting rows?

the architecture as it is :

there are two procedures, 'insert_bi_date_asqenh' and
'update_bi_date_asqenh'.
When an insert in table 'bi_date_asqenh' is taking place the
'insert_bi_date_asqenh' rule is fired which calls the
'insert_bi_date_asqenh' procedure which raises a DBEVENT.Similarly, upon an
'update' happening.

A Perl daemon (on Linux) is listening for those dbevents, captures
them,extracts the bundled parameters/data, and then calls another Perl
script propagating this data.This script in turn builds an XML file after
the data and forwards the file to a REST web service.

There's more procedures and events going on which work just fine and I can
attest that Ingres' dbevents functionality is pretty stable.The only one
giving me heat is the 'update_bi_date_asqenh' rule/procedure which it seems
like is being fired erratically and out of sync.

With that in mind,where should I call 'set printrules' from ?
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres