About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
White Papers
Abstract
SQL maps use the SQL (ODBC) File Format on the input side or output side of the map. Maps with the SQL File Format for the input side of the map will retrieve and process data from a database. Maps with the SQL File Format for the output side of the map will add, update, or delete data in the database.
The SQL data format enables you to create a map directly from a database schema, which saves time and ensures that the map is synchronized with the most current version of the database. You can also specify several data sources allowing the map to query or update multiple databases during translation.
Content
This paper will discuss SQL (ODBC) maps and outline general information necessary to complete a SQL map. The paper will also cover the flow of the translator for outbound SQL (ODBC) Maps and how to use the components available with the SQL File Format to design a map to process the result set returned via the SQL statement defined in the map.
The concepts listed in this paper are focused towards outbound SQL maps; however some of the information provided is related to inbound SQL maps.
The concepts discussed in this paper apply to ODBC maps created in Gentran:Server for Windows (GSW) and SQL maps created in B2B Sterling Integrator (B2BSi)
[{"Product":{"code":"SS6UP7","label":"Sterling Gentran:Director"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.4;5.3.1","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6V3G","label":"Sterling Gentran:Server for Microsoft Windows"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6V5U","label":"Sterling Gentran:Server for UNIX"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
More support for:
Sterling Gentran:Director
Software version:
5.4, 5.3.1
Operating system(s):
Windows
Document number:
590477
Modified date:
17 June 2018
UID
swg27022719
Manage My Notification Subscriptions