|
The SQL manual states:
GENERAL
A general call to the procedure is performed.
Additional arguments are not passed for indicator
variables.
So how come when I
CREATE PROCEDURE ROB/ROBPROC3
(OUT StrSize DEC (5 , 0), OUT StrReturned CHAR ( 500))
LANGUAGE RPGLE
NOT DETERMINISTIC
NO SQL
EXTERNAL NAME ROB/PROC
PARAMETER STYLE GENERAL
and then use:
C/EXEC SQL
C+ CALL ROB/ROBPROC3 (:StrSize :StrReturned)
C/END-EXEC
My compile bombs with:
918 C+ CALL ROB/ROBPROC3 (:StrSize :StrReturned)
MSG ID SEV RECORD TEXT
SQL0080 35 918 Position 38 Indicator variable STRRETURNED not SMALLINT
type.
I thought PARAMETER STYLE GENERAL got rid of the need
for the indicator variables?
DSPMSGD RANGE(SQL0080) MSGF(QSQLMSG)
Message ID . . . . . . . . . : SQL0080
Message file . . . . . . . . : QSQLMSG
Library . . . . . . . . . : QSYS
Message . . . . : Indicator variable &1 not SMALLINT type.
Cause . . . . . : The definition of indicator variable &1 must be a 2-byte
binary with a zero scale.
Recovery . . . : Specify an indicator variable that is defined as a 2-byte
binary with a zero scale. Try the request again.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.