krescruz/IBMiCallCLfromSP.sql

Created July 21, 2018 00:09

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/krescruz/af77ce3ab13f36092507b6d00b30c374.js"></script>
Save krescruz/af77ce3ab13f36092507b6d00b30c374 to your computer and use it in GitHub Desktop.

Download ZIP

IBM i Create store procedure for calling CLP (Programming Control language)

Raw

IBMiCallCLfromSP.sql

	CREATE PROCEDURE MYLIB.SPNAME(
	IN @P1 CHAR(10),
	)
	LANGUAGE CL
	NOT DETERMINISTIC
	NO SQL
	EXTERNAL NAME MYLIB.MYCL
	PARAMETER STYLE GENERAL;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment