MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

doubt on numeric DFSORT data formats(ZD,PD,BI,FI..).

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming
View previous topic :: View next topic  
Author Message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Sat Aug 26, 2006 10:29 am    Post subject: doubt on numeric DFSORT data formats(ZD,PD,BI,FI..). Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose

PostPosted: Sat Aug 26, 2006 7:49 pm    Post subject: Reply with quote

vjkumk,


Check this link which answers your question

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/C.3?DT=20050222160456

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Sun Aug 27, 2006 1:44 am    Post subject: Reply with quote

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


cheers,
jai Smile
Back to top
View user's profile Send private message
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Sun Aug 27, 2006 9:39 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Sun Aug 27, 2006 10:29 am    Post subject: Reply with quote

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
View user's profile Send private message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Fri Sep 01, 2006 9:21 pm    Post subject: Reply with quote

HI,

can i know the corresponding PL1 equavalent data types of DFSORT.



thanks,
VJ
Back to top
View user's profile Send private message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Sun Sep 03, 2006 1:47 am    Post subject: Reply with quote

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
View user's profile Send private message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Sun Sep 03, 2006 2:01 am    Post subject: Reply with quote

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 Very Happy


Cheers,
jai
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
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


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group