-
2 SQL Ideas to Remove Duplicate Rows
Eliminate duplicates SQL query ideas to use quickly in your project Read More ⇢
-
DB2 The Four SYSDUMMY Tables
The popular tables SYSDUMMYX in DB2 and their role and uses in SQL to retrieve data from tables. Read More ⇢
-
Mainframe Alternative You Can Switch Easily to Data Analytics
Top careers you can choose an alternative to mainframe programming. Read More ⇢
-
COBOL: Static Vs Dynamic Call Which is Better
Static call is better than Dynamic call. I have shared top differences of these two calls. Read More ⇢
-
Here’s Simplified Data Sharing Architecture of DB2
DB2 data sharing lets an application run on one or more DB2 subsystems in a Parallel Sysplex environment. The applications can read and write to the same data at the same time. Data sharing is new concept, earlier we used Distributed Data Facility (DDF) to access data on other subsystems,… Read More ⇢
-
DB2-Timestamp Mismatch -818 SQL Error
DB2 -8181 Timestamp mismatch error and resolution. Read More ⇢
-
DB2: Local Vs Remote Collections
DB2: Local Vs Remote Collections Explained how to use them correctly. Read More ⇢
-
Syntax for DASD Files READ, WRITE, REWRITE and DELETE in CICS
VSAM Files we can use in CICS like flat files. You already know that VSAM files can be concurrently accessed by Batch and Online. VSAM Record-Level Sharing (RLS). This explores a method for accessing VSAM files that gives multiple CICS address spaces concurrent READ/WRITE access to recoverable VSAM data sets. On the other hand, below syntax… Read More ⇢
-
DB2: Performance Tuning A Quick Tutorial
Useful Db2 performance tuning interviews questions Read More ⇢
Srinimf 