Multiple subfiles

[Deskin, Bob]

The problem is which file the reference to STUD_SEX looks in. Try qualifying
it with OF PEN_MASTER.

Bob Deskin              
Senior Product Advisor  bob.deskin@cognos.com
Cognos Inc.             (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Thomson, Martyn EDUC:EX [mailto:martyn.thomson@gems1.gov.bc.ca]
Sent: Monday, January 25, 1999 12:35 PM
To: 'POWERHOUSE Listserv'
Subject: Multiple subfiles


Perhaps somebody could shed some light on this?  Why can I not have more
than one subfile in a request?
Consider the following simplified example -

run subtest
request subtest
set proc limit 1000
access pen_master in pen
subfile males keep if stud_sex='M'  &
include stud_no of pen_master, stud_sex of pen_master
subfile females keep if stud_sex='F'   &
include stud_no of pen_master, stud_sex of pen_master
build

On running this, records are written to the first subfile , but not the
second!  If I switch the order of the subfiles - same result.  I've seen two
subfiles in a request before, but outputting at different control breaks.
If I put in a sort (say on stud_no), I don't get any output at all!  What is
going on here?  I can't see anything in the QTP manual or the 7.10F4 RBF
relating to this scenario. 
Any help much appreciated.
Using 7.10E1 on OpenVMS 6.1

Regards,
Martyn Thomson
Ministry of Education,
B.C., Canada


 


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.