15.00 - External String Literal Examples - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

External String Literal Examples

The following examples demonstrate various UDF external string literals.

Example 1

The following example indicates that the source is to be obtained from the client, from absolute directory UDF Source. The file name on the platform and the source file name are both sales.c. The function entry name is sales1 and the function is to be compiled with debug symbols.

    'CS¡sales¡C:\UDF Source\sales.c¡F¡sales1¡D'

Example 2

In the following example, the object is to be obtained from the client. udfdev/imagef.o is the relative path to udfdev/imagef.o from the home or current client directory for the logged on user. The file name on the Teradata Database server is img.o. The name of the object it retrieves is imagef.o, and the function entry name for the UDF is img_match.

    'CO¡img¡/udfdev/imagef.o¡F¡img_match'