Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Welcome to the Online Session Guide for the COMMON 2017 Annual Meeting and Exposition. With your free account, you will be able to create a personal schedule, connect with other attendees, take session evaluations and download handouts.

Please note: the log in information for the Online Session Guide is different than your Cosmo ID and password. If you have an Online Session Guide account from a past COMMON event, please use it to log in. If you do not have an account, set up one here.
View analytic
Tuesday, May 9 • 2:00pm - 3:15pm
35CL Using DB2 and SQL with Open Source Languages

Sign up or log in to save this to your schedule and see who's attending!

DB2's ever-expanding capabilities can simplify development in open source languages such as PHP, Ruby, Node.js, and Python. These languages, known for their ease in building web and mobile applications, can run most types of SQL, but why complicate them with repetitive database code that distracts from their power and simplicity? This talk shows examples of how to reduce tedious coding by using such DB2 structures as Views, User Defined Functions, stored procedures, Row and Column Access Control (RCAC), LIMIT/OFFSET, exciting new DB2 Services, and more. Security, performance, and ease of maintenance in the open source scripting languages will be the result of the recommendations and techniques given in this talk.

Learning Objectives:
Learn DB2 techniques that improve security, performance, simplicity Understand how coding in open source scripting languages can be made simpler and more powerful by use of DB2's modern capabilities. This session 170477.

Speakers
avatar for Scott Forstie

Scott Forstie

DB2 for i Business Architect, IBM
Scott Forstie is the DB2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989. In addition to his development responsibilities, he is the IBM i developerWorks content manager and IBM i Technology Updates wiki owner. Scott is a freq... Read More →
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
As the most experienced PHP expert on the IBM i platform, Alan Seiden helps IBM i teams develop smart, high-performance web and mobile applications using PHP, Zend Server, RPG and DB2. Founder of Seiden Group, an independent consultancy, Alan also works closely with some of the best minds at both Zend and IBM on behalf of his clients. | An award-winning speaker, Alan has been called "the performance guru of PHP on IBM i." Alan is a passionate advocate for open source. Among his many contributions to the PHP on IBM i community, Alan co-developed the PHP Toolkit with IBM, became one of the first Zend Framework certified engineers, was named a “must-read” writer of a “Top 10 IBM i Blog," consulted on IBM's manual PHP: Zend Core for i5/OS, and created the Club Seiden community to nurture young talent and IBM i open source. Contact him at Seiden Group, Ho-Ho-Kus... Read More →


Tuesday May 9, 2017 2:00pm - 3:15pm
Caicos 1, Caicos Level

Attendees (37)




Twitter Feed