SQL/MX 3.5.1 Procedural Language for SQL/MX (PL/MX) Reference Manual
  • Overview
    • PL/MX language
    • PL/MX Environment
  • PL/MX language elements
    • Character set
    • Reserved words
    • Delimiters
    • Operators
    • Literals
    • Declarations
      • Identifiers
      • Variables
      • Constants
      • Functions
    • Statements
    • Blocks
    • Compiler Conditional Statements
  • Datatypes
  • Expressions
    • Arithmetic expression
    • Boolean expression
    • Operator precedence
  • PL/MX statements
    • Assignment
    • CONTINUE
    • DBMS_OUTPUT
    • EXIT
    • FOR
    • IF
    • LOOP
    • NULL
    • RETURN
    • WHILE
  • Managing user defined functions
    • Managing NonStop SQL/MX User Defined Functions and their properties
      • Prerequisites
  • Using User Defined Functions
    • Prerequisites
    • Using NonStop SQL/MX User Defined Functions in queries
      • Using a UDF in the select list of a main query
      • Using a UDF in the where clause of a main query
  • PL/MX errors
  • PL/MX Exception Conditions
  • The Standalone Compiler
  • Websites (NonStop)
  • Support and other resources
    • Accessing Hewlett Packard Enterprise Support
    • Accessing updates
    • Customer self repair
    • Remote support
    • Warranty information
    • Regulatory information
    • Documentation feedback
  1. Home
  2. Using User Defined Functions

Using UDFs in Queries

You can use UDFs in the select list of a main query or in the WHERE clause of a main query.

  • Prerequisites

  • Using NonStop SQL/MX UDFs in SQL Queries