Previous Topic: IntroductionNext Topic: Open the Inline Code Dialog


How to Add Inline Code Statements Containing ODBC/JDBC/ADO.NET Statements

The Inline Code statement lets you include target-specific source code inline within an action diagram and stored in the model. Instead of maintaining external action block (EAB) code outside the model, you can put that code into Inline Code statements in an action diagram and store them within the model. The Inline Code statement lets you add custom code in native target languages (such as C or COBOL) or SQL statements which may be database specific or non-specific.

This document includes tips and best practices that will help you add inline code statements targeting ODBC/JDBC/ADO.NET statements. But this is not an exhaustive list of all possible scenarios.

How to Build an Action Diagram Containing Inline Code Statements

Follow these steps:

  1. Open the Inline Code Dialog.
  2. Inline Code Statements with ODBC/JDBC/ADO.NET.
    1. Declare Variables.
    2. Construct the ODBC/JDBC Statements.
    3. Execute SQL Statement.
    4. Retrieve Data.
    5. Clean-up Resources.