SQLSTATUS


The 4GL command SQL and TRANSACTION return a SQLSTATUS() for every command and can contain the following values:

Table 32. SQLSTATUS

ValueDescriptionAdditional Information
0Command processed successfully.All OK.
10201Already connected.Already connected to a data source. Data source remains open.
10202Can not close connection.No connection to close. Connection already closed or was never opened.
10203Error in 3rd party product using 'ACTION' statement.Refer to log files for more details.
10204Error executing 'ACTION' sql statement.Refer to log files for more details.
10205Error in 3rd party product using DataModel query.Refer to log files for more details.
10206Error executing DataModel query.Refer to log files for more details.
10207Error in 3rd party product using Transaction.Refer to log files for more details.
10208Error executing Transaction.Refer to log files for more details.
10209Can not load DataSource object.Validate application and resolve errors.
10210Can not open connection.Check connection configuration.
10211Can not open data source.Check data source object and connection configuration.
10212Can not close data source.Data Source already closed or was never opened.
10213Can not close connection.Connection already closed or was never opened.
10298Feature not implemented yet.Please contact support about the status of this feature.
10299Unknown error.No additional info. Please contact support.