Yep, it was introduced in Release 6.1.

Values is even much more powerful, i.e. not only a single column/value can
be returned but also a table of values and this table of values can be even
used in an SELECT statement for example if you need some test data and do
not want to generate a table.
Examples:

Values(Current_Date, DayOfWeek_ISO(Current_Date), DayName(Current_Date));

Select x.*, MyInt + 100
From (Values('A', 123), ('B', 456), ('C', 789)) x (MyChar, MyInt)

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

-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Gerald
Magnuson
Gesendet: Friday, 24.6 2016 18:55
An: RPG programming on the IBM i (AS/400 and iSeries)
Betreff: Re: Char to hex

omg......
I can just type "values......", without doing a select?

that is cool!


On Fri, Jun 24, 2016 at 11:33 AM, Darren Strong <darren@xxxxxxxxx> wrote:

SQL can do it. Try the following in an SQL screen, like STRSQL:

values(char(hex(12345678901)))

Gives:
VALUES
00000002DFDC1C35
___________________________________
Darren Strong
Dekko





From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 06/24/2016 12:07 PM
Subject: Char to hex
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



I have a non-blank char field that shows up as blanks in an e-mail.
I'm thinking the field could contain unprintable characters, so I'd
like to include the hex value as well in the e-mail. How do I go
about getting the hex value?

Thanks
--
This is the RPG programming on the IBM i (AS/400 and 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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.



--
This is the RPG programming on the IBM i (AS/400 and 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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
This is the RPG programming on the IBM i (AS/400 and 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.

Please contact support@xxxxxxxxxxxx for any subscription related questions.


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].