Re: Two trigger programs allowed on a file. Maybe more allowed?

Hey Ray!

Is it the orange T-shirt? Or a white one with boring blue and black
design? Seems I was also involved with the UCD sessions back then - was
working at Centerfield Technology in Rochester at the time.

Cheers
Vern

----- Original Message -----
Now that I didn't know! Of course after seeing Rob's response, maybe my
best bet is to do both!

Thanks so much. Anything that improves my performance is highly
appreciated.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of TheBorg
Sent: Monday, May 20, 2013 10:07 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Two trigger programs allowed on a file. Maybe more allowed?

I quit using the search feature in the IBM Information Center.

I now use Google to search for stuff on IBM sites, using 'site:ibm.com"
in the search string to force it to search the IBM site.

In fact, I attended a User-Centered Design session (got a T-shirt!) in
Rochester almost 10 years ago and expressed my frustration with the search
feature in the Information Center, and some of the IBM'ers admitted that it
wasn't very good.

- sjl


"Raymond B. Dunn" wrote in message
news:mailman.4859.1369061731.7202.midrange-l@xxxxxxxxxxxx...

I use the search function on the IBM website.

My comments may have been a little strong, but lately I have really had
problems finding things in the manuals.

I am the cutting edge guy here, so I have no one to bounce things off of.
In addition, I am the one who is expected to be able to resolve the
problems none of my coworkers are able to. I have two resources: You guys
(thank
god) (and the other internet sites) and the manuals. I would love to be
able to effectively use the manuals. I just seem to have a great deal of
trouble finding things in the manual, which in the past was never a problem.

That said, the system we work on has evolved so far from V5R1 that I know
there has to be more complexity in the manuals. It just seems like there
should be some kind of middle ground.

I very much appreciate your assistance Rob, Brent

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, May 20, 2013 9:36 AM
To: Midrange Systems Technical Discussion
Subject: RE: Two trigger programs allowed on a file. Maybe more allowed?

Don't blame it on the manuals - blame it on misuse of the manuals.
You CANNOT use the top url in your browser to get to the point you are
currently at in the manual.
You need to find a point which will point to that point. A blue
highlighted area for example like
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzlimtabs.htm
In Firefox I right click on the blue highlighted area and select "Copy
Link Location".

Information Center, Availability, Database and SQL limits, SQL limits

Triggers
Maximum number of triggers on a table 300

You can also search Infocenter for system limitations. That's how I
originally found this. Back in the old manuals you are so fond of I don't
think they had this. It was a separate manual entitled system limitations
or some such thing.

If you search for Maximum triggers you will see SQL Limits on the results
list, granted tis would have been nice to be closer to the top.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Raymond B. Dunn" <Raymond.Dunn@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 05/20/2013 10:26 AM
Subject: RE: Two trigger programs allowed on a file. Maybe more
allowed?
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Really? It took me to a generic V7R1 screen. I even tried to search for
maximum number of triggers in the DB2 manual. Nothing.

Again, this is an example of how IBM has made the manuals absolutely
worthless. I would love to take the person in charge of the V7R1 manuals
and beat him/her within an inch of their life.

I can remember back when the manuals were an asset. Thank god for the
internet and non-IBM information resources.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Monday, May 20, 2013 8:52 AM
To: Midrange Systems Technical Discussion
Subject: RE: Two trigger programs allowed on a file. Maybe more allowed?

Eric,
This link shows a max of 300
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/index.jsp


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Eric Lehti
Sent: Monday, May 20, 2013 7:45 AM
To: Midrange Systems Technical Discussion
Subject: Two trigger programs allowed on a file. Maybe more allowed?

I succeeded in attaching a second trigger program to a file yesterday.
Happy. I did not realize that system will allow more than one trigger
program.

I did not want to modify the existing (first) program trigger that tracks
sales order totals in real-time.

I created second trigger program with JD Edwards DBAM (data base audit
manager) to identify which process is changing info in one field.

How many trigger programs will system allow on a file? I will find out
someday.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.