Re: Stored procedure INOUT parm

["Eric N. Wilson" <doulos1@xxxxxxxx>]

What language are you using? With Delphi just set the parameter to In/Out
and then after the call do something like

SomeVariable := StoredProc1.ParamByName('SomeParm').Value;

VB with ADO requires a little more setup but in the end you reference the
Parameter's value the same way.

HTH
Eric Wilson
______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: <eric.delong@pmsi-services.com>
To: <midrange-l@midrange.com>
Sent: Friday, May 19, 2000 8:34 AM
Subject: Stored procedure INOUT parm


>
>      I've written a stored procedure in RPG4, and tried to pass back a
>      return value as the second parm. We want a PC app to call this
>      procedure via ODBC, but we can't figure out how to map the INOUT
>      parm to a host variable in the PC app. Can someone point me in the
>      right direction?
>
>      tia,
>
>      eric.delong@pmsi-services.com
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---