ODBC HY000: User Defined Function source on the client is not supported by the driver

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

ODBC HY000: User Defined Function source on...

Rate Topic

Display Mode

Topic Options

Author

Message

manuk82

Posted 11/8/2006 2:30:15 AM

Junior Member

Group: Forum Members
Last Login: 1/30/2008 2:50:13 AM
Posts: 17, Visits: 14

Hi All,

I am new to teradata. I was writing the scripts for Create Function and while executing the script in Teradata SQL Assistance, i am getting the following error

Code =-1.
ODBC HY000: User Defined Function source on the client is not supported by the driver

The Script which i used is

CREATE FUNCTION COMP3TODEC8 (Buffer BYTE(10),bufferLength INTEGER)
RETURNS DECIMAL(18,0)
LANGUAGE C
NO SQL
PARAMETER STYLE TD_GENERAL
DETERMINISTIC
RETURNS NULL ON NULL INPUT
EXTERNAL NAME 'CS!Comp3ToDec8!E:\Comp3ToDec8.c';

In our company, we are connecting to an NCR Server located outside of our company using ODBC. We need to test the validity of the scripts which we write. The "E:\Comp3ToDec8.c" is located in the client machine where i am running the script. Can any one help me out in telling how i can execute the script fully without any error?

Regards,

Manu.

Post #5755

Fred Pluebell

Posted 11/8/2006 11:42:27 AM

Supreme Being

Group: PAC and SFT Members
Last Login: Today @ 8:40:04 AM
Posts: 331, Visits: 532

As the message says, you can't do this via ODBC (e.g. using SQL Assistant). Source files on the client are supported only with the CLI driver (e.g. using BTEQ or BTEQWIN).

Post #5765

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 5:43pm