15.00 - Example 3 - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Example 3

The following example indicates that the header file sp_types.h and the C source file stdxml.c to be used for the procedure are to be found on the server. /home/jcx/headers/sp_types.h is the relative path from the home or current client directory for the logged on user to the header file and home/jcx/src/stdxml.c is the relative path to the C source file. The procedure name in the C source code is called stdxml. Both files have the same name on the server.

    'SI¡sp_types¡/home/jcx/headers/sp_types.h¡SS:stdxml¡home/jcx/src/
     stdxml.c¡F¡stdxml'

The table on the following page summarizes the naming issues for the EXTERNAL NAME clause and its various components.

 

IF you specify this procedure name …

THEN the source file name is the same as …

AND the procedure name in DBC.TVM is …

AND the C/C++ procedure name is the same as …

Comments

procedure_name only

procedure_name

procedure_name

procedure_name

procedure_
name
must be unique within its database.

procedure_name and external_procedure_name but not as 'string'

external_procedure_name

procedure_name

external_procedure_name

procedure_name and external_procedure_name as 'string'

source_name as specified in 'string'

procedure_name

procedure_name if not in 'string'

or

external_procedure_name if in 'string'