Introduction to Data Management

Accessing Databases With NonStop SQL

15873 Tandem Computers Incorporated 3-13

Figure 3-6. SQLCI Response to an Online Query

FNAME LNAME SID

_____ _____ ___

Audrey Brown 2761

Rodney Carey 1654

Robert Colvin 3476

Carol Dooley 2003

Stephanie Duncan 1764

Samuel Edison 2002

Douglas Eliot 2009

Lana Fong 1777

April Fowler 1642

. . .

Generating Reports

You can use SQLCI to produce reports based on data derived from queries. You

would do this, for instance, if you wanted the information in the previous example

formatted with a formal title and column headings. Your SQLCI statements might

appear as follows:

OUT_REPORT $S.#LASER ;

SET LIST_COUNT 0 ;

SELECT FNAME, LNAME, SID FROM STUDENT WHERE DEPTID = "BUSAD" ;

REPORT TITLE "Business Administration Students" ;

DETAIL FNAME HEADING "Student Name" , LNAME NOHEAD,

SID HEADING "ID No." ;

LIST ALL ;

The listing would appear as shown in Figure 3-7, generated by the powerful and

flexible NonStop SQL interactive report writer.