I have a RPGLE PCM5085 which generates a workfile WF1. When I call this from the command line it works fine.
I also have a wrapper program PCM5085SP which accepts two numeric parametes, converts these two parms into char and calls PCM5085.
I have created a store procedure as
CREATE PROCEDURE dhillond/PCM_SP_SelectSizes1 (@store dec (4 ),
@sku dec (7)) DYNAMIC RESULT
SETS 1 LANGUAGE RPGLE SPECIFIC Dhillond/PCM_SP_SelectSizes1 NOT
DETERMINISTIC MODIFIES SQL DATA CALLED ON NULL INPUT EXTERNAL NAME
'DHILLOND/PCM5085SP' PARAMETER STYLE GENERAL
I run this as CALL PCM_SP_SELECTSIZES1 (0053, 5054978).
I have two problems - when I finish calling this I do a select on workfile but its empty. If this means it has not worked, then which part has n't?
Also workfile is being locked by this session.
Please help
Devarshi.
I also have a wrapper program PCM5085SP which accepts two numeric parametes, converts these two parms into char and calls PCM5085.
I have created a store procedure as
CREATE PROCEDURE dhillond/PCM_SP_SelectSizes1 (@store dec (4 ),
@sku dec (7)) DYNAMIC RESULT
SETS 1 LANGUAGE RPGLE SPECIFIC Dhillond/PCM_SP_SelectSizes1 NOT
DETERMINISTIC MODIFIES SQL DATA CALLED ON NULL INPUT EXTERNAL NAME
'DHILLOND/PCM5085SP' PARAMETER STYLE GENERAL
I run this as CALL PCM_SP_SELECTSIZES1 (0053, 5054978).
I have two problems - when I finish calling this I do a select on workfile but its empty. If this means it has not worked, then which part has n't?
Also workfile is being locked by this session.
Please help
Devarshi.
Comment