Page 1 of 2

ICETOOL step that generates a Signal file

PostPosted: Tue Feb 26, 2013 12:53 pm
by sharmila_3
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

Re: icetool

PostPosted: Tue Feb 26, 2013 12:56 pm
by sharmila_3
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

Re: ICETOOL step that generates a Signal file

PostPosted: Tue Feb 26, 2013 1:40 pm
by dick scherrer
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?

Re: ICETOOL step that generates a Signal file

PostPosted: Tue Feb 26, 2013 2:13 pm
by sharmila_3
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.

Re: ICETOOL step that generates a Signal file

PostPosted: Tue Feb 26, 2013 3:35 pm
by BillyBoyo
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.

Re: ICETOOL step that generates a Signal file

PostPosted: Tue Feb 26, 2013 4:04 pm
by sharmila_3
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.

Re: ICETOOL step that generates a Signal file

PostPosted: Tue Feb 26, 2013 4:12 pm
by BillyBoyo
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.

Re: ICETOOL step that generates a Signal file

PostPosted: Tue Feb 26, 2013 5:11 pm
by enrico-sorichetti
.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:

Re: ICETOOL step that generates a Signal file

PostPosted: Tue Feb 26, 2013 5:39 pm
by sharmila_3
To Mr.BillyBoyo,
Ya thank you ....i will try that and let you know.

Re: ICETOOL step that generates a Signal file

PostPosted: Wed Feb 27, 2013 6:16 am
by NicC
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.