Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Question when converting from ZD to PD.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Mon Oct 19, 2009 5:17 pm    Post subject: Question when converting from ZD to PD.
Reply with quote

HI

I have a file and converted all the zoned decimal to packed decimal. i tried with the cobol program then with SYNCSORT. But converted without any issue. but the file compare did not show the desire result (all records were mismatching).
when i opened the file with HEX ON option, i could see the sign field is "C" when converted using COBOL and "F" with SYNCSORT. In production, the same file has "C". Will this be any problem. i mean to say that i know that both represents positive field but when used in the program will the program behave differently.

Code:

..cÈ..%../.............æWeek Ending 06/18/20             
008700621620000100000039E8894C988984FF6FF6FF444444444444
083432C041C00000C000003C65520554957006118120000000000000


Code:

..cÈ..?../.............¤Week Ending 06/18/20           
008700621620000100000039E8894C988984FF6FF6FF444444444444
083432F041F00000F000003F65520554957006118120000000000000
Back to top
View user's profile Send private message

Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Oct 19, 2009 7:45 pm    Post subject:
Reply with quote

Hello Arvind.

Based on your description, I assume that you are running SyncSort for z/OS 1.3. If this is correct, please identify the maintenance level. If this is not correct, then please specify the complete release and maintenance level of SyncSort currently installed at your shop.
Back to top
View user's profile Send private message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Mon Oct 19, 2009 8:05 pm    Post subject:
Reply with quote

Hi Alissa,

you are correct. The syncsort verion in my shop is:
Code:

SYNCSORT FOR Z/OS  1.3.2.1R


How to identify the maintenance level.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Oct 19, 2009 8:21 pm    Post subject:
Reply with quote

Instead of specifying (p,l,ZD,PD) to convert the data, try (p,l,ZD,PDC).
Let me know if you run into any difficulties.
Back to top
View user's profile Send private message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Tue Oct 20, 2009 9:57 pm    Post subject:
Reply with quote

I did work for me. But i want to know as if there is any difference between "C" and "F".
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Oct 20, 2009 10:18 pm    Post subject:
Reply with quote

Hello,

Quote:
if there is any difference between "C" and "F".
As numbers, no - both are positive.

As character values, yes. As you've seen, when comparing these, they compare unequal (which is the way they should compare - they are not equal).
Back to top
View user's profile Send private message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Wed Oct 21, 2009 11:05 am    Post subject:
Reply with quote

All four fields are numeric. so i don't think it will be a problem.
Thank you all.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Oct 21, 2009 7:51 pm    Post subject:
Reply with quote

Hello,

Quote:
All four fields are numeric. so i don't think it will be a problem.
If any of these fields are used as a key or are part of a group level compare, the operation may fail. . .
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts Fault Analyzer - listings question. egrove IBM Tools 4 Thu Aug 11, 2016 5:31 pm
No new posts Converting multiple VB files to FB fi... Viswanath Reddy JCL & VSAM 6 Mon Aug 08, 2016 11:49 pm
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm
No new posts dataset copy question - REPRO or some... atulxp TSO/ISPF 2 Wed Aug 03, 2016 10:56 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us