----- Original Message -----
From: Helen Borrie
To: ib-support@yahoogroups.com
Sent: Friday, November 15, 2002 12:30 PM
Subject: Re: [ib-support] Extract Function


At 11:50 AM 15-11-02 +0530, you wrote:
> Thanks i got that DLL and placed the libarary in
> IB_INSTALL/UDF and restarted the server but the server gives an error
> fucntion unknown do i have to do something more for the server to know
> about that DLL.
>
>Ajay.

Sorry, Ajay, I should not answer support questions so late at night. :-(

Did you declare the function to the database?

> declare external function f_DayOfMonth
> date
> returns
> integer by value
> entry_point 'DayOfMonth' module_name 'FreeUDFLib;

commit;

Now, here is what you *actually* need to do what you asked:

Select Count(ID), f_DayOfMonth (Msg_Date)
From DR_Main
Group By f_DayOfMonth (Msg_Date)

heLen



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]