Course Details:

Course Outline:

This course is designed for application development staff who need to view, create or modify data in a more flexible way than that afforded by standard RPG operation codes and logic by including standard and dynamic SQL statements.

Pre-requisites:

Delegates should have attended the Access DB2 with SQL (ISSQI) and RPGIV Programming (ISR4P) or RPG/400 Programming (ISRPP) courses prior to attending this course or have the equivalent hands on experience.

Course content:

  Data definition language
    • Creating SQL data store – CREATE TABLE
    • Using Constraints such as: PRIMARY KEY, UNIQUE, FOREIGN KEY, CHECK
    • Changing tables and columns – ALTER
    • Removing SQL objects – DROP
    • Adding Documentation using COMMENT ON & LABEL ON
    • Creating SQL views and indexes – CREATE VIEW, INDEX, ALIAS
    • Performance considerations
    • Catalog and Data Dictionary consideration
    • Data control and security overview
  Including SQL in RPG
    • Pre compilation – and pre-compiler parameters
    • Source code availability and control for Debug
    • Syntax rules to embed SQL in RPG and RPGLE
    • Syntax rules to embed SQL in free-format RPGLE
    • Using host variables
    • SQL return codes
    • Communication area
    • Using SELECT in an RPG program
  Updates with SQL in RPG
    • Using SQL DML to manipulate data from RPG:
        • INSERT INTO
        • UPDATE SET
        • DELETE FROM
    • Maintaining transaction integrity
    • Journaling and Commitment control
    • WHENEVER
    • SET TRANSACTION
  Embedded SQL commands
    • Using a results table – DECLARE CURSOR
    • Scrollable cursors
    • OPEN CURSOR, CLOSE CURSOR
    • Single and multiple row FETCH
    • Updating or Deleting current row
  Dynamic Embedded SQL
    • Execute Immediate
    • Prepare and Execute
    • Using parameter markers to control select structure at run time
    • Prepare with Cursor
    • Open using
    • Variable sequencing at run time
    • SET OPTION

Follow on Courses:

There are no specific follow on courses to this course.

Schedule:       

Schedule:

Book course:

ISSQE Power RPG with SQL booking form

If you are human, leave this field blank.

Company name: *

Your name: *

Your e-mail address: *

Please double check this!

Phone number:

Address:

Commencement date: * Please call or email for details

Purchase order number:

Is this a confirmed or provisional booking: * Please select Confirmed Provisional

Number of delegates: *

Delegate names: *

Please tick the box below to confirm that you agree to the Privacy Policy of Sierra Training.

Checkboxes *

I agree to the privacy policy

Please tick the box below to confirm that you agree to the Terms & Conditions of Sierra Training.

Checkboxes *

I agree to the terms and conditions