Copy from environment to environment!!

Hi there,
I am using table conversion tool to copy a range of records from Prototype environment to Production

environment (using F0101 table)
and I followed the JDE Wizard of table conversion
I used Data copy with table input option
and I used the "where" clause to specifiy the addresses I need to copy
BUT!! it copied the Whole table from F0101 in the Prototype environment to the production!!!

is there any thing wrong in the tool itself??? or I missed something??
please help
Thank you

Hi,
why don't you use a simple report with data selection?
Gigi

Thankx gigi for your reply
but how I can use Reports to copy data from environment to environment??
sorry for my questions but I'm still a beginner in JDE

Thanks

Its hard to make a suggestion without seeing your table conversion, but here
are two things to check:

1. Make sure the data selection isn't overridden in the version.

2. If you are on an AS400, check with CNC/Admin to make sure SQL packages
are being cleared on the AS400.

Ellen



Ellen Deak
Senior Analyst/Programmer
Cooper-Standard Automotive
OneWorld Xe (B7333, Service Pack 22)
AS/400 DB2

Thanks for your help.
I've used the first option in the data conversion tool to copy the records and it worked fine.

Regards

Hi Developer

Is this conversions a 'one off'? Moving data between environments can also be achieved through DTS (if you use Sequel), Enterprise manager or straight SQL. If the selection of data to be copied is straight forward, these type of jobs are very quick and there is no need to create a table conversion UBE.

Rgds

I have a VB app that uses Sequel bulk copy to perform this process. It out
performs any other option at least 3 to 1. If you would like I can share
the code. Let me know.



Sef
<[email protected]. To: [email protected]
au> cc:
Sent by: Subject: Re: Copy from environment to environment!!
jdeowdev-bounces@
jdelist.com


12/21/2003 04:11
PM
Please respond to
JDELIST One World
Developers
Discussions






Hi Developer

Is this conversions a 'one off'? Moving data between environments can also
be achieved through DTS (if you use Sequel), Enterprise manager or straight
SQL. If the selection of data to be copied is straight forward, these type
of jobs are very quick and there is no need to create a table conversion
UBE.

Rgds
Sef van den Nieuwelaar
Australia
E81 on NT/SQL, XE on NT/Oracle
--------------------------
To view this thread, go to: http://www.jdelist.com/ubb/showthreaded.php?Cat
=&Board=OWDEV&Number=65685

This is the JDELIST One World Developers Mailing List. To stop receiving
these messages, login to http://www.jdelist.com/forums, click Control
Panel, then click Edit by "Subscribe / Unsubscribe from receiving board
posts by email, change message notifications, etc." and adjust your
subscription preferences. JDEList is not affiliated with JDEdwards®