DB2 Equivalent COBOL Data Types

As DB2/SQL and COBOL field declarations are different, It is important to have Equivalanet COBOL data types to the corresponding DB2 table columns in COBOL programs to process the data correctly. More importantly, the precompiler uses the equivalent SQL data types for the declared Host variables. So if the host variable declaration is not correct,

DBS Mainframes Interview Questions

These Questions were asked in the first round of Interviews for DBS, Hyderabad from Optimum solutions. How a transaction is defined in CICS? What is the use of TSQs & TDQs? What are the ways that a transaction can be auto-initiated? How to initiate a transaction using TDQ? Where does this need to be defined?

CICS RETURN with Examples

RETURN IN CICS is to return the control back to the next higher level which is either main program or CICS(Operating System).It is very useful in programs where there are sub programs involved in exchanging the data Or screens involved where there is a need to preserve the data and use it after the user


In JCL, SYSOUT is an Optional Keyword parameter that indicates that the dataset is a system output data set. Basically it assigns an output class to the SYSOUT dataset. As each class would be attached to a device to handle the output, the desired output would be routed to that device. Syntax: SYSOUT= { class

JCL Region Parameter, Default, examples

In JCL, Region is an Optional Keyword Parameter which can be specified at JOB and/or Step Level. Region Parameter in JCL indicates that the amount of storage (Virtual or Real) that the JOB or step can use to execute. It specifies an upper limit of memory to be used and thus the job/step can use

CICS Scenario Based Questions

CICS Scenario Based Interview Questions Apart from the basics, CICS has scope to ask many questions by giving a scenario. Here I am giving the list of few scenario based ones. I have two CICS PROGRAMS – PROGA & PROGB. 1st Prog should pass some data to Program B and using this data Program B

Read VSAM File in REVERSE Order

Apart from reading forward, VSAM KSDS file can be read Backwards starting from a specified Key value. READPREV command is used for this purpose. To read a record in reverse order starting from a key needs to establish a starting point first which can be done using STARTBR, then READNEXT and READPREV does the backwards

VSAM Share Options

VSAM Share Options defines the VSAM datasets accessibility among different users. Share options are like the DB2 locking system, by using these options different levels of shared access can be given to different jobs/users on a single VSAM dataset. Where to Set these options? Can be set while defining the VSAM cluster using IDCAMS. These

How to Get workday Community Access?

How to get Workday community access for learning & practicing purpose? There are many online courses available to learn different modules of Workday. They even provide access at the time of training for a limited period of time. But to get the access individually to do some hands on the tool, I do not find
Close Bitnami banner