› › RFE for Ability to use Variable for Environment, Library Value in SQL Statement

Ability to use Variable for Environment, Library Value in SQL Statement

EXTOL Business Integrator 2.6 - Current functionality

Currently EBI 2.6 users who create SQL Actions must hardcode the library Environment/Library value

  • EXAMPLE: Select SZEDOC from "PRODDTA"."F470371" where SZVR01 = '0718338380'

This is set-up/requirement is not conducive to users who must maintain multiple environments and migrate the ruleset between these environments.

EXTOL Business Integrator 3.1 - Request for Enhancement

Allow users to pass a variable value into the SQL Environment/Library value. A request for enhancement in EXTOL Business Integrator 3.1 has been made to EXTOL.

  • EXAMPLE: Select SZEDOC from "&VARIABLE"."F470371" where SZVR01 = '0718338380'

EXTOL Business Integrator 2.6 - Workaround


Extol Business Integrator (EBI) 3 SQL statement workaround for Library/Environment variable screenshot




By: on