> Sorry, I am not familiar with the EXTERNAL NAME clause. All of the SPs I
have used on the AS400 have been SQL procedures. I'll ask around though
as we have a few RPG guys. I just don't know if they have ever created an
RPG stored procedure.
Yes that would be great! Thanks in advance!
If I only could I would use an SQL procedure. But the table I have to
retrieve data from counts over 10 million records, so an SQL selection with
one simple condition takes about 3-5 minutes. RPG needs only 600milliseconds
:-)
--
?Chr(119)& Chr(095)& Chr(119)& Chr(101)& Chr(110)& _
Chr(100)& Chr(114)& Chr(121)& Chr(099)& Chr(104)& _
Chr(111)& Chr(119)& Chr(105)& Chr(099)& Chr(122)& _
Chr(064)& Chr(112)& Chr(111)& Chr(099)& Chr(122)& _
Chr(116)& Chr(097)& Chr(046)& Chr(102)& Chr(109)