Informix-ESQL/C Programmer's Manual
Chapter 16: Using a System-Descriptor Area
Home
Contents
Index
Master Index
New Book
Handling a Parameterized UPDATE or DELETE Statement
How you determine the input parameters in the
WHERE
clause of a
DELETE
or
UPDATE
statement is very similar to how you determine them in the
WHERE
clause of a
SELECT
statement
(
page 16-36
)
. The major differences between these two types of dynamic parameterized statements are as follows:
You do not need to use a cursor to handle a
DELETE
or
UPDATE
statement. Therefore, you provide the parameter values from a system-descriptor area with the
USING SQL DESCRIPTOR
clause of the
EXECUTE
statement instead of the
OPEN
statement.
You can use the
DESCRIBE
...
USING SQL DESCRIPTOR
statement to determine if the
DELETE
or
UPDATE
statement has a
WHERE
clause. For more information, see
"Checking for a WHERE Clause"
.
Informix-ESQL/C Programmer's Manual
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.
