Call AS400 iSeries Program

[Guest]

I have created a database that utilizes linked tables to files on the iSeries
through ODBC. The files on the iSeries are created by AS400 Query. I would
like to call the query, on the iSeries, from the Access database. Any
suggestions?
Thanks,
David

 

[Rick Brandt]

I have created a database that utilizes linked tables to files on the
iSeries through ODBC. The files on the iSeries are created by AS400
Query. I would like to call the query, on the iSeries, from the
Access database. Any suggestions?
Thanks,
David

If you mean that a Query400 query needs to be executed and it puts its
output into your tables so you can view them via the link then there is no
easy wasy to do that. You cannot execute an AS400 command via ODBC.

If you had a stored procedure on the AS400 that would then call the command
then you could use a passthrough query to execute the Stored Procedure.

 

[Guest]

Hi all,

I want to call a CL or RPG program from Visual Basic 6.0. Can someone tell
where to find a good example.

Thanks,

MN