Mainframe

VSAM PRINT using IDCAMS with Examples

VSAM PRINT command is used to print the contents of VSAM or non-VSAM datasets. Contents can be printed in various…

4 years ago

VSAM REPRO using IDCAMS with Examples

VSAM REPRO command is used to copy data from one file(Input file) to another file(Output file). Input & Output files…

4 years ago

VSAM Alternate Index using IDCAMS with Examples

VSAM Alternate index is the additional index that is created for KSDS/ESDS datasets (but not RRDS or extended ESDS) in…

4 years ago

VSAM DEFINE CLUSTER using IDCAMS with Examples

VSAM DEFINE CLUSTER is used to define attributes for the cluster as a whole or for the components like data…

4 years ago

SQL Subqueries with IN or NOT IN operator

SQL Subqueries with IN or NOT IN check is similar to the ANY and SOME checks. Use the IN clause for multiple-record,…

4 years ago

SQL subqueries with operations & examples

SQL Subqueries are also called inner queries or inner select or a nested queries. The statement containing the subquery is…

4 years ago

SQL Subqueries with ANY or ALL operator

Comparison operators (=, >, < , etc.) are used only on subqueries that return one row. SQL Subqueries with ANY and ALL operators, you can…

4 years ago

OUTER JOIN – step by step walkthrough with examples

The JOIN operation allows you to combine rows from two or more tables based on a related column. OUTER JOIN…

4 years ago

INNER JOIN – step by step walkthrough with examples

There are four basic types of JOINS – Inner, Outer (left, right, full), Self and Cross join. An inner join…

4 years ago

CAST expression to convert data type – SQL

CAST expression is used to convert one data type to another. It is similar to the various field-type functions (e.g.…

4 years ago