ODBC
SQL functions
Contents
In SQL statements, you can use any function that your backend DBMS
supports (such as aggregate or mathematical functions). For example, if
your DBMS supports the function Sum, you can use the function Sum in a
SELECT statement:
|
1 2 3 |
SELECT Sum(salary) INTO :salary_sum_var FROM employee; |
Calling ODBC functions
While PowerBuilder provides access to a large percentage of the
features within ODBC, in some cases you may decide that you need to call
one or more ODBC functions directly for a particular application.
PowerBuilder provides access to most Windows DLLs by using external
function declarations.
The ODBC calls qualify for this type of access. Most ODBC calls
require a pointer to a connection handle (of the variable type HDBC) to a
structure as their first parameter. If you want to call ODBC without
reconnecting to the database to get a connection handle, use the
PowerScript DBHandle function.