RE: Creating an SQL function from a service program

Hi Dave
I just tried changing that to all the different values - with the same result
Decimal data error

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of dlclark@xxxxxxxxxxxxxxxx
Sent: Tuesday, January 09, 2018 1:33 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Creating an SQL function from a service program

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 01/09/2018
12:38:43 PM:

Not sure what you mean by different parameter style

In your case, Alan, I don't expect that changing the parameter
style is going to make a difference.

PARAMETER STYLE GENERAL means that you will get just the 8 parameters you
defied passed to your service procedure;

PARAMETER STYLE GENERAL WITH NULLS means that you will get 16 parameters
passed to your service procedure -- the 8 you defined followed by 8 null
indicator parameters;

PARAMETER STYLE SQL means that you will get 20 parameters passed to your
service procedure -- the 8 you defined, followed by 8 null indicator
parameters, followed by 4 SQL parameters (used for output SQL STATE code,
input procedure name, input specific name, and output message text).


Sincerely,

Dave Clark