How to Add Inline Code Statements Containing ODBC/JDBC/ADO.NET Statements › Inline Code Statements with ODBC/JDBC/ADO.NET › Declare Variables

Declare Variables

The following are the types of variables:

• Variables specific to data access
• Host variables

Follow these steps:

• Declare variables specific to data access.

  They facilitate executing ODBC/JDBC statements. Use the Global Variable Declarations section of the inline code statement.

  The Global Variable Declarations fields lets you specify any variables that you need to define globally within the action diagram that may be used by multiple Inline Code statements.

  • C/ODBC

    /* To execute SQL (INSERT) query */
    static TIHSTMT create_stmt = {SQL_NULL_HSTMT, NULL};
    static RETCODE ret_code = 0;
    
    /* To execute SQL (SELECT) query*/
    static TIHSTMT read_stmt = {SQL_NULL_HSTMT, NULL};
    static RETCODE ret_code = 0;
    
    /* To execute SQL (UPDATE) query*/
    static TIHSTMT update_stmt = {SQL_NULL_HSTMT, NULL};
    static RETCODE ret_code = 0;
    
    
    

  • C#/ADO.NET

    /* To execute SQL (INSERT) query */
    IAbstractCommand create_cmd;
    IAbstractResultSet create_rs;
    Exception sql_ex = null;
    
    /* To execute SQL (SELECT) query*/
    IAbstractCommand read_cmd;
    IAbstractResultSet read_rs;
    Exception sql_ex = null;
    
    
    /* To execute SQL (UPDATE) query*/
    IAbstractCommand update_cmd;
    IAbstractResultSet update_rs;
    Exception sql_ex = null;
    
    
    

  • JAVA/JDBC

    /* To execute SQL (INSERT) query */
    PreparedStatement create_cmd;
    ResultSet create_rs;
    Exception sql_ex = null;
    
    /* To execute SQL (SELECT) query */
    
    PreparedStatement read_cmd;
    ResultSet read_rs;
    Exception sql_ex = null;
    
    /* To execute SQL (UPDATE) query */
    
    PreparedStatement update_cmd;
    ResultSet update_rs;
    Exception sql_ex = null;
    
    
    

• Declare the host variables.

  They will be used to bind either columns or parameters while constructing the SQL statement. Use either of the declaration sections of the Inline Code statement because no pre-compilation is required to process the ODBC / ADO.NET / JDBC SQL declarations.

  The SQL Declaration field lets you specify any host variables that may be needed by the Inline Code statement especially containing embedded SQL statements. They are collected separately from the Inline Code statement so that they may be included in the EXEC SQL DECLARE section of the generated code. These variables are used with SQL statements to retrieve information from the database or add information to the database. To enable this field, select the SQL option on the dialog.

  Note: Even though you may have entity action views defined in the action diagram, the host variables generated for those views are not accessible to the Inline Code statement.

  • C/ODBC

    static SDWORD hv_number;
    static UCHAR FAR hv_name[31];
    static UCHAR FAR hv_work_phone[17];
    static SQLLEN hvind_work_phone;
    
    

  • C#/ADO.NET

    int hv_number;
    string hv_name;
    string hv_work_phone;
    bool hvind_work_phone;
    
    

  • JAVA/JDBC

    int hv_number;
    String hv_name;
    String hv_work_phone;
    boolean hvind_work_phone;
    
    

  Use the following native data types for declaring host variables corresponding to available GEN types.

  • C/ODBC

• C#/ADO.NET

• JAVA/JDBC