The
University
of
Vermont

Use repgen to help build SQL  (RQBE)

 Some tools have a "Relational Query By Example" feature.  This is usually some kind
of wizard that helps you build SQL.

Our home-grown report menu system "repgen" has a feature like this.
After specifying some selection criteria, use the "Show SQL" option.

kdk                 R E P O R T   O P T I O N S                            PROD
                               0 People

                   1  - Report:   <none>

                   2  - Make Selections
                   3  - Choose Sort Options
                   4  - Choose Print options
                   5  - Change Report Name

                   6  - Select Count
                   7  - View Selection
                   8  - Show generated SQL          <<<<< Look here.

                   9  - Don't keep REPGEN files
 

                  [0] - Quit [DEFAULT]

                        Enter Selection/ID:

Here's a sample.

kdk                 Debug Joins and Conditions                             PROD

from spriden
,spbpers,swv_repgen_rec_dcsn,saradap

 Where spriden.spriden_change_ind is null
 and saradap_pidm = spriden.spriden_pidm and saradap_term_code_entry =  (sele
ct max(saradap_term_code_entry) from saradap   where saradap_pidm = spriden.s
priden_pidm) and rec_dcsn_pidm = saradap_pidm and rec_dcsn_term = saradap_ter
m_code_entry and rec_dcsn_appl_no = saradap_appl_no and rec_dcsn_code  IN ('6
7','68') and spbpers_pidm = spriden.spriden_pidm and spbpers_pidm = spriden.s
priden_pidm and spbpers_ethn_code = '7' and spbpers_lgcy_code in ('F','M','P'
) and trunc(spbpers_birth_date) > '01-JAN-77'
 
 

Special filters in effect:
Check deceased flag.
 
Brought to you through the courtesy of Computing and Information Technology, University of Vermont. Copyright © 1996 The University of Vermont and others. All rights reserved.

The University supports both institutional and personal web pages. The views expressed on personal web pages are strictly those of the author, and are not reviewed or approved by the University of Vermont

Send questions and comments to  Keith.Kennedy@uvm.edu

Read the Webmaster's Policies.
Last page update: November 11, 1998