Impromptu and personal function DB

[GilMerc]

Hi,

I would like use a fonction that define in a database. I define in a file a personal function DB but I don't see the function in a fonction list. I following the steps in cognos documentation.

Somebody has use define a personal function who's help me?

thanks, Gilles.

 

[Draoued]

if you are using Oracle db , for example,
YOu need to include the function also in the Orfunc.ini file, in the bin folder.
it needs to be in the list , then in between bracket the same name, and the parameters.
You need to put a tips line for all the parameters , if one is missing it will not display the function in the list of available functions in Impromptu

 

[GilMerc]

Hi Draoued,

Effectively, I am using Oracle DB.

I am fallowing all this step and it doesn't works. Do you know if I must add a function definition in a ImpFunct.ini file?

I add this lines in a orfunct.ini

[Database-specific Function List]
RechercheListeCode=

[RechercheListeCode]
label=RechercheListeCode
type=R
param=3
return=NM
1=CH;exp_chaîne
2=CH;exp_chaîne
3=CH;exp_chaîne
exp=RechercheListeCode ( ^1 , ^2, ^3 )
tip=Syntaxe :RechercheListeCode(Nom de la table, Nom de la colonne, Liste des valeurs a recherchée)
tip1=Expression de chaîne indiquant la table dans laquelle exécuter la recherche
tip2=Expression de chaîne indiquant la champ de recherche
tip3=Expression de chaîne contenant les valeurs recherchées séparées par une virgule

and I define the function in a cogudfor.sql

DECLARE DATABASE FUNCTION RechercheListeCode( STRING, STRING, STRING )
RETURNS NUMBER
FUNCTION NAME RechercheListeCode;

What do you think about this code? Is it suppose works or I take a mistake?

Gilles.

 

[Draoued]

It looks okay.
I noticed also that it s very sensitive.
So try with :
exp=RechercheListeCode ( ^1 , ^2 , ^3 )
Add a space between the 2 and the comma