Facing a big Problem In DEV

[udaik3]

Hi
We are now in the Dev Stage with Junk data in our
Business Data Test Data Source. We want to get rid of
those data in Transaction table alone. I know by using
Object Use in Omw we can Identify, but not so
confirmed.

We have tha Copy of the same setup in CRP too.
So pls advice me on how to Clear all tables(delete
data alone in all tables) on DV and copy only Few
tables like System setup tables, and all necessary
tables which were used to setup the CRP. Our control
Table is OK, only problem with Business data data
Source.

Note: If someone can tell me on how to Identify the
System setup tables and other necessary tables to be
copied from CRP to DV, then we can input fresh and
perfect data to proceed with our developmwnt.

Its Really critical And Development has stoped Because
of junk data.

Udai

 

[jdebill]

Hi Udai,

I think you need to tell us the information about your system, especially your data base. Then someone can give you more help

Thank You,
Bill
Windows NT, SQL 7, XE 17.0

 

[tnelipov]

Depending on exactly what you desire to do, some of the Oracle examples
below may help. I recommend having a clear goal / plan in mind before
manipulating data. I am not clear on what you mean by "System setup
tables"... do you mean SYSB733 tables or just business data / control tables
in CRP?

If CRP is fine, you may just want to do a refresh. You could export any
data you want to retain and then load it back in. Question of which method
is easiest given your situation.


DELETE FROM devdta.f0102 WHERE column_name = value;

TRUNCATE TABLE devdta.f0102;

CREATE TABLE devdta.f0102 AS (SELECT * FROM proddta.f0102);

If you are manipulating large tables, I would suggest using IMP / EXP to
save time.

SQL Server uses similar SQL commands and has tools similar to IMP / EXP.

Tony Nelipovich

=============================

Hi
We are now in the Dev Stage with Junk data in our
Business Data Test Data Source. We want to get rid of
those data in Transaction table alone. I know by using
Object Use in Omw we can Identify, but not so
confirmed.

We have tha Copy of the same setup in CRP too.
So pls advice me on how to Clear all tables(delete
data alone in all tables) on DV and copy only Few
tables like System setup tables, and all necessary
tables which were used to setup the CRP. Our control
Table is OK, only problem with Business data data
Source.

Note: If someone can tell me on how to Identify the
System setup tables and other necessary tables to be
copied from CRP to DV, then we can input fresh and
perfect data to proceed with our developmwnt.

Its Really critical And Development has stoped Because
of junk data.

Udai




------------------------------------------------------------------------------
This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

==============================================================================

 

[Larry_Jones]

Look at the documentation (Knowledge Garden) on R98403 - specifically the processing option regarding Loading Production vs Demo Data. I believe setting to '1' (Load Production Data) will copy master tables and zero the transaction tables. I have not tried this but that is my understanding. See versions XJDE0021 and XJDE0022 as samples of copying data between data sources.

Regards,

Larry Jones
[email protected]
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials

 

[flyingmg]

We experienced the same problem too. I usually deal with it in two ways.

1. If you can individually and specifically identify those tables you wou=
ld like to refresh, you can use standard SQL scripts such as delete/trunc=
ate table/insert into;

2. If the number of tables are too large to delete/copy one at a time, yo=
u may need blow away the whole DEV database (not objects) and then copy C=
RP database into DEV. Of course the assumption is your CRP has all the da=
ta you need. And Solution 2 may take more than one day if you have a larg=
e database.

I am not sure there is a canned UBE in JDE to do the same thing. However,=
you can always design one. The list of JDE tables is store in Object Lib=
rarian's tables.

MG

----- Original Message -----
From: udaik3
Sent: Monday, January 21, 2002 12:56 PM
To: [email protected]
Subject: Facing a big Problem In DEV

Hi
We are now in the Dev Stage with Junk data in our
Business Data Test Data Source. We want to get rid of
those data in Transaction table alone. I know by using
Object Use in Omw we can Identify, but not so
confirmed.

We have tha Copy of the same setup in CRP too.
So pls advice me on how to Clear all tables(delete
data alone in all tables) on DV and copy only Few
tables like System setup tables, and all necessary
tables which were used to setup the CRP. Our control
Table is OK, only problem with Business data data
Source.

Note: If someone can tell me on how to Identify the
System setup tables and other necessary tables to be
copied from CRP to DV, then we can input fresh and
perfect data to proceed with our developmwnt.

Its Really critical And Development has stoped Because
of junk data.

Udai





--------------------------


G
[email protected]

 

[Terry B]

It sounds like you want to clean out your transaction data, but retain your setup info (AAI's, Company Constants etc,).

Here are a couple of ways of doing this. The first way is really an interim measure to clean out the junk.

1) Just clean out the tables you know are full of junk. If you are wiping a header table, then ensure the detail is cleared also. This approach will work for transactional data (Sales Order detail, F0911 etc) but is not such a good idea for master info (ie Item Master or Account Master).
This method is really just a selective purge.

2) This is the same approach as Larry's post (with a couple of additions). Using the R98403 UBE and the flag CPYD in the Object Librarian is another way to selectively copy data over. The flags on the OL specify whether to copy data, or to create a blank table.
There are about 170 tables already defined with this flag set to a Y.

Both methods require you to know which tables should be kept and which tables should be cleared.

My 2 cents...

Kind regards
Terry

OW XE SP14.2 ES=AS400 V4R5, DS=NT4.0
Set up OW Security FAST. QSeries - For all your OW Security needs www.qsoftware.com/products/qseries/