Archives of the TeradataForum

Message Posted: Fri, 09 Feb 2007 @ 09:14:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I am not aware of any other method (yet).

However, if you have the required privileges (and space) on your own Teradata userid/database, then you could compile the function just for your own use.

You would then:

     Select .otranslate('r?sum?','???????','eeeeiii');

To compile the function (once downloaded from NCR using the link previously provided) you could:

(assuming you are running a windows workstation)

1. Place the file (otranslate.c) containing the otranslate UDF in c:\temp\otranslate

2. In bteq, execute following:

          REPLACE FUNCTION .otranslate(
                Str VARCHAR(512),
                aFrom VARCHAR(512),
                aTo VARCHAR(512)
          )RETURNS   VARCHAR(512)
          LANGUAGE C
          NO SQL
          SPECIFIC otranslate
          EXTERNAL NAME 'CS!otranslate!C:\temp\otranslate\otranslate.c'
          PARAMETER STYLE SQL;

If you run into privilege or space problems (you would not require much space to compile this), such as lack of create/execute privileges, then ask you Teradata DBA to provide these rights for your own user ID/database only.

Regards

Etienne Stieger

	<Prev	Next>		<<First	<Prev	Next>	Last>>