AW: Char to hex

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.