subfile name

[Joe Boyle]

I think the following works on Unix, VMS and NT and possibly HP3000 (  the
syntax in braces [ logical , "lnm$job" ] is required for VMS only ), but the
two quiz processes have to be executed in the same quiz session - see below.

$ typ jotst1.qts

can cle
set def

set input lim 1

access nocent-rec

define d'subname char*50 =                      &
        truncate ( logonid) + "-" +             &
        truncate ( ascii(sysdate,8) )           &
        + "-" + truncate ( ascii(systime,12) )

define d'set-subname = 1       &
if setsystemval ( "sfjotst2" , d'subname, logical , "lnm$job")

subfile my-dummy temp include d'set-subname 

bui jotst1

then

$ typ jotst2.qzs

can clea
set defa
set rep nolim
acc  date-rec-lin
set sub nam sfjotst2 keep
rep summ  date-key  date-6  date-8
bui  jotst2

quiz
>exe jost1.qzc
>exe jost1.qzc
>exit


Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this 
e-mail and any attachments sent with it may have been altered without the
consent or knowledge of the author.

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Viet Nguyen
Sent: 12 October 2004 19:41
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.