January 19, 2025
+ 12
How to call a user-defined function from SQL++ statements.

Introduction

A user-defined function can be called like any other SQL++ function.

Calling the SQL++ User-Defined Function

An SQL++ user-defined function can be called from anywhere that a standard SQL++ function can be called.

  1. Access the Query Workbench UI from the Administration Console.

    accessing the query tool
  2. Set the context to match the namespace of the function you are calling.

    switch context to travel sample
  3. Enter the SQL++ statement in the query editor to run your function:

    EXECUTE FUNCTION GetBusinessDays("02/14/2022", "04/16/2022");