Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • CICS – Function Shipping

    The following information contains guidance about parameters that are important in the definition of remote data resources that are to be accessed by function shipping. Those data resources are: Remote files Remote transient data queues Remote temporary storage queues Reference IBM: Defining remote files: A remote file is a file that resides on another region.…

  • 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. ENVIRONMENT DIVISION. CONFIGURATION SECTION. SOURCE-COMPUTER. IBM-370 WITH DEBUGGING MODE. DATA DIVISION. WORKING-STORAGE SECTION. 01 WS-VAR. 10 WS-INPUT PIC 9(04) VALUE…

  • 10 Points Instream Vs. Cataloged Procedures

    Here are basic to advanced details on JCL instream and Cataloged procedures. 1. In-stream Procedures 2. Cataloged Procedures //STEP1 EXEC PROC=RPT,ACCT=5670 //STEP1 EXEC PROC=RPT,ACCT.PSTEPWED=5670 //pstepname.name OUTPUT parameters//pstepname.ddname DD parameters Rules to Override Procedures Here are the rules to override a procedure. To nullify a DUMMY parameter on the procedure statement, code one of the following…

  • 3 Types of HINT in DB2 to Read now

    PLAN_TABLE hints This type of hint tries to enforce a particular access path for an SQL statement issued by a specific single authorization ID. It uses rows in a PLAN_TABLE instance owned by the same authorization ID to apply hints based on the values specified for the OPTHINT bind option or the CURRENT OPTIMIZATION HINT…

  • SQL Queries top eight ways to become expert

    The most popular websites on SQL you can refer for quick help. The SQL queries really good to use to your project.

  • SQL Queries 30 Days Challenge – Day 1

    I am posting 30 difficult SQL queries in 30 days. Follow me on “Srinimf” to grab these queries. Query:1 How to select employee name who does not have supervisor? Solution: SELECT ENAME,EMPNO FROM EMP WHERE ESUPER IS NULL; The above results all the employees who does not have supervisor. About NULL: NULL means no value.…

  • DB2 LOCATE Function Advanced Examples

    LOCATE SCALAR – Function returns first occurrence position in first string, second string: Example 1: SELECT LOCATE(‘I’,’MINE STRING’) FROM SYSIBM.SYDUMMY1 It returns value 2. Since first occurrence is 2. Example 2: SELECT LOCATE(‘I’,’MINE STRING’,3) FROM SYSIBM.SYDUMMY1 Now the answer will be 9. Since after third position it starts searching for ‘I’. Read my post on…

  • 3 Popular Ways to Handle DB2 VARCHAR Field in COBOL

    Handling VARCHAR in COBOL is a tricky subject. Explained to handle it in COBOL 49 level with examples in a way that a novice can understand quickly.

  • 5 ways to deal with a difficult team member

    1.Spot Signs Early Observe signs early on. ” Procrastination, blaming others and not trying for self improvement are signs of a non-cooperative team member,” says Sudhir Dhar, associate director and head — human resources and administration at Motilal Oswal Financial Services. 2.Tolerate or Counsel Them One approach is to live with the fact that you…

  • The Usage of Each PL/SQL Block

    Oracle PL SQL tutorial explained how to write a procedure in oracle or any RDBMS.

  • UNIX and Shell Scripting Programming – A to Z PPT

  • 6 Ways to Manage People in the Office

    Managing people very much needed when you are working for an office.