WMCPA Spring Conference 2017

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, simplicityUnderstand 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.