Learning Roadmap for Table UDF Developers

Use annotated examples to learn how to develop a C or C++ table UDF. After completing the development tasks, the SQL analyst can then reference your UDF in a SQL query.

This roadmap assumes:
Task See
Become familiar with table UDF and TPF restrictions.

Table UDF Restrictions

Create a table UDF.

Developing a Table UDF

(Optional) Define the library version validators for distributed query processing (DQP).

Library Version (extfn_get_library_version)

Library Version Compatibility (extfn_check_version_compatibility)

Compile and link source code.

Compile and Link Source Code to Build Dynamically Linkable Libraries

Declare the UDF to the server using the CREATE PROCEDURE statement. Write and execute these statements as commands, or use Sybase Control Center.

Learning Roadmap for SQL Analysts