IBM Support

SQL Mapping General Information

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"}}]

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