ICETOOL Controlcard for Signed and Unsigned Data Types



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

Postby Frank Yaeger » Thu Dec 22, 2011 11:17 pm

Ravi,

Since you mentioned ICETOOL, I assumed you were using DISPLAY with ON fields. If you had shown your control statements in your first post, I would have known that you're using BUILD and could have given you what you needed in my first post. In the future, please try to do a better job of explaining what you want to do.

At any rate, Kolusu has shown you how to use BI with BUILD.

2. For SIGNED also do I need to use BI with ON?


No, for SIGNED you would use FI if it's binary, or PD (for packed decimal) or ZD (for zoned decimal), etc. Again, you need to understand which data formats you're using in your records to use them properly.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

Postby ravisankarc » Fri Dec 23, 2011 6:48 pm

Thank you Frank, I will try this and come back to you. By the way what is the meaning of M11 after BI in controlcard. I have refered manuals but I couldn't find any info.

Also how I have to mention in the controlcard for SIGNED data type..

Kindly clarify

Thanks N Regards
Ravi
ravisankarc
 
Posts: 47
Joined: Thu Aug 27, 2009 2:18 am
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

Postby skolusu » Fri Dec 23, 2011 9:20 pm

ravishankarc wrote:By the way what is the meaning of M11 after BI in controlcard. I have refered manuals but I couldn't find any info.


You sure you couldn't find any info on M11? A simple search in DFSORT Application Programming Guide gives lots of explanation and examples of the usage of M11. Essentially here is a spoon feeding link

Edit Mask Patterns

ravishankarc wrote:Also how I have to mention in the controlcard for SIGNED data type..


Did you read frank's earlier post?

Frank Yaeger wrote:for SIGNED you would use FI if it's binary, or PD (for packed decimal) or ZD (for zoned decimal), etc. Again, you need to understand which data formats you're using in your records to use them properly.
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

Postby Frank Yaeger » Fri Dec 23, 2011 10:30 pm

Ravi,

If you need to use FI instead of BI, just substitute FI for BI in the control statements you were shown earlier.

M11 is a decimal value with leading zeros and no sign. M26 would be the same thing except with a sign. You need to choose the edit mask you need.

I would strongly suggest you read through "z/OS DFSORT: Getting Started".
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post