Issue with Numeric to Character Conversion in RPG Free -- RPG400-L

CONSNO = %CHAR(Partner#);

Consno is 8A
Partner# 8S 0 and has a value of 00012345

When Statement CONSNO = %CHAR(Partner#); is executed the Value of CONSNO
is 12345bbb (b=Blank)

How can I get the Value of CONSNO to = 00012345

Thanks for your assistance

Mike

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
rpg400-l-request@xxxxxxxxxxxx
Sent: Friday, November 30, 2007 9:38 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RPG400-L Digest, Vol 6, Issue 1158

Send RPG400-L mailing list submissions to
rpg400-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/rpg400-l
or, via email, send a message with subject or body 'help' to
rpg400-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
rpg400-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than
"Re: Contents of RPG400-L digest..."

*** NOTE: When replying to this digest message, PLEASE remove all text
unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

1. Re: 00:00:00 or 24:00:00 (Joep Beckeringh)
2. Re: 00:00:00 or 24:00:00 (Bill Wragg)
3. RE: 00:00:00 or 24:00:00 (GUY_HENZA@xxxxxxxxxxxxxx)
4. Re: 00:00:00 or 24:00:00 (Douglas Handy)
5. Re: 00:00:00 or 24:00:00 (Ron Power)
6. Re: Reclaim storage - time estimation (Jerry Adams)

----------------------------------------------------------------------

message: 1
date: Fri, 30 Nov 2007 15:16:14 +0100
from: Joep Beckeringh <joep@xxxxxxxxxxxxxxxxxxx>
subject: Re: 00:00:00 or 24:00:00

Was that Question 67 or Question 68?

Joep Beckeringh

Weber, Richard (US) schreef:

Does anybody really know what time it is...? ;-)

------------------------------

message: 2
date: Fri, 30 Nov 2007 06:14:47 -0800 (PST)
from: Bill Wragg <bill_wragg@xxxxxxxx>
subject: Re: 00:00:00 or 24:00:00

25 or 6 to 4

Good Luck
Bill
(All else fails READ THE INSTRUCTIONS)

----- Original Message ----
From: "Weber, Richard (US)" <Richard.Weber@xxxxxxxxxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, November 30, 2007 9:05:16 AM
Subject: RE: 00:00:00 or 24:00:00

Does anybody really know what time it is...? ;-)

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Thursday, November 29, 2007 4:40 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: 00:00:00 or 24:00:00

"fortunately, we only have a second to think about it and it is gone."

Unlike this thread 8-)

Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

"John Arnold

(MFS)"

<jarnold@medicalf
To
undingservices.co "RPG programming on the AS400 /

m> iSeries" <rpg400-l@xxxxxxxxxxxx>

Sent by:
cc
rpg400-l-bounces@

midrange.com
Subject
RE: 00:00:00 or 24:00:00

11/29/2007 04:31

PM

Please respond to

RPG programming

on the AS400 /

iSeries

<rpg400-l@midrang

e.com>

As was stated many times yesterday January 1, 2000 00:00:00 is the same
as January 1, 2000 24:00:00 - the reason is that there really is no zero
in time computation.
The truth is zero hour does not exist, only 2400 exists, however, 2400
is the end of the day so there is no time of 24:00:01 - that time is
expressed as 00:00:01 thus leading one to believe that 00:00:00 exists.
If the zero hour existed, it would be the first marker in the next day
but since it does not exist time always moves from today at 24:00:00 to
tomorrow at 00:00:01 - fortunately, we only have a second to think about
it and it is gone.

John Arnold
(301) 354-2939

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of qsrvbas@xxxxxxxxxxxx
Sent: Thursday, November 29, 2007 4:18 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: 00:00:00 or 24:00:00

Peter.Colpaert wrote:

1. 00:00:00 or 24:00:00 (Peter.Colpaert)

One of our processes involves parsing a directory listing of a windows

shared drive, and there are 6 files which cause problems.

These files have an entry in the listing as follows:

01/01/2000 12:00a 438,082 GN0229084.JPG

The listing is parsed by two different programs (one made by me, the
other made several years ago by another developer).

His program (using pre-bif methods) returns the time as 00:00:00,
whereas mine (using the %time built-in function) returns 24:00:00

First of all, I'd like to know whether January 1, 2000 00:00:00 is the

same as January 1, 2000 24:00:00 (I would think that the latter
actually means January 2).

(I know, this was beaten into the ground; but I gotta add my opinion
after just getting back...)

My purely personal opinion is that hour '24' cannot be valid. Hour '24'
implies that hour '24' has minutes '00' through '59' and the time
'24:15' doesn't exist. True, the implication is a logical one, not
enforced by standards. But programming should have a logical foundation.
(Ignoring Daylight Saving Time, leap-years, etc., since we need to
handle all special cases as... "special cases" anyway.)

