-
DB2 Catalog Tables Where Accessing of Remote System Updated
Catalog tables listed in this post where you need to look in about remote system details. Read More ⇢
-
How to Copy File to Multiple Files using ICETOOL
Combining ICETOOL with DFSORT in Mainframe JCL. Best DFSORT examples so you can simplify your JCL code. Read More ⇢
-
ICETOOL Complete Tutorial Alternative to DFSORT
The complete basics about ICETOOL. The details are highly useful for beginners in ICETOOL. This is the best alternative tool to DFSORT. Read More ⇢
-
DB2 SQL – Perfect Way to Use Conditions in WHERE
Best rewriting SQL query methods to improve Query performance. First write Split predicates out if possible: SELECT DEPTNO, DEPTNAMEFROM DEPTWHERE (ADMRDEPT = ‘E01’AND DEPTNAME LIKE ‘BRANCH%’)OR (DEPTNO = ‘D01’AND DEPTNAME LIKE ‘BRANCH%’)can also be tried as: Second write SELECT DEPTNO, DEPTNAMEFROM DEPTWHERE (ADMRDEPT = ‘E01’ ORDEPTNO = ‘D01’)AND DEPTNAME LIKE… Read More ⇢
-
DB2 SQL: How to Create Index (1 of 2)
Provide a fast, efficient method for locating specific rows of data in very large tables. (In some cases, all the information needed to resolve a query may be found in the index itself, in which case the actual table data does not have to be accessed.) Read More ⇢
-
How to Handle Errors in CICS
Error handling methods in CICS. Explained real project ideas. Useful for your projects to use today. Read More ⇢
-
COBOL: Alternative Key Vs Index
This is really a critical question for all COBOL developers that the difference between Al Read More ⇢
-
DB2 Tutorial For Software Developers (4 of 5)
DB2 tutorial given in the form of questions and answers. So that any mainframe or DB2 developer can read and implement quickly. Useful to your projects too. Read my previous post(3 of 5). Functions: Types are two : column function scalar function Column functions: compute from a group of rows aggregate value… Read More ⇢
-
XCTL, LINK, RETURN in CICS: Here are Top Differences
Here are the ways, in CICS, the programs are called to respond to proper messages to the screen. Read More ⇢
Srinimf 