Informix-ESQL/C Programmer's Manual
Chapter 17: Using an sqlda Structure
Home
Contents
Index
Master Index
New Book
Handling a Parameterized UPDATE or DELETE Statement
The way to determine the input parameters in the
WHERE
clause of a
DELETE
or
UPDATE
statement is very similar to the way to determine them in the
WHERE
clause of a
SELECT
statement
(
page 17-32
)
. 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. You provide the parameter values from an
sqlda
structure with the
USING DESCRIPTOR
clause of the
EXECUTE
statement instead of with the
OPEN
statement.
You can use the
DESCRIBE
...
INTO
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.
