[Openroad-users] Deleting SCP's

[James Higson]

Yep, that was my next plan of attack.  I was hoping that someone was going
to point me to an undocumented feature; of which there appears to many in
OpenROAD.

  _____  

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
Kenneth.H.Olsson at tietoenator.com
Sent: Thursday, 7 December 2006 19:36
To: openroad-users at peerlessit.com
Subject: Re: [Openroad-users] Deleting SCP's


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/b3abc12f/attachment.html