MVSFORUMS.com A Community of and for MVS Professionals
View previous topic :: View next topic
Author
Message
vjkumk Beginner Joined: 28 Sep 2005 Posts: 98 Topics: 33
Posted: Sat Aug 26, 2006 10:29 am Post subject: doubt on numeric DFSORT data formats(ZD,PD,BI,FI..).
I am a beginner in mainframes.There are many dataformat for numeric like ZD,PD,BI,FI,etc.I am not sure which one to use for numeric(integer,fixed decimal).I also checked with the IBM manuals , but unable to get a clear idea.Please give a clear explanation on this.I see many people are not aware of this basic .Your help is appreciated.
thanks,
jai
Back to top
kolusu Site Admin Joined: 26 Nov 2002 Posts: 12375 Topics: 75 Location: San Jose
Back to top
vjkumk Beginner Joined: 28 Sep 2005 Posts: 98 Topics: 33
Posted: Sun Aug 27, 2006 1:44 am Post subject:
Kolusu,
Thanks for your response.In IBM manuals, it is just given the equvalent cobol data types , but they haven't explained about the data types ZD,FD... in details.After a long search i found the following website ,which gives those datatypes in details and it is really worth to check it.It will be better if you put this information in a common section.
http://www.simotime.com/spsnum01.htm
If any body has more information on this data type formats,please post the information.
cheers,
jai
Back to top
Frank Yaeger Sort Forum Moderator Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Sun Aug 27, 2006 9:39 am Post subject:
Quote: In IBM manuals, it is just given the equvalent cobol data types , but they haven't explained about the data types ZD,FD..
Actually, the same Appendix in "z/OS DFSORT Application Programming Guide" describes all of DFSORT's formats. See:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/C.1?DT=20060615185603
You can also find more general information about the "standard" data types in "z/Architecture Principles of Operation" (POP). See Chapters 7-9:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dz9zr003/CONTENTS?SHELF=EZ2ZO10E&DT=20040504121320#8.1.1 _________________ 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 Last edited by Frank Yaeger on Sun Aug 27, 2006 1:46 pm; edited 1 time in total
Back to top
vjkumk Beginner Joined: 28 Sep 2005 Posts: 98 Topics: 33
Posted: Sun Aug 27, 2006 10:29 am Post subject:
Frank,
Thanks for posting the additional information.
I think the second link has more information compared to the first one.
cheers,
jai
Back to top
vjkumk Beginner Joined: 28 Sep 2005 Posts: 98 Topics: 33
Posted: Fri Sep 01, 2006 9:21 pm Post subject:
HI,
can i know the corresponding PL1 equavalent data types of DFSORT.
thanks,
VJ
Back to top
vjkumk Beginner Joined: 28 Sep 2005 Posts: 98 Topics: 33
Posted: Sun Sep 03, 2006 1:47 am Post subject:
after searching the net , i got this information ,Correct me if i am wrong.
Pl1 attributes: Ibm data format:
fixed decimal====> Packed Decimal(two digits per byte)
fixed binary=====> Fixed point(halfword or fullword)(halfword - 2bytes)
float decimal,float binary ====>floating-point(fullword,doubleworld)
picture====>Zoned decimal(one digit per byte)
character or picture=====>character(one byte)
Bit =====>Bit(one byte)
cheers,
VJ
Back to top
vjkumk Beginner Joined: 28 Sep 2005 Posts: 98 Topics: 33
Posted: Sun Sep 03, 2006 2:01 am Post subject:
I think this will be useful for members
Supported data types between cobol and pl1:
COBOL: PL1:
PIC S9(4) USAGE IS BINARY---->REAL FIXED BINARY(15,0)
PIC S9(9) USAGE IS BINARY ---->REAL FIXED BINARY(31,0)
COMP-1 ----> REAL FLOAT DECIMAL(6)
COMP-2 ----->REAL FLOAT DECIMAL(16)
PIC S9(N) PACKED- DECIMAL ---->FIXED DECIMAL(n)
PIC S9(N) COMP-3 ------->FIXED DECIMAL(N)
PIC X(N) USAGE IS DISPLAY ----->CHARACTERS(N)
Cobol: PL1:
01 PLISTRING. PLISTRING CHAR(N) VARYING.
02 LEN PIC 9(4) BINARY .
02 CHAR PIC X OCCURS 1 TO N
DEPENDING ON LEN
I will be glad if any body post equvalent data type between DB2 ,COBOL & PL1
Cheers,
jai
Back to top
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