Hi All,
I've defined a few functions to DB2.
I can see the entries in SYSIBM.SYSROUTI NES - but where is the source
text stored.
I want to reverse engineer the definitions.
Thanks
Bill 6 4535
wfs wrote: Hi All,
I've defined a few functions to DB2.
Functions with LANGUAGE SQL or an external programming language like C/C++
or Java?
For language SQL functions you might want to look at SYSCAT.ROUTINES .TEXT.
I can see the entries in SYSIBM.SYSROUTI NES - but where is the source text stored.
You should not use the internal, undocumented tables but rather the catalog
view SYSCAT.ROUTINES . The reason being that the internal tables might
change at any time - the external interface is much more stable.
I want to reverse engineer the definitions.
Thanks
Bill
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Thanks
Bill
(I'll check it out when I'm back at work)
"Knut Stolze" <st****@de.ibm. com> wrote in message
news:cp******** **@fsuj29.rz.un i-jena.de... wfs wrote:
Hi All,
I've defined a few functions to DB2.
Functions with LANGUAGE SQL or an external programming language like C/C++ or Java?
For language SQL functions you might want to look at SYSCAT.ROUTINES .TEXT.
I can see the entries in SYSIBM.SYSROUTI NES - but where is the source text stored.
You should not use the internal, undocumented tables but rather the catalog view SYSCAT.ROUTINES . The reason being that the internal tables might change at any time - the external interface is much more stable.
I want to reverse engineer the definitions.
Thanks
Bill
-- Knut Stolze Information Integration IBM Germany / University of Jena
wfs wrote: Thanks
Bill
(I'll check it out when I'm back at work)
Oops, I just saw that you're on z/OS - things might be different there.
--
Knut Stolze
Information Integration
IBM Germany / University of Jena
On 2004-12-17, Knut Stolze scribbled: wfs wrote:
Thanks
Bill
(I'll check it out when I'm back at work)
Oops, I just saw that you're on z/OS - things might be different there.
I've got access to a DB2 z/OS instance (v7.1.1), and from what I can
see the catalog tables are considerably different to UDB:
* The SYSCAT schema doesn't exist (well, I can see one, but there's
only one table in it called PROCEDURES).
* In the SYSIBM schema, there is a SYSROUTINES tables but I can't see
any columns which contain the source text (there's things like
JAVA_SIGNATURE, PARM_SIGNATURE, lots of PARMn columns, REMARKS, RUNOPTS
and EXTERNAL_NAME, but no TEXT column).
I've had a look at some of the other tables in the SYSIBM schema
(unfortunately I don't have SELECT access on all of them), but I think
you might be out of luck on this one.
Dave.
--
Cogito cogito ergo cogito sum
-- Ambrose Bierce
Hi All,
The procedure definition doesn't appear to be stored in
SYSIBM.SYSROUTI NES, just parts of the definition.
If I use BMC, it displays the function as I defined it.
CREATE FUNCTION AAA.WFS_S_1
(X FLOAT)
RETURNS SYSIBM.DOUBLE
SPECIFIC AA.WFS_S_1
LANGUAGE SQL
DETERMINISTIC
CALLED ON NULL INPUT
CONTAINS SQL
EXTERNAL ACTION
RETURN
SIN(X)/COS(X)
Maybe I'll count all the rows in all catalog tables, create a new
function, count all rows again, and see which ones have changed.....
Bill
"Dave Hughes" <da*********@wa veform.plus.com > wrote in message
news:xn******** ********@usenet .plus.net... On 2004-12-17, Knut Stolze scribbled:
wfs wrote:
Thanks
Bill
(I'll check it out when I'm back at work)
Oops, I just saw that you're on z/OS - things might be different there.
I've got access to a DB2 z/OS instance (v7.1.1), and from what I can see the catalog tables are considerably different to UDB:
* The SYSCAT schema doesn't exist (well, I can see one, but there's only one table in it called PROCEDURES). * In the SYSIBM schema, there is a SYSROUTINES tables but I can't see any columns which contain the source text (there's things like JAVA_SIGNATURE, PARM_SIGNATURE, lots of PARMn columns, REMARKS, RUNOPTS and EXTERNAL_NAME, but no TEXT column).
I've had a look at some of the other tables in the SYSIBM schema (unfortunately I don't have SELECT access on all of them), but I think you might be out of luck on this one.
Dave. -- Cogito cogito ergo cogito sum -- Ambrose Bierce
Hello,
in DB2 z/OS V7.1 there are two additional catalog tables containing the
information you are looking for:
SYSIBM.SYSROUTI NES_SRC
SYSIBM.SYSROUTI NES_OPTS
If you can't find them, your system is not V7.1, or your system admin did
not the complete installation/migration.
Cheers - Walter.
"wfs" <wf**@optonline .net> schrieb im Newsbeitrag
news:ko******** *********@fe11. lga... Hi All,
I've defined a few functions to DB2.
I can see the entries in SYSIBM.SYSROUTI NES - but where is the source text stored.
I want to reverse engineer the definitions.
Thanks
Bill
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David MacQuigg |
last post by:
I'm not getting any feedback on the most important benefit in my
proposed "Ideas for Python 3" thread - the unification of methods and
functions. Perhaps it was buried among too many other less important
changes, so in this thread I would like to focus on that issue alone.
I have edited the Proposed Syntax example below to take out the...
|
by: Anthony Baxter |
last post by:
To go along with the 2.4a3 release, here's an updated version of
the decorator PEP. It describes the state of decorators as they
are in 2.4a3.
PEP: 318
Title: Decorators for Functions and Methods
Version: $Revision: 1.34 $
Last-Modified: $Date: 2004/09/03 09:32:50 $
Author: Kevin D. Smith, Jim Jewett, Skip Montanaro, Anthony Baxter
|
by: Sue |
last post by:
After finishing up my first quarter JavaScript on 12/12/03, I decided
to improve character checking on my project. In my project I only had
to do very basic validation. Therefore, I only had one function to
verify the name fields, age, email and gender.
My question is: if I create a function for each field like the code
below, what would be...
|
by: BlueDragon |
last post by:
The place where I work is moving to MS SQL Server from Lotus Notes. I
have done a lot of coding in Lotus Notes, and have, I suppose,
intermediate skills in basic SQL -- queries, insert, updates, table
design, etc. I have a couple of questions, however. First, stored
procedures vs. functions. In my world, a function is a body of code
that...
|
by: Martin Johansen |
last post by:
take the function:
char f(){
return(-1);
}
f is the function pointer, i know how it is used to call a function.
But, what exactly does the pointer point to?
Where is the return value stored?
| |
by: Mikhail Teterin |
last post by:
Hello!
I'd like to have a variable of a pointer-to-function type. The two possible
values are of type (*)(FILE *) and (*)(void *). For example:
getter = straight ? fgetc : gzgetc;
nextchar = getter(file);
What type should I give to `getter' so that the compiler does not issue
|
by: Alan Silver |
last post by:
Hello,
I have spent ages trawling through Google, looking for information about
global functions in ASP.NET and I'm still not clear about the best way
to go about this (or not).
I am writing a site that will be for members only. They will have to log
in to gain access to any of the pages. I am holding the user information
in an XML file...
|
by: Liam.M |
last post by:
hey guys,
I have one last problem to fix, and then my database is essentially
done...I would therefore very much appreciate any assistance anyone
would be able to provide me with.
Currently I have set up a Query to show only records that meet a
certain criteria...therefore excluding all of the records that do not
meet this criteria (just for...
|
by: Lauren Quantrell |
last post by:
I use the code below to generate a text file containing every stored
procedure and view in my SQL Server backend database, but I can't
figure out how to generate text of the User Defined Functions.
I see I can reference: SQLDMO.UserDefinedFunction
But can't find any way to reference dbs.<user defined functions>
Any help is greatly...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |