Tech.Jobs.Biz.Success

Technology blog,Readers across the world. It contains articles on mainframe,cloud,Analytics,mobile.

Already a Member? Log In to Your Account
Technology blog,Readers across the world. It contains articles on mainframe,cloud,Analytics,mobile.
URL: http://srinimf.com
Added: January 26, 2011
Authority: 28.9743
Type: Website
Language: English
  Analytics :: more
   Latest Posts :: more

Mainframe – SQL Challenge -1

Question 1: Get maximum salaries department wise? Sol: SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY DeptID Question 2: Write COBOL logic to get nth prime number? IDENTIFICATION DIVISION. PROGRAM-ID. PRIME. AUTHOR. XYZ. DATE-WRITTEN. JULY 2014.

10 Points – Instream and Cataloged Procedures of JCL

There are many rules to modify a Instream or Cataloged procedures: I have given here important rules. In-stream Procedures : Do not place any JCL statements (other than the ones listed in this topic) or any JES2 or JES3 control statements in the proc

3 Different Types of HINT in DB2

PLAN_TABLE hints This type of hint to tries to enforce a particular access path for an SQL statement that is issued by a specific single authorization ID. It uses rows in a PLAN_TABLE instance that owned by the same authorization ID to apply hints ba



  Related Blogs
Language: English
Language: English
© 2006-2014 OnToplist.com, All Rights Reserved