This event has ended. Create your own event → Check it out
This event has ended. Create your own
View analytic
Wednesday, March 15 • 2:30pm - 4:00pm
Embedded SQL An Introduction

Log in to save this to your schedule and see who's attending!

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.

Learning Objectives:
In this session you will learn how to embed and execute SQL commands from within an HLL respectively RPG. It provides an overview of the commands to use in an application program to exploit SQL scalar functions as well as for updating, deleting and accessing data located in database objects.

Audience: Developers who already discovered the power of SQL and want to profit from those features from within RPG or Cobol. Developers originally coming from other programming languages who want to access data in the same way they are used to do. Developers working in a “multi-(programming)lingual” environment who need or want to embed the same or slightly modified source code in different programming languages.

Level: Beginner

Duration: Single Session

avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →

Wednesday March 15, 2017 2:30pm - 4:00pm
Geneva 2

Attendees (9)