ICETOOL step that generates a Signal file



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

ICETOOL step that generates a Signal file

Postby sharmila_3 » Tue Feb 26, 2013 12:53 pm

Hi ,
develop a JCL with one ICETOOL step that generates a Signal file for the file passed as input to it.

Sample Signal File:
CV_FLNAME = recovery_init.dat               - File Name
CV_DIR=/prod/etc/home                        - Directory Path
CV_RECCNT=0000000089        - No. of records in input file
CV_HASHTOT=000000001456     - Sum of last four digit of account number
CV_TIME=<Current Date><Current Timestamp>


Code'd
sharmila_3
 
Posts: 11
Joined: Tue Feb 26, 2013 12:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: icetool

Postby sharmila_3 » Tue Feb 26, 2013 12:56 pm

And this is my input file
Account Number,Category,Transaction Date,User ID,Amount
1234567890,PAY,2/19/2013,UWOB745, 100
1234567891,PRN,2/20/2013,UWOB745,-100
1234567892,OPY,3/01/2013,UWOB745, 300
1234567893,BKP,2/22/2013,UWOB745,-500
1234567894,PAY,2/21/2013,UWOB745,-700
1234567895,PRN,2/24/2013,UWOB745, 900
1234567896,OPY,2/25/2013,UWOB745,-1100


Code'd
sharmila_3
 
Posts: 11
Joined: Tue Feb 26, 2013 12:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL step that generates a Signal file

Postby dick scherrer » Tue Feb 26, 2013 1:40 pm

Hello and welcome to the forum,

Please clarify what you are trying to do - i do not understand from the info posted.

Explain the "rules" for processing. Mention the recfm and lrecl of the files.

Why is icetool mentioned specifically?
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 step that generates a Signal file

Postby sharmila_3 » Tue Feb 26, 2013 2:13 pm

Thanks for your reply,
That was the task given to me.when i mention the name of the input file in ''IN DD DSN=..", the output should should contain the name of the file ,its location ,no. of records in it, sum of the last 4 digit of acc number, and the timestamp.recfm is fb and lrecl is 80.They want me to do this in icetool specifically.
sharmila_3
 
Posts: 11
Joined: Tue Feb 26, 2013 12:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL step that generates a Signal file

Postby BillyBoyo » Tue Feb 26, 2013 3:35 pm

In general you can't easily "get at" the "name"/"location" information from a DD statement.

IF you use "parameter substitution" for the name/location, you could also use that, with the same parameters, for JPn parameters which would be available to... ICETOOL?

Yes, it can take them, but I'm not sure that there is a particular need to use ICETOOL for this.

If you have no option but to blindly follow orders, then ICETOOL's COPY function with USING(ctln). The the ctlnCNTL file, you'd put all the "SORT" statements to do the task in SORT, but it would be an ICETOOL job.

//S1 EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN   DD   *
  OPTION COPY
/*


Can you run the above step and post the sysout, please? This will tell us what "level" your installed product is at, which may affect the solutions proposed.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: ICETOOL step that generates a Signal file

Postby sharmila_3 » Tue Feb 26, 2013 4:04 pm

sorry i don't have mainframe id now...They just want me to tell the control card for this.But i culdn't do that even after searching in google.
sharmila_3
 
Posts: 11
Joined: Tue Feb 26, 2013 12:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL step that generates a Signal file

Postby BillyBoyo » Tue Feb 26, 2013 4:12 pm

Well, how about looking at the manuals for DFSORT then.

Look at the OUTFIL reporting functions. You should be able to get count of the records, total of a particular field, date and time (although what the date/time might mean is anyone's guess).

To get the DSN and PATH, they are going to have to be supplied as symbolic parameters, which is perhaps not what the dicator-of-the-solution wants, but tough.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: ICETOOL step that generates a Signal file

Postby enrico-sorichetti » Tue Feb 26, 2013 5:11 pm

.They want me to do this in icetool specifically.

what if the supposed icetool solution is not the most appropriate one

replying on a forum is on voluntary base ...
if, when, how, we feel like

and the replies you will get will be to the best of OUR judgement and experience

if You need a particular solution You might be better off by hiring a paid consultant
who will for the proper fee provide any solution You ask for :evil:
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 165 times

Re: ICETOOL step that generates a Signal file

Postby sharmila_3 » Tue Feb 26, 2013 5:39 pm

To Mr.BillyBoyo,
Ya thank you ....i will try that and let you know.
sharmila_3
 
Posts: 11
Joined: Tue Feb 26, 2013 12:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL step that generates a Signal file

Postby NicC » Wed Feb 27, 2013 6:16 am

Well, I do not see any correlation between your input, output and your stated aims. You have a "signal" file with whatever data in it and an output csv file which seems to have none of your input in it.

Also, if you know this is a DFSort/Icetool topic, why post in the JCL forum when there is a perfectly good part of the forum for DFSort and Icetool? Topic being moved.
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

Next

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post