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
EXEC SQL MM510ITL/PODATACL
I get an error:
""Qualified Object name PODATACL not valid (#-5016)"
"Token EXEC was not valid. Valid Tokens: (END GET SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER BEGIN. (# - 104)