Difference Between Vsam And Database Tables

1.	Difference Between Vsam And Database Tables
Answer» VSAM file can not run SQL QUERIES. -VSAM lacks any kind of relation -VIEWS and SYNONYMS can not be defined on VSAM files -RDBMS concepts can not be applied in VSAM files. SQL queries can be run in DATABASE table - Data FETCHING is more efficient than VSAM files - RDBMS concepts are applicable in DB2 database - ALIAS VIEWS can be defined on tables for sharing customized data.

Answer»

VSAM file can not run SQL QUERIES. -VSAM lacks any kind of relation -VIEWS and SYNONYMS can not be defined on VSAM files -RDBMS concepts can not be applied in VSAM files.
SQL queries can be run in DATABASE table - Data FETCHING is more efficient than VSAM files - RDBMS concepts are applicable in DB2 database - ALIAS VIEWS can be defined on tables for sharing customized data.

Discussion