Problem use the function Ingres existed in UDF

[zhaoxu710]

Hi all,


I'm working on User Define Function.
When I want to create a new function, how can I call(use) the function which already existed in my define function.

For exemple:
.....
II_STATUS
my_function(
II_SCB *scb,
II_DATA_VALUE *p1,
II_DATA_VALUE *rdv
){
string field1;
....
/*call the function*/
replace(field1, ':', '$')
....
}
....
Please give me more detail explain.


Thx

[zhaoxu710]

Have some ideas? No one read? Or my question isn't clear? Plz.

[kschendel]

You have to call the ADF function that implements the SQL function you want to call. So for example if you wanted to call an integer coercion int4(xxx), you would have to call the adu_1int_coerce ADF function from your UDF, and pass it the necessary DB_DATA_VALUE (II_DATA_VALUE) and ADF_SCB (II_SCB) pointers.

[zhenchen17]

Originally Posted by zhaoxu710

Have some ideas? No one read? Or my question isn't clear? Plz.

You'd better read OME.pdf first in install_dir/ingres/file/. This pdf explains how OME and UDF works.
Also you could find some examples in install_dir/ingres/demo/udadts/. You could write your own udts according to these samples...

Chen zhen

[zhaoxu710]

Thx for your answer.
How I could find the relationship between every ADF function and function ingres?
Is there some doc or table to describ?

[zhaoxu710]

Originally Posted by zhenchen17

You'd better read OME.pdf first in install_dir/ingres/file/. This pdf explains how OME and UDF works.
Also you could find some examples in install_dir/ingres/demo/udadts/. You could write your own udts according to these samples...

Chen zhen

Hi CHEN ZHEN,

Thanks for your advice!

[zhenchen17]

Originally Posted by zhaoxu710

Thx for your answer.
How I could find the relationship between every ADF function and function ingres?
Is there some doc or table to describ?

Do you mean a list of all SQL functions?
A pdf named sql .pdf (SQL reference ) in the same dir introduces all SQL functions.

Chen zhen

[zhaoxu710]

Originally Posted by zhenchen17

Do you mean a list of all SQL functions?
A pdf named sql .pdf (SQL reference ) in the same dir introduces all SQL functions.

Chen zhen

I have send a message to you.
And I have find the document, not in the path you have proposed.
But the exemples still can't be finded.

Zhao Xu

[kschendel]

$ING_SRC/common/adf/adg/fi_defn.txt

is the definitive mapping between function instances and ADF calls. adgoptab.roc in the same directory will tell you the mapping between function names and function operator codes used in fi_defn.txt.

[schma01]

I just updated the following wiki page w/ a complete example, in case it helps.

OME: User Defined Functions - Ingres Community Wiki