Hi Murray;

  Do mean basically what I call a  "Stored Function"?

Regards ... Chris

Hello Murray,

as Chris pointed out, you're asking for stored funcs/procs support.

In PB you can just declare

FUNCTION  DBfunctionName(args) RPCFUNC
SUBROUTINE DBprocedureName(args) RPCFUNC

​And invoke in your code

returnValue = sqlca.DBfunctionName(args).

Look for "RPCFUNC" keyword in the PB help and you will get plenty of examples.

HTH.
Cheers,

.m

A table valued function is a user defined function that returns a result set (similar to many stored procedures) but can be used in a query as if it were a table.

You wouldn't be calling them directly from PowerBuilder.