illegal procedure entry

Posted in 1999

daviddnv@my-deja.com — Thu, 11 Nov 1999 17:03:13 GMT — source: Informix-list mailing list archive (1991-1998)

Hi everyone, I'm running dbschema -d database_name to get the schema of the database to load it to another instance. When I run it I get a illegal procedure entry for some of the stored procedures. The procedures are there an are able to be ran, but I can not get a schema of them. Any ideas on why this happens. Any comments would be appreciated. Thanks in advance Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to daviddnv@my-deja.com

Art S. Kagel — Thu, 11 Nov 1999 14:50:19 -0500 — source: Informix-list mailing list archive (1991-1998)

daviddnv@my-deja.com wrote: > > Hi everyone, > I'm running dbschema -d database_name to get the schema of the > database to load it to another instance. When I run it I get a illegal > procedure entry for some of the stored procedures. The procedures are > there an are able to be ran, but I can not get a schema of them. Any > ideas on why this happens. Any comments would be appreciated. I've never seen this behavior myself. Have you tried to use my utility: myschema.ec which is in the IIUG Software Repository in the package utils2_ak. You may have better luck with that. It provides greatly enhanced dbschema support and only uses system catalog and SMI tables so if you can see the procedure it should be able to report its declaration. Art S. Kagel

↪ replying to daviddnv@my-deja.com

mars1972@my-deja.com — Thu, 11 Nov 1999 20:11:34 GMT — source: Informix-list mailing list archive (1991-1998)

In article <80esse$1vs$1@nnrp1.deja.com>, daviddnv@my-deja.com wrote: > Hi everyone, > I'm running dbschema -d database_name to get the schema of the > database to load it to another instance. When I run it I get a illegal > procedure entry for some of the stored procedures. The procedures are > there an are able to be ran, but I can not get a schema of them. Any > ideas on why this happens. Any comments would be appreciated. > Thanks in advance > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Are you getting an error number or anything? I had a problem with dbschema a year ago or so where it would lock up if it tried to create the schema for a procedure with a single quote inside of a comment. (That was a pain to find, I can tell you...) -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.