How to replace Dictionary records?

[Deskin, Bob]

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.