Can I create views on my Zortec data?

Easysoft ODBC-Zortec System Z Driver

Can I create views on my Zortec data?

Article :	00807
Last Reviewed :	19th July 2005
Revision :	1

Yes Easysoft Data Access for SystemZ allows the creation of views through SQL passed into the schema files from the command line sql utility or graphically through any ODBC compliant application. Views can be used to limit the dataset returned from your files by setting criteria on the tables. SQL for creating a view is as follows:

create view new_view as select * from Z.LASER where "LASER-RETAIL-PRICE" > 49.99

Applies To

Products
- Easysoft ODBC-Zortec System Z Driver

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-Zortec System Z Driver

Can I create views on my Zortec data?

Applies To

Knowledge Base Feedback