[Info-ingres] Can a rule work with a global temporary session table-

[Karl and Betty Schendel]

> On Jun 12, 2018, at 1:29 PM, nksvg1 at gmail.com wrote:
> 
> I want whenever an ABF application is called to get the terminal of the user and it's Linux users and inset those values in a session table.since the session is persistent I want whenever an insert happens in a specific table to capture the values inserted but also get the user ID values from the session table and all together pass them to a stored procedure summoned by the rule.

Unfortunately I can't think of any way you can do that, without having dummy columns in the
table being inserted-into that can take the appropriate session table values.  (In which case
you would include the session table values into the insert, not the rule.)

Referencing global temporary tables in DB procedures is generally not possible, except
via SET OF parameters, because the current DBP architecture requires that the table
ID's be compiled in, and session tables don't have static table ID's.

Karl