IBM Support

Remote 3-part name support on ASSOCIATE LOCATOR

News


Abstract

Remote 3-part name support on ASSOCIATE LOCATOR

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > Remote 3-part name support on ASSOCIATE LOCATOR

Two SQL programming topics that are very popular are:

  1. Using external or SQL procedures to deploy modularized application logic.
  2. 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.

Requirements:

  1. Application requestor (AR) target must be IBM i 7.1 or higher
  2. Application server (AS) target must be IBM i 6.1 or higher

Example:

image-20200115131358-1

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
15 January 2020

UID

ibm11164538