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