Re: RPG Program as a Stored Procedure

I built this using just a few of the fields using STRSQL You should be able
to past into STRSQL and press F4 and go to the third screen and add the
rest of your parameters.

CREATE PROCEDURE V64BPCSUSR/SVLBRTEST
(IN @pTransactionNum FLOAT ,
IN @pRevisionDate VARCHAR (25 ),
IN @pNRBDX FLOAT )
LANGUAGE RPGLE
SPECIFIC V64BPCSUSR/SVLBRTEST
NOT DETERMINISTIC
MODIFIES SQL DATA
EXTERNAL NAME V64BPCSUSR/SVLBRTEST
PARAMETER STYLE GENERAL

On Wed, Aug 7, 2019 at 3:29 PM <THarteau@xxxxxxxxxxxxxxxxxx> wrote:

I notice you're mixing system naming and SQL naming
CREATE PROCEDURE V64BPCSUSR.SVLBRTEST
and
specific V64BPCSUSR/SVLBRTEST
...
external name V64BPCSUSR/SVLBRTEST

Idk if that's causing the problem.

I originally had all /. The . was a test that did not work.

<===================================================>

Terri Harteau
Felker Brothers Corporation
****************
Practice random acts of kindness and senseless acts of beauty
-Anonymous
****************
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com