JCL - SORT CARDS - Practical Video - Mainframe Wednesday Talks # 6

[@ntrtarak1036]

Very clean video, explanation is very good and neat .thank you so much sir...

[@vishnunarayananvs3962]

Very good quality and informative content! (Y)

[@yasaswideepthi6153]

Thanks for the video.. very helpful..

[@kartheekc1534]

Awesome 👏

[@anandgupta3237]

amazing video, please keep uploading more like these, and other complex programs.

[@vmnajay]

Good information for freshers and helps experienced to refresh

[@ronilkumarisahoo4879]

Very good refreshing video

[@pallvithakur3107]

AMAZING video Thanks very much

[@richardsonarun]

Nice practical teaching bro. Very much useful to me. Thank you so much 🙏😎

[@mannesandhya3015]

Tq so much sir....u have given clear cut on sort cards

[@rajamahendra8117]

So helpful video to recap.

[@amarbinabdul4652]

Thank you soooooo Much Sir , im a fresher this video is very much useful to me , God bless you sir !!!

[@higiniofuentes2551]

Very good video explaining SORT Thank you Kumar!

[@KumarITChannel]

My pleasure

[@PiyanshuMyWorld]

Revision was the best part..

[@venud1800]

In the same way ,with Practical examples... If you do for CICS it will be helpful

[@igalshikhman1261]

Thank you, sir!

[@chandun7018]

Could you please prepare a video about - How to Solve SOC4 & SOC7 abends with Mainframe Terminal please ? Thank you for the detailed explanation!

[@Dosala-Vijaya]

Voice 👌

[@SatishKumar-bx5mg]

Thanks for your session, Can you please explain sort function in cobol code on vsam files

[@SagarParte95]

Very helpful video expecting same for cobol and db2

[@KumarITChannel]

kzbin.info/www/bejne/h6GraGaXZr17lZo kzbin.info/www/bejne/aWnTf4KrfM6Go9k

[@jaycahow4667]

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.

[@mistersz]

Thanks! do you have also tutorials about using headers and trailers in JCL Sort utility?

[@chaithanyareddy4568]

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

[@Rafilkis]

Thanks for sharing your knowledge! I just didn't understand whats SORTWK01 for !

[@krishna_is_great]

Super

[@ravigangapure8509]

We want information about varsion control tool..that will be help for we can you make it?

[@seemakashyap3471]

How to format first name to last name Which condition we have to use

[@DurgaPrasad-oe7he]

Thank you

[@sakshitripathi3179]

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.

[@rajamahendra8117]

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

[@prashanthv197]

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

[@vidhisfoodfuntour_channel2729]

Can you make a video for overiding a step from proc in jcl.

[@KumarITChannel]

Please do watch out my JCL Playlist. thank you!

[@athirapaaru5848]

Expecting sort Join keys class 😊

[@KumarITChannel]

Sure.

[@krishnaraddihosamani8392]

Wow

[@mounikareddy3478]

How to sort comp-3 values

[@monisharaji5686]

Sir can you put programs regarding DB2 concept

[@KumarITChannel]

Sure.

[@PavanKumar-sq9xj]

Followed same but getting errors

[@nehavijayvargia1800]

can we write a sort card to write current date in new file?

[@KumarITChannel]

Yes you can. Try with DATE //SYSIN DD * SORT FIELDS=COPY OUTREC FIELDS=(5:&DATE1,13:&TIME2)

[@NileshChaubey]

Sir can you please make vedioes on assembler.

[@KumarITChannel]

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.

[@NileshChaubey]

@@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

[@KumarITChannel]

@@NileshChaubey Check the below bcs.solano.edu/workarea/kanderso/CIS%2020/Tutorials/David%20Woolbright's%20Assembly%20Tutorial.pdf

[@NileshChaubey]

@@KumarITChannel Thanks a lot...I will check this document

[@ashokmetha3373]

Watch it in 3x speed

[@ganeshmuthulingam1332]

Any one have Percentage calculation used by SORT

[@rty1955]

Ugh. Please change your video title to su kects unde Z/OS ONLY! This will not work under Z/VSE

[@saikumarb9382]

Super