Scott Klement wrote a nice article on this very subject:
Associate membership is free.
Celebrating 10-Years of SQL Performance Excellence
Subject: Updating Windows SQL from ILE RPG
I am trying to update a table that resides on a Windows 2000 SQL Server.
How does one go about this from an ILE RPG program?