IBM Support

You set a trap on SQL error -201, but it traps the -201 error even when your syntax is correct.

Troubleshooting


Problem

You are trapping for syntax errors (SQL -201). You execute the CREATE DISTINCT TYPE statement or the CREATE DATABASE statement. The engine traps on a -201 error, indicating a problem with SQL syntax, but there are no syntax errors in the statement.

Symptom

You set a trap for a syntax error on your instance with the following command:

    onmode -I 201

You execute the CREATE DISTINCT TYPE statement. The online log shows there is an assert failure and an assert fail file is created. However, the SQL statement succeeds and the -201 error is not printed to the computer terminal.

You are using IDS 11.5 or a later version. You experience the same problem executing CREATE DATABASE.

You can determine the problem by examining the data for the failed session in the assertion failure file. Expect to see the information as follows, depending on which SQL statement generates the assertion:

  • You execute CREATE DISTINCT TYPE

    The failed session data in the assertion failure file shows CREATE DISTINCT TYPE in the SQL Stmt type field and -201 in the SQL ERR field. The SQL statement data shows your statement and a CREATE DOMAIN statement:


    •    Current SQL statement :
        create distinct type mytype as int

      Last parsed SQL statement :
        create domain tmpdom mytype


  • You execute CREATE DATABASE



    • The failed session data in the assertion failure file shows CREATE DISTINCT TYPE in the SQL Stmt type field and -201 in the SQL ERR field. The SQL statement data shows the following statements:
      Current SQL statement :
        create distinct type informix.IDSSECURITYLABEL as varchar(128);

      Last parsed SQL statement :
        create domain tmpdom idssecuritylabel

    [{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.5;11.7;12.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

    Log InLog in to view more of this document

    This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

    Document Information

    Modified date:
    29 September 2018

    UID

    swg21375543

    Page Feedback