SQL_CommunicationsArea class | QSYS API Reference Guide
Estimated reading time: 2 minutes
Implements SQLCA (SQL communications area)
Namespace: ASNA.QSys.Runtime.JobSupport Assembly: ASNA.QSys.Runtime.dll
Inheritance: Object
Constructors
| Name | Description |
|---|---|
| SQL_CommunicationsArea(String) | Initializes a new SQL_CommunicationsArea class instance. |
| SQL_CommunicationsArea(String, SqlException) | Initializes a new SQL_CommunicationsArea class instance for the last SQL operation that caused Error condition. |
| SQL_CommunicationsArea(String, Int32, String) | Initializes a new SQL_CommunicationsArea class instance for the last SQL operation. |
| SQL_CommunicationsArea(String, Int32, String, Exception) | Initializes a new SQL_CommunicationsArea class instance for the last SQL operation that caused an Error condition. |
SQL_CommunicationsArea(String)
Initializes a new SQL_CommunicationsArea class instance.
SQL_CommunicationsArea(String)
Parameters
| Type | Parameter name | Description |
|---|---|---|
| String | cmdText | The SQL command. |
SQL_CommunicationsArea(String, SqlException)
Initializes a new SQL_CommunicationsArea class instance for the last SQL operation that caused Error condition.
SQL_CommunicationsArea(String, SqlException)
Parameters
| Type | Parameter name | Description |
|---|---|---|
| String | cmdText | The SQL command. |
| SqlException | sqlException | The Exception thrown by the .NET SQL Engine. |
SQL_CommunicationsArea(String, Int32, String)
Initializes a new SQL_CommunicationsArea class instance for the last SQL operation.
SQL_CommunicationsArea(String, Int32, String)
Parameters
| Type | Parameter name | Description |
|---|---|---|
| String | cmdText | The SQL command. |
| Int32 | iSeriesCode | The resulting Code as defined by IBM i. |
| String | iSeriesState | The resulting State as defined by IBM i. |
SQL_CommunicationsArea(String, Int32, String, Exception)
Initializes a new SQL_CommunicationsArea class instance for the last SQL operation that caused an Error condition.
SQL_CommunicationsArea(String, Int32, String, Exception)
Parameters
| Type | Parameter name | Description |
|---|---|---|
| String | cmdText | The SQL command. |
| Int32 | iSeriesCode | The resulting Code as defined by IBM i. |
| String | iSeriesState | >The resulting State as defined by IBM i. |
| Exception | e | >The Exception thrown by the .NET SQL Engine. |
Properties
| Type | Name | Description |
|---|---|---|
| Exception | SQL_Exception | Gets or Sets the .NET equivalent Exception thrown by the SQL Engine during execution of last SQL operation. |
| Int32 | SQLCOD | Gets or sets the the SQL return code: 0 = successful execution, positive = successful execution but with warnings, negative = error condition. |
| Int32 | SQLCODE | SQLCOD alias added to RPG ILE. |
| String | SqlCommandText | Gets or Sets the SQL command text used in the last SQl operation. |
| String | SQLSTATE | SQLSTT alias added to RPG ILE. |
| String | SQLSTT | Gets or Sets the result of SQL Procedure execution. The Message or Code uses a 5 character numeric value. |