Stored procedures on client/server environment and I really need help!

[Guest.Visitor]

I've been given the assignment to provide a stored procedure on Windows NT that can be called from other platforms (VAX) to retrieve information from an AS/400. Since my background is purely AS/400, I need any help and/or suggestions that can point me in the right direction. I've been told that Client Access Express will be used as a link (TCPIP) between the NT and the AS/400. TIA

[Guest.Visitor]

Hi, All you have to do on the AS/400 is to create a store procedure (can be written in any language ie. RPG, CLLE, COBOL etc ...). The easiest way is to STRSQL and then use sql cmd CREATE PROCEDURE to actually define the program like a store procedure. Look in the SQL manual for all the parameters. You can optionally pass parameters to the store procedure. On the remote system (VAX or WINDOWS NT etc...) you use the sql cmd CALL to run the above store procedure on the AS/400. So all you need is 2 systems that support SQL (almost every system support that). Have fun

[Guest.Visitor]

Alan, Where is this stored procedure supposed to run DB2/400 or ?, what is calling it ODBC or ?, and what is it retrieving from the AS/400? David Morris

[Guest.Visitor]

David, let's say that a program (PGMA) running on the VAX needs to retrieve the time of the day, as it is known to the AS/400. PGMA will issue an SQL Call to a program (getTime) on the NT. getTime will call a program on the AS/400 to retrieve and return the current time to its caller. 1. How do I initiate a communition NT <> AS/400? What are my choices? 2. How do I code the program on the NT and How do I executed? My responsibility is to provide the program on the NT and AS/400 side. TIA