How to replace Dictionary records?

[Thomson, Martyn EDUC:EX]

I was afraid that might be the case.
Replacing the whole dictionary in other environments is not an option. They
are development, test and production and not in-sync, so I could potentially
be messing up other developers' work.
I think I'll write 2 scripts to be run before migrating the changed programs
- 
script1: save data to subfile, and display message "Delete Dict record in
POW before running script 2";
script2: Use PDL to "USE" and "LOAD" revised dict record/indices, use "PHDFM
FDL" to create an empty data file and .FDL, then reload the data.

Thanks all for your input.
Martyn Thomson

-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
Sent: December 11, 2004 3:52 AM
To: brian_matthewsbrian matthews; Thomson, Martyn EDUC:EX;
powerh-l@sowder.com
Subject: RE: How to replace Dictionary records?


There is no syntax ability to remove specific entities in PDL on MPE/iX,
OpenVMS, UNIX, or Windows. The best bet on OpenVMS, where the dictionary is
not a flat file, is to make the change centrally and generate the PDL to
recreate the dictionary in the other environments. Once you have that, you
can easily create a script that offloads the file to a subfile, deletes the
old dictionary, creates the revised dictionary, and reloads the file.

Bob Deskin              
Senior Product Manager, Application Development Tools
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
bob.deskin@cognos.com (613) 738-1338 ext 7268

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of brian_matthewsbrian
matthews
Sent: December 10, 2004 10:17 PM
To: Martyn.Thomson@gems1.gov.bc.ca; powerh-l@sowder.com
Subject: RE: How to replace Dictionary records?


I don't recall if POW lets you remove record structures.  If it does, you 
can run your script option once you have deleted the rec and exited POW, if 
not, you will get an error on the attempt to add the new record syntax.

I suspect you will have to rename a copy of your current dict , then delete 
it , and then do a rebuild after adding your altered syntax to a full pdl 
source file.

Bri,

>From: "Thomson, Martyn EDUC:EX" <Martyn.Thomson@gems1.gov.bc.ca>
>To: "POWERHOUSE NEW (E-mail)" <powerh-l@sowder.com>
>Subject: How to replace Dictionary records?
>Date: Fri, 10 Dec 2004 17:01:31 -0800
>
>Hello listers,
>I need to add a new field to the record and indices of an RMS file. A 
>simple
>task in POW, but I need to automate the replacement of the dictionary
>definition so it can be migrated between environments.
>The PDL manual states "A change to any of the index attributes requires you
>to unload, create and reload any associated files and record structures".
>I have created a PDL script with the new definition, but running it in PDL
>has no effect and gives no error messages. Do I need to delete the existing
>definition before loading the new? I can't find any PDL statement that does
>a global delete aka POW.
>Is there another approach to this? Any advice appreciated.
>I'm using 7.10g1 on OpenVMS Alpha V7.3-2.
>
>Regards,
>Martyn Thomson
>Information Management Branch
>Ministry of Education, Victoria, BC
>
>
>

_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now!  
http://toolbar.msn.co.uk/

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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. 
  
       This message may contain privileged and/or confidential information.
If you have received this e-mail in error or are not the intended recipient,
you may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.