A UNION operation combines two sets of columns and removes duplicates. The UNION ALL expression does the same but does…
DYNALLOC PARM: This option requests the dynamic allocation of SORTWK data sets. DYNALLOC=OFF can be specified to override a DYNALLOC=ON…
UNSTRING statement The UNSTRING statement used to separate single string to multiple based on the delimiter provided in the UNSTRING.…
STRING statement STRING statement strings together the partial or complete contents of two or more data items or literals into…
COALESCE DB2 function is used to handle the NULL values that might be present in the data or a list…
Intrinsic Functions COBOL Intrinsic Functions provides many ways to manipulate data. These are a set of functions that return values…
SQL CASE statement allows you to perform IF-THEN-ELSE functionality within an SQL statement. CASE SQL expression can help make your…
GROUP BY clause specifies a result table that consists of a grouping of the rows of intermediate result table that…
PUSH defines the input field, sequence number, or identifier that will be overlaid for each group’s records. For fixed-length records,…
PARSE and IFTHEN PARSE are new options that allow you to extract variable position/length fields into fixed-length parsed fields defined…
SEQNUM creates & inserts sequence numbers in the output record. The sequence numbers are assigned in the order in which…
ICETOOL is a batch front-end utility that uses the capabilities of DFSORT toperform the operations you request. Input and output…
Fill Method Paired and unpaired records - This example illustrates an alternative way to create three output files; paired F1/F2…
Indicator method: Paired and unpaired records - This example illustrates how you can create three output files; paired F1/F2 records,…
Unpaired records F2: This example illustrates how you can select only unpaired records from one of two files. In this…
Paired records F1 - Below example illustrates how you can select only paired records from one of two files. In…
Paired records with duplicates: This example illustrates how you can join paired records from two files, both of which have…
Paired records without duplicates - ASA (formerly ANSI)control characters appear in Position 5 for variable-length records (just after the Record…
JOINKEYS feature joins transactions/records from two different files based on certain keys (i.e. fields with common information). The SORTJNF1 and…
In SORT JCL, the STOPAFT SKIPREC are two conditions that control the processing of input records. You can use the…
You can use the INCLUDE OMIT statement in conjunction with other options to select/omit the number of records to be…
Preparing for the Project Management Professional (PMP Certification) is challenging & according to the Project Management Institute (PMI®), project professionals spend on…
PMP Certification Practice Exam - Project Management Professional (PMP Certification) is challenging & according to the Project Management Institute (PMI®), project professionals…
ITIL Foundation Practice Exam is the entry level certification, providing general awareness of the key elements, terminology and concepts of…
ITIL Foundation Certification is the entry level certification of the ITIL® qualification. It aims at certifying that the holder of…