The FETCH FIRST n ROW ONLY clause is used to limit the result set of a query to a specified number of rows. It is particularly useful when you are only interested in retrieving a subset of the total records. Retrieving the entire result table from the query can be inefficient. You can specify this […]
FETCH FIRST n ROW ONLY and OPTIMIZE FOR n ROWS Read More »
A DB2 null Indicator/value represents missing or unknown information at the column level. When a column is set as null, it can mean one of two things: the attribute is not applicable for certain occurrences of the entity, or the attribute applies to all entity occurrences, but the information may not always be known. It
DB2 NULL Indicator use in SQL Queries Read More »
DB2 locking and concurrency is a critical part of DB2 as well as batch performance. Batch update jobs processing large amounts of data will need to have restart logic through the use of the COMMIT statement and a program data save area. This will identify the restart point. Commit frequency should be an input parameter
DB2 locking and concurrency – Tips & Trick Read More »
Depending on the linkage options, the object module of the calling program is linked with the object module of the called program “before or during” execution – referred to as static or dynamic linking. Note : Even if your program is coded to call a program statically, the compiler can convert it to the dynamic
Static or Dynamic Call Option in Cobol Read More »
How to protect few selected cells in an excel document? Select the entire worksheet by clicking the Select All button (the gray rectangle directly above the row number for row 1 and to the left of column letter A). Click Cells on the Format menu, click the Protection tab, and then clear the Locked check
Tips on Microsoft Excel Read More »
Scrum Cheatsheet: Scrum is a term from RUGBY. It is an ordered formation of players, used to restart play, in which the forwards of a team form up with arms interlocked and heads down, and push forward against a similar group from the opposing side. The ball is thrown into the scrum and the players try
Scrum Cheatsheet use in Agile Framework Read More »
Product Backlog Refinement or Grooming is an exercise out of which a prioritized list of work emerged. It consists of Creating & Refining User Stories, Estimating User Stories & Product Backlog Prioritization. Product Backlog is the single source of requirements for any changes to be made to the product. This is for the development team
Product Backlog Refinement – Tips and Tricks Read More »
LINEAR and BINARY searches can be coded using traditional code or using the SEARCH or SEARCH ALL verb. The one that is coded using traditional code uses an Occurs to define the re-occurrence of the elements in the table and the Subscript to control stepping through the table one element at a time using the
SEARCH and SEARCH ALL use in Cobol Program Read More »
Using indexes to address a table is more efficient than using subscripts since the index already contains the displacement from the start of the table and does not have to be calculated at run time. Subscripts, on the other hand, contain an occurrence number that must be converted to a displacement value at run time
Indexes vs Subscripts use in Cobol Program Read More »
The ONCODE built-in function provides a fixed-point binary value that depends on the cause of the last condition. ONCODE can be used to distinguish between the various circumstances that raise a particular condition—for instance, the ERROR condition. For codes corresponding to the conditions and errors detected, refer to the specific condition. 3 in a SELECT/WHEN/OTHERWISE
While executing a job there are many abend code due to which it can fail. Here is a list of common Abend Codes and their explanations. Abend Code:1. S001 – An I/O error occurred. Check reason code for exact cause. Examples are trying to read beyond End of File, trying to write to an input
Abend Code and their meaning in JOB Spool Read More »
Create a poll in Microsoft Outlook email by using Email Voting buttons in an email message. For responses to the poll,it can automatically tabulate the results of the vote in Outlook or export the responses to an Excel worksheet. Create an Outlook message Type your question into the body of the email. Choose options from
Email Voting : Poll in Microsoft Outlook Read More »
Pictures can dramatically increase the size of your Microsoft Office file (Word, PowerPoint, Excel, Visio, Publisher, etc.). You can control file size by making choices about the resolution, quality, and compression of an image. One easy way to balance this tradeoff is to match the picture resolution to the use of the document. For example,
Compress Microsoft Office File Size Read More »
Export Calendar from SharePoint to Outlook : Access a SharePoint calendar from Outlook here’s how: Access the SharePoint calendar you want to connect to your Outlook to export calendar. Then at the very top of the screen, towards the left hand side, click on “Calendar” from the ribbon bar. Then from the ribbon bar,
Export Calendars from SharePoint to Outlook Read More »
Sprint Retrospective is a short meeting for project teams to reflect on the most recent stage of their project, analyze their processes, and identify things they can do better moving forward. Regular agile retrospective meetings support constant learning and improvement over the life cycle of the project. Start Stop and Continue Sprint Retrospective Glad-Sad-Mad Sprint
Sprint Retrospective – Tools and Techniques Read More »
USAGE and COMP: USAGE CLAUSE -There are two general forms of internal representation – computational and display (Usage and Comp). Only numeric data items can be displayed as computational, and as the name suggests, an item specified as computational can take part in arithmetic operations more efficiently. Whether a data item is computational or display, it
USAGE and COMP Declaration Read More »
REDEFINES: Sometimes, it may be found that two or more storage areas defined in the DATA DIVISION are not in use simultaneously. In such cases, only one storage area can serve the purpose of two or more areas if the area is redefined. The REDEFINES clause allows the same memory area to be described by
REDEFINES and RENAMES use in COBOL Program Read More »
How to Automatically Color Code Incoming Emails in Outlook Conditional formatting is a way to make messages that meet defined conditions stand out in the message list by using color, fonts and styles. You specify conditions that an incoming message should meet, such as a sender’s name or email address, and then conditional formatting is
Tips on Outlook Email Read More »
Outlook Email Rules : A rule is an action that Microsoft Outlook performs automatically upon incoming or outgoing messages, based on conditions that you specify in the rule. You can choose many conditions and actions by using the Outlook Email Rules Wizard. The Outlook Email Rules Wizard includes templates for the most frequently used rules, which include the
Tips and Tricks to Manage Outlook Email by using Rules Read More »
W. Edwards Deming in the 1950’s proposed that business processes should be analyzed and measured to identify sources of variations that cause products to deviate from customer requirements. The Deming cycle is a continuous quality improvement model which consists of a logical sequence of four key stages: Plan, Do, Study, and Act. Plan, Do, Study,
Deming Cycle (PDCA) – Importance in Agile Read More »
The Agile Manifesto was written in 2001 by seventeen independent-minded software practitioners. While the participants didn’t often agree, they did find consensus around four core values. The purpose is to give a new way of developing software “by doing it and helping others do it”. Agile Core Values Individuals and Interactions over Processes and Tools. Working Software over Comprehensive
Agile Manifesto & Principles Read More »
Agile and Scrum: Traditional software development models built on statements of work which needs to be signed at an early stage of the development process. At early stage customers don’t know exactly what they wanted, and also not being able to articulate precisely their needs. Developers don’t know how to build it & during execution changes
Agile and Scrum use in Software Development Read More »
