DDM UMN 1st v Reviewed-by: Wagner, Fabian <fabian.wagner@t-systems.com> Co-authored-by: proposalbot <proposalbot@otc-service.com> Co-committed-by: proposalbot <proposalbot@otc-service.com>
31 lines
3.8 KiB
ReStructuredText
31 lines
3.8 KiB
ReStructuredText
:original_name: ddm_03_0035.html
|
|
|
|
.. _ddm_03_0035:
|
|
|
|
Advanced SQL Functions
|
|
======================
|
|
|
|
.. table:: **Table 1** Restrictions on advanced SQL functions
|
|
|
|
+-----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------+
|
|
| Item | Restriction |
|
|
+===================================+=========================================================================================================================================+
|
|
| SQL functions | - PREPARE and EXECUTE syntax is not supported. |
|
|
| | |
|
|
| | - Customized data types and functions are not supported. |
|
|
| | |
|
|
| | - Views, stored procedures, triggers, and cursors are not supported. |
|
|
| | |
|
|
| | - Compound statements such as BEGIN...END, LOOP...END LOOP, REPEAT...UNTIL...END REPEAT, and WHILE...DO...END WHILE are not supported. |
|
|
| | |
|
|
| | - Process control statements such as IF and WHILE are not supported. |
|
|
| | |
|
|
| | - The following prepared statements are not supported: |
|
|
| | |
|
|
| | **PREPARE**\ Syntax |
|
|
| | |
|
|
| | **EXECUTE**\ Syntax |
|
|
| | |
|
|
| | - Comments for indexes are not supported in table creation statements. |
|
|
+-----------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------+
|