![]() |
Working with SQL-J's Java Extensions
|
|
VALUES ExpressionBefore you do the next section, you have to learn a little more about SQL and SQL-J. As you saw in Chapter 4, "Objects and SQL", SELECT is the SQL-J command that lets you retrieve data from a table. UPDATE and DELETE modify and delete data stored in a table. There is another basic SQL-J command that does not iterate over values in a database; it simply constructs a value or values. This command is VALUES. Use the VALUES CommandThe VALUES clause is used in an INSERT statement.
The VALUES expression is useful in many cases. One example is that it allows you to execute system-supplied functions that return values. |
|
![]() 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. |