Anybody ever run a program on an AS/400?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alex Lifeson - 08 Jul 2006 12:59 GMT

Through a VB application, I have to run a program on an AS 400.

The program takes 6 parameters. The first 5 are input and the 6th is an
output parameter.

I guess I would do something like:

Create an ADODB.Command object. Command type is text. Command text "call
Library.ProgramName". Populate / append 5 parameters of type input.
Populate / append one parameter of type input output.

Does this sound correct?

Reply to this Message

Evan Nelson - 31 Jul 2006 21:39 GMT

Alex,

I found it easiest to do it the following way:

CALL LIB.PRGM ('PARM1', 'PARM2', 'PARM3', 'PARM4', 'PARM5')

But I never ran anything where I had return pararmeters. Let me know if it
works setting up ADO parameters.

I'm assuming you have to use the AS/400 ADO drivers provided by either
Microsoft or IBM for free. I know that I found some good third party ones I
would have liked to use but wasn't allowed to buy. I think they handled ADO
parameters, but I couldn't get the IBM or MS drivers to work with them.

Evan

> Through a VB application, I have to run a program on an AS 400.
>
[quoted text clipped - 8 lines]
>
> Does this sound correct?

Reply to this Message

VB Forum / Database Access / July 2006

Anybody ever run a program on an AS/400?