hi team I have a question take an example i have a file in that file i have 10 records of the employees with their levels now I need to copy the file into a new file and in the new file
Another thing to note is that Sort=Copy requires no Sortwrks at all as the input file is read and nothing is actually sorted. You need to realize how a normal Sort actually works. ALL input records are completely read into the Sorkwrks before any sorting takes place whether it is a CObOL or JCL sort. Therefore the Sortwrks will be slightly larger in total space as compared to the input files (as multiple inputs can be concatenated together) as the data does need some space to be manipulated. Super large sorts (10s of millions of records) are done through sorted intermediary datasets. The Sortwrks are filled and sorted and written out time after time until all records are sorted. Then the system reads in all the sorted datasets and Merges them into one large output file. When you use Sort=Copy there is no actual sorting being done (just copying) so no Sortwrks are ever required. Only when Sort Fields are specefied are Sortwrks tequired. That being said we stopped using TRK and CYL Space allocations over 20 years ago. No one should ever use those notations in JCL as you have no idea what type of device you are writing to very well the track or cylinder size of that device. New space allocations should always be requested based on the RECFM, LRECL .and the amount of records projected for the file. The system will calculate the actual space required based on the device iwhere it actually writes the data That also being said most people have no idea how to write good efficient JCL as they have no idea how the underlying systems and devices really work. Most large shops bring in third party software (at least they did 15 years ago) that monitors JES and catches your JCL before it actually runs and modifies the crap out of it. It changes all kinds of things to make it more efficient, free up resources, points to dynamic resources anbd pools, overrides tape to disk. I use to write Production JCL as we did not allow programmers to do it as most did not know enough. We also had thir party JCL scanners that did not just look for Syntax errors like Typrun=Scan but did indepth analysis of the JCL telling you how to make it efficient and enforce hundreds of in house JCL standards. The vast majority of sorts are small enough to just do in foreground anyways and bypass the entire JCL process. No waiting for a Job to run but you still need to know how to write the parms. If you want you can even use the input file as the output file as the Sort will Open and Close the input file before it ever processes the output file. I did that thousands of times and never had a problem.
If i want to print count only in the output file as total no. of records in input file ? trailer formate 'UTRL 00001212022' how can I omit 'UTRL' and '2022' ? I want to print only total no. Of count Could you please guide me.
One way is to use icetool with toolin card SUBSET FROM(INFILE) TO(OUTFILE) KEEP INPUT LAST(10). But again this includes your trailer.so my guess is to remove the trailer by using omit and then pass file to icetool
Hi Nilesh, thank you! for dropping a message. Sorry it's been a long time I have worked on Assembler, but I will try to make few Videos on it. If you are looking for specific topic , do reply on this.
@@KumarITChannel I was looking for full tutorial like you have created for COBOL and PL/1. If u can share some link or study material from where I can start ...that will be great help
Very clean video, explanation is very good and neat .thank you so much sir...
amazing video, please keep uploading more like these, and other complex programs.
Very good quality and informative content! (Y)
Good information for freshers and helps experienced to refresh
Awesome 👏
Nice practical teaching bro. Very much useful to me. Thank you so much 🙏😎
Very good refreshing video
Thanks for the video.. very helpful..
Thank you soooooo Much Sir , im a fresher this video is very much useful to me , God bless you sir !!!
Very good video explaining SORT
Thank you Kumar!
My pleasure
In the same way ,with Practical examples... If you do for CICS it will be helpful
So helpful video to recap.
Could you please prepare a video about - How to Solve SOC4 & SOC7 abends with Mainframe Terminal please ?
Thank you for the detailed explanation!
Thanks! do you have also tutorials about using headers and trailers in JCL Sort utility?
Tq so much sir....u have given clear cut on sort cards
AMAZING video Thanks very much
hi team I have a question take an example i have a file in that file i have 10 records of the employees with their levels now I need to copy the file into a new file and in the new file
Revision was the best part..
Another thing to note is that Sort=Copy requires no Sortwrks at all as the input file is read and nothing is actually sorted.
You need to realize how a normal Sort actually works. ALL input records are completely read into the Sorkwrks before any sorting takes place whether it is a CObOL or JCL sort. Therefore the Sortwrks will be slightly larger in total space as compared to the input files (as multiple inputs can be concatenated together) as the data does need some space to be manipulated.
Super large sorts (10s of millions of records) are done through sorted intermediary datasets. The Sortwrks are filled and sorted and written out time after time until all records are sorted. Then the system reads in all the sorted datasets and Merges them into one large output file.
When you use Sort=Copy there is no actual sorting being done (just copying) so no Sortwrks are ever required. Only when Sort Fields are specefied are Sortwrks tequired.
That being said we stopped using TRK and CYL Space allocations over 20 years ago. No one should ever use those notations in JCL as you have no idea what type of device you are writing to very well the track or cylinder size of that device. New space allocations should always be requested based on the RECFM, LRECL .and the amount of records projected for the file. The system will calculate the actual space required based on the device iwhere it actually writes the data
That also being said most people have no idea how to write good efficient JCL as they have no idea how the underlying systems and devices really work. Most large shops bring in third party software (at least they did 15 years ago) that monitors JES and catches your JCL before it actually runs and modifies the crap out of it. It changes all kinds of things to make it more efficient, free up resources, points to dynamic resources anbd pools, overrides tape to disk. I use to write Production JCL as we did not allow programmers to do it as most did not know enough. We also had thir party JCL scanners that did not just look for Syntax errors like Typrun=Scan but did indepth analysis of the JCL telling you how to make it efficient and enforce hundreds of in house JCL standards.
The vast majority of sorts are small enough to just do in foreground anyways and bypass the entire JCL process. No waiting for a Job to run but you still need to know how to write the parms. If you want you can even use the input file as the output file as the Sort will Open and Close the input file before it ever processes the output file. I did that thousands of times and never had a problem.
Thank you, sir!
How to format first name to last name
Which condition we have to use
Thanks for your session, Can you please explain sort function in cobol code on vsam files
Voice 👌
We want information about varsion control tool..that will be help for we can you make it?
If i want to print count only in the output file as total no. of records in input file ? trailer formate 'UTRL 00001212022' how can I omit 'UTRL' and '2022' ? I want to print only total no. Of count Could you please guide me.
I want to copy onlylast 10 records of input file. How can I.
Usually files will have header and trailer records, can I sort excluding them
One way is to use icetool with toolin card SUBSET FROM(INFILE) TO(OUTFILE) KEEP INPUT LAST(10). But again this includes your trailer.so my guess is to remove the trailer by using omit and then pass file to icetool
Very helpful video expecting same for cobol and db2
ruclips.net/video/QpH73a1XH_8/видео.html
ruclips.net/video/38pNOuGiSmw/видео.html
Can you make a video for overiding a step from proc in jcl.
Please do watch out my JCL Playlist. thank you!
How to sort comp-3 values
Followed same but getting errors
Super
can we write a sort card to write current date in new file?
Yes you can. Try with DATE
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(5:&DATE1,13:&TIME2)
Thanks for sharing your knowledge! I just didn't understand whats SORTWK01 for !
Sir can you put programs regarding DB2 concept
Sure.
Wow
Thank you
Expecting sort Join keys class 😊
Sure.
Sir can you please make vedioes on assembler.
Hi Nilesh, thank you! for dropping a message. Sorry it's been a long time I have worked on Assembler, but I will try to make few Videos on it. If you are looking for specific topic , do reply on this.
@@KumarITChannel I was looking for full tutorial like you have created for COBOL and PL/1. If u can share some link or study material from where I can start ...that will be great help
@@NileshChaubey
Check the below
bcs.solano.edu/workarea/kanderso/CIS%2020/Tutorials/David%20Woolbright's%20Assembly%20Tutorial.pdf
@@KumarITChannel Thanks a lot...I will check this document
Watch it in 3x speed
Any one have Percentage calculation used by SORT
Ugh. Please change your video title to su kects unde Z/OS ONLY!
This will not work under Z/VSE
Super