Natural System Error Messages 3700-3749

#### Search Results

Search

# Natural System Error Messages 3700-3749

#### NAT3739: SQLDISCONNECT not allowed while a transaction is open.

    Text
    SQLDISCONNECT not allowed while a transaction is open.
    Explanation
    SQLDISCONNECT cannot be executed while a transaction is open.
    Action
    Issue END TRANSACTION or BACKOUT TRANSACTION before executing
    SQLDISCONNECT.

#### NAT3740: Syntax error found in SQLDISCONNECT statement.

    Text
    Syntax error found in SQLDISCONNECT statement.
    Explanation
    A syntax error was detected in an SQLDISCONNECT statement.
    Action
    Correct the SQLDISCONNECT statement.

#### NAT3741: Already connected to SQL database.

    Text
    Already connected to SQL database.
    Explanation
    SQLCONNECT failed, because a connection to an SQL database is
    already established.
    Action
    Close the existing connection with SQLDISCONNECT before
    executing SQLCONNECT.

#### NAT3742: Syntax error found in SQLCONNECT statement.

    Text
    Syntax error found in SQLCONNECT statement.
    Explanation
    A syntax error was detected in an SQLCONNECT statement.
    Action
    Correct the SQLCONNECT statement.

#### NAT3743: SQL date/time conversion failed.

    Text
    SQL date/time conversion failed.
    Explanation
    SQL date/time conversion failed, because the data to be converted
    do not correspond to the date/time conversion mask.
    Action
    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.
    Explanation
    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.
    Action
    Remove either the NO RECORDS FOUND clause or the GIVING clause
    from the SQL statement.