SQL PLUS SYSTEM login as a manager DESC PDM.PDM_RELEASELEVEL; update pdm.pdm_releaselevel set RLNAME='new RL name' WHERE RLNAME='old RL name'; COMMIT; ========================= SQL PLUS SYSTEM login as a manager DESC PDM.PDM_RELEASELEVEL; UPDATE PDM.PDM_RELEASELEVEL='new RL name' WHERE RLNAME='old RL name'; COMMIT; ========================= Subj: [datamgt] RE: rename release levels Date: 7/4/2003 1:36:33 AM Eastern Standard Time From: "Kakoussis, Yiannis" To: "datamgt" Reply-To: "Kakoussis, Yiannis" Sent from the Internet (Details) It seems to be very easy. Follow the next steps SQL PLUS SYSTEM login as a manager DESC PDM.PDM_RELEASELEVEL; update pdm.pdm_releaselevel set RLNAME='new RL name' WHERE RLNAME='old RL name'; COMMIT; This worked just fine for all of my objects Good luck Yiannis Kakoussis Product Design Engineer R&D Shavers Bic Violex S.A. Aghiou Athanasiou Str. 145 69 Anixi, Greece * Tel : +30 210 6299 461 * Fax : +30 210 8140 524 * mailto:yiannis.kakoussis@bicworld.com -----Original Message----- From: charlie.sears@radiusdevelopment.com [mailto:charlie.sears@radiusdevelopment.com] Sent: Thursday, July 03, 2003 2:44 PM To: datamgt Subject: [datamgt] rename release levels How easy is it to write a SQL script that would go through all table data and rename any instance of release level "WIP" with "Draft"? We are using 3.2 SP2 on an windows 2000 server. Thanks, Charlie --- You are currently subscribed to datamgt as: Yiannis.Kakoussis@bicworld.com To unsubscribe send a blank e-mail to %%email.unsub%% For assistance, contact listadmin@ptcuser.org or visit our web site at www.ptcuser.org/exploder . PTC/USER and the PTC/USER logo are registered trademarks of PTC/USER, Inc. Pro/ENGINEER is a registered trademark of PTC. Message authors are solely responsible for the content of their posts. ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________ ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________ --- You are currently subscribed to datamgt as: datajett@aol.com To unsubscribe send a blank e-mail to leave-datamgt-17687U@ptcuser.org For assistance, contact listadmin@ptcuser.org or visit our web site at www.ptcuser.org/exploder . PTC/USER and the PTC/USER logo are registered trademarks of PTC/USER, Inc. Pro/ENGINEER is a registered trademark of PTC. Message authors are solely responsible for the content of their posts.