Cool and very useful mainframes tips and tricks!!!
Check out some useful DB2 tips
1. Break up SQL statements and avoid using joins to save CPU hours.
2. For DB2 variable of DECIMAL the COBOL program should have PIC S9(n-m)v9(m) COMP-3
3. When using CURSOR for only reading the database, use FOR FETCH ONLY option.
4. Use ‘Move current-date to ……’ to obtain a date or to do a date calculation instead of ‘SET CURRENT TIMESTAMP’.
Check out more mainframe tips at http://mainframetipstricks.blogspot.com/
Check out our 100% free intraday share market tips at http://freesharemarkettips4u.blogspot.com/
