subfile name

[Bickel, Jon]

Viet,

I usually use an environment variable set in the calling program.

e.g. in UNIX (csh):
setenv SUB_OUT_NAME VARNAME
quiz auto=somequizjob
> [quiz statements]
> set subfile name $SUB_OUT_NAME keep
> go
> exit


jb


-----Original Message-----
From: Viet Nguyen [mailto:VNguyen@wsboces.org]
Sent: Tuesday, October 12, 2004 1:41 PM
To: powerh-l@lists.sowder.com
Subject: subfile name


Hi All,
   How do I set subfile name based on a variable
   For Example: Every Month we run a report and I want to save data to a
file name with the month as part of the file name i.e SAVE01, SAVE02,
SAV03 etc... Let's say the variable is xMonth - values 01,02,03...etc...
Thanks in advance.
Viet.



-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of
brian_matthewsbrian matthews
Sent: Wednesday, September 29, 2004 7:49 PM
To: Kristina.Carlton@JICompanies.com; powerh-l@lists.sowder.com
Subject: RE: Linking tables

sorry Kristina, I missed the data example.


>From: Kristina Carlton <Kristina.Carlton@JICompanies.com>
>To: powerh-l@lists.sowder.com
>Subject: Linking tables
>Date: Wed, 29 Sep 2004 16:54:36 -0500
>
>Hi List,
>
>I am using OpenVMS v7.3-2 and Quiz V7.10.G4.
>
>My intention is to link to a table twice but link on different fields.
The
>table is self-referencing and contains physician information. Each 
>physician
>has a tin (FEIN) and a sub tin (provider within a facility). If the
>physician works for a clinic he would be listed with the clinic's tin
plus 
>a
>sub tin, but the name field would contain his name. The clinic has no
sub
>tin.
>
>In the case of a physician having his own practice he would be listed
twice
>with the same tin, but once without a sub tin and once with a sub tin.
Each
>record will have the same name. This would look as follows:
>
>TIN		SUB TIN		NAME
>75-261977			Victory Medical Services
>75-261977	001		Dr. Franklin
>75-261977	002		Dr. Garcia
>and so on
>
>75-269999			Dr. Williams
>75-269999	001		Dr. Williams
>
>I need to link to this file twice in order to get the physician's name
as
>well as the clinic name and also to determine if it is a clinic or an
>individual. The physician file (PRV) has a combo key on tin/sub tin.
The
>file I am linking to has tin and sub tin as well. I want to link to it
once
>by tin and sub tin and that part is no problem. However, when I attempt
to
>link to it again (giving an alias) with tin only, I get the following
error
>message:
>
>Access PRV viaindex PRV_KEY0.
>                                               ^
>*E* Expected:  <file>
> >        TO TIN_NUM OF PRV ALIAS PRV1
>          ^^
>
>Can someone tell me what the correct syntax is? Also, the other file I
am
>linking to is a subfile, not a database table.
>
>Thanks,
>-Kristina
>Ext. 2459
>
>

_________________________________________________________________
Express yourself with cool new emoticons
http://www.msn.co.uk/specials/myemo

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.