Gamache Consulting
About Us Contact Us Links Search
   
  Application Development for iSeries and Microsoft platforms
Home
Microsoft
Web Development
AS/400 - iSeries
Tradesphere from Vastera
RSP (RPG Server Pages) Tips
Excel Tips
System i Tips
SQL Tips
Live Support
DVCUG Sessions

Visit the Delaware Valley Computer Users Group for more great sessions on iSeries topics.

 

SQL
We have been using SQL for a number of years on the iSeries.  We use it to replace IBM's Query/400 tool most of the time and use the Query Manager product and the RUNSQLSTM command extensively to do fast one-time updates of database files.

This is probably one of the most under-utilized application development tools on the iSeries and one that has the most potential payback in terms of simplifying application development.  It can also greatly increase the maintainability of programs written in RPG.

Fred's Delaware Valley Computer Users Group December Seminar sessions -

bullet Embedding SQL in RPG - download a zipped copy of the Powerpoint here.
bulletDownload the Sample source code here
bullet Introduction to Stored Procedures - download a zipped copy of the Powerpoint here.