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

ICETOOL Controlcard for Signed and Unsigned Data Types

Postby ravisankarc » Wed Dec 21, 2011 8:35 pm

Hi Team,

In my input certain columns have data types character, signed and unsigned. I am able to pick the columns which are of data type character and placing in output file with ICETOOL controlcard.

But I am not able to write ICETOOL Controlcard for Signed and Unsigned Data Types.

Could somebody help me in the same.

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 BillyBoyo » Wed Dec 21, 2011 8:42 pm

Can you show us what you have so far, and some sample input data and required output? Include LRECL and RECFM of files, please.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

Postby ravisankarc » Wed Dec 21, 2011 9:13 pm

Here is the data :

Input dataset DCB=VB,4096,27998
Output dataset DCB=FB,80,800

Input dataset sample record :

.µ..V ..6P11.ëS%...¤....SYSF00...t

Desired output :

SYSF00 54096

The SYSF00 is a character type field and i am able to fetch it. It starts in 25th position in input and length is 6

...t is a UNSIGNED type filed and i am not able to fetch it. It starts in 31st position in input and length is 4

Though the length of UNSIGNED data type field is 4 in output it should come more than that.
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 Frank Yaeger » Wed Dec 21, 2011 11:07 pm

You have to understand the DFSORT data types before you can select the appropriate length and format (e.g. BI, FI, PD, ZD, UFF, SFF, etc) for your fields. For complete details on the DFSORT data types, see:

http://publibz.boulder.ibm.com/cgi-bin/ ... 0608113434

"UNSIGNED" might mean BI, but it might mean something else. If it does mean BI, then you could use an ON field like this for DFSORT's ICETOOL:

ON(31,4,BI)
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 » Thu Dec 22, 2011 10:35 am

Hi Frank,

1. I am not able to view the link : http://publibz.boulder.ibm.com/cgi-bin/ ... 0608113434

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

3. I tried with many options but could not able to write control card. Could you please help me.

My Copy Statement :

COPY FROM(IN) TO(OUT) USING(CPY1)

My CPY1 Control Statement :

INCLUDE COND=(9,2,CH,EQ,C'SG')
OUTFIL VTOF,BUILD=(29,6,80:X)

With the above statements I am able to print SYSF00 in output.

I am not sure how to use ON(31,4,BI) in these statements.

May I request you to help me in writing the correct control card.

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 dick scherrer » Thu Dec 22, 2011 11:50 am

Hello,

1. I am not able to view the link : http://publibz.boulder.ibm.com/cgi-bin/ ... 0608113434

You need to directly click on the link Frank provided. What you have posted is not the link Frank posted.

If you directly clicked the posted link (not a copy/paste of a link), what happened?

Until you are able to understand the data formats, there is no reason to submit job after job just hoping.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

Postby ravisankarc » Thu Dec 22, 2011 12:00 pm

Thank you Dick Scherrer. I was trying to do a copy paste. When I clicked on the link directly then it is opening. I will go thru the material. However, in order to meet my urgent requirement I need help in writing the controlcard.

Mean time I will read this manual and try with the options

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 NicC » Thu Dec 22, 2011 5:45 pm

Please note that forums do not 'do' urgent. They do as and when a member feels like (if at all).
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

Postby ravisankarc » Thu Dec 22, 2011 6:58 pm

Hi Nic,

Yes offcourse and sorry for that....

But I still need someone's help in writing this controlcard

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 » Thu Dec 22, 2011 10:25 pm

ravishankarc,

Use the following DFSORT control cards. I put a space (X) between the 2 values you picking. If you don't need it then remove the X after 29,6 on your build statement.
//CPY1CNTL  DD *
  INCLUDE COND=(9,2,CH,EQ,C'SG')
  OUTFIL VTOF,BUILD=(29,6,X,35,4,BI,M11,LENGTH=8,80:X)
//*
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

Next

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post