Re: QUERIES ON STORED PROCEDURES
Yes. Me too have the same questions!
Please, forward.
Thanks,
Parviz
In article <49ht0k$im9@cssun.mathcs.emory.edu>,
hari@psi.ernet.in (v harinath) wrote:
>
>Hello informixusers,
>
> I have few questions on informix stored procedures.
>
>Q : 1
>------
>I am writing a stored procedure to be called from INFORMIX-4GL. Here is
>the piece of code for creating a procedure.
>
>May I know, how to call from a 4GL program ?
>
>______________________________CODE STARTS HERE_______________________________
>DROP PROCEDURE check_user;>
>CREATE PROCEDURE check_user(plo_user_name CHAR(8)) RETURNING SMALLINT;>DEFINE plo_users SMALLINT;
>
>SELECT count(*) INTO plo_users FROM security
>WHERE user_name = plo_user_name;>
>IF plo_users = 0 THEN
> RETURN 0
>ELSE
> RETURN plo_users
>END IF
>
>END PROCEDURE;
>______________________________CODE ENDS
HERE__________________________________
>
>Q.2
>---
> To add on , How to get value of the environment variable inside a stored
> procedure ?
>
>
>
>Thanks in advance,
>
>
>HARINATH VENKATASUBBIAH
>PSI DATA SYSTEMS,
>BANGALORE INDIA
>
>e-mail : hari@psi.ernet.in