× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MAPICS-L
  3. June 2003

RE: Trigger pgm - SQL errors

Read triggers came out in V5R1.. They were created to allow user to 
support the governments requirement for logging of all access to data for 
medical data.  They are very dangerous in that they will fire 1000000 
times if you DSPPFM a file that has 1000000 records in it.. This was 
implemented at that level of the database, so it can't distinguish from a 
DSPPFM from a simple CHAIN.

The SQL expert that I asked stated that it sounded like the error was 
caused from recursive calls of the trigger.. 

Michael Franchino
Custom Systems Corporation
http://www.cussys.com
(973) 726-0202 X214 (Phone) 
(973) 726-4552 (Fax)




"Neely, Chris" <chris.neely@xxxxxxxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
06/19/2003 12:17 PM
Please respond to MAPICS ERP System Discussion

 
        To:     "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: Trigger pgm - SQL errors


With what version of the operating system did 'read' triggers come out? 
And, in what scenarios were they intended to be used for?

Thanks

-----Original Message-----
From: michael.franchino@xxxxxxxxxx [mailto:michael.franchino@xxxxxxxxxx]
Sent: Thursday, June 19, 2003 10:46 AM
To: MAPICS ERP System Discussion
Subject: RE: Trigger pgm - SQL errors


SQL is an additional licensed program that many customers don't buy.. If 
you have access to their machine through a PC, you can use Operation 
Navigator's SQL feature.. Also, if you want to test to see if the trigger 
is working, do a DSPPFM on the file.. It will fire that trigger a zillion 
times.

Just be aware, that READ triggers are very very dangerous.. Use sparingly.

Michael Franchino
Custom Systems Corporation
http://www.cussys.com
(973) 726-0202 X214 (Phone) 
(973) 726-4552 (Fax)




Pete Olshavsky <polshavsky@xxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
06/19/2003 11:42 AM
Please respond to MAPICS ERP System Discussion

 
        To:     MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
        cc: 
        Subject:        RE: Trigger pgm - SQL errors


Konrad & Malcolm, Thanks for your input. Don't want to beat a dead horse 
here. 
One more question. Malcolm. Your suggestion about strsql reminded me of 
something else... On the customer that I am trying to do this. I am not 
able to run the strslq command. Also I am not 100% sure about this but if 
I do a   GO CMDSQL ... I only have a couple of menu options. Could 
something not have been ordered on this box? Just installed beginning of 
the year. Missing a licensed product (DB2 Query Mgr and SQL DevKit for 
AS/400)
Thanks again for input
 
Pete
Malcolm Westley <mwestley@xxxxxxxxxxx> wrote:
Pete,

I would agree with Konrad that it would be a good idea to do a bit more 
investigation, although there is a good case for an os400 bug. *Read= is
a fairly new trigger program option, and a quick check of the ibm w ebsite 

produced the following APAR whereby a decimal data error in Quer= y
produced the same error you are seeing (the error was incorrectly gen 
erated).



Another way to test your problem would be to use the STRSQL command, th en 

type in the command SELECT * FROM GELMAS and press Enter. If SQL i= s
causing your error, you should see it crop up.

As to how to report an APAR, I have not had to do so, but it looks as t 
hough you will need a customer number of a customer with a valid servic= e
contract in order to submit one. Ibm should be able to tell you how= to
go about it. No doubt the first thing they will want to know is i= f you
have all the latest fixes installed.

Good luck,
Malcolm

> Pete,
>
> I would still rule out an OS/400 bug until you have done a bit mor= e
> tracing. AM+ could be doing something strange in ODBC that is no rmally
> not seen because of the speed of the 400.
>
> You may want to look at the stack on the job that is making the re 
peated
> call to see exactly which program / line is creating the issue. = A
> further step would be to do a normal odbc read of GELMAS and see i= f
the
> same issue arises. If it does not, check the ODBC connection par ameters
> for the AM+ vs your odbc connection to see if there are difference= s.
> Finally, if that fails turn on ODBC tracing for the AM+ connection= to
> see exactly what the application is doing. In that you should se= e
the
> connection SQL strings as they get executed.
>
> HTH
>
> Konrad
>
>
>
> -----Original Message-----
> From: Pete Olshavsky [ma= ilto:polshavsky@xxxxxxxxx]
> Sent: Thursday, June 19, 2003 7:17 AM
> To: MAPICS ERP System Discussion
> Subject: RE: Trigger pgm - SQL errors
>
>
> Malcolm, I tend to agree with you. I have never done this. Can= you
> explain how? Also I am an independant programmer. Will I need an= IBM
> customer no? Thanks Pete
>
> Malcolm Westley wrote:
> Pete,
>
> Looks like you found an os400 bug. You should submit an APAR to ibm.
>
> Malcolm_______________________________________________
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.





---------------------------------
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.



_______________________________________________
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.


_______________________________________________
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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.