[Openroad-users] Deleting SCP's

[Kenneth.H.Olsson at tietoenator.com]

Hi James,
 
Another way of deleting the scp, ascp_Load_Metagen, DefineBPM, GetMetaDataInterface procs is to do it through the destroyapp command usingh the -c flag:
 
w4gldev destroyapp <database> <application> -c<scp>
 
>From a list of your apps components you could extract the names of the generated procs.
Make that into a batfile to issue the above destroyapp command.
Don't destroy your app, remember to use the -c flag!
 
Hope this helps
Kenneth 

Kenneth Olsson
TietoEnator Corporation
Digital Innovations
Kronborgsgränd 1
SE - 164 87 KISTA
Phone    +46 (0)  8 632 15 09 
Mobile   +46 (0)70 365 46 38 
Kenneth.H.Olsson at TietoEnator.com

________________________________

	From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Kerstin Fleck-Ruecker
	Sent: den 7 december 2006 08:57
	To: James.Higson at GUI-tek.com.au; International OpenROAD Users
	Subject: Re: [Openroad-users] Deleting SCP's
	
	
	Hi James,
	 
	here are the steps for removing the SCP's:
	 
	1.  Edit each method, in every User Class, in the application and examine the Generate SCP toggle box.
	2.  If the toggle is checked, then uncheck and save the method.  If not checked then simply continue checking the methods.
	3.  Run "Generate All SCPs" from Workbench's tools  menu.  All existing SCPs will be deleted by this process.
	4.  Then do a MakeImage on the application and make sure the  Generate SCP(s) toggle is unchecked.
	 
	There is SIR 110615 requesting: Add the ability to delete all SCPs from an application.
	 
	Hope this helps,
	 
	Kerstin
	 
	Kerstin Fleck-Ruecker

	Technical Support Specialist

	Ingres

	email: Kerstin.Fleck-Ruecker at ingres.com

	http://www.ingres.com

	 

	EMEA Support Toll free numbers :

	 

	DENMARK        80887727

	FRANCE           0800917212

	GERMANY        08001862072

	IRELAND          1800882387

	ITALY               800979184

	NETHERLANDS    08000225076

	SPAIN              900954413

	U.K.                 0800 5873071


________________________________

	From: openroad-users-bounces at peerlessit.com [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of James Higson
	Sent: Donnerstag, 7. Dezember 2006 08:00
	To: openroad-users at peerlessit.com
	Subject: [Openroad-users] Deleting SCP's
	
	
	
	We have a small problem with SCP's.  We "Generated All SCPs" using OR4.1MR (yeh, yeh, don't lecture me).  Later we exported the apps and imported them into a couple of other databases.  Now all the databases have SCP's in them, though we want to use the "other" databases for building client-server apps only.  The problem is exasperated by the fact that many of the SCP's fail to compile (strange, I know) and we can't delete them under SP3.
	 
	Since there is the ability to generate all SCP's, is there an undocumented way to remove all SCP's?
	 
	Am I going to have to export every component individually (all 3000 of them), then import individually?
	 
	Regards,
	James
	Melbourne, Australia

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://peerlessit.com/pipermail/openroad-users/attachments/20061207/9651f40a/attachment.html