1.0

SET ADDR=NULL, SINCE=null
WHERE CID > 10
-- Set Address of all customers to 'VMWare' where current
address is null.
UPDATE TRADE.CUSTOMERS
SET ADDR = 'VMWare'
WHERE ADDR IS NULL;
// Increase the qty field by 10 for all rows of SELLORDERS
table
stmt.executeUpdate(" UPDATE TRADE.SELLORDERS SET QTY = QTY+10
“);
-- Change the STATUS field of all orders of SELLORDERS
table to DEFAULT ( 'open') , for customer ID = 10
UPDATE TRADE.SELLORDERS
SET STATUS = DEFAULT
WHERE CID = 10
SQL Clauses
For each SQL clause in this release of VMWare vFabric SQLFire, read descriptions of syntax, custom extensions,
and examples.
FOR UPDATE Clause
SQLFire does not support this clause from a thin client connection.
FROM Clause
Specify the tables from which the other clauses of the query can access columns for use in expressions.
Syntax
FROM table-expression [ , table-expression ] *
Description
The FROM clause is a mandatory clause in a select-expression. It specifies the tables (table-expression) from
which the other clauses of the query can access columns for use in expressions.
Example
SELECT CUST_NAME FROM TRADE.CUSTOMERS WHERE CID < 5
-- other types of TableExpressions
SELECT TABLENAME, ISINDEX
FROM SYS.SYSTABLES T, SYS.SYSCONGLOMERATES C
WHERE T.TABLEID = C.TABLEID
ORDER BY TABLENAME, ISINDEX
-- force the join order
SELECT * FROM TRADE.SECURITIES S, TRADE.PORTFOLIO F WHERE
SEC_ID = F.SID AND F.TID = ?
-- a TableExpression can be a joinOperation. Therefore
-- you can have multiple join operations in a FROM clause
SELECT * FROM TRADE.CUSTOMERS C LEFT OUTER JOIN
TRADE.PORTFOLIO F LEFT OUTER JOIN TRADE.SELLORDERS SO ON F.CID
= SO.CID ON C.CID= F.CID
WHERE SO.SID < 100 AND SO.QTY > 500
489
SQL Language Reference