Log in
 NESTU - An IBM i users group

DB2 and SQL with Open Source Languages

  • 18 Aug 2016
  • 5:30 PM - 9:30 PM
  • Spice Grill 111 Route 46 East, Parsippany, NJ 07054


  • Includes dinner
  • Includes Dinner

Registration is closed

Start Time: Registration at 5:30pm

Alan Seiden

DB2 and SQL with Open Source Languages 

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.


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

Powered by Wild Apricot. Try our all-in-one platform for easy membership management