viktaeh,
[ QUOTE ]
truncate table PD812.proddta.f0911
that will take care of everything. good luck.
[/ QUOTE ]
Yes that would "take care" of everything - including your job. All the best for your search for another one.
However, if you elect not to take such "decisive" action, please provide more details. You have been registered as a user for over 18 months and therefore should probably realise by now that to get appropriate answers you need to provide appropriate detail. You really need to help us to help you. All your question reveals is that you want to delete some data and at some point you have changed from world to oneworld. Whether the change from world to oneworld is because your employer changed, you changed employers, or you are a consultant working for your second client, is unknown, and probably not important.
What is important is:
1) What version of JDE Oneworld are you using? (eg 8.11sp1)
2) What tools release are you using? (eg 8.97.2.1)
3) What is your platform for the enterprise server, database server and webserver? (eg enterprise server: Sun, database server: Sun, web server: windows)
4) What is you database? (eg Oracle)
5) what data do you want to delete and why? (eg archive old data from F0911)
If you deleted data in world with SQL, then why can't you do the same in oneworld?