Problem: How to explain INNER JOIN and OUTER JOIN with the help of an example on ORDERS and TRANSACTION DB2 table.SolutionThe JOIN is used to combine data from one or more tables in DB2. There are two main types of JOIN — INNER JOIN and OUTER JOIN. The basic difference ... Read More

We can revert all the changes done on a COBOL-DB2 program using the ROLLBACK statement. However, ROLLBACK is only applicable until COMMIT has not been issued. If we have used a COMMIT statement, then ROLLBACK will revert all the changes made in DB2 tables after the last COMMIT point.For example, ... Read More

Both JOIN and UNION are used to combine the data from one or more tables. In case of JOIN, the additional data appears in column while in case of UNION additional data appears in rows.For example, JOINSuppose we have two DB2 tables, ORDERS and TRANSACTIONS. We have to extract TRANSACTION_ID ... Read More

The purpose of VALUE function in DB2 is to check for NULL values and it can be used in place of NULL indicator or COALESCE function. The VALUE function replaces the column value with the given argument if it contains a NULL value.For example, if we have an ORDER table ... Read More

Operation cycle method considers total cycle of operations, from raw materials to finished goods, from accounts payable to net cash.The times taken to complete these operations are called operating cycle time.If the operating cycle is long then, requirement of working capital is less, if the operating cycle is less then, ... Read More

In regression analysis method, statistical tool is used to calculate working capital.CalculationsWorking capital = Int + m*R            Int = intercept, m = slope, R = RevenueΣy = na + bΣxΣxy = aΣx + bΣ2            Where x = sales, y = ... Read More

Percentage of sales method is the traditional method to find out working capital. This method is based on historical relationship between sales and working capital. Each of historical value is converted to percentage of net sales and those values are used to forecast.Steps involved in this method are −Determine historical ... Read More

Appraisal methods are categorised into two types. Each method has its own merits and de-merits. One of the methods used by companies are modern methods which are divided into following typesMBOMBO means Management by Objectives. This concept was developed by Peter F.Drucker in 1954. It is the process where, both ... Read More

Appraisal methods are categorised into two types. Each method has its own merits and de-merits. One of the methods used by companies are traditional methods, which are divided into following types −Ranking method − It is the oldest method used in performance appraisal. In this method, employees are ranked according ... Read More

An appraisal is the process of conducting a fair analysis to evaluate an asset, a business, an organization or a performance based on certain standards. A qualified person called an appraiser does appraisal. It is done whenever properties need to be sold and its value is determined for tax obligations ... Read More