Message Image

Skip main navigation (Press Enter).

Informix

View Only

Expand all | Collapse all

Question on sysprocedures

Mark CollinsTue July 12, 2022 06:25 PM

Informix 14.10.FC7W1 on RHEL 8.6 I've got a couple of questions about the sysprocedures table. Fir...

Art KagelTue July 12, 2022 07:51 PM

Mark: See my notes below inline with your post: I've got a couple of questions about th...

Mark CollinsWed July 13, 2022 06:30 PM

Hi Art, Thanks for the info. I won't lie, it's disappointing that there is no way to positively ...

Davorin KremenjasThu July 14, 2022 02:38 AM

Would be nice to have a created attribute in sysprocedures too, see if you can sneak it into th...

Art KagelThu July 14, 2022 08:14 AM

created and also last updated/compiled! ------------------------------ Art S. Kagel, President ...

Mark CollinsThu July 14, 2022 09:48 AM

Since there is no "CREATE OR REPLACE PROCEDURE", we have to drop the procedure and then create ...

Mark CollinsThu July 14, 2022 10:25 AM

I see now that they did sneak in a new OR REPLACE clause on the CREATE FUNCTION / CREATE PROCE...

Art KagelThu July 14, 2022 11:14 AM

Mark: Actually we do have CREATE OR REPLACE, here: > create or replace PROCEDURE "infor...

Mark CollinsThu July 14, 2022 01:07 PM

Art, Davorin, I've created the RFE . It's ready for your votes. I've only ever created ...

Davorin KremenjasFri July 15, 2022 02:14 AM

Thanks for the effort Mark, just voted on it. ------------------------------ Davorin Kremen...

Andreas LegnerThu July 14, 2022 11:36 AM

dbschema/dbexport would only produce mode 'O', 'D' and 'R' ones, so not those 'd' and 'r' internal ...

Mark CollinsThu July 14, 2022 01:03 PM

Andreas, I believe you are correct about it excluding the 'o', 'd', and 'r' routines, but that's ...

Marcus HaarmannThu July 14, 2022 01:10 PM

Sounds like these are procedures from a datablade. These are not standard, at least not ...

Mark CollinsThu July 14, 2022 01:23 PM

Marcus, You may be correct about it being related to a datablade. I do not recall installing a...

Paul WatsonThu July 14, 2022 01:40 PM

With blades you can also get caught if the path has changed, very common with TS when the b...

Mark CollinsThu July 14, 2022 04:31 PM

Hence my thought that dbexport/dbschema should not include those routines in their output. ...

Art KagelThu July 14, 2022 01:57 PM

Marcus: Yes, those are from an auto-installed Bladelet that is included with Informix, the bin...