Also, when comparing hours with minutes or seconds, why would anyone
expect hours to range up to '24', but minute '60' and second '60'
wouldn't be allowed? Minutes and seconds start at '00', so hours should
be consistent. Is '24:60:60' a valid time? If so, what time is it?

IMO, hour '24' ought to be tossed onto the heap of discarded nonsense.
Much like division by zero...

Also, "12noon" must be /neither/ AM nor PM. The conceptual use of 'AM'
is 'before noon' (ante meridiem) and 'PM' is 'after noon' (post
meridiem). "Noon" can be neither 'before' nor 'after' "noon".
Similarly, "12midnight" is 'special'. "Noon" is not part of the morning
nor part of the afternoon; it is the point that marks the boundary
between them. (Is your property line part of your property?
or your neighbor's?) But I'm totally lost on what that means. Sigh.

Purely opinion, not based upon expertise with standards.

Tom Liotta

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone 253-872-7788 x313
253-479-1416
Fax 253-872-7904
http://www.powertech.com
--
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.

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

This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law. These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited. Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption from
disclosure as to this communication. If you have received this
communication in error, please immediately notify the sender and delete
the message from your system.

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

Looking for the perfect gift? Give the gift of Flickr!

http://www.flickr.com/gift/

------------------------------

message: 3
date: Fri, 30 Nov 2007 09:23:34 -0500
from: GUY_HENZA@xxxxxxxxxxxxxx
subject: RE: 00:00:00 or 24:00:00

Don't know, don't care... :-)

Please STOP this thread...

"Weber, Richard (US) "

<Richard.Weber@PoloRalph To: "RPG
programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>

Lauren.com> cc:

Sent by: Subject: RE:
00:00:00 or 24:00:00

rpg400-l-bounces@midrang

e.com

11/30/2007 09:05 AM

Please respond to RPG

programming on the AS400

/ iSeries

Does anybody really know what time it is...? ;-)

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Thursday, November 29, 2007 4:40 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: 00:00:00 or 24:00:00

"fortunately, we only have a second to think about it and it is gone."

Unlike this thread 8-)

Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

"John Arnold

(MFS)"

<jarnold@medicalf
To
undingservices.co "RPG programming on the AS400 /

m> iSeries" <rpg400-l@xxxxxxxxxxxx>

Sent by:
cc
rpg400-l-bounces@

midrange.com
Subject
RE: 00:00:00 or 24:00:00

11/29/2007 04:31

PM

Please respond to

RPG programming

on the AS400 /

iSeries

<rpg400-l@midrang

e.com>

As was stated many times yesterday January 1, 2000 00:00:00 is the same
as January 1, 2000 24:00:00 - the reason is that there really is no zero
in time computation.
The truth is zero hour does not exist, only 2400 exists, however, 2400
is the end of the day so there is no time of 24:00:01 - that time is
expressed as 00:00:01 thus leading one to believe that 00:00:00 exists.
If the zero hour existed, it would be the first marker in the next day
but since it does not exist time always moves from today at 24:00:00 to
tomorrow at 00:00:01 - fortunately, we only have a second to think about
it and it is gone.

John Arnold
(301) 354-2939

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of qsrvbas@xxxxxxxxxxxx
Sent: Thursday, November 29, 2007 4:18 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: 00:00:00 or 24:00:00

Peter.Colpaert wrote:

1. 00:00:00 or 24:00:00 (Peter.Colpaert)

One of our processes involves parsing a directory listing of a windows

shared drive, and there are 6 files which cause problems.

These files have an entry in the listing as follows:

01/01/2000 12:00a 438,082 GN0229084.JPG

The listing is parsed by two different programs (one made by me, the
other made several years ago by another developer).

His program (using pre-bif methods) returns the time as 00:00:00,
whereas mine (using the %time built-in function) returns 24:00:00

First of all, I'd like to know whether January 1, 2000 00:00:00 is the

same as January 1, 2000 24:00:00 (I would think that the latter
actually means January 2).

Does anybody really know what time it is...? ;-)

Does anybody (in Chicago) really care? :)

------------------------------

message: 5
date: Fri, 30 Nov 2007 11:02:18 -0330
from: Ron Power <RPower@xxxxxxxxxx>
subject: Re: 00:00:00 or 24:00:00

Well no matter what time it is in the world, it's always at least one
half
an hour off our time here in Newfoundland portion of Newfoundland and
Labrador. We have our own time zone in the island portion that puts us
@
-3:30 off Greenwich time. Which is why all our programs on TV have the
additional message (7:30, 7:00 in Labrador). lol. We are a unique
bunch....
At least Microsoft recognized us with the time zone on the PC settings
lol.

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/