|
View
|
Supported ABL
|
|
All columns from a single table:
SELECT custnum, name, postalcode
FROM customer |
Full support for this view. Use the USE-INDEX option with FIND NEXT statements to get the same results you would expect from ABL.
|
|
Some columns from a single table:
SELECT custnum, name FROM
customer |
Full support for this view. Use the USE-INDEX option with FIND NEXT statements to get the same results you would expect from ABL.
|
|
All columns from a single table with an expression:
SELECT custnum, UPPER(name),
postalcode WHERE postalcode < 20000 FROM customer |
Full support for this view, except that you cannot update the column with the expression (name, in this example).
|
|
All columns from a single table with an aggregate or function:
SELECT custnum, name, postalcode
WHERE postalcode < 20000 FROM customer GROUP BY postalcode |
The only supported statements are:
FOR EACH
NO-LOCK SHARE-LOCK: FIND NO-LOCKSHARE-LOCK: |
|
Columns from multiple tables:
SELECT custnum, name,
postalcode, ordernum FROM customer, order WHERE salesrep = 'HXM' |
The only supported statements are:
FOR EACH
NO-LOCK SHARE-LOCK: FIND NO-LOCKSHARE-LOCK: |
