Re: External Stored Procedures

Could use some help.

Is there any way I can avoid hard coding the library name on the call
statement?
If I can know the userid, I can determine where to call the program from.

I guess I could call this stored procedure from a clp program and pass in
a library reference, but that seems like the long way around.

I admit, I'm not too sharp on the stored procedures, but I've been kicking
and biting my way thru it.
I tried to DECLARE USER and then VALUES SESSION_USER INTO USER but that
didn't seem to work as it does in SQL stored procedures.

Appreciate any help, or references.
Ignore the &lib, that's something Aldon uses when a proc is created in
aldon to promote to programs from development to QA.


CREATE PROCEDURE &LIB/REM125SP ( )
RESULT SETS 1
LANGUAGE CL
SPECIFIC &LIB/REM125SP
NOT DETERMINISTIC
NO SQL
CALLED ON NULL INPUT
EXTERNAL NAME CRPRDLIBTS/REM110CL
PARAMETER STYLE GENERAL;

CALL CRPRDLIBTS/STRTSTLIB(COCD);

Regards,



SWBC
9311 San Pedro Ave., Suite 600
San Antonio, TX 78216

Visit our website at www.swbc.com