subfile name

[Johnson, Tracy]

In our monthly process we just rename it 
after-the-fact outside of Powerhouse in the JCL.

Our code just uses a static name that never changes,
we let the O/S take care of file naming conventions.

BT


Tracy Johnson
MSI Schaevitz Sensors 

> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com
> [mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Joe Boyle
> Sent: Tuesday, October 12, 2004 3:47 PM
> To: 'Viet Nguyen'; powerh-l@lists.sowder.com
> Subject: RE: subfile name
> 
> 
> 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.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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.
>