INTOUCH®
Guided Query Language
Previous Contents Index

Appendix C
Sample GQL Procedure to Access DBMS Data

The following GQL procedure produces a report using several DBMS record types to illustrate the different methods of accessing DBMS data: 


        open devdisk:[devint.dbms]employee systemset 'all_employees' 
        open devdisk:[devint.dbms]part 
        open devdisk:[devint.dbms]component 
        open devdisk:[devint.dbms]class 
        relate employee to many part set 'responsible_for' 
        relate part to many component set 'part_uses' 
        relate part to class set 'class_part' expression 'owner' 
        break emp_id nototals 
        break part_id 
        print emp_id group 1, emp_first_name group 1, emp_last_name group 1 
        print part_id group 2 
        print class(class_code) 
        print comp_sub_part

Index Contents