Srini

COBOL VSAM Files READ with START Logic

Here’s COBOL sample program that explains that reading of VSAM files.

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 Check for Select statement, is…

SQL -204 error resolution to resolve quickly

SQL -204 error quick resorption

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.

DB2-SQL Part-2

6 DB2 SQL Set Operators

Here are complete DB2 SQL Set operators that use to get data from multiple Tables

CICS: When to use NODYNAM Compiler Option

NODYNAM compiler why you need to use in CICS programs

8 Complex VSAM Interview Questions

VSAM tough interview questions useful for your interviews.

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 13 and 14 Error :13…