Execute SQL Statement

How to Add Inline Code Statements Containing ODBC/JDBC/ADO.NET Statements › Inline Code Statements with ODBC/JDBC/ADO.NET › Execute SQL Statement

Execute SQL Statement

You can now type code that are for executing SQL statements.

Follow these steps:

Execute the SQL statement and retrieve the result set, if any. Use the Code section of the inline code statement for this purpose.

C/ODBC

/* To execute SQL (INSERT) query */
ret_code = SQLExecute(create_stmt.hstmt);
ret_code = SQLRowCount(create_stmt.hstmt, &create_count);

/* To execute SQL (SELECT) query */
ret_code = SQLExecute(read_stmt.hstmt);

/* To execute SQL (UPDATE) query */
ret_code = SQLExecute(update_stmt.hstmt);
ret_code = SQLRowCount(update_stmt.hstmt, &update_count);

C#/ADO.NET

/* To execute SQL (INSERT) query */
try {
    …
    create_count = create_cmd.ExecuteNonQuery();
    …
} catch (Exception ex) { sql_ex = ex; }

/* To execute SQL (SELECT) query */
try {
    …
    read_rs = read_cmd.ExecuteQuery();
    …
} catch (Exception ex) { sql_ex = ex; }

/* To execute SQL (UPDATE) query */
try {
    …
    update_count = update_cmd.ExecuteNonQuery();
    …
} catch (Exception ex) { sql_ex = ex; }

JAVA/JDBC

/* To execute SQL (INSERT) query */
try {
    …
    create_cmd.execute();
    create_count = hstmt_cmd.getUpdateCount();
    …
} catch (Exception ex) { sql_ex = ex; }

/* To execute SQL (SELECT) query */
try {
    …
    read_cmd.execute();
    read_rs = hstmt_cmd.getResultSet();
    …
} catch (Exception ex) { sql_ex = ex; }

/* To execute SQL (UPDATE) query */
try {
    …
    update_cmd.execute();
    update_count = hstmt_cmd.getUpdateCount();
    …
} catch (Exception ex) { sql_ex = ex; }

Verify the return code from every TIR or SQL ODBC API yielded. Use try/catch blocks to catch SQL exceptions for both C#/ADO.NET and JAVA/JDBC for further error handling.

The following predicates may be helpful in catching SQL errors:

For successful execution

C/ODBC
```
ODBC_SUCCESSFUL(ret_code)
```

C#/ADO.NET

Globdata.GetDBMSData().GetDBMSManager().WasSuccessful(sql_ex)

JAVA/JDBC

globdata.getDBMSData().getDBMSManager().wasSuccessful(sql_ex)

For data not found on SELECT / UPDATE / DELETE SQL statement execution

C/ODBC
```
ODBC_NOT_FOUND(ret_code)
```

C#/ADO.NET

Globdata.GetDBMSData().GetDBMSManager().WasNoDataFound(sql_ex)

JAVA/JDBC

globdata.getDBMSData().getDBMSManager().wasNoDataFound(sql_ex)

For duplicate data found on INSERT

C/ODBC
```
TiodbcDuplicate(&create_hstmt)
```

C#/ADO.NET

Globdata.GetDBMSData().GetDBMSManager().WasDuplicateFound(IefRuntimeParm2, “IEFDB”, sql_ex)

JAVA/JDBC

globdata.getDBMSData().getDBMSManager().wasDuplicateFound(“IEFDB”, sql_ex)

Propagate the error information to callers using action block runtime global data so that the application sees the failures.

C/ODBC

strcpy(globdata->psmgr_dasg_data.status_flag, fatal_error);
strcpy(globdata->psmgr_dasg_data.last_status, db_error);
TiodbcError(&create_stmt);
longjmp(excp_jumpbuf, TRACE_EXCEPTION);

C#/ADO.NET

Globdata.GetErrorData().SetStatus(ErrorData.LastStatusFatalError);
Globdata.GetErrorData().SetLastStatus(ErrorData.LastStatusDbError);
Globdata.GetErrorData().SetErrorMessage(sql_ex);
throw new ABException();

JVM/JDBC

globdata.getErrorData().setStatus(ErrorData.FATAL_ERROR_FL_LS);
globdata.getErrorData().setLastStatus(ErrorData.DB_ERROR_FL_LS);
globdata.getErrorData().setErrorMessage(sql_ex);
throw new ABException();