INFORMIX SERVER / 5725A3900 / E10 - 

dbimport is throwing 201 error while importing a
procedure/function with create or replace procedure/function
syntax.


create or replace procedure "informix".sample_proc2 ( percent
INT,unit INT,grade CHAR )
.....
end procedure;

create or replace procedure "informix".sample_proc4 ( percent
INT,unit INT,grade CHAR ) returning INTEGER
......
RETURN 0;
end procedure;

create or replace function "informix".sample_func6 ( percent
INT,unit INT,grade CHAR ) returning INTEGER
...........
RETURN 0;
end function;

dbimporting these create or replace procedure/function failed
with 201 error.

create or replace function "informix".sample_func6 ( percent
INT,unit INT,grade CHAR ) returning INTEGER

UPDATE customer SET fname="kkkk" where customer_num=104;
*** prepare sqlobj
201 - A syntax error has occurred.

When changed the syntax from create or replace function to
create function it worked.
Same issue can be seen with create or replace procedure as well.

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC11.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC11.                       *
****************************************************************

****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC11.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC11.                       *
****************************************************************

Fixed in Informix Server 14.10.xC11.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.03.2024
12.06.2024
12.06.2024