Session Description:

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

• 1. Learn DB2 techniques that improve security, performance, simplicity.
• 2. Understand how coding in open source scripting languages can be made simpler and more powerful by use of DB2’s modern capabilities.

Audience: Developers using open source languages such as PHP, Node.js, Python, or Ruby on IBM i with DB2.

Biography: Our Speaker is Stephanie Rabbini

A senior consultant for Seiden Group, Stephanie has been developing web applications on the IBM i for over 15 years. She previously worked for BCD Software Professional Services. She has developed a large range of applications including shopping cart, ordering, warehousing, dashboards, mobile/responsive applications, and many others for small to Fortune 500 companies. Steph has chosen PHP as her primary language, is Zend Framework 2 certified and has expertise in various web development technologies, including RPG and WebSmart. She also has in-depth experience with DB2, SQL, and the IBM i environment, and she consults on the ongoing development of the PHP Toolkit for IBM i. Recognized by IBM as a “Fresh Face of IBM i,” Steph also speaks at COMMON, ZendCon, and Local User Groups.

Handout