| Text | SQLDISCONNECT not allowed while a transaction is open. |
| Expl. |
SQLDISCONNECT cannot be executed while a transaction is open. |
| Actn. |
Issue END TRANSACTION or BACKOUT TRANSACTION before executing SQLDISCONNECT. |
| Text | Syntax error found in SQLDISCONNECT statement. |
| Expl. |
A syntax error was detected in an SQLDISCONNECT statement. |
| Actn. |
Correct the SQLDISCONNECT statement. |
| Text | Already connected to SQL database. |
| Expl. |
SQLCONNECT failed, because a connection to an SQL database is already established. |
| Actn. |
Close the existing connection with SQLDISCONNECT before executing SQLCONNECT. |
| Text | Syntax error found in SQLCONNECT statement. |
| Expl. |
A syntax error was detected in an SQLCONNECT statement. |
| Actn. |
Correct the SQLCONNECT statement. |
| Text | SQL date/time conversion failed. |
| Expl. |
SQL date/time conversion failed, because the data to be converted do not correspond to the date/time conversion mask. |
| Actn. |
Check the mask for SQL date/time conversion which is specified for this DBID. |
| Text | IF NO RECORDS not allowed in SELECT with SCROLL and GIVING. |
| Expl. |
IF NO RECORDS FOUND is not allowed in a SELECT statement with SCROLL and GIVING clause. When using SCROLL and GIVING clauses the application requests to act on the returned SQL code in the GIVING variable. This causes the NO RECORDS FOUND block never to be executed. Therefore the NO RECORDS FOUND clause is useless and not allowed. |
| Actn. |
Remove either the NO RECORDS FOUND clause or the GIVING clause from the SQL statement. |
