QUERIES ON STORED PROCEDURES
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