System i (AS/400, iSeries, i5) Power RPG with SQL

Course Details:

Course code: ISSQE View/Download data sheet (PDF)
Duration: 1 Day Book Course
Price: £395 Return to Courses

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:       

  2017                      
Public schedule Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
Northampton              15      14    
We can run this course at our location or on your site – Please contact us for details

 

Schedule:

2017 / 2018
 
Sep  
Oct  
Nov  
Dec  
Jan  
Feb  
Mar 15
Apr  
May  
Jun 14
Jul  
Aug  
We can run this course at our location or on your site – Please contact us for details

 

Book course:

ISSQE Power RPG with SQL booking form
Please double check this!
Press 'Submit' below to send your reservation to Sierra. We will confirm the booking in due course. Thank you.
Sending