At 10:39 16/11/00 +0100, Zeugswetter Andreas SB wrote:
>
>Has anybody had time to look at how this is done in DB/2, Oracle ? Philip ?
>
Don't know about Oracle or DB2, but Dec/RDB has:
Create Function <name1> [Stored Name Is <name2>] (...) Returns <type>; [ External Name <name3> ] [ Location
<libfile>] [Language {ADA|C|Fortran|Pascal|General] General Parameter Style [Not] Variant
where <name1> is the function name, the 'Stored Name' relates to
cross-schema functions, the 'External Name' is the name of the entry point,
'location' is the file location and the 'Variant' part corresponds to our
'iscacheable' attribute.
Functions themselves require no special coding. This is pretty much what I
think 'Language C' does for us now - just calling a shared library. There
is definitely a case to be made for coninuing to support standard calls to
general libraries unmodified. In Tom's current proposal, I think this will
be the case if there is no 'function-info' function available.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/