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 is a powerful keyword in mainframe SORT JCL utilities used to generate and insert sequential numeric values into records.…
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…
STOPAFT SKIPREC are two powerful control parameters in IBM DFSORT that allow you to precisely control which records are processed during…
INCLUDE OMIT conditions in SORT JCL (DFSORT, Syncsort) are powerful filters that decide which input records are passed on for…
PMP Certification Practice Exam – Project Management Professional (PMP Certification) is challenging & according to the Project Management Institute (PMI®),…
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…
COMBINATION based questions for PMP: These will combine any of the types mentioned above. There is no guessing what kind you’ll…
Professional Social Responsibility - PMP Professional Social Responsibility based questions in PMP expect you to follow a certain code of…
ITTO based questions for PMP: The PMBOK® Guide describes 47 processes, where each process has Inputs, Tools, Techniques & Outputs.…