The DB2 interview questions and answers are intended for those with a working knowledge of DB2 as a programmer. This will help you prepare for technical DB2 interview and online selection tests during campus placement for freshers and job interviews for professionals. DB2 Interview Questions 1. What do the initials DDL and DML stand for […]
DB2 Interview Questions with Answers Read More »
COBOL or Common Business Oriented Language is an English like compiled programming language used mainly for business COBOL Interview questions with answers will help you prepare for technical interviews and online selection tests during campus placement for freshers and job interviews for professionals. COBOL Interview questions with answers 1. What is the distinction among INCLUDE
COBOL Interview Questions with Answers Read More »
PSM Practice Exam is designed to validate expertise in Scrum principles and practical application. The exam challenges candidates to demonstrate mastery of the Scrum framework through scenario-based questions. It will improve your Scrum knowledge and help you in achieving PSM Certification. This course will help participants cultivate a profound understanding of servant leadership, through which
PSM Practice Exam Practice Mode Questions Read More »
PSM Practice Exam Real Mode will help you to prepare for Scrum.org Professional Scrum Master ®( PSM ®) Certification. Tech Agilist PSM Practice Exam contains 20 sample questions to help you in evaluating your preparedness for the actual exam. These Practice Tests will evaluate your knowledge of Scrum practices, values, and responses to impediments &
PSM Practice Exam Real Mode Sample Questions Read More »
An INTERSECT operation retrieves the matching set of distinct values (not rows) from two columns. The INTERSECT ALL returns the set of matching individual rows. An INTERSECT and/or EXCEPT operation is done by matching ALL of the columns in the top and bottom result sets. In other words, these are rows, not the column, operations.
INTERSECT and EXCEPT use in SQL Queries Read More »
A UNION operation combines two sets of columns and removes duplicates. The UNION ALL expression does the same but does not remove the duplicates. When DB2 encounters the keyword, it processes each select / sub-select to form an interim result table, then it combines the interim result table and deletes duplicate rows to form a
UNION vs UNION ALL use in SQL Queries Read More »
DYNALLOC PARM: This option requests the dynamic allocation of SORTWK data sets. DYNALLOC=OFF can be specified to override a DYNALLOC=ON installation default. If DYNALLOC has been specified on the SORT control statement as well as in the PARM field, the PARM specification will take precedence. ZDPRINT PARM: This option applies to the SUM, DUPKEYS SUM, and
PARM: How to use in SORT JCL with examples Read More »
The UNSTRING statement used to separate single string to multiple based on the delimiter provided in the UNSTRING. It needs at least two destination identifier or literals. It can only separate alphabetic and alpha-numeric items. END-STRING, DELIMITED BY, TALLYING, WITH POINTER, ON OVERFLOW and NOT ON OVERFLOW clause is optional in UNSTRING usage. UNSTRING statement
UNSTRING statement use in cobol program Read More »
STRING statement strings together the partial or complete contents of two or more data items or literals into one single data item. STRING needs at least two identifiers or literals. It can only concatenate alphabetic and alpha-numeric items. It will remove multiple instances of delimiter character and consider multiple spaces as a single space. END-STRING,
STRING statement use in cobol program Read More »
COALESCE DB2 function is used to handle the NULL values that might be present in the data or a list of values that are specified. If the NOT NULL constraint on the column is not applied, then the default value that gets inserted in those columns when not specified is the NULL value. It returns the
COALESCE DB2 Function in SQL Queries Read More »
COBOL Intrinsic Functions provides many ways to manipulate data. These are a set of functions that return values from a specific algorithm on input arguments. Intrinsic Functions are available for mathematics, character manipulation, date/time and statistics, and financial work. These functions are elementary data items that will return a numeric (whole or decimal) or an
Intrinsic Functions in COBOL Programs Read More »
SQL CASE statement allows you to perform IF-THEN-ELSE functionality within an SQL statement. CASE SQL expression can help make your data more readable and useful to the user or to the application. It allows selecting one sequence of statements to execute out of many possible sequences. There are two general flavors of the expression. In
CASE statement in SQL Queries with Examples Read More »
GROUP BY clause specifies a result table that consists of a grouping of the rows of intermediate result table that is the result of the previous clause. The GROUP BY clause allows you to find the characteristics of groups of rows rather than individual rows. ORDER BY clause specifies the particular order in which you
GROUP BY and ORDER BY clause in SQL Read More »
PUSH defines the input field, sequence number, or identifier that will be overlaid for each group’s records. For fixed-length records, the first input and output data byte start at position 1. For variable-length records, the first input and output data byte start at position 5, after the RDW in positions 1-4. PUSH=(c:item,…) You can use
PUSH unique ID and SEQ number using IFTHEN Read More »
PARSE and IFTHEN PARSE are new options that allow you to extract variable position/length fields into fixed-length parsed fields defined as %nn fields. It gives you powerful new capabilities for handling variable fields such as delimited fields, comma-separated values (CSV), tab-separated values, blank-separated values, keyword-separated fields, null-terminated strings, and many other types. The PARSE parameter
PARSE fields using IFTHEN parameter Read More »
Syntax: Starting position:SEQNUM,m,f,START=j,INCR=i,RESTART=(p,m) Name Description Starting Position Specifies the position from where the sequence number starts in the o/p file. SEQNUM A keyword specifies the sequence number to be generated from the next available position of INREC. Length (m) Length of the sequence number to be generated. Format (f) Format of the sequence number to
SEQNUM: How to use in SORT JCL with examples Read More »
ICETOOL is a batch front-end utility that uses the capabilities of DFSORT toperform the operations you request. Input and output datasets can be defined using user-defined DD names. The file operations are specified in the TOOLIN DD statement. Additional conditions can be specified in user-defined ‘CTL’ DD statements. A few of the utilities of ICETOOL
ICETOOL : Matching records from different data sets Read More »
Fill Method Paired and unpaired records – This example illustrates an alternative way to create three output files; paired F1/F2 records, unpaired F1 records, and unpaired F2 records. It produces the same output as Example 5. Whereas Example 5 uses an indicator in one position to determine where the key was found, Example 6 uses
Fill Method: Paired and unpaired records Read More »
Indicator method: Paired and unpaired records – This example illustrates how you can create three output files; paired F1/F2 records, unpaired F1 records, and unpaired F2 records. In this case: F1 records which do not have a match in F2 on the specified keys (for example, key=David) will be written to the F1ONLY output file.
Indicator method: Paired and unpaired records Read More »
Unpaired records F2: This example illustrates how you can select only unpaired records from one of two files. In this case, we will select the F2 records that do not have a match in F1 on the specified keys (for example, key1=Molly and key2=2100). We will also omit certain records from each input file and
Unpaired records F2 using SORT Utility Read More »
Paired records F1 – Below example illustrates how you can select only paired records from one of two files. In this case, we will select the F1 records that have a match in F2 on the specified keys (for example, key1=Development and key2=Master). The F1 records are in comma-delimited form so we will parse them
Paired records F1 using SORT Read More »
Paired records with duplicates: This example illustrates how you can join paired records from two files, both of which have duplicate records. The result will be a cartesian join. The paired records are the records in F1 and F2 with matching keys (for example, key=Cats). Paired records with duplicates Example //SEP002 EXEC PGM=SORT //SYSOUT DD
Paired records with duplicates using SORT Read More »
Paired records without duplicates – ASA (formerly ANSI)control characters appear in Position 5 for variable-length records (just after the Record Descriptor Word (RDW)). So coding REMOVECC on the OUTFIL statement suppresses the control characters. This example illustrates how you can join paired records from two files using multiple keys. In this case, neither file has
Paired records without duplicates using SORT Read More »
JOINKEYS feature joins transactions/records from two different files based on certain keys (i.e. fields with common information). The SORTJNF1 and SORTJNF2 DD statements were used to specify these files. Each JOINKEYS statement must specify the DDNAME of the file it applies to and the starting position, length, and sequence of the keys in that file. You
JOINKEYS joining two files using SORT Read More »
STOPAFT SKIPREC are two powerful control parameters in IBM DFSORT that allow you to precisely control which records are processed during sorting, merging, or copying operations. These parameters help optimize performance by reducing the amount of data processed and enable selective record processing without requiring complex programming logic. STOPAFT and SKIPREC are optional parameters and can
STOPAFT SKIPREC condition in SORT JCL Read More »
