-
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… Read More ⇢
-
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. Read More ⇢
-
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 ]… Read More ⇢
-
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 ⇢
Srinimf 