ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

System i navigator - SQL output parameter

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • System i navigator - SQL output parameter

    I'm using Navigator (7.1.0) to test a procedure call. I pass a few parameters and end with "?" so I can see the return message. My return message is defined as 20 characters, but I'm only seeing 2.

    example:

    call library.myprogram('D', '22', 'parm1', 'parm2', 'LOC1', 'LOC2,' 'PART', QTY, ?)

    my Return Code is zero

    my output parameter should be 'NA RESULTS < ZERO IN FROM LOC' but all I see is
    Output Parameter #9 = NA

    Can anyone see what I'm missing? I'm sure it's a silly mistake as it normally is!

Working...
X