troubleshooting Question

Syntax for executing a process on AS400 with a pass thru query

Avatar of askolits
askolits asked on
Microsoft AccessIBM System iSQL
6 Comments1 Solution586 ViewsLast Modified:
I have someone who executes a process on an AS400 called PODATACL. I want to do this through Access.
What is the syntax for diong this.

I already set up an ODBC connection and can link to tables, so I know MY ODBC connection works.
I believe the library is  MM510ITL (This is a test database)
I have created a pass through query with the ODBC string and have tried the following:

EXEC SQL CALL  MM510ITL/PODATACL
CALL  MM510ITL/PODATACL
EXEC SQL MM510ITL/PODATACL

I get an error:
""Qualified Object name PODATACL not valid (#-5016)"
or
"Token EXEC was not valid. Valid Tokens: (END GET SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER BEGIN. (# - 104)

Thanks,

John

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
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 6 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