awk% bobj \|||||||||||||||||/ --- Welcome to BOBJ --- /|||||||||||||||||\ BOBJ version 0.0042 built: Wed May 28 02:25:05 PST 2001 University of California, San Diego Wed Jun 13 22:05:40 PDT 2001 BOBJ> in b ========================================== ***> first define the List data structure, for creating columns ========================================== obj LIST ========================================== ***> query conditions in SQL select statement ========================================== obj QUERY-COND ========================================== ***> select statement in SQL ========================================== obj TABLE-SELECT ========================================== ***> database specification ========================================== bth DATABASE ========================================== ***> integrated database ========================================== bth BOOK-DATABASE ========================================== reduce in BOOK-DATABASE : query(db , SELECT 'title FROM 'book WHERE (('author = ('Joe 'Walter)) and ('price > 33))) result ResultSet: query(db1 , SELECT 'title FROM 'book WHERE ((('first-name = 'Joe) and ('last-name = 'Walter)) and ('price > 33))) U query(db2 , SELECT 'title FROM 'book WHERE (('author = ('Joe 'Walter)) and ('price > 264))) rewrite time: 31ms parse time: 262ms ========================================== reduce in BOOK-DATABASE : query(db , SELECT ('author , 'price) FROM 'book WHERE ('title = (('Modern 'Operating) 'System))) result ResultSet: concat-two-columns-at-as(query(db1 , SELECT (('first-name , 'last-name) , 'price) FROM 'book WHERE ('title = ('Modern 'Operating 'System))) , 1 , 2 , 'author) U each-div-by-8-at-column(query(db2 , SELECT ('author , 'price) FROM 'book WHERE ('title = ('Modern 'Operating 'System))) , 2) rewrite time: 87ms parse time: 127ms BOBJ> q Bye. awk%