Sessions


Embedded SQL - Beyond the Basics

  Application #1
  Kungsholmen 1
  Jun 14, 2016
  12:15-13:00

You have been using embedded SQL in RPG. You have mastered the syntax, tried a few selects, declared a cursor, performed an update - you may even have tried some dynamic SQL!

You have been using embedded SQL in RPG. You have mastered the syntax, tried a few selects, declared a cursor, performed an update - you may even have tried some dynamic SQL!

Time to take it to the next stage and see what you can do with embedded SQL - beyond the basics

Topics covered in this session include:-

Discussion of the key points in writing powerful embedded SQL
What tools should you use to write and test SQL prior to embedding it?
Controlling CRTSQLRPGI
SQLCA and SQLCODE considerations
Getting data without SELECT - GET DIAGNOSTICS and VALUES INTO
Mastering Multi Row Fetch
Handling NULL
Dates, Times and Timestamps

Speaker: Paul Tuohy, ComCon

Session Handout: 33C Embedded SQL in RPG Beyond the Basics V2.pdf

Back to the sessions

Paul Tuohy

, ComCon

Paul Tuohy has specialized in application development and training on IBM midrange systems for more than 20 years.

Read more