AW: Has something changed, with respect to join logicals?

Hi,

I assume you mean Instead Of Triggers that are introduced with PTF in V5R3
and available for release V5R4.
An Instead of Trigger is a special kind of SQL trigger that is not linked to
a physical file or table but to a SQL View.

Even though for physical files up to 300 triggers can be specified, it is
only possible to add 3 instead of triggers to a SQL view, one for each event
(Insert, Update, Delete).

When updating or writing to an joined SQL view an error will occur, as long
as no instead of trigger is defined.
If an instead of trigger for the appropriate event exists, the source code
specified in the trigger program will be executed. That means you can update
each of the linked tables.

But instead of triggers cannot be specified for DDS described joined logical
files.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von James Lampert
Gesendet: Monday, October 15, 2007 18:52
An: Midrange Systems Technical Discussion
Betreff: Has something changed, with respect to join logicals?


I'm getting this crazy rumor that there's now a way to write directly to
join logicals.

It is just a crazy rumor, isn't it?