- Blog
- Blog
- Homepage
- Homepage
-
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.
-
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.
-
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.
-
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 ‘BRANCH%’The idea here is to…
-
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.)
-
How to Handle Errors in CICS
Error handling methods in CICS. Explained real project ideas. Useful for your projects to use today.
-
COBOL: Alternative Key Vs Index
This is really a critical question for all COBOL developers that the difference between Al
-
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 for a specified column(s) avg,…
-
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.
-
Mainframe: Batch JCL Conditon Code Confusing Question
Step return code (condition code) and System completion codes are confusing questions in batch jcl. I have given here differences between those.
-
Mainframe: MQSeries for Senior Software Developers(1 of 3)
Read basics on cluster and shared queues being used in MQSeries
-
COBOL DB2 Program 10 Best Points You Need
In Mainframe, it is possible to run a SQL query without writing a COBOL program. You can do it by using, SPUFI, QMF and IBM Studio. SQL query must begin with EXEC SQL and end with END-EXEC. Second, your SQL query uses COBOL host variables. Host variables in COBOL: Host variables appear with a colon…
Srinimf 