Re: External Stored Procedures

[DLee@xxxxxxxx]

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