Re: varchar_format illegal on customer box?

We're still on 7.1. I can confirm that the examples in your OP won't work
on our box, but

select dec(varchar_format(
timestamp_iso(current_date), 'YYYYMMDD'),8,0)
from sysibm.sysdummy1

does work.

- Dan

On Tue, Mar 20, 2018 at 9:18 AM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

Thx Rob - i think i narrowed it down to we are on 7.2 and client is 7.1

or

less...

in 7.1 or less, I believe the answer is to refer to a timestamp initially
and not a date, such as...

select dec(varchar_format(
timestamp_iso(current_date), 'YYYYMMDD'),8,0)
from sysibm.sysdummy1

At least I found this through some googling which solved the problem for
one person on 7.1.

If anyone can confirm this it would be appreciated.

--
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