DB2 Stored Procedures in Mainframes

DB2 stored procedures mainframe–>  Stored procedures are the programs that contains one or more SQL statements to perform a business functionality and can be called by any application with SQL call statements. These are ALSO considered as the programs that are compiled and stored in a DB2 server which can be called/INVOKED from any application

JCL DISP Parameter

JCL DISP (Disposition) parameter is a Keyword parameter which is used to describe the status of a data set used in JCL to the OS. It indicates the OS on what should be done with the dataset after JOB/STEP termination. It has 3 sub parameters which indicates THE STATUS,Normal & abnormal termination ACTIVITIES of the

Transaction Initiation in CICS

There are multiple ways of initiating a transaction in CICS. Initiating a transaction is nothing but running that transaction to start any process. Below are the different ways of transaction initiation process. 1. Entering the trans ID on native region. Example: If CST1 is the transaction ID to display the main customer details screen. Then

Symbolic Parameters in JCL

Symbolic Parameters in JCL Using Symbolic parameters in JCL/PROC is a good practice to modify any PROC parameters from the JOB. This method gives the flexibility of using different parameters in Different jobs which are using a single PROC. It is not only used to modify the proc parameters, it can also be used in

JCL override with examples

JCL override with examples JCL/PROC override is useful when a proc parameters, data sets needs to be modified while executing it. Adding parameters, Nullifying the existing parameters or Overriding the parameters of a PROC are the common overrides that can be done via a JOB. 1. Overriding a DSN: PROC has an input data set

COBOL DISPLAY Statement

COBOL DISPLAY Statement is used to Display the data on Output device. This is a procedure division statement and very useful to get the required data on output device. Syntax: [crayon-5dcb285383810483158331/] Identifier is any declared variable of the program. Literal is any text string or figurative constants like ZEROES, SPACES, QUOTES, HIGH-VALUES, LOW-VALUES. Example  for Identifier 

Populating Current USERID in CICS map field

Populating Current USERID in CICS (COBOL) map filed is the most common requirement for the Update-able Maps. Along with USERID, getting Current date-time are also can be retrieved using the CICS supplied commands. These can be coded in COBOL program under EXEC … & END-EXEC just like any other commands. ASSIGN USERID – ASSIGN command

CTS Mainframe Interview Questions

These Questions have been asked in Cognizant(CTS) for Mainframes Technical round of Interview. CICS & VSAM–> What is the MAX size of COMMAREA? What happens if we try to send the data with size more than 32k? While passing data between two programs(PGMA TO PGMB) using COMMAREA. If in PGMA The commarea size is 30

Scrollable Cursors In DB2 Mainframes

Scrollable cursors are introduced to overcome the limitation of reading the result table in sequential order.In Normal cursors, the cursor places at the first row of the result set when OPEN cursor statement is executed. And for each Fetch, the cursor gets moved by 1 row forward in the result table and this is the

Handling Null Values in COBOL DB2

Handling Null Values in COBOL DB2 program is an important aspect without which program may get into erroneous status. Null is nothing but no value has been populated or Value is missing for that DB2 table column.In other words, few columns gets populated only based on certain criteria, if it meets that criteria then it
Bitnami