top of page

Who knew you could do that with embedded SQL in RPG- Paul Tuohy


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 paoints 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

  • Talking to Watson with Embedded SQL SQL

  • Mastering Multi Row Fetch

  • Handling NULL

  • Dates, Times and Timestamps

bottom of page