FILE ALLOCATION is a key concept in COBOL programming. A file is a collection of data related to a set of entities and typically exists on a magnetic tape or a disk. We refer file as PS in the Mainframe environment. In File, data is organized as records. Each record is divided into fields that […]
FILE ALLOCATION – COBOL File Handling Read More »
Any I-O operations on a file, there are chances that it may fail. We need to have COBOL FIle Error Handling. COBOL itself does not automatically take corrective action, we have to choose whether our program should continue running after an error or not. The severity of the error has to be defined in the
COBOL File Error Handling and Status Code Read More »
The ROUNDED option used to round the fraction result of the compute statement exceeds the length of the target data item fractional places. After decimal point alignment, the number of fraction places in arithmetic operation is compared with the number of fraction places of result identifier. If the size of the fractional result exceeds the
ROUNDED and ON SIZE ERROR use in COBOL Read More »
JQL full form is Jira Query Language is used to search your issues in Jira. A JQL query is a set of words and operators that define how JIRA will narrow your search. A function in JQL appears as a word followed by parentheses, which may contain one or more explicit values or JIRA fields. Field – Fields are different types of
JQL functions – Advanced searching in JIRA Read More »
GDG Stands for ‘Generation data group’ & is used to catalog a group of datasets that have common and similar data formats, and these datasets can be referenced by relative generation and version number. It is mostly used to take periodic backups of critical data for future reference. All datasets within GDG share the same
GDG – Generation Data Groups operations in JCL Read More »
COUNT function can be used to print messages containing the count of records in a data set. It can also be used to subtract a value from the count or add a value to the count, to create an output data set containing text and the count, or to set RC=12, RC=8, RC=4, or RC=0
COUNT Function: Count number of records in a file Read More »
ACCEPT parameter is an OUTFIL option that limit the number of input records accepted for OUTFIL processing. A record is “accepted” if it is not deleted by STARTREC, ENDREC, SAMPLE, INCLUDE or OMIT processing. ACCEPT makes it easy to limit the number of OUTFIL input records selected for processing. After n OUTFIL input records have
ACCEPT n records with OUTFIL SORT utility Read More »
IFTRAIL parameter is used to update count and total values in an existing trailer (last) record to reflect the actual data records in the output data set using COUNT and TOTAL features of TRAILER1. TRAILER1 lets you build a new trailer record but IFTRAIL lets you update an existing trailer record. When you specify IFTRAIL
IFTRAIL – Trailer record update using SORT Read More »
This feature helps “Add a flag and comment” at the same time to the tasks of Scrum Board. The comment section is also automatically updated with the comment provided in the flag. You can also remove the flag and comment. To make it more obvious, flagged issues are displayed in yellow in the backlog and
Scrum Board – Tips and Tricks for JIRA Read More »
Burnup chart is used to show how many story points are in the product backlog versus how many we’ve completed till date, as well as how much work remaining in the project (Not on Sprint level but at project level). In other words it displays the scope of a project and the work completed. Burnup
Burnup Chart – Sprint & Release Tracking Read More »
A Burndown chart is a graphical representation of work left to do versus time. Each point on the chart shows how much work was left to do at the end of that day (or week, month or other time period). In the Daily Scrum the Development Team updates the Sprint Burndown and plots the remaining work of the day. It is a chart
BurnDown Chart – Sprint, Release and Product Tracking Read More »
A Product Owner’s most important word: “No” & Saying No to a stakeholder is very difficult. Stakeholder management is the process of engaging with these people, and maintaining good relationships with them. You’ll likely be working with people in many different roles, with varying levels of influence over your project. Make Stakeholders feel heard and understood
Saying No to Stakeholder by Product Owner Read More »
Figurative constants are reserved words that name and refer to specific constant values. These can be easily used by writing the word itself instead of the value. The figurative constants supported by COBOL are: ZERO, ZEROS, ZEROES SPACE, SPACES HIGH-VALUE, HIGH-VALUES LOW-VALUE, LOW-VALUES QUOTE, QUOTES ALL literal – which means fill the field with ALL
Figurative constants use in COBOL Programs Read More »
Two types of abend codes, user abends and system abends (S0C Abends). User abends format is Unnnn, where nnnn is a decimal user abend code. System abends follow the format of Snnn, where nnn is a hexadecimal abend code. S0C Abends are the abnormal ending of Job & when it happens a message from the JCL or Fault Analyzer will
S0C Abends – S0C1 S0C4 S0C5 S0C7 Read More »
In this tutorial we will learn how the Outlook search function works and how you can use it to quickly search emails you are looking for.The Outlook Instant Search Tool provides a simple and easy to use set of features that will allow you to search through your Email messages. You activate the Outlook Search
Outlook Search Function: Find Emails Quickly Read More »
Database NORMALIZATION is used to reduce data redundancy and eliminate undesirable characteristics like Database Anomalies (Update anomaly, Insertion anomaly, Deletion anomaly). This also divides larger tables into smaller tables and links them using relationships and follows simple data structure design rules to make the data easy to understand, maintain and query. Rule of Clarity –
Database Normalization with Examples Read More »
By default, cursors are moved by 1 row at a time in the result table in sequential order starting from the first row. To remove this limitation SCROLL clause is used to indicate whether the cursor moves sequentially through the result table or can move randomly through the result table. You can declare row-positioned or
SCROLL vs NO SCROLL Cursors in DB2 Read More »
TIME parameter specifies the maximum amount of time that step may use the processor or to find out through messages how much processor time a step used. It is an optional Keyword parameter & this is important to save MIPS(Million Instructions Per Second). This can be used either in JOB or in STEP or in
TIME parameter use & S322 Abend in JCL Read More »
IF THEN ELSE ENDIF construct is used to conditionally execute job steps within a job. A job step execution can be controlled based on the return code of the previous step(s) using the COND parameter and IF-THEN-ELSE-ENDIF construct. The IF statement is always followed by a relational expression and a THEN clause. Optionally, an ELSE
IF THEN ELSE ENDIF construct use in JCL Read More »
COND parameter is used to test return codes from previous job steps and determine whether to bypass or execute specified job steps. Return code is set based on the status of execution of a job. The return code can be a number between 0 (successful execution) to 4095 (non-zero shows error condition). 0 = Normal
COND Parameter – Evaluate Return Code in JCL Read More »
Space ABEND generally occurs when your system encounters the end of volume condition occurs. There are three types of Space ABEND as mentioned below. SB37: There are not enough space or no more extents available on the current volume. The system gave all the primary space and as much secondary space as it could. Disk
Space ABEND – SB37, SD37, SE37 & Resolution Read More »
SQL Error Code is used on a day to day basis for the diagnosis of programming failures as a result of SQL calls by DB2 computer programs. An important feature of DB2 programs is the error processing. The error diagnostic containing the SQL Error Code are held in the field SQLCODE within the DB2 SQLCA block. This Instant
SQL Error Code with Explanation & Resolution Read More »
The OPTION control statement allows you to override some of the options available at installation time (such as EQUALS and CHECK) and to supply other optional information (such as DYNALLOC, COPY, and SKIPREC). Some of the options available on the OPTION statement are also available on the SORT or MERGE statement (such as FILSZ and
OPTION control statement in SORT JCL Read More »
The LISTCAT command is used to list and view the attributes and characteristics like space allocation information, password and security-related information, usage characteristics, creation, and expiration date, etc of VSAM or non-VSAM entries. It stands for LISTing of CATalog entry. The LISTCAT line command allows access to IDCAMS and displays the tablespace or indexspace space usage
LISTCAT use in retrieving GDG or VSAM Information Read More »
SPS Practice Exam (SPS) – Scaled Professional Scrum with Nexus helps you to gain an understanding of how to scale Scrum using the Nexus Framework and launch structure, staff, and manage large Agile projects using Scrum. The SPS Practice Exam questions are designed to help you prepare and practice for the Scrum.org Scaled Professional Scrum Assessment.
SPS Practice Exam Practice Mode Questions Read More »
