RE: Trigger pgm - SQL errors

Pete,

The one about SQL being too fast is funny. What exactly was the message?
SQL0000?
That usually points out the problem or at least points in the direction
of a correct diagnosis. Also what did or does the trigger program do?

Regards

Konrad

-----Original Message-----
From: Pete Olshavsky [mailto:polshavsky@xxxxxxxxx] 
Sent: Wednesday, June 18, 2003 7:43 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Trigger pgm - SQL errors


Morning list,
I have a customer that wanted to put some kind of security over the
GELMAS file. We discussed on this thread about using AS400 security. But
the feeling I came away with was... Be careful be very very careful. And
be afraid. So the route we decided was to put a *read trigger on the
gelmas file. Which seems to be working perfectly. Whenever anyone reads
the file. Like a G/L audit. INquiry into an acct, Query the file, Dfu
the file. Program works like I want it to. 
Now the Problem. 
If I go to AM+ in the browser and click the icon for General ledger I
get SQL trigger in failed SQLCODE SQLSTATE. 
I can barely spell SQL. So I really don't understand the error message..
But the best that I can tell and that Mapics support can tell is that
SQL is reading records faster than the AS400 trigger pgm can process,
and end. I have even tried to setup my CL to really do nothing more than
cancel if the user is QUSER. Is there a way to tailor SQL to slow down
without affecting the other browser apps' or any other tricks not to get
the trigger pgm to fire?????
 
I am not at that account today so I don't have the ability to test
anything.  
TIA
Pete Olshavsky
Ind Mapics Programmer/Systems Analyst


---------------------------------
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.