Record deletion

[dalfanz]

List:

Within the toolset it looks like there is no option to do a delete/clear all
records even though SQL allows for this. Does this have to be done thru a C
function or another way to initialize a work table?

Otherwise it would seem thru an NER you have to set up a loop and request
delete thru all records?

Curious.

** Shared Knowledge = Better Knowledge **

Implementing B7333 (Xe) SP18.1, SQL

 

[sdollard]

Perry,

I usually do it in the initialize section for a work file. Just pick what
you want to base you delete on.

Steve Dollard
Weil-McLain
Programmer/Analyst JD Edwards XE
AS/400 ES, NT DS, Citrix,Agile,Cognos,JetForms,Sirius/MDLink and good ole
RPG.

The information contained in the electronic mail transmission is intended
by SPX Corporation for the use of the named individual or entity to which
it is directed and may contain information that is confidential or
privileged. If you have received this electronic mail transmission in
error, please delete if from your system without copying or forwarding it.
and notify the sender of the error by reply email or call the SPX Help Desk
at 215-293-2811.

** Shared Knowledge = Better Knowledge **

Implementing B7333 (Xe) SP18.1, SQL

 

[forjoydeep1]

Perry,

Yes this can be done using multiple ways.
1) in ur table i/o for delete for the P-Key set u can give selection like for an example DCTO <> '' and this wud select all the records..DCTO being the only P-Key.

2) Else use a C function. They call it Open table kind of thing which will return a pointer to you and using that u can use another C Function to purge all data. The name for this start with Delete ........ and in the end close the file using another c Function avaialable.

Thanks Joydeeo

 

[custhe]

I never tried this (only because I stumbled upon it on the List AFTER I needed it), but BSFN B8000002 Delete All Rows is yet another way.