• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

P00PURGE in One World!

MikeELUX

Member
Dear all,

In world it was easy to purge different files using P00PURGE. In One World the equivalent of P00PURGE is to write a 'batch delete' table conversion application apparently. I have tried to write a simple application which will run using data selection over the F0101Z2, but it does not work - I just get ' the following One World job did not finish successfully' in the work centre...
Am I missing something obvious...?
Has anyone else written simple routines to purge files for which One World do not provide a purge facility..?
Thanks...
Mike
 

neil_shepherd

Well Known Member
Hi Mike,

Although P00PURGE doesn't exist most of the programs do. From the Object Librarian (or OMW if your on XE) have a search for UBE's with *Purge* in the description and you'll find loads. To purge the F0101Z2 try R0101Z1P.

I've only used the btach delete a couple of times, but always without problem. Have you checked the "Delete all selected records" check box? Also ensure your data selection is correct for the environment you pointing at (which isn't necessarily the one you've logged into).

Regards

Neil.

OW B733.2, SP 11.1
Sun Solaris/UNIX
 

Carl_Fisher

Well Known Member
Are you Oracle or SQLServer?

We just use the standard Oracle SQL facility to Truncate a Table, so this is
done outside JDE.

However do a search on the List, I am sure there was a discussion a while
back on a Business Function to Empty Tables, and what you need to pass it to
get it to work.



OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + 4 NT PC's for development
 
Top