Page 1 of 2

ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Wed Dec 21, 2011 8:35 pm
by ravisankarc
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

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Wed Dec 21, 2011 8:42 pm
by BillyBoyo
Can you show us what you have so far, and some sample input data and required output? Include LRECL and RECFM of files, please.

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Wed Dec 21, 2011 9:13 pm
by ravisankarc
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.

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Wed Dec 21, 2011 11:07 pm
by Frank Yaeger
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)

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Thu Dec 22, 2011 10:35 am
by ravisankarc
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

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

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

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Thu Dec 22, 2011 12:00 pm
by ravisankarc
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

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Thu Dec 22, 2011 5:45 pm
by NicC
Please note that forums do not 'do' urgent. They do as and when a member feels like (if at all).

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Thu Dec 22, 2011 6:58 pm
by ravisankarc
Hi Nic,

Yes offcourse and sorry for that....

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

regards
Ravi

Re: ICETOOL Controlcard for Signed and Unsigned Data Types

PostPosted: Thu Dec 22, 2011 10:25 pm
by skolusu
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)
//*