Re: Calling Stored Procedures from 4GL

Posted in 1995

Mike Lemon — 11 Sep 1995 13:38:07 GMT — source: Informix-list mailing list archive (1991-1998)

steve@nezsdc.fujitsu.co.nz (Steve Chell) wrote: >I've been reading up about stored procedures recently, and can see how >to use them with SQL. One thing that is not clear, however, is how to >call them from 4GL programs. Is this possible using 4GL version 4.1x >in conjunction with a 5.0x engine (Online or SE)? If so how? Actually, I've been laboring for quite a while now under the assumption that it wasn't, but I recently discovered I was wrong. All you have to do is prepare and execute the statement. Put the normal ? parameter place-holders in the statement, and open/fetch the cursor if there are return values. Works bloody good.