Srinimf

DB2-Triggers and Stored Procedures

Both, Triggers and Stored procedures are DB2 objects. Triggers info will be stored in SYSIBM.SYSTRIGGERS Stored procedures will be stored in SYSIBM.SYSROUTINES Read More ⇢

Mainframe: Cool Tips

Mainframe tips that you may apply in your project. Read More ⇢

How to Write Simple Easytrieve Program

The first step Easytrieve is a reporting Language. The benefits and types of flavours available in the market explained here. A sample program is given to undestand about this language. Read More ⇢

To know if risk is involved in an IT project ,we need to calculate two values: one is MEAN and 2nd is SD (standard deviation). Formule: SD==> (PE-OPE)/6 Percentage ==> SD/Mean==> for example, percentage is 10.90, that project we treat risky. Note :-Read my previous post for more clarity: https://srinimf.wordpress.com/2011/07/03/it-project-estimation/ General thumb Rule to… Read More ⇢

IMS DB HDAM, PHDAM, HIDAM, and PHIDAM databases

A hierarchical direct (HD) database is a database that maintains the hierarchical sequence of its segments by having segments point to one another (instead of by physically storing the segments in the hierarchical sequence). HDAM HD databases are stored on direct-access devices in either a VSAM ESDS or an OSAM data set. In most… Read More ⇢