You can write to and read from the Oracle files within the same program that is calling the stored procedure. It is a simple stored procedure with no paramaters or result sets and uses the SQL_RunSPBasic function. For example: To clear some Oracle files before inserting data from the iSeries:
* call CLEAR store procedure c eval rtn = SQL_RunSPBasic(SQL_Socket: c 'ClearOrders')
Still have questions? We can help. Submit a case to Technical Support.