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

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
------------------------------

Yes, even if the procedure's source was previously there in the database, it is wiped out. 

Found out the hard way when I was testing the new myschema feature to generate procedure and function definitions using CREATE OR REPLACE instead of just CREATE. I used it to generate code for every proc and func in one of my test database which included some datablade code. When I tested the generated script, all of the source was gone, including built-in procs and funcs!

Obviously it is a high priority fix for 14.10.FC2

------------------------------
Art Kagel
------------------------------

Original Message:
Sent: Thu August 01, 2019 02:45 AM
From: SangGyu Jeong
Subject: Version 14.10 bug

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
------------------------------

No Patch Scheduled before FC2 ?

------------------------------
[eric] [Verceletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
------------------------------

Original Message:
Sent: Thu August 01, 2019 10:59 AM
From: Art Kagel
Subject: Version 14.10 bug

Yes, even if the procedure's source was previously there in the database, it is wiped out. 

Found out the hard way when I was testing the new myschema feature to generate procedure and function definitions using CREATE OR REPLACE instead of just CREATE. I used it to generate code for every proc and func in one of my test database which included some datablade code. When I tested the generated script, all of the source was gone, including built-in procs and funcs!

Obviously it is a high priority fix for 14.10.FC2

------------------------------
Art Kagel
------------------------------


Original Message:
Sent: Thu August 01, 2019 02:45 AM
From: SangGyu Jeong
Subject: Version 14.10 bug

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

I am no aware of any interim patch scheduled before .FC2.

------------------------------
Art Kagel
------------------------------

Original Message:
Sent: Wed August 14, 2019 10:26 AM
From: Eric Vercelletto
Subject: Version 14.10 bug

No Patch Scheduled before FC2 ?

------------------------------
[eric] [Verceletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
------------------------------


Original Message:
Sent: Thu August 01, 2019 10:59 AM
From: Art Kagel
Subject: Version 14.10 bug

Yes, even if the procedure's source was previously there in the database, it is wiped out. 

Found out the hard way when I was testing the new myschema feature to generate procedure and function definitions using CREATE OR REPLACE instead of just CREATE. I used it to generate code for every proc and func in one of my test database which included some datablade code. When I tested the generated script, all of the source was gone, including built-in procs and funcs!

Obviously it is a high priority fix for 14.10.FC2

------------------------------
Art Kagel


Original Message:
Sent: Thu August 01, 2019 02:45 AM
From: SangGyu Jeong
Subject: Version 14.10 bug

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

​Please be Aware that this bug might influence the Migration from 12.10 to 14.10FC1  .
We lost a couple of procedures during this Migration and had to re-create it afterwards

------------------------------
Rainer von Bongartz
------------------------------

Folks,


14.10 .xC2 has been released a few days ago. A friend has QA'ed successfully the fix of 'lost procedures' issue.
I am not sure you can find it everywhere it should be ( Passport Advantage, Fix Central etc.. I have been told it was not there yet) but I know you can find it there 

http://bit.ly/ifmxdev

------------------------------
[eric] [Verceletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
------------------------------

Original Message:
Sent: Tue September 17, 2019 10:06 AM
From: Rainer von Bongartz
Subject: Version 14.10 bug

​Please be Aware that this bug might influence the Migration from 12.10 to 14.10FC1  .
We lost a couple of procedures during this Migration and had to re-create it afterwards

------------------------------
Rainer von Bongartz
------------------------------

I downloaded Informix 14.10.FC2 from the IBM Software Access Catalog.

In an environment running version 14.10, Informix should be patched as soon as possible.

------------------------------
SangGyu Jeong
Software Engineer
Infrasoft
Seoul Korea, Republic of
------------------------------

Original Message:
Sent: Tue September 17, 2019 10:44 AM
From: Eric Vercelletto
Subject: Version 14.10 bug

Folks,


14.10 .xC2 has been released a few days ago. A friend has QA'ed successfully the fix of 'lost procedures' issue.
I am not sure you can find it everywhere it should be ( Passport Advantage, Fix Central etc.. I have been told it was not there yet) but I know you can find it there 

http://bit.ly/ifmxdev

------------------------------
[eric] [Verceletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
------------------------------


Original Message:
Sent: Tue September 17, 2019 10:06 AM
From: Rainer von Bongartz
Subject: Version 14.10 bug

​Please be Aware that this bug might influence the Migration from 12.10 to 14.10FC1  .
We lost a couple of procedures during this Migration and had to re-create it afterwards

------------------------------
Rainer von Bongartz

------Original Message------

Folks,


14.10 .xC2 has been released a few days ago. A friend has QA'ed successfully the fix of 'lost procedures' issue.
I am not sure you can find it everywhere it should be ( Passport Advantage, Fix Central etc.. I have been told it was not there yet) but I know you can find it there 

http://bit.ly/ifmxdev

------------------------------
[eric] [Verceletto] []
[Founder]
[kandooerp.org]
[Pont l'Abbé] [France]
[+33 626 52 50 68]
------------------------------

#Informix