Mike Cain
Mike Cain is an IBM Senior Technical Staff Member with over 25 years of IT
experience, and leads the DB2 for i Center of Excellence in Rochester,
Minnesota USA.
Prior to his current position, Mike worked as an AS/400 Systems Engineer
and Technical Consultant. Before joining IBM in 1988, Mike worked as a
System/38 programmer and data processing manager for a property and
casualty insurance company.
Track abstract - IBMi
What’s New in DB2 for i?
Come and find out how the DB2 for i 6.1 features that can help your IBM i
databases and applications take a giant leap forward. You will learn how
these new database features and functions can be used to improve your
applications and to reduce your design and development time. You will also
be hearing about the self-learning capabilities of the SQL Query Engine and
the productivity gains delivered by the enhancements to the DB2 OnDemand
Performance tools in System i Navigator. We will also take a look into the
future of DB2 for i.
Track abstract - IBMi
SQL Programming DB2 for i SQL OLAP Functions
In the spirit of doing a LOT more with less, we will cover the V5R4 and 6.1
SQL OLAP functions.
In general, analytic functions are valuable because:
* They simplify the expression of complex but commonly asked business
questions
* They are efficient
* They are fast compared to other methods of running calculations
Come and learn how you can be more productive and provide information
faster with SQL and DB2 for i.
