Natural System Error Messages 3701-3750

NAT3739: SQLDISCONNECT not allowed while a transaction is open.

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.

NAT3740: Syntax error found in SQLDISCONNECT statement.

Text
Syntax error found in SQLDISCONNECT statement.
Expl.
A syntax error was detected in an SQLDISCONNECT statement.
Actn.
Correct the SQLDISCONNECT statement.

NAT3741: Already connected to SQL database.

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.

NAT3742: Syntax error found in SQLCONNECT statement.

Text
Syntax error found in SQLCONNECT statement.
Expl.
A syntax error was detected in an SQLCONNECT statement.
Actn.
Correct the SQLCONNECT statement.

NAT3743: SQL date/time conversion failed.

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.

NAT3744: IF NO RECORDS not allowed in SELECT with SCROLL and GIVING.

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 SQLCODE 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.