Srinimf

  • DB2 Columnar Functions- CAST and DECIMAL

    CAST can be used to change the data type of an expression to a different data type or the same data type with a different length, precision, or scale. SELECT EMPNO, CAST(SALARY AS INTEGER) FROM   Samples.EMP; The specified data type if DB2 not supported, DB2 will through an error. Columnar Functions:… Read More ⇢

  • Passing Data From JCL to COBOL

    Here is the logic to pass data from JCL to COBOL. It helps you to use this code in your projects. Read More ⇢

    Passing Data From JCL to COBOL

  • DB2 SQL – Select, Insert, Delete and Update

    Here are the best examples to write SQL queries for SELECT, INSERT, DELETE and UPDATE. Read More ⇢

    DB2 SQL – Select, Insert, Delete and Update

  • How to Tune SQL Query 5 Ideas

    The Merge statement and Select FROM statement improves performance read more. Read More ⇢

    How to Tune SQL Query 5 Ideas

  • DB2: Zero Matching Rows Then Which Value Function Returns

    DB2 Aggregate functions also called Column functions. Example: SELECT MAX(VALUE_1) FROM SAMPLES.TABLE_1; Rules: All aggregate functions, we need to use only in SELECT statement If no row found, we will not get +100 sqlcode, instead we will get NULL value The return value from all Aggregate functions can be NULL,… Read More ⇢

  • DB2- Avoid Select Column Before do UPDATE

    We do not have to retrieve data first and manipulate it before executing the SQL UPDATE. Avoiding that work requires an extra call to DB2. Below example dynamically retrieve a row, and update the Column value. suppose an employee is to be given a 10% raise. You could select the employee’s salary,… Read More ⇢

  • DB2 Creating Index: 6 Thumb Rules

    Indexes speed-up the performance in database. Here are best practices to keep in mind while creating an index in DB2. Best Practices to Create Index From DB2 V9 onwards, we can create Index on expression. By creating expression as alias, and we can create index on alias. Related posts Read More ⇢

    DB2 Creating Index: 6 Thumb Rules

  • CICS – Pseudo Conversational Program

    CICS- is also called Customer information control system. The term pseudo conversation program refers effective utilization of resources, and the conversation terminates itself. Traditional program has both presentation logic and business logic in single program. Where as in modular design presentation logic is separated from business logic. CICS- is following pseudo conversational… Read More ⇢

    CICS – Pseudo Conversational Program

  • COBOL VSAM Files READ with START Logic

    Here’s COBOL sample program that explains that reading of VSAM files. Read More ⇢

    COBOL VSAM Files READ with START Logic