Srinimf

  • SQL: What Is An Index

    SQL why you need Index and its complete tutorial Read More ⇢

    SQL: What Is An Index

  • IMS DB – User (System) Abend Codes

    In the IMS database, you will get errors(abends). This complete list provides you the reason for abend(error) and resolution. Read More ⇢

    IMS DB – User (System) Abend Codes

  • Srinimf.Jobthread | India,USA,World IT Jobs

    http://srinimf.jobthread.com Read More ⇢

  • COMMIT Vs ROLLBACK top differences to manage data

    COMMIT and ROLLBACK are two popular statement in SQL. What is COMMIT and ROLLBACK explained in a way that any layman can understand the concepts and apply to their projects. Read More ⇢

    COMMIT Vs ROLLBACK top differences to manage data

  • SQL NULLs Complete Tutorial

    NULL BASICS: An arithmetic operation involving a NULL returns NULL. For example, NULL minus NULL yields NULL, not zero. A boolean comparison between two values involving a NULL returns neither true nor false, but unknown in SQL’s three-valued logic. For example, neither NULL equals NULL nor NULL not-equals NULL is… Read More ⇢

  • 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… Read 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. ENVIRONMENT DIVISION. CONFIGURATION SECTION. SOURCE-COMPUTER. IBM-370 WITH DEBUGGING MODE. DATA DIVISION. WORKING-STORAGE SECTION. 01 WS-VAR.… Read More ⇢

  • 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,… Read More ⇢

    10 Points Instream Vs. Cataloged Procedures

  • 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… Read More ⇢

    3 Types of HINT in DB2 to Read now