Re: Error in Create Procedure statement? Where?

Sql procedures are polymorphic . That means that the same procedure name
can be used In a number of different implementations ... handy is you ie.
swap dates and some times the date is a real date in SQL and some times
maybe packed 8. Now this feature bites you since you are dropping the
procedure Version without parameters and on next line reusing the name with
parameters... so in your case I would add the “specific” key word - both
when you create and drop - the specific is the object name in IBM i. And my
guess is you are thinking of the procedure name is also the object name
(hence the lib / name qualifications you are using) .. but that is not the
case - procedure names are sql internal and will result in a “random”
object name. But you can controls the “randomness” by the “specific “
keyword

Hop it helps
Niels


tor. 12. nov. 2020 kl. 00.42 skrev Thomas Garvey <tgarvey@xxxxxxxxxx>:

I can't afford to lose any more hair off this old head.
Can someone please tell me what's wrong with this SQL Procedure code?

Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 .
1 Drop Procedure BIO610F/ZXUZSC ;
2 Create Procedure BIO610F/ZXUZSC (
3 in @XUUSER char(10),
4 in @XUTYPE char( 1),
5 in @XUATTN char( 1),
6 in @XULANG char( 3),
7 in @XUAPRD char( 1),
8 in @XUCLAS char(10),
9 in @XUGRUP char(10),
10 in @ZWHSE char(80),
11 in @ZCOMP char(80),
12 in @ZTREF char(80),
13 in CallingProgram char(10),
14 in CopyFromUserID char(10)
15 )
16 language SQL
17 set option dbgview = *source
18

And here's the error produced when RUNSQLSTM is executed...

MSG ID SEV RECORD TEXT
SQL7990 0 1 Position 1 DROP PROCEDURE statement complete.
SQL0117 30 2 Statement contains wrong number of values.

--

Best Regards,

Thomas Garvey


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

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