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