-
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. 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:… 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 ⇢
-
DB2 SQL – Select, Insert, Delete and Update
Here are the best examples to write SQL queries for SELECT, INSERT, DELETE and UPDATE. Read More ⇢
-
How to Tune SQL Query 5 Ideas
The Merge statement and Select FROM statement improves performance read more. 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,… 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 ⇢
-
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 ⇢
Srinimf 