Selection set problem using -rx
Ray Scheel
ray.scheel at wsdtx.org
Thu May 27 11:24:37 PDT 2004
I'm having inconsistent results with a pair of selection sets which use @px
and @py.
In my test area, using copies of the source (@yr) key, data, and map I
copied from production a few days ago, everything selects correctly and I
get the results I expect.
Today, when I moved this set of files into production, two of the four quit
selecting, even though all are called from the same shell script in the same
manner and have the relevant fields (year and month) in the same spots.
I can't figure out what might be causing the selection failure on only 2
tables and only on one machine. The only consistent theme I've found is the
two that work have "_tea" in the name of the table and are the last two
files in the loop I have running this processing.
The point of the processing involved is to rebuild the raw information in
the monthly qualifiers after the end of the month processing is complete so
they contain the reconciled data placed in yr from the working month file.
Relevant info:
Production
Filepro: 5.0.00/5.0.11aR4
Linux tyler 2.4.20-6smp #1 SMP Thu Feb 27 09:59:40 EST 2003 i686 i686 i386
GNU/Linux
Test machine
Filepro: 04.08.00/5.0.11aR4
Linux fpdev 2.4.20-20.8 #1 Mon Aug 18 14:59:07 EDT 2003 i686 i686 i386
GNU/Linux
Selects nothing:
/appl/fp/rreport att_cla -fp yr_to_month -s yr_to_month -m yr -u -rx 03 -ry
2004
(As written, this never hits report processing. It will work if specify a
selection set where the passed values are instead "hard coded" in the set,
and processing then "sees" the passed values, so its only the selection set
not working as expected.)
Selects as expected:
/appl/fp/rreport att_cla_tea -fp yr_to_month -s yr_to_month -m yr -u -rx 03
-ry 2004
Syntax from calling script when running automated (note only att_stu and
att_cla fail to select):
cp_files() #/**** copy yr records to qualifier
{
for i in att_stu att_cla att_cla_tea att_tea_plan
do
$dir $i -m $month -k -l #/**** kill existing qualifier
$fp $i -fp yr_to_month -s yr_to_month -m yr -u -rx $month -ry $year
done #/**** rebuild monthly qualifier
}
::::::::::::::
att_cla/map
::::::::::::::
unitcd ; code of unit: 2:allup:
clanum ; number of class on unit: 5:.0:
year ; year of record: 4:.0:
month ; month of record: 2:allup:
clacd ; code of class: 11:allup:
syscd ; system code for class: 1:allup:
...
::::::::::::::
att_cla_tea/map
::::::::::::::
unitcd ; code of unit: 2:allup:
teacd ; teacher code: 5:allup:
year ; year of record: 4:.0:
month ; month of record: 2:#:
clanum ; class number: 5:.0:
lname ; teacher lastname: 15:allup:
fname ; teacher firstname: 12:allup:
...
::::::::::::::
att_cla/sel.yr_to_month
::::::::::::::
:4:eqf:@px
:3:eqf:@py
::::::::::::::
att_cla_tea/sel.yr_to_month
::::::::::::::
:4:eqf:@px
:3:eqf:@py
-rw------- 1 filepro sys 59392 May 27 09:42 att_cla/index03.A
-rw------- 1 filepro sys 21504 May 27 09:42 att_cla/index03.B
-rw------- 1 filepro sys 17408 May 27 09:42 att_cla/index03.C
-rw------- 1 filepro sys 24576 May 27 09:42 att_cla/index03.D
-rw------- 1 filepro sys 55296 May 27 09:42 att_cla/index03.E
-rw------- 1 filepro sys 167936 May 27 12:17 att_cla/indexyr.A
-rw------- 1 filepro sys 47104 May 27 12:17 att_cla/indexyr.B
-rw------- 1 filepro sys 40960 May 27 12:17 att_cla/indexyr.C
-rw------- 1 filepro sys 92160 May 27 12:19 att_cla/indexyr.D
-rw------- 1 filepro sys 160768 May 27 12:17 att_cla/indexyr.E
-rwxrwxrwx 1 filepro sys 397684 Apr 2 09:05 att_cla/key03
-rwxrwxrwx 1 filepro sys 1190308 May 25 12:10 att_cla/keyyr
-rwxrwxrwx 1 filepro csd 1288 Oct 28 2003 att_cla/map
-rwxrwxrwx 1 filepro sys 1724 May 27 11:30
att_cla/prc.yr_to_month
-rwxrwxrwx 1 filepro sys 63 May 21 14:18
att_cla/sel.yr_to_month
-rw------- 1 filepro sys 478208 May 27 09:43
att_cla_tea/index03.A
-rw------- 1 filepro sys 366592 May 27 09:43
att_cla_tea/index03.B
-rw------- 1 filepro sys 1342464 May 25 12:11
att_cla_tea/indexyr.A
-rw------- 1 filepro sys 1103872 May 27 11:51
att_cla_tea/indexyr.B
-rwxrwxrwx 1 filepro sys 1056078 Apr 2 09:05 att_cla_tea/key03
-rwxrwxrwx 1 filepro sys 3171924 May 25 12:11 att_cla_tea/keyyr
-rwxrwxrwx 1 filepro csd 387 Nov 12 1998 att_cla_tea/map
-rwxrwxrwx 1 filepro sys 1724 May 27 10:52
att_cla_tea/prc.yr_to_month
-rwxrwxrwx 1 filepro sys 63 May 26 16:05
att_cla_tea/sel.yr_to_month
Ray Scheel ray.scheel at wsdtx.org
Windham School District Computer Services
Programmer 936-291-5206
More information about the Filepro-list
mailing list