Embedded SQL in RPG

Code: ESR

Description

-

Audience

-

Prerequisites

It is assumed that the participants have mastered both RPGIV (Free Format) and SQL basics. It is recommended that participants first take the course SQL Queries for professionals so that they learn what is possible in SQL and can then use SQL correctly.

Objectives

-

Topics

Overview

  • Terminology
  • Pre-Requisites
  • (Pre-)Compile

Embedding SQL in RPG

SQL without Data Access

Using Variables in SQL

  • Host Variables
  • Indicator Variables

Error Handling

  • Based on the SQLCA (Communications Area)
  • GET DIAGNOSTICS

Data Access without Cursor

  • Static SQL
  • Dynamic SQL

Cursor Types

  • Serial Cursor
  • Scroll Cursor

Static SQL with Cursor

  • Consuming the Cursor Data
  • Updating/Deleting rows with a Cursor

Dynamic SQL with Cursor

  • Fixed Select List
  • Varying Select List
    • SQLDA (Descriptor Area)

Consuming Result Sets returned by Stored Procedures

Reading and Writing IFS Documents

Performance

  • SQL Analysis Feedback Tools in ACS
  • Index Advisor, Index Condenser, Index Evaluator

Price (ex. VAT)

€ 2.460,00 per person

Duration

3 days

Schedule

Please send us a message with the form below

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)

Questions?

Write us and we will contact you to discuss your requirements
contact us