Re: Help with UDFs or stored procedures

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Dan

It is too bad IBM uses different techniques for the 2 styles - they 
could have made the GENERAL use multiple parameters instead of an 
array - oh well!

As to the hyphen for NULL, I believe it is not changeable - that is 
why I often use the following

values(null_capable_column, ' ')

This uses the value of the column if it is not NULL and a blank when 
it is - of course, use a zero if column is numeric.

HTH
Vern

At 09:53 AM 12/29/2006, you wrote:

> On 12/28/06, Vernon Hamberg <vhamberg@xxxxxxxxxxx> wrote:
> >
> > I think I was the one that given you the earlier suggestion - I
> > apologize for any confusion - I was referring to the SQL parameter
> > style, which is different. Here is the description of the parameters
> > from the manual:
>
> <snip>
>
> Thanks for the clarification, Vern.  Had to read your explanation a few
> times, but I get the gist of it now.
>
> Is the standard "output" of a null value for display / print in interactive
> SQL always a single dash?  Is there a way to change that?  I'm just
> wondering in case I encounter having to show nulls on a character field for
> which a valid value may be a single dash character.
>
> - Dan
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.