Chapter B: Hierarchical Model. Basic Concepts Tree-Structure Diagrams Data-Retrieval Facility Update Facility Virtual Records Mapping of Hierarchies to Files The IMS Database System. Basic Concepts.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Parkview, Fleming, A-522, A-561, Freeman, A533, Seashore, Boyd, A-409, A-622
get first customerwhere customer.customer-name = “Fleming”;print (customer.customer-address);
get first accountwhere customer.customer-name = “Fleming”;and account.balance > 10000;if DB-status = 0 then print (account.account-number);
get next <record type>where <condition>
get next within parent <record type>where <condition>
sum := 0;get firstcustomerwhere customer.customer-name = “Boyd”;get next within parent account;while DB-status = 0 do beginsum = sum + account.balance;get next within parent account;end print (sum);
insert <record type>where <condition>
customer.customer-name := “Jackson”;customer.customer-street := “Old Road”;customer.customer-city := “Queens”;insert customerwhere branch.branch-name= “Seashore”;
account.account-number := “A-655”;account.balance := 100;insert accountwhere customer.customer-name= “Jackson”;
get hold first customerwhere customer.customer-name = “Boyd”;customer.customer-street := “Northview”;replace;
get hold first accountwhere account.account-number = “A-561”;delete;
get gold firstcustomerwhere customer.customer-name = “Boyd”;delete;