![]() |
ij Commands and Errors Reference
|
Absolute |
AsyncSyntaxASYNC Identifier String DescriptionThe Async command lets you execute an SQL statement in a separate thread. It is used in conjunction with the Wait For command to get the results. You supply the SQL statement, which is any valid SQL statement, as a String. The Identifier you must supply for the async SQL statement is used in the Wait For command and is a case-insensitive ij identifier; it must not be the same as any other identifier for an async statement on the current connection. You cannot reference a statement previously prepared and named by the ij Prepare command in this command. ij creates a new thread in the current connection to issue the SQL statement. The separate thread is closed once the statement completes. Exampleij> async aInsert 'INSERT INTO t VALUES 1,2,3,4'; ij> INSERT INTO t VALUES 5,6,7,8; 4 rows inserted/updated/deleted. ij> wait for aInsert; 4 rows inserted/updated/deleted. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |