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