Friday, January 21, 2011

IBM announcement : price changes for subscription and support software

Last year we already signaled a price raise for DB2 V8 for z/OS starting at April 1, 2011. Hey, come to think of it, no April Fools' Day joke, this one. Here's another announcement for some Subscription and Support software in order "to bring the price of the Subscription and Support offerings in line with the price of the associated product offerings" : Price changes on several IBM Subscription and Support Software Programs (S&S) (ZA11-1001)("http://www-01.ibm.com/common/ssi/ShowDoc.jsp?docURL=/common/ssi/rep_ca/1/877/ENUSZA11-1001/index.html&breadCrum=DET001PT022&url=buttonpressed=DET002PT005&specific_index=DET001PEF502&DET015PGL002=DET001PEF011&submit.x=7&submit.y=8&lang=en_US")

The products with their respective S&S are :

IBM WebSphere Portal Enable for z/OS V7.0
IBM Rational Asset Analyzer for z/OS V6
IBM Tivoli Omegamon XE for DB2 PE on z/OS V5.1
IBM Tivoli Omegamon XE for DB2 PM on z/OS V5.1
IBM DB2 Utilities Suite for z/OS V10.1
IBM DB2 High Performance Unload for z/OS V4.1
IBM DB2 Administration Tool for z/OS V10.1
IBM DB2 Object Comparison Tool for z/OS V10.1
IBM DB2 Buffer Pool Analyzer for z/OS V5.1
IBM DB2 SQL Performance Analyzer for z/OS V4.1

Price increases vary per product and go from 0% up to 55% for Belgian customers. Prices also become effective April 1, 2011. Check out the announcement for more details.

Monday, January 17, 2011

Query for selecting second maximum salary from a table

Many a times i heard that it is the most asking questions by the mainframe opportunity seeker that "Query for selecting second maximum salary from a table"
here is the code

SELECT MAX(SAL) FROM EMP WHERE SAL < (SELECT MAX(SAL) FROM EMP);
Where SAL is the salary column,
EMP is the name of table.
___________________________________________________________________________
Find out Nth highest salary from emp table

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

lets take an example:
EMP
e_no e_name sal
-------------------------
001 ram 15000
002 shyam 35000
003 hari 5000
004 krishna 20000
005 rahul 25000



eg:-
a= 3;
20000
hope this will help

List of company working on mainframe

INFOSYS
HCL
ACCENTURE
TCS
IBM
PATNI
KANBY
CTS
COVANYS
EDS
WIPRO
POLARIS
L&T
VETTRI
SATHYAM/PCS
MASCON
SYNTEL
XANSA
HCL
HPS4
Ford
Hexaware
verizon
Mpowerss
MASTEK
ANZ
Iflex
CGI
HSBC
MPHASIS
MBT
CITI BANK
COLES MYERS
DETUSCHE BANK
NET CRAFT
INFINITY
PHENIX
EFUNDS
MINDTREE
MINDTEK
FEDILITY
TIMKEN
DIGITAL
KEANE
POLARIS
MAJORIS
US Software
Macro Soft
Nest
____________________________________________________________________________
Here is the list of company having monopoly in specific sectors:
Health care - Wipro(Cardinal,pedigree)
Banking - HSBC,IBM,ACCENTURE
Insurance - SATYAM,PATNI,IBM
Admin&production support - IBM,CSC,SATYAM

Thursday, January 6, 2011

difference between examine and inspect in cobol used for IBM Mainframe

EXAMINE & INSPECT are used for same purpose. INSPECT is used now, which has replaced EXAMINE. The EXAMINE statement is an HP extension to the ANSI COBOL standard. It has been replaced by the INSPECT statement, Although HP COBOL II includes the EXAMINE statement for compatibility with COBOL'68, it is advisable that one should use the INSPECT statement for coding new programs.
For reading more please refer the following link:
http://docs.hp.com/cgi-bin/doc3k/B3150090013.11820/84