Informix - Problem description
Problem IT17265 | Status: Closed |
SYNTAX ERROR -201 IF RUN INSERT INTO WITH THE OWNER IDENTIFIER OF THE RESULT TABLE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The INSERT INTO clause does not work with authorization identifier of the owner of the result table and gets error -201: select * from systables into standard 'informix'.my_table; 201: A syntax error has occurred. The same select works without owner identifier of the result table. As it is described in the documentation you can identify the name of the owner of the result table in the INSERT INTO clause: https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ib m.sqls.doc/ids_sqs_0159.htm | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.09.2016 10.07.2017 10.07.2017 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC9 | |
Problem solved according to the fixlist(s) of the following version(s) |