Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • Here’s All About Nested Cursor in DB2

    The cursor in DB2 is an important logic to read records one by one from multiple tables. There are scenarios to declare cursors more than one to achieve desired result. I have given here step by step flow to declare nested cursors. What is nested cursor in DB2? A cursor within the cursor is called…

  • Driverless Cars: 2 Top IT Skills You Need

    The complete story of driver less cars of future transportation and highly useful for students and professionals.

  • CICS-ABEND Command and Rules

    The ABEND command forces the current task to terminate abnormally. If a HANDLE ABEND command is in effect, control will be transferred to the routine it specifies. Otherwise, control is returned to CICS. An optional storage dump can be produced. Syntax EXEC CICS ABEND [ ABCODE(name) ] [ CANCEL ] [ NODUMP ] END-EXEC. Options…

  • Synchronous Vs Asynchronous Message-queues Working Concept to Read now

    Messaging means that programs communicate by sending each other messages (data), rather than by calling each other directly. Read more.

  • 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: DECIMAL(BONUS) is equal to :-…

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

  • 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…