Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri Mar 14, 2008 2:33 pm Post subject:
I don't understand what result you're trying to get in the output.
123456/100 = 1234 so EDIT=(TTTT.TT) would give you 0012.34 which is what you got.
What output do you want? _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Thanks for the resonce.My question is when I use DIVIDE option on a number(123456) by 100,I need to get the o/p as 1234.56.How can I achive by using DIVIDE option.
Joined: 02 May 2007 Posts: 202 Topics: 0 Location: Viginia, USA
Posted: Sat Mar 15, 2008 11:23 am Post subject:
bprasanna wrote:
Thanks for the resonce.My question is when I use DIVIDE option on a number(123456) by 100,I need to get the o/p as 1234.56.How can I achive by using DIVIDE option.
123456 /100 = 1234.56
Regards
Tempuser
What is the difference between that and
Quote:
I think all he wants to do is put a decimal point in his data.
What about using
OUTREC FIELDS=(1,6,ZD,EDIT=(TTTT.TT),80:X)
Files on the mainframe do not normally have explicit decimal points. The decimal position is determined by the definition of the field in the program using it.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Sat Mar 15, 2008 3:23 pm Post subject:
Quote:
My question is when I use DIVIDE option on a number(123456) by 100,I need to get the o/p as 1234.56.How can I achive by using DIVIDE option.
Tempuser,
What you're saying makes no sense. You can't divide the number by 100 and still retain all of the digits. Dividing by 100 removes the last two digits. You don't want to divide by 100. You just want to edit the existing value to have a decimal point.
Craig already showed you how to do that. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum