Re: triggers & s36 update pgms

["Jim Franz" <franz400@xxxxxxxxxxxx>]

I had always assumed that the database update from a pgm running in S36ee
(not M36) was running a "normal" db2 update. The triggers themselves are
ile. I searched the archives & ibm support and found no matches for s36 &
triggers. We tested thoroughly the triggers in native envvironment. We "may"
have pinpointed the prob last nite to an add in an rpg2 where the output
specs had fields overlaying each other (an old s34/36 trick to copy a
record, but assign a new key)
OFILE         EADD                $ADD
O                                            FIELD1         256
(defined as 1 - 256)
O                                            FIELD2         512
(defined as 256 - 512)
O                                            KEY                  7
(defined as 7.0)
and several more fields
I rewrote the output, removing large fields and outputting all the
individual fields.
Will find out this am when production starts.
jim

----- Original Message -----
From: ken shields
To: MIDRANGE-L@midrange.com
Sent: Friday, May 11, 2001 6:47 AM
Subject: Re: triggers & s36 update pgms


The S/36 environment works slightly different than most of the 400 machines,
for example, I'm not sure it recognizes a data base..db2 etc, as most of
it's file structures were 'flat' or 'indexed'.
I doubt also, that you'll find anything that resembles a trigger in the 36
arena.
My guess is you may have to code a work around , which triggers a Cl access
to a 36 program execution, passing a record as parm. The 36 program, simply,
would read the record, update the file, and then LR.
Hope this helps, the folks at IBM ported the 36 environment, I suspect,
because there were, as in my case, a lot of accounts, which still ran their
systems on the S36 and did not upgrade through the years, (cost savings I
guess)
I tend to look at it a dual personality,,,something akin to mental
illness...
Ken
Jim Franz wrote:
Is there any known problems with a trigger pgm on a file updated by various
pgms,including s36 screen & batch, rpg3 & rpg4 & rpgsql? Error is cpf502B,
very vague.Only halting when s36 pgm was involved, and not halting on every
update.Previous msg in joblog indicates reference to missing or deleted
object,but doesn't say what it was looking for.At V4R4 cum 00350 and very
old databasegroup ptf (from 99) - any help appreciatedjim
--
Best Regards
Ken Shields
Home phone: 905 404-2062
Bus  phone  905 725-1144 (326)


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---