IBM Support

Errors -206 and -111 attempting to access database objects with Enterprise Gateway Manager

Troubleshooting


Problem

This document discusses possible causes of errors -206 and -111 while attempting to execute a select with full qualified name, create a synonym or view .

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, CREATE VIEW, CREATE SYNONYM statements.


206: The specified table (datasource@egmserver:user.TABLE) is not in the database.
111: ISAM error:  no record found.

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. If the owner is in between quotes in the original statement, send the owner as specified.

2. 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 owner to uppercase and send it as a quoted value.
  • If the database logging mode is non-ANSI, convert the original owner to lower-case and sent it as a quoted value.

3. 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.
  • If the database logging mode is a non-ANSI database, do not send an owner value.


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 table, informix is the Operating System user that is used to connect to the Gateway Manager. scott is the user used by informix at the data source. In the example, the egmdba utility might have been used to map the informix user to the datasource user scott.

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.

[{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Informix Enterprise Gateway Manager","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF026","label":"Reliant UNIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"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;4.0;4.1;4.2;5.1;6.0;7.2;7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 January 2022

UID

swg21154756

Page Feedback