Re: varchar_format illegal on customer box?

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

7.2

On Tue, Mar 20, 2018 at 10:05 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> Which IBM i Release you are on?
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> „Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Jay Vaughn
> Sent: Dienstag, 20. März 2018 13:57
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Subject: varchar_format illegal on customer box?
>
> Trying to figure out why the below statements works fine in embedded sql on
> our development box but not for our customer?
>
>
>
> select dec(varchar_format(current_date, 'YYYYMMDD'),8,0)
>
> from sysibm.sysdummy1
>
>
>
> and
>
>
>
> select dec(varchar_format(current_date, 'MMDDYYYY'),8,0)
>
> from sysibm.sysdummy1
>
>
>
>
> and
>
>
>
> select dec(varchar_format(current_timestamp, 'HHMM'),4,0)
>
> from sysibm.sysdummy1
>
>
>
> On customer box, the joblog shows...
>
> Argument 1 of function VARCHAR_FORMAT not valid.
> DECIMAL use not valid.
>
>
> Any ideas?
>
>
> Jay
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe,
> or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link:
> http://amzn.to/2dEadiD
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD