Remote 3-part name support on ASSOCIATE LOCATOR
Two SQL programming topics that are very popular are:
- Using external or SQL procedures to deploy modularized application logic.
- Using implicit or explicit 3-part RDB name support to seamlessly access remote databases.
Prior to this enhancement, programmers were unable to consume result sets created on behalf of a remote procedure CALL.
With this enhancement, the ASSOCIATE LOCATOR SQL statement is able to target RETURN TO CALLER style result sets created by a procedure that ran on a remote database due to a remote 3-part CALL.
This style of programming is an alternative to the INSERT with remote subselect statement.
- Application requestor (AR) target must be IBM i 7.1 or higher
- Application server (AS) target must be IBM i 6.1 or higher
Was this topic helpful?
15 January 2020