ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-14
Functions
Escape Clauses for Executing Stored Procedures
ODBC uses the following form of escape clause for executing stored procedures:
CALL
specifies that this is a call to a previously established procedure (a Pathway server
class) for execution of that procedure.
For example, the following CALL statement invokes a stored procedure named
SELECT_DEPT3000:
{ call select_dept3000 }
Functions
CORE SQL provides several types of functions for manipulating and retrieving data.
This subsection summarizes NonStop ODBC Server support of CORE SQL functions,
then describes, by the following function types, how to use the supported functions:
•
Date functions
•
Mathematical functions
•
String functions
•
System functions
•
Data type conversion function
Summary of CORE SQL Functions
Table 3-5 summarizes the supported CORE SQL functions. Descriptions of each
function follow the table.
--*( VENDOR(Microsoft),PRODUCT(ODBC)
[ ?= ] CALL procedure-name [ ( parameter [, ... ] ) ] )*--
or
{ [ ?= ] CALL procedure-name [ ( parameter [, ... ] ) ] }
Table 3-5. Supported CORE SQL Functions (page1of2)
Function Type Function Comments
Date CURDATE See CURDATE
on page 3-16
CURTIME See CURTIME
on page 3-16
DAYOFMONTH See DAYOFMONTH
on page 3-16
DAYOFWEEK See DAYOFWEEK
on page 3-16