Wow, it's really dangerous. I thought it was a useful feature, but when I use it, the SPL code disappears altogether.
Thank you for informing us.
<example>
$ dbaccess stores_demo -
Database selected.
> create procedure myproc ()
> define a int;
> end procedure;
Routine created.
> create or replace procedure myproc ()
> define b int;
> end procedure;
Routine created.
$ dbschema -d stores_demo -f myproc
DBSCHEMA Schema Utility INFORMIX-SQL Version 14.10.FC1
**
Illegal SPL Routine Entry.
Routine Name: myproc, Owner: informix
Buffer Detail:
------------------------------
SangGyu Jeong
------------------------------
Original Message:
Sent: Wed July 31, 2019 09:20 AM
From: Art Kagel
Subject: Version 14.10 bug
FYI: If anyone is installing version 14.10 for production or even testing purposes, DO NOT USE the new CREATE OR REPLACE PROCEDURE/FUNCTION feature in the 14.10.FC1 release! The procedures so installed will work correctly, however, their source code will not be saved in the database catalog and dbschema will get an error trying to access the sysprocbody table (myschema will not return an error but it will ignore those procedures and functions). It is my understanding that this bug will be fixed in the 14.10.FC2 release due out soon.
------------------------------
Art S. Kagel
------------------------------
#Informix