-
How to Write COBOL Logic for DB2 VARCHAR Field
Real usage of VARCHAR in DB2 is to store variable data. Explained in this post how to use it in COBOL programs. Read More ⇢
-
How to Create Tape Dataset in JCL
JCL Tape datasets and its parameters with syntax Read More ⇢
-
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 ⇢
Srinimf 