Posted: Fri Apr 14, 2006 6:46 am Post subject: How to assign values to BI,ZD and PD fields using SORT?
Hai All,
I am creating an input dataset with multiple records for a SORT operation and i want to assign
Code:
1.value 2600 to fields 170 - 173 and the field is BI.
2.value 32 to fields 18 - 21 and the field is ZD.
3.value 22530 to fields 22 - 27 and the field is PD.
4.value negative4278 to fields 28 - 33 and the field is PD.
How can i achive that as i want to perfrom SUM operation on those fields and i want to set up my input dataset ? _________________ Shekar
Grow Technically
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri Apr 14, 2006 10:44 am Post subject:
It's not clear if you already have the input records and want to overlay these values on them, or if you want to create the records from scratch. Assuming the former, you can use this DFSORT job:
If you actually want to create the records, please give more details about what exactly you're trying to do and where SUM fits in all this. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
I actually want to create records from the scratch to work on some sample examples with DFSORT.I am refering to the PDF ICE1CG10
Title: z/OS V1R6.0 DFSORT: Getting Started
Document Number: SC26-7527-01
And i am creating the sample datasets
Sample Data Set - SORT.SAMPIN
Sample Data Set - SORT.SAMPADD
Sample Data Set - SORT.BRANCH _________________ Shekar
Grow Technically
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri Apr 14, 2006 12:13 pm Post subject:
Oh, why didn't you says so. You don't need to set up a job to create those data sets. We've already provided a job that sets up those data sets.
See Appendix A of "z/OS DFSORT: Getting Started". It shows you how to execute PGM=ICESAMP to create those data sets. ICESAMP is shipped with DFSORT, so you should be able to use it.
Thanks a lot for your help Frank , it was simple to create the sample datsets with data in it and can now work and learn DFSORT and ICETOOL.
I was unable to understand that ICESAMP is shipped with DFSORT and the job is so easy. _________________ Shekar
Grow Technically
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri Apr 14, 2006 1:11 pm Post subject:
Quote:
I was unable to understand that ICESAMP is shipped with DFSORT and the job is so easy.
Hmmm ... I thought Appendix A was pretty clear about how to use the job shown there. Not sure why you weren't able to understant that. Did you read through Appendix A before you started this thread or did you miss it? If you did read through Appendix A, what made you think you couldn't run the job shown there? Can you suggest anything I can add to Appendix A to make that clearer? _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Thanks for making me clear in my understanding and it is mistake from my end that i did not go well through the Appendix A.Actually i was unaware of the program PGM=ICESAMP,PARM=(BOOKS) to what actually it is as i had never come across ICESAMP and i did not give a second thought but after your reply i was able to understand.
A suggestion:
A brief description of ICESAMP would be more clear as to what it is actually and how it is related to DFSORT.
I am just a begineer in learning and my apologies if my suggestion is not proper. _________________ Shekar
Grow Technically
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri Apr 14, 2006 2:36 pm Post subject:
Quote:
A suggestion:
A brief description of ICESAMP would be more clear as to what it is actually and how it is related to DFSORT.
I am just a begineer in learning and my apologies if my suggestion is not proper.
Ok, I can add something like that. Your suggestion is perfectly proper ... that's exactly what I asked you for.
After 35+ years at IBM, it's can be a bit difficult for me to see through the eyes of a beginner when I'm writing content for the DFSORT books, so it helps to have suggestions from beginners.
Thanks. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum