Home:Learn XQuery:White Papers:Generating SQL:Calling Database Functions

Calling Database Functions

DataDirect XQuery® lets you call any function defined in your database directly as an XQuery external function. Both built-in database functions and user-defined SQL functions are supported. External Java functions can also be called, and these can invoke database functions. Our support for external functions provides a way to invoke SQL functions or Java functions with virtually no performance overhead. Because this support is a central part of our open design, you can use DataDirect XQuery® in just about any architecture.

declare function ddtek-sql:RTRIM($s as xs:string) as xs:string external;
collection('USERS')/USERS/ddtek-sql:RTRIM(LASTNAME)

SELECT ALL
  RTRIM(nrm7."LASTNAME") AS RACOL1
FROM
  "PEPPINO"."USERS" nrm7