-
How to Improve Your SQL Queries
The following SQL checklist will help to review SQL Queries. Check for by mistake any inner join is coded as outer-join Check all union statements, is it really needed, or we can go with UNION ALL Check for NULLABLE columns, if NULL value comes, we need to handle -305 errors… Read More ⇢
-
SQL -204 error resolution to resolve quickly
SQL -204 error quick resorption Read More ⇢
-
COBOL VB Files – Top Interview Questions
Variable records are very common in Mainframe real-time projects. The data varies in length. The awesome collection of question on VB files really an asset for you to review quickly when you are in leisure or working on the COBOL project. Read More ⇢
-
6 DB2 SQL Set Operators
Here are complete DB2 SQL Set operators that use to get data from multiple Tables Read More ⇢
-
CICS: When to use NODYNAM Compiler Option
NODYNAM compiler why you need to use in CICS programs Read More ⇢
-
8 Complex VSAM Interview Questions
VSAM tough interview questions useful for your interviews. Read More ⇢
-
CICS Invoking Web Service – How to Fix Errors 13 and 14
In our workshop we use CICS web services. We have a scenario that we need to invoke a web service to get third party service. Just after triggering service we got an error. INVOKE-SERVICE(data-value) CHANNEL(data-value) OPERATION(data-value) URI(data-value) URIMAP(data-value) SCOPE(data-value) SCOPELEN(data-value) We did some investigation on it. The return error codes are: Response codes… Read More ⇢
-
DB2 SQL error -104 and -199 Resolution
SQL errors in DB2 -104 and -199 are due to syntax related problems. Resolution provided in this post. Read More ⇢
Srinimf 