Loading…
POWERUp 2019 has ended
Experience the magic of education. 
Tuesday, May 21 • 5:15pm - 6:15pm
38BP Using Db2 and SQL with Open Source Languages

Log in to save this to your schedule, view media, leave feedback 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.

Speakers
avatar for Dave Owen

Dave Owen

Advisory Software Engineer, IBM
David Owen is an Advisory Software Engineer at IBM. Joining IBM in 1991, he has worked in the guts of the operating system in Journal and Database. He is also the technical consult for Guardium on i and has assisted several customers with installation and proof of concept activities... Read More →
avatar for Alan Seiden

Alan Seiden

Principal, Seiden Group
Alan founded Seiden Group to help modernize IBM i applications using open source technologies such as PHP, Python, Node.js, and DB2 for i and RPG business logic.Recognized as an IBM Champion, Alan hosts the the CIO Summit twice per year. He and his team work with the best minds in... Read More →


Tuesday May 21, 2019 5:15pm - 6:15pm PDT
Fantasy Tower Magic Kingdom 4
  Database
  • Focused Education Roadmap SQL Programming
  • Level Intermediate
  • AWARD Silver
  • Operating System IBM i
  • Audience Developers using open source languages such as PHP, Node.js, Python, or Ruby on IBM i with DB2.