The Madison Area Midrange Systems Users Group is made up of
professionals from various business and technical industries who
are interested in providing quality technical information to the
iSeries community. MAMSUG meets monthly to discuss the latest
advances in technology and learn how iSeries technology is being
advanced throughout the professional community.
NOTICE - To view or download previous presentations by
our speakers, go to Past Meetings.
|| -- CANCELLED -- Tuesday February 23rd, 2010 | 9:00am
Full Day Session - Joe Pluta
Practical SQL - Tips and Techniques for Productive Business SQL
Are you tired of the examples of SQL that change the price for every item by
ten percent? Do you want someone to show you how to really use SQL? Well,
whether you want to create great traditional reports using embedded SQL,
build results sets that can drive powerful reporting tools like Jasper,
or use SQL as a data warehousing and archiving tool, this presentation
will focus on real world uses of SQL. Learn about formatting dates, using
CASE statements to handle special values, and dealing with user selection
criteria (select a warehouse or enter "*" for all). See examples of advanced
techniques including outer joins and CTEs (common table expressions). If
you've moved past "SELECT * FROM CUSTMAST", then you'll love this topic.
Getting the Most Out of Java and the IBM i
During this presentation, you'll gain a solid understanding of how to
use Java in a business environment. Practical examples show you how
and why you should add Java into your existing systems. See how JDBC
can access data anywhere in your system. Learn about the powerful
reporting capabilities of Jasper Reports, a tool which allows you to
generate PDFs and Excel spreadsheets with ease, and the JavaMail API,
which allows you to send them to your end users via standard email.
Familiarize yourself with the incredible spectrum of Java software — much
of which is free — so you can integrate it into your shop immediately!
Eclipse, Rational, RDi and WDSC: What They Mean to You and i
Eclipse has taken the development world by storm; Rational is IBM’s development
product line; and RDi is IBM’s must-have IDE, replacing the powerful WDSC
tooling. This soup to nuts presentation teaches you everything you need to
know about these four entities and how they interrelate. Explore RDi, the
PC-based GUI development tool that does everything PDM and SEU can do and
more, including providing a gateway to Web application development via RDi
SOA and EGL. Find out how RDi springboards from the Rational tooling that
is built on the open source Eclipse workbench, offering programmers hundreds
of reusable plug-ins. Walk through the basics of Eclipse, see how it makes
programming easier, and tap into some of the coolest RDi insider
techniques — little-known gems that will make you a more productive
developer. The presentation winds up with an overview of RDi-SOA, the
newest i-based tool in the Rational tool suite, and its free counterpart,
EGL Community Edition. Come get a look at what EGL can offer you!
Cost is $40 for members and $65 for non-members.
The meeting will be held at
Comfort Inn. Coffee
and donuts at 8:30.
Please Register for the meeting here.
Looking for a great, afforable educational opportunity? As a
MAMSUG member, you are eligible for the WMCPA member
rate for the annual Spring Technical Conference sponsored by
WMCPA. Click below to get all the information and to register.