No privileges to change character sets in TPT

Database
Enthusiast

No privileges to change character sets in TPT

Hi,

 

I need to change to perform a latin to unicode data conversion to create a file with UTF8. I found the unicode tool kit and I need to install UDF on my machine. However, the first part is to connect to Bteq and run 

REPLACE FUNCTION udf_ascii2wide(
inputString VARCHAR(16000) CHARACTER SET LATIN
)
RETURNS VARCHAR(16000) CHARACTER SET UNICODE
LANGUAGE C
NO SQL
EXTERNAL NAME 'CO!i18n502!c:\temp\udf_installation\udf_ascii2wide.o!F!udf_ascii2wide'
PARAMETER STYLE SQL;

 

But I get:

*** Failure 3524 The user does not have CREATE FUNCTION access to database
DBC.

 

 

There are not other users and I've already run GRANT ALL ON dbc TO dbc but I still can't perform this action in Btq or grant myself the CREATE FUNCTION privilege. 

 

What do I do?

 

Thanks in advance!

Tags (3)
2 REPLIES
Teradata Employee

Re: No privileges to change character sets in TPT

Do NOT create the UDF in database DBC.  In fact, I don't think that's even possible.  That's not what DBC is for.  You should put it in your own database first to test it.  User-installed UDFs that are intended for use by all go into SYSLIB: REPLACE FUNCTION SYSLIB.udf_ascii2wide (...).

Teradata Employee

Re: No privileges to change character sets in TPT

If you set the session character set to UTF8, the LATIN data will be translated by the driver when it is exported.

Why do you think you need a UDF at all? Even if you did, I doubt it would be udf_ascii2wide (converting ASCII characters to their "wide" UNICODE variants).