DFSORT Complex Interview Questions

DFSORT Complex Questions
DFSORT Complex Questions

Srinimf.com has all the answers for the below complex DFSORT questions. The following are the list of keywords where you can expect questions on DFSORT. When your JCL interview starts, surely they might ask at least one question on DFSORT.

JOINS in SORT –How to use this feature

Control Statements:

INCLUDE – selects records to be kept based on logical criteria.

OMIT – selects records to be deleted based on logical criteria.

SUM – produces a single record for each unique sort or merge key with optional field totals.

INREC and OUTREC – specifies reformatting, find and replace operations, group operations, parsing, justifying, squeezing, past, current and future timestamps, translation, date editing, date conversion, date field arithmetic,numeric editing, numeric conversion, substitution, arithmetic operations, hexadecimal display, bit display and sequence numbers. Can build records item by item, only overlay specific parts of records, or reformat different records in different ways by specifying how items are to be applied to records that meet given criteria.

OPTION – overrides installation defaults and supplies optional information such as the number of records to skip before sorting.

OUTFIL – specifies multiple output data sets, subsets, sampling, repetition, reports, reformatting, find and replace operations, group operations, parsing, justifying, squeezing, past, current and future timestamps, translation,date editing, date conversion, date field arithmetic, numeric editing, numeric conversion, substitution,arithmetic operations, hexadecimal display, bit display, sequence numbers, VB to FB and FB to VB conversion,and more. Can build records item by item, only overlay specific parts of records, or reformat different records in different ways by specifying how items are to be applied to records that meet given criteria. Can update counts and totals in existing trailer records.

Reformatting Data sets: Reformatting: FINDREP, BUILD, OVERLAY and IFTHEN

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.