Deleting OMW projects outside OneWorld

I am interested in deleting old OMW projects in OneWorld as many users have both an exceptional amount of objects in their default, and some previous developers have an exceptional number of projects. Doing this through OMW can be very time consuming so I am planning to use Access.

My plan for projects to be deleted is to remove all like records from the F98220, F98221, and F98222 according to OMWPRJID. For default projects with too many objects, I was simply going to delete specific records from F98222.

My question is with regard to F98210 (Logging Header) and F98211 (Logging detail). I had originally planned to delete records here as well to avoid having logging records for projects that do not exist, but I ran a test and found that deleting projects in OMW writes additional records to both log tables. Some logs are in reference to the original software update process (this is in regard to projects beginning in JD######.

Does any one see me walking myself right into a problem by leaving F98210 and F98211 records behind?

Thanks.

Ryan Hunt
OneWorld XE; Update2; SP17.1_C1
AS400; V4R5
DS: Win2k SP2, SQL 7.0 SP3
TSE's: Win2k(SP2) & NT4.0(SP6a) with Metaframe 1.8

I don't think that there will be an issue with the tables. However, you could do this A LOT easier with SQL.

Matthew Scott
XE, SP 17.1, AS/400, Win2000 Logic Servers, Win2000 Term. Servers, Win2000 Java Servers, Central Objects in Oracle.

Hi Ryan,

Why don't you try running the R98222B to Purge OMW Projects first, this might reduce the number of projects

Adrian Valentim
Valmatrix Consulting Inc.

Mathew,
I am sometimes DB chalenged. ;-) How would I do this?

Thanks!

Ryan Hunt
OneWorld XE; Update2; SP17.1_C1
AS400; V4R5
DS: Win2k SP2, SQL 7.0 SP3
TSE's: Win2k(SP2) & NT4.0(SP6a) with Metaframe 1.8

Adrian,

I didn't realize that UBE was there. I am running some trials with it now. Thanks for the info.

Ryan Hunt
OneWorld XE; Update2; SP17.1_C1
AS400; V4R5
DS: Win2k SP2, SQL 7.0 SP3
TSE's: Win2k(SP2) & NT4.0(SP6a) with Metaframe 1.8

Do you still want the SQL syntax, or are you going to go with the UBEs?

Matthew Scott
XE, SP 17.1, AS/400, Win2000 Logic Servers, Win2000 Term. Servers, Win2000 Java Servers, Central Objects in Oracle.

The SQL syntax would be great. Thanks. RH



Ryan Hunt
OneWorld XE; Update2; SP17.1_C1
AS400; V4R5
DS: Win2k SP2, SQL 7.0 SP3
TSE's: Win2k(SP2) & NT4.0(SP6a) with Metaframe 1.8

Yes, please. I would still like to see the SQL syntax.

Thanks.

Ryan Hunt
OneWorld XE; Update2; SP17.1_C1
AS400; V4R5
DS: Win2k SP2, SQL 7.0 SP3
TSE's: Win2k(SP2) & NT4.0(SP6a) with Metaframe 1.8

Hmmm. lets see. AS/400....

You have to start SQL, so enter STRSQL at the command line.

then it delete * from LIBRARY/FILE where OMWPRJID = 'WHATEVER THE VALUE IS';

Just run this for each project you want to delete. If you had some other SQL utility, you could develop a script to run.

I hope this helps. By the way, I am not very DB oriented either...


Matthew Scott
XE, SP 17.1, AS/400, Win2000 Logic Servers, Win2000 Term. Servers, Win2000 Java Servers, Central Objects in Oracle.

Proper AS/400 syntax has no * and no ; in this sql statement. Otherwise
you are very close!

Also, try
delete from LIBRARY/FILE where OMWPRJID in ('value 1', 'value 2', ...,
'value n')
for multiple values. F9 will also help tremendously by retrieving the last
SQL statement and simply change the FILE.



Good luck


Adam Clark
Corporate Information Services
Office: (626) 434-4275





msouterblight1
<matthew.scott@archon To: [email protected]
group.com> cc:
Sent by: Subject: Re: Deleting OMW projects outside OneWorld
owner-jdelist@jdelist
.com


02/28/2002 02:31 PM
Please respond to
jdelist






Hmmm. lets see. AS/400....

You have to start SQL, so enter STRSQL at the command line.

then it delete * from LIBRARY/FILE where OMWPRJID = 'WHATEVER THE VALUE
IS';

Just run this for each project you want to delete. If you had some other
SQL utility, you could develop a script to run.

I hope this helps. By the way, I am not very DB oriented either...


Matthew Scott
XE, SP 17.1, AS/400, Win2000 Logic Servers, Win2000 Term. Servers, Win2000
Java Servers, Central Objects in Oracle.
--------------------------
Visit the forum to view this thread at:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OW&Number=29844
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list / forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+






Adam Clark
Project Manager
Golden State Foods -- Information Services

Thank you for the syntax clarification. Like I said, I am DB deficient.

Matthew Scott
XE, SP 17.1, AS/400, Win2000 Logic Servers, Win2000 Term. Servers, Win2000 Java Servers, Central Objects in Oracle.

Adam and Mathew...thanks! ...been caught up in Non-jde stuff. Sorry for the late "thanks".

Regards.

Ryan Hunt
OneWorld XE; Update2; SP17.1_C1
AS400; V4R5
DS: Win2k SP2, SQL 7.0 SP3
TSE's: Win2k(SP2) & NT4.0(SP6a) with Metaframe 1.8