JCL Tutorial: JCL SORT JOINKEYS | JCL SORT JOIN TWO Files, JCL JOINKEYS Paired and Unpaired [DFSORT]

preview_player
Показать описание
#jcl #joinkeys #mainframe #topictrick

JCL Tutorial: JCL SORT JOINEKYS are used to join data from the flat files. JOINKEYS in JCL or SORT JCL can be used for various join operations such as inner join, outer join, join keys pair and joinkeys unpair. The sort joins unpaired example clearly explain the join operation of JCL SORT JONKEYS. JCL tutorial, JCL sort joinkeys, JCL sort joinkeys example, JCL sort join two files,joinkeys in sort JCL, how to use joinkeys in sort JCL,joinkeys in sort JCL tutorial, BUILD in SORT JCL,OUTFIL BUILD in SORT JCL, REFORMAT FIELDS in SORT, joinkeys in JCL, joinkeys in sort, joinkeys, joinkeys in JCL example, DFSORT JOINKEYS Sample JCL, joinkeys with multiple keys,joinkeys paired and unpaired,joinkeys paired, sort join unpaired example, topictrick, joinkeys example, DFSORT

JOINKEYS in JCL Tutorial Index.

00:00 JCL Introduction.
00:31 JCL Tutorial Agenda.
01:08 Mainframe Enterprise Applications.
01:48 What is JCL Sort utility (DFSORT)?
02:42 RDBMS JOIN Operation.
03:15 JCL SORT JOIN Operation.
03:47 JCL JOINKEYS Flow.
04:05 JCL JOINKEYS Business Case.
04:40 JCL JOINKEYS Example.
06:25 JCL JOINKEYS control card explanation.
08:06 JCL JOINKEYS demo.
08:20 Thank you.

►Subscribe to Topictrick & Don't forget to press THE BELL ICON to never miss any updates. ◄

Also, Please visit below mention the link to stay connected with Topictrick on -

► Youtube : @topictrick

Thank you for your support.
Topictrick™
Рекомендации по теме
Комментарии
Автор

Many thanks for this useful video Jessica.

amii
Автор

Thank you so much for sharing valuable information to all of us. Could you please share any videos or material about easytrieve programming language with IMS DB?

nagasowjanya
Автор

Very Useful video. Thanks for sharing. Having basic knowledge, I am able to understand it fully.. One thing I didn't get, in Build Parameter, What is 3X, 2X, 1X ?

saikatghosh
Автор

Nice basic video 👍 for joinkey ...
I have question can I use joinkey to Subtract two input file (numeric data) and write subtracted records in output file ..if yes then how ?

anuragmishra
Автор

only overview is given, detail information is not provided. I was expecting the explanation of each value use in control statement like which are value provided in REFORMAT FIELDS or BUILD, What is the role of this values gona play in data formatting in output file.

prashantkakadeMf