Presentation Detail Select Presentation   "I didnt know my IBM i could do that! Open source tools can make it happen!" "BREAKING BAD" IBM i Habits! 10 things you can do about security 30 PHP tips on IBM i in 60 Minutes 9 years of i Can - Top Tips for IBM i A Pictorial Introduction To Cybersecurity A Programmer’s Future – looking back in time to see the future Accelerate Your Excel! Accessing External Databases from RPG ACS Run SQL Scripts & Other DB2 for i Tools Re-invented Agile Software Development in Theory & Practice, Manor Room An engaging interactive discussion is planned. Application Development Overview and Application Runtime Expert Application Modernization Artificial Intelligence and Machine Learning Assessing your IBM i (AS/400) server security in 15 minutes Awesome RSE Navigation - Advanced Edition Best Practices for IBM i Performance Management Best Tips and Tricks to Improve System Performance and Save Disk Space Bonus 30 minute Q&A session Breaking Bad IBM i Habits! Bring RPG/COBOL Business Logic to the Web with the PHP Toolkit Bring Your Browser Apps to Life with jQuery Browser Tools that Make Web Development Easier Building a DR Plan for Todays Business Building Reusable APIs Business Resiliency for IBMi - Dont Fall with the Fallen BYOD to the Cloud Can your IBM i recover from a disaster CL ENHANCEMENT V5R3 TO i 7.1 AND BEYOND. Command Jeopardy Configuring and Using IBM i Auditing Features Connecting the Dots: Building Web Apps with PHP, HTML, CSS & javascript Constellations on i Cool Things in Navigator to be a Rockstar System Administrator, Library Create Mobile applications using PHP, JSON and Sencha Framework CREATE or REPLACE DDS with DDL Current Issues in Cyber Security in the Public and Private Sectors Cybersecurity Darn Cursored Again! Using SQL & Cursors in your Programs Data Centric - Moving Business Logic into the Database DB2 and SQL Security DB2 Field Procedures DB2 for i - What's New Db2, Node.js, best friends? Determining Risk to Data and Implementing Multiple Layers of Defense Developing Secure Applications Development Strategies on Power DevOps and CI/CD Pipelines in the IBM i World Disaster! How did we get here and what could I have done to avoid it? Do-It-Yourself Web Reports! Don't Be Shy, Use RDi! Embedded SQL in RPG - Beyond the Basics Embedding SQL into Legacy Code Enterprise DevOps for IBM i Everything you need to know about to get started with the new Systems Director Navigator Console Exploring Open Source Solutions on IBM i (Bring your laptop) Exploring Open Source Solutions on IBM i (Workshop) Externalizing Database Processing in RPG IV Failure to Modernize The Real Cost! From STRSDA and STRRLU to RDP Fun!(damental) and Fun!(ctional) Table-Driven Programming General Virtualization topics plus IBM i specific examples Get With The Program! It"s Not Your Grandmas RPG Anymore! Getting started with PHP! Getting Started with Python on IBM i Give me an hour, and I'll give you a week! Glorious Past, Glorious Future! Going Mobile How does an open IBM i platform enable success for my business How to setup Wordpress to begin your own blogging site How to Successfully Upgrade to IBM i 7.4 & 7.3, Library I Clicked a Link and I Liked It i Know Where i is Going, Do You? iAccess Mobile - Accessing your IBM i from anywhere IBM Announcements IBM Announcements - April 2011 IBM i (SQL) Services - Live! IBM i Around the World IBM i Box of Chocolates IBM i IFS Containers IBM i in the cloud IBM i Lifecycle and 7.5 IBM i Performance Tools for the Application Developer IBM i security "inside the firewall" IBM i Security for Programmers IBM i Security: The Good, the Bad, and the Ugly IBM i Trends and Directions IBM i Trends and Directions IBMi Announcements IFS Security IFS Security Implementing Animations and Transformations on the IBM/i using CSS3. Impress Your Boss with Open Source Integrated Web Services - Web Services for the RPG programmer Intro to Git and Github w/ Live Demo Introduction to System i Visual Explain Introduction to the IBM i Navigator Performance Tasks Introduction to Web Development with PHP Is RPG Dead? Join the Conversation - Online Networking Strategies for Professionals Journal Forensics jQuery Mobile and the IBMi Lets Learn Linux - The Lab! LISUG Q&A is Back! Live Demo of RPG Open access using Look Software Live Demo of RPG Open access using Profound Logic Software Machine Learning on IBM i Manage Work Better with Better Work Management Management By The Movies May Day 2012 May Education Day - SQL, CL and RPG May Education Day! The Business value of PHP on IBMi MEETING CANCELED Mobile Application Development Modern CL Programming Modernization and Refactoring-Improving the Design of Software Modernization myths: DDS, DDL and IBM i Modernization Roadmap Modernizing Your File I/O with Data Structures Monitoring the Health and Performance of IBM i Moving to Dataset Processing New Navigator for I New PHP Toolkit from Zend and IBM Night of 1000 Stars Night of 1000 Stars Night of 1000 Stars Night of 1000 Stars Night of 1000 Stars Night of 1000 Stars Night of 1000 Stars Night of 1000 Stars Night of 1000 Stars Node.js & RPG: The Perfect Partners for Business Applications Node.js Intro Node.js Transacts with DB2 and RPG Open LAB-Requires Laptop w/Zend Studio Open Source ILE Concepts Open-Source Tools for RPG/ILE Development Opening Presentation on GDPR Options for Consuming REST APIs from RPG Organizing an ILE Application Panel Discussion Panel Discussion - Security Update 2017 Panel Discussion - The future of IBM i Panel Discussion-Application Modernization Partitioned Tables in IBM i Pete's Perspective on IBM i PHP & RPG Integration Examples PHP Tricks for the RPG Programmer: graphics, Excel, PDFs, E-Mail and More. PHP – Beyond the Basics PHP/MySQL Tricks and Techniques Power 9, TR 5 and What You Need to Know Power i Overview Practical AI and Watson for IBM i Providing Web Services on IBM i Putting the Pedal to the Metal for RDi Q&A Q&A Q&A Q&A Q&A Q&A Q&A Q&A Q&A Q&A Q&A Q&A Q&A Q&A Q&A w/IBM announcements & TR/7 plus the Latest RPG enhancements Raising the Bar-A Jumpstart to Using SOAP Web Services in RPG Ready, Set, Test Real-life examples for Access Client Solutions Recent DB2 Web Query Enhancements RESTful Web Services for Everyday RPG Consumption RPG Enhancements for i 7.1 RPG Open Access DEMO and XMLSERVICE discussion! Say YES to Change Secure PHP and MySQL Security Compliance: The Heart of the Matter Selecting your POWER Systems hosting environment Service Programs and Unit Testing - The Perfect Pair Shallow Dive into Database modernization Shell Programing SQL easy as MAGIC! SQL for the Security Officer SQL in ACS: Learn SQL in Your Very Own Playground! SQL in RPG: Transform Your RPG with the Power You Deserve! SQL on Steroids SQL Stored Procedures and Functions SQL Views for Dummies State of IBM i Security Systems Management with IBM i Services Tale of Two Cities Test Driven Development The 7 Habits of Highly Secure Organizations The Best of the IBM i Performance Data Investigator The Business, Science and Uses of ILE Service Programs The DevOps Playing Field-The Tools of Ignorance The IBM I Superhero Paradox The Limit's the Sky with RDi! The open book - Open Source on i The RedBook Revealed - What is Modernization on IBM i The SQL Procedures Language in a Nutshell The State of IBM i - 2013 Edition The Who, What and Why of Application Modernization This is a Disaster Declaration! This is not a Test Top 5 Things You Didnt Know You Can Do Using Open Source on Your IBM i Top Ten Vulnerabilities facing IBM i Turn on the LAMP - please Uh Oh, I think my IBM i has been breached Using a Website Template to Build a Website in Under 3 Hours Using DB2 and SQL with Open Source Languages on IBM i Using DB2 and SQL with Open Source Languages on IBM i Using iNavigator to make you a RockStar System Administrator Virtual Happy Hour! Watson and IBM i Web and API Language Shootout Web Performance First Aid What Happens When I Click SUBMIT? A Look At How The Web Works What is SCRUM? What will you do with your IBM i in 2017? What you need to know to upgrade to 7.2 or 7.3 What you need to know when upgrading IBM i (i5/OS) to 6.1, 7.1, OR 7.2 What's all this I hear about Encryption and Authentication and all that Secret Security Stuff? What's new and exciting in PHP for 2023 What's new in IBMi security including Technology Refresh Whats the Fuss? Using Procedures and Service Programs Why and How of DB Modernization Why Cloud, Why Not - Am I Ready? Worst Practices in Systems Management (A.K.A. 'Tales from the data center') www.LISUG.org The redesign project You Are Extraordinary   Title Using DB2 and SQL with Open Source Languages on IBM i Speaker Alan Seiden Presented November 15, 2017 Time 8:00pm Description DB2s 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. Softcopy Download Home Page http://www.alanseiden.com