United States English English IBM® Site map IBM IBM Support Check here to start a new keyword search. Resolving the problem Make sure that the table exists at the data source and consider the rules that apply to the owner value on fully qualified object names. You can remove the working files and tables by explicitly running the command archecker -DX or by using the -d option when you run the next archecker table-level restore command. These working tables refer to acu_ tables in the sysutils database that are created during an archecker table-level restore. https://books.google.com/books?id=eprEAgAAQBAJ&pg=PA116&lpg=PA116&dq=informix+error+206+odbc&source=bl&ots=6UxjfUgza3&sig=AdhhgBJYnOBCUetH1Dz_44q5QG4&hl=en&sa=X&ved=0ahUKEwjp3NLOzt7PAhVJ44MKHZozAhoQ6AEIHjAA
Example: Owner value as specified in SQL statement Owner value used by the data source ANSI database Non-ANSI database "Valau" "Valau" "Valau" Valau "VALAU" "valau" not specified "informix" "scott" In this Document information More support for: Informix Tools Informix Enterprise Gateway Manager Software version: 1.0, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9, 3.0, If the database logging mode is non-ANSI, convert the original owner to lower-case and sent it as a quoted value. 3.
Symptom Archecker table level restore returns ERROR: -206: The specified table (informix.ext_tlr_1) is not in the database. If the database logging mode is a non-ANSI database, do not send an owner value. If the original statement contains the owner, but the owner is not in between quotes, the following conditions apply: If the database logging mode is an ANSI database, convert the original In the example, the egmdba utility might have been used to map the informix user to the datasource user scott.
Symptom You might get Errors -206 and -111 when referring to a database object (table, view, synonym) using a fully qualified name with IBM Informix Enterprise Gateway Manager™ (EGM) in SELECT, If you do not specify the owner, the following conditions apply: If the database logging mode is an ANSI database, send the UNIX user ID as a quoted value. Cause Errors -206 and -111 indicate the object does not exist in the remote target. To construct the fully qualified name, the following rules apply: 1.
Watson Product Search Search None of the above, continue with my search Archecker table level restore returns ERROR: -206: The specified table (informix.ext_tlr_1) is not in the database Technote (troubleshooting) Problem(Abstract)