IBM Support

Example of an External Stored Procedure Calling a CL Program with Parameter

Troubleshooting


Problem

This document provides an example of an External Stored Procedure calling a CL Program with an input parameter.

Resolving The Problem

This document provides an example of an External Stored Procedure calling a CL Program with an input parameter.

The parameter is an input parameter passed in to the stored procedure on the call, and then passed on to the CL program. It was created using V7R1 i Acess and on a V7R1M0 i. The stored procedure passed a value in (up to 10 characters) that will be sent as a message to the user's message queue specified in the CL program.

3 > CRTCLPGM PGM(KBRETTIN/JTEST3) SRCFILE(KBRETTIN/SRC)
Program JTEST3 created in library KBRETTIN.

CL PGM source:

This shows the source of the CL program.

This shows the CREATE PROCEDURE statement and messages in IBM i Navigator

This shows the results of the stored procedure call.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"}]

Historical Number

597170611

Document Information

Modified date:
18 December 2019

UID

nas8N1011570

Page Feedback