Can I create views on my Zortec data in Easysoft Data Access for System Z?
Yes, Easysoft Data Access (EDA) for System Z supports views. Use the command line sql
utility (or another ODBC-compliant application) to create views by using SQL. Use views to limit the dataset returned from your files by setting criteria on the tables. For example:
CREATE VIEW
new_view AS
SELECT
*
FROM
Z.LASER
WHERE
"LASER-RETAIL-PRICE" > 49.99