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.