This code implements a simple DBMS system. This DBMS will allow the user to type in simple DDL statements and build a system catalog (set of packed descriptors). Once the table definition is in place, the user can insert, update, delete, and select from a table.
Data type supports: INT, CHAR can be SUM, AVG, COUNT
Command Syntax:
- CREATE TABLE table_name ( { column_name <data_type> [NOT NULL] } )
- DROP TABLE table_name
- LIST TABLE
- LIST SCHEMA FOR table_name [TO report_filename]
- INSERT INTO table_name VALUES ( { data_value } )
- DELETE FROM table_name [ WHERE column_name <relational_operator> data_value ]
- UPDATE table_name SET column = data_value [ WHERE column_name <relational_operator> data_value ]
- SELECT { column_name } FROM table_name [ WHERE column_name [(AND | OR) column_name ] ] [ ORDER BY column_name [DESC] ] || SELECT (column_name) FROM table_name [ WHERE column_name [(AND | OR) column_name ] ] [ ORDER BY column_name [DESC] ]
- BACKUP TO
- RESTORE FROM
[WITHOUT RF]
- ROLLFORWARD [TO ]