Download PDF 4.4M - Robelle

Transcript
Select All Records .....................................................................................................12
Look at the First Few Records...................................................................................12
Selecting by Criteria ................................................................................................................13
Simple Criteria...........................................................................................................13
Complex Criteria .......................................................................................................13
String of Digits ..........................................................................................................13
Selecting by Date .....................................................................................................................13
Select by Today's Date ..............................................................................................14
Select by Particular Date ...........................................................................................14
Select by Year............................................................................................................14
Select Prior Month.....................................................................................................14
Selecting by Lists of Values ....................................................................................................15
Finding Data Based on a List.....................................................................................15
Finding Data Based on a File.....................................................................................15
Finding Data Based on Another Table’s Criteria ......................................................16
Finding Data in a Data File........................................................................................16
Sorting Database Records ........................................................................................................16
Sort Records ..............................................................................................................16
Sort Records in Descending Order ............................................................................17
Sort by Multiple Keys................................................................................................17
Duplicate Records....................................................................................................................17
Report without Duplicate Records.............................................................................17
Report Only the Duplicate Records ...........................................................................18
Report Only the Unique Records...............................................................................18
Report Only the Duplicates and Their Originals .......................................................19
Deleting Duplicate Data File Records .......................................................................19
Decimal Places.........................................................................................................................20
Converting Numbers................................................................................................................20
Counts and Subtotals................................................................................................................21
Count and Subtotal on Sort Keys...............................................................................21
Sort by Count or Subtotal ..........................................................................................21
Total by Field ............................................................................................................21
Listing Records ........................................................................................................................22
Changing the Output Record Format .......................................................................................22
Producing a Condensed Table Listing .....................................................................................23
Simple Reports.........................................................................................................................23
Your First Report.......................................................................................................23
Column Headings ......................................................................................................24
Printing Mailing Labels .............................................................................................24
Running Suprtool under HP-UX
27
Running Suprtool.....................................................................................................................27
Configuring Different Shells....................................................................................................27
Bourne and Korn Shells.............................................................................................27
C Shell .......................................................................................................................27
Setting Up a PATH for Suprtool..............................................................................................28
Bourne and Korn Shells.............................................................................................28
C Shell .......................................................................................................................28
Control Characters and stty......................................................................................................29
Suprmgr Configuration Files ...................................................................................................29
On-Line vs. Batch Access........................................................................................................29
Command Line Options...........................................................................................................29
Initial Command Line: -ccmdstring..........................................................................29
Default Outcount File Name: -oc .............................................................................30
Exit with Verify: -v...................................................................................................30
ii • Index
Suprtool 4.6 for HP-UX User Manual