Welcome to the IBM Community, a place to collaborate, share knowledge, & support one another in everyday challenges. Connect with your fellow members through forums, blogs, files, & face-to-face networking.
Skip to main content (Press Enter).
Skip auxiliary navigation (Press Enter).
Data Management Global
Db2 (On Premises and Cloud)
Db2 Early Access Program (EAP) Forum
Db2 for z/OS
Db2 Tools for z/OS
Integrated Analytics Systems
Netezza Performance Server
Open Source Offerings
Upcoming Data Management Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Post to Forum
Share a Resource
Share Your Expertise
Blogging on the Community
Connect with Data Management Users
All IBM Community Users
Community Front Porch
IBM Cloud Support
IBM Technology Zone
IBM Data Management Community
Connect with Db2, Informix, Netezza, open source, and other data experts to gain value
from your data, share insights, and solve problems
Join / Log in
Skip main navigation (Press Enter).
User Group Tag Test
sort by most recent
sort by thread
Question on sysprocedures
Tue 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...
Tue July 12, 2022 07:51 PM
Mark: See my notes below inline with your post: I've got a couple of questions about th...
Wed 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 ...
Thu 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...
Thu July 14, 2022 08:14 AM
created and also last updated/compiled! ------------------------------ Art S. Kagel, President ...
Thu July 14, 2022 09:48 AM
Since there is no "CREATE OR REPLACE PROCEDURE", we have to drop the procedure and then create ...
Thu 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...
Thu July 14, 2022 11:14 AM
Mark: Actually we do have CREATE OR REPLACE, here: > create or replace PROCEDURE "infor...
Thu July 14, 2022 01:07 PM
Art, Davorin, I've created the RFE . It's ready for your votes. I've only ever created ...
Fri July 15, 2022 02:14 AM
Thanks for the effort Mark, just voted on it. ------------------------------ Davorin Kremen...
Thu July 14, 2022 11:36 AM
dbschema/dbexport would only produce mode 'O', 'D' and 'R' ones, so not those 'd' and 'r' internal ...
Thu July 14, 2022 01:03 PM
Andreas, I believe you are correct about it excluding the 'o', 'd', and 'r' routines, but that's ...
Thu July 14, 2022 01:10 PM
Sounds like these are procedures from a datablade. These are not standard, at least not ...
Thu July 14, 2022 01:23 PM
Marcus, You may be correct about it being related to a datablade. I do not recall installing a...
Thu 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...
Thu July 14, 2022 04:31 PM
Hence my thought that dbexport/dbschema should not include those routines in their output. ...
Thu July 14, 2022 01:57 PM
Marcus: Yes, those are from an auto-installed Bladelet that is included with Informix, the bin...