Loading…
COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall
Back To Schedule
Monday, October 15 • 4:00pm - 5:00pm
17AD POWER PICK: Embedded SQL - An Introduction

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback Survey
SQL is IBM's relational database language that can be used to query, update and delete data from the database. SQL is becoming the 'de facto' industry standard for accessing distributed data. Record Level Access can only be used with RPG and Cobol, while in all other programming languages data access is performed through SQL. Additionally SQL provides a lot of great features, such as aggregating rows and building sub-totals or updating a bunch of rows with a single statement. SQL also includes various scalar functions for example for date and time calculation, that are not available in RPG or Cobol. Embedded SQL allows SQL commands to be included and executed directly from within RPG or Cobol and thereby profiting from all the powerful SQL features without additional programming.

This is Session ID:170051
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Monday October 15, 2018 4:00pm - 5:00pm EDT
Grand Ballroom 5
  Application Development