troubleshooting Question

AS400 Stored Procedures

Avatar of JArndt42
JArndt42Flag for United States of America asked on
Microsoft AccessIBM System i
4 Comments1 Solution1077 ViewsLast Modified:
I have an access data base that I use successfully used pass through queries to get data from AS400 database. I want to know if there is a way to create a stored procedure on AS400 and call it from Access. Basically what I am trying to do is this. I have a carrier data base. the carriers are in the AS400 database and I view them in my Access database, allot more flexible and easier to find. Each carrier has a city. I want to run a query in Access that would find the carriers in so many mile radius of a search city. On the AS400 there is a PC miler version for AS400. I want to be able to pass the city and radius to that and get the results. Is this even possible? I would think I need to create a stored procedure and somehow pass the parameters to this from Access. Am I even close?
Gary Patterson, CISSP
Expert for hire: IBM i, AIX, Linux, Windows, DB2, Performance, Security. EDI

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros