Kbase P123988: How to suspend execution of the next SQL statement using SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/07/2008 |
|
Status: Unverified
GOAL:
How to suspend execution of the next SQL statement using SQL-92?
GOAL:
Does SQL-92 have statements to pause execution?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
SQL-92 does not contain statements which can suspend (pause) execution. This needs to be done using either Stored Procedures (Java, using its time features to accomplish this) or using the capabilities of the host language (Java, VB etc.) which is executing SQL statements.