Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • DB2 SQL – Select, Insert, Delete and Update

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

  • How to Tune SQL Query 5 Ideas

    The Merge statement and Select FROM statement improves performance read more.

  • 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, but for COUNT and COUNT_BIG…

  • 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, add 10% to the value,…

  • 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

  • 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 program approach. This means once…

  • COBOL VSAM Files READ with START Logic

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

  • How to Improve Your SQL Queries

    The following SQL checklist will help to review SQL Queries. Check for by mistake any inner join is coded as outer-join Check all union statements, is it really needed, or we can go with UNION ALL Check for NULLABLE columns, if NULL value comes, we need to handle -305 errors Check for Select statement, is…

  • SQL -204 error resolution to resolve quickly

    SQL -204 error quick resorption

  • COBOL VB Files – Top Interview Questions

    Variable records are very common in Mainframe real-time projects. The data varies in length. The awesome collection of question on VB files really an asset for you to review quickly when you are in leisure or working on the COBOL project.

  • DB2-SQL Part-2

  • 6 DB2 SQL Set Operators

    Here are complete DB2 SQL Set operators that use to get data from multiple Tables