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.
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
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