Difference between revisions of "Documentation/DevGuide/Database/Support Scalar Functions"
m (1 revision(s)) |
OOoWikiBot (Talk | contribs) m (FINAL VERSION FOR L10N) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
|NextPage=Documentation/DevGuide/Database/Open Group CLI Numeric Functions | |NextPage=Documentation/DevGuide/Database/Open Group CLI Numeric Functions | ||
}} | }} | ||
| − | {{DISPLAYTITLE:Support Scalar Functions}} | + | {{Documentation/DevGuideLanguages|Documentation/DevGuide/Database/{{SUBPAGENAME}}}} |
| + | {{DISPLAYTITLE:Support Scalar Functions}} | ||
SDBC supports numeric, string, time, date, system, and conversion functions on scalar values. The Open Group CLI specification provides additional information on the semantics of the scalar functions. The functions supported are listed below for reference. | SDBC supports numeric, string, time, date, system, and conversion functions on scalar values. The Open Group CLI specification provides additional information on the semantics of the scalar functions. The functions supported are listed below for reference. | ||
| Line 16: | Line 17: | ||
{{PDL1}} | {{PDL1}} | ||
| − | [[Category: Database Access]] | + | |
| + | [[Category:Documentation/Developer's Guide/Database Access]] | ||
Latest revision as of 12:54, 15 May 2009
- SDBC Driver
- Driver Service
- Connection Service
- XDatabaseMetaData Interface
- Statements
- Support Scalar Functions
SDBC supports numeric, string, time, date, system, and conversion functions on scalar values. The Open Group CLI specification provides additional information on the semantics of the scalar functions. The functions supported are listed below for reference.
If a DBMS supports a scalar function, the driver should also. Scalar functions are supported by different DBMSs with different syntax, it is the driver's job to map the functions into the appropriate syntax or to implement the functions directly in the driver.
By calling metadata methods, a user can find out which functions are supported. For example, the method XdatabaseMetaData.getNumericFunctions() returns a comma separated list of the Open Group CLI names of the numeric functions supported. Similarly, the method XDatabaseMetaData.getStringFunctions() returns a list of string functions supported.
In the following table, the scalar functions are listed by category.
| Content on this page is licensed under the Public Documentation License (PDL). |
