Keep Leading Zeroes in Character Field
Ohmes, Matt
Matt.Ohmes@COGNOS.com
Thu, 5 Apr 2001 15:49:47 -0400
Rats, Conrad beat me to most of the punch. We didn't know you were joining.
I sent you one set of bad code, nconvert(gbsbl,8) is indeed an error. I was
thinking of Cconvert(x,8)... [ASCII(x,8) to non-IBMers]
If you are linking numeric to numeric then it shouldn't really make a
difference what numeric data storage type you use. The only exception is
perhaps if you are trying to link to a floating point number, 1.99999999...
is not equal to 2.
I suspect you are linking to a character field with leading zeros, not a
numeric. Either that or both "gbsbl" and the item you are linking to are
character. One without leading zeros and one with. If that is the case, try
"00" + gbsbl
Good luck,
Matt
-----Original Message-----
From: joann.l.olsen@us.abb.com [mailto:joann.l.olsen@us.abb.com]
Sent: Thursday, April 05, 2001 3:26 PM
To: powerh-l@lists.swau.edu
Subject: Keep Leading Zeroes in Character Field
Thanks to everyone for the help. I needed the leading zeroes for linking to
another file where the key in that file is numeric and contains the leading
zeroes. I tend to agree with Bob Edis. It can't be done. Back to the
drawing
board!
This did not produce an error, but did not give me leading zeroes:
def d-num num*8 significance 8 pic "^^^^^^^^" = nconvert(gbsbl)
On the following define, I got an error pointing to the comma. def
d-num
num*8 = nconvert(gbsbl,8)
Original message:
I need to convert a character field to a numeric field, but keep the leading
zeroes. If the nconvert is used, it drops the leading zeroes. How can that
be
accomplished? We are on an AS/400.
Example: subledger char*8 = 00100241
def D-NUM num*8 = nconvert(subledger)
The results in D-NUM is 100241
Thanks
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.