1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
#!/bin/sh
# set up
PATH=.:/bin:/usr/bin:/usr/unsupported/bin:/usr/unsupported/informix/bin
INFORMIXDIR=/usr/unsupported/informix
DBPATH=/users/db/infx
DBTEMP=/tmp
export PATH
export INFORMIXDIR
export DBPATH
export DBTEMP
BUGDIR=/users/db/reports
INFX=/usr/unsupported/informix/bin
#---------------------------------------------------------------
# query the GNATS db for derivative data
#---------------------------------------------------------------
query_pr -sql > $BUGDIR/gnats`date +%y%m%d`
cp $BUGDIR/gnats`date +%y%m%d` $BUGDIR/gnats.curr
#---------------------------------------------------------------
# load into informix database
#---------------------------------------------------------------
$INFX/isql engdb loadGNATS.sql
#---------------------------------------------------------------
# calculate age of non-closed bugs and update db
#---------------------------------------------------------------
cd $DBPATH
$INFX/fglgo calc_age
|
