Srini

Mainframe: How to Read a Tape File

Tape files in mainframe are not readable. So this sample JCL you can use to copy to DASD file and you can read.

Sample SQL Query: How to Define Identity-Column

Here are ideas on how to identity-column on a table. Identity column on a new table An identity column provides a way for DB2 to automatically generate a unique numeric value for each row that is added to the table. When creating a table where you know that you need to uniquely identify each row…

How to Write SQL Queries Efficiently in DB2

Many times the three tables could all be coded with inner joins, which would run more efficiently. Outer joins are not inefficient, but if they bring in extra exception rows, and a subsequent inner join then gets rid of those extra rows, was processing not needed. SQL Join Query Ideas to Write Efficiently Also, make…