• 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!

Re: Clearing work files in UBE's

Joseph_Sadler

Well Known Member
Re: Clearing work files in UBE\'s

Hi list.
I have followed this exchange closely, as we also wish to know how to
CLEAR a workfile. The delete method in a loop is simply not acceptable
for large files. Certainly there must be a business function that will
clear
the entire table.

Does anybody out there know how to "clear" the table?




euroboy
<sabirpatankar@exc To: jdeowdevml@jdelist.com
ite.co.uk> cc:
Sent by: Subject: Re: Clearing work files in UBE's
owner-jdeowdevml@j ~~2419:2475
delist.com


12/12/00 05:56 AM
Please respond to
jdeowdev






Thanks guys for all your answers. I did know I could use the delete IO
statement ... but when you've got thousands of records in the file I didnt
want to that as its not CPU effective.

Zoltan, if u are reading this, then please answer this. Yes I did like
your use of a key identifier .. but then how are you deleting / clearing
the set of records belonging to a particular key??? Using table IO delete
statement in a loop?? I suppose thats the only way in this case.


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OWDEV&Number=2475
*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 

pcaenaro

Well Known Member
Re: Clearing work files in UBE\'s

Hi Joseph

The function is called "Delete all rows from Table" (B8000002) and accepts
the Table name as a parameter.

Regards

Philippe


----- Original Message -----
From: "Joseph_Sadler" <Joseph_Sadler@worldvision.ca>
To: <jdeowdevml@jdelist.com>
Sent: Tuesday, December 12, 2000 7:09 AM
Subject: Re: Clearing work files in UBE's ~~0:2492


>
> Hi list.
> I have followed this exchange closely, as we also wish to know how to
> CLEAR a workfile. The delete method in a loop is simply not acceptable
> for large files. Certainly there must be a business function that will
> clear
> the entire table.
>
> Does anybody out there know how to "clear" the table?
>
>
>
>
> euroboy
> <sabirpatankar@exc To:
jdeowdevml@jdelist.com
> ite.co.uk> cc:
> Sent by: Subject: Re: Clearing
work files in UBE's
> owner-jdeowdevml@j ~~2419:2475
> delist.com
>
>
> 12/12/00 05:56 AM
> Please respond to
> jdeowdev
>
>
>
>
>
>
> Thanks guys for all your answers. I did know I could use the delete IO
> statement ... but when you've got thousands of records in the file I didnt
> want to that as its not CPU effective.
>
> Zoltan, if u are reading this, then please answer this. Yes I did like
> your use of a key identifier .. but then how are you deleting / clearing
> the set of records belonging to a particular key??? Using table IO delete
> statement in a loop?? I suppose thats the only way in this case.
>
>
> --------------------------
> Visit the forum to view this thread at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
> =&Board=OWDEV&Number=2475
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>
>
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Numb
er=2492
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
 

barrier

Reputable Poster
Re: Clearing work files in UBE\'s

I suppose you could use B9800200 (Drop Table and Create Table) as used in
JDE application P9866. It would probably be faster but I think it would
also be very dangerous.

B.




Joseph_Sadler
<Joseph_Sadler@world To: jdeowdevml@jdelist.com
vision.ca> cc:
Sent by: Subject: Re: Clearing work files in UBE's ~~0:2492
owner-jdeowdevml@jde
list.com


12/12/00 10:09 AM
Please respond to
jdeowdev







Hi list.
I have followed this exchange closely, as we also wish to know how to
CLEAR a workfile. The delete method in a loop is simply not acceptable
for large files. Certainly there must be a business function that will
clear
the entire table.

Does anybody out there know how to "clear" the table?




euroboy
<sabirpatankar@exc To:
jdeowdevml@jdelist.com
ite.co.uk> cc:
Sent by: Subject: Re: Clearing
work files in UBE's
owner-jdeowdevml@j ~~2419:2475
delist.com


12/12/00 05:56 AM
Please respond to
jdeowdev






Thanks guys for all your answers. I did know I could use the delete IO
statement ... but when you've got thousands of records in the file I didnt
want to that as its not CPU effective.

Zoltan, if u are reading this, then please answer this. Yes I did like
your use of a key identifier .. but then how are you deleting / clearing
the set of records belonging to a particular key??? Using table IO delete
statement in a loop?? I suppose thats the only way in this case.


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OWDEV&Number=2475
*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************







--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=2492

*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
Re: Clearing work files in UBE\'s

Try Business Function B8000002 - Delete All Rows from Table


---------------------- Forwarded by Chris Mueller/dhagroup/US on 12/12/2000
11:07 AM ---------------------------


Joseph_Sadler <Joseph_Sadler@worldvision.ca> on 12/12/2000 10:09:09 AM

Please respond to jdeowdev@jdelist.com

To: jdeowdevml@jdelist.com
cc: (bcc: Chris Mueller/dhagroup/US)
Subject: Re: Clearing work files in UBE's ~~0:2492





Hi list.
I have followed this exchange closely, as we also wish to know how to
CLEAR a workfile. The delete method in a loop is simply not acceptable
for large files. Certainly there must be a business function that will
clear
the entire table.

Does anybody out there know how to "clear" the table?




euroboy
<sabirpatankar@exc To: jdeowdevml@jdelist.com
ite.co.uk> cc:
Sent by: Subject: Re: Clearing work
files in UBE's
owner-jdeowdevml@j ~~2419:2475
delist.com


12/12/00 05:56 AM
Please respond to
jdeowdev






Thanks guys for all your answers. I did know I could use the delete IO
statement ... but when you've got thousands of records in the file I didnt
want to that as its not CPU effective.

Zoltan, if u are reading this, then please answer this. Yes I did like
your use of a key identifier .. but then how are you deleting / clearing
the set of records belonging to a particular key??? Using table IO delete
statement in a loop?? I suppose thats the only way in this case.


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OWDEV&Number=2475
*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************







--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=2492

*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 

atlurip

Member
Re: Clearing work files in UBE\'s

Hi List,

To clear the work file(Everything) with out any
data selection on it you could use B8000002
(DeleteAllRowsfromTable), If u want to delete them
with some selection on it I think Table I/O is the
only option for us.

Thanks
Prash
--- Joseph_Sadler <Joseph_Sadler@worldvision.ca>
wrote:
>
> Hi list.
> I have followed this exchange closely, as we also
> wish to know how to
> CLEAR a workfile. The delete method in a loop is
> simply not acceptable
> for large files. Certainly there must be a business
> function that will
> clear
> the entire table.
>
> Does anybody out there know how to "clear" the
> table?
>
>
>
>
>
> euroboy
>
> <sabirpatankar@exc To:
> jdeowdevml@jdelist.com
> ite.co.uk> cc:
>
> Sent by:
> Subject: Re: Clearing work files in UBE's
> owner-jdeowdevml@j
> ~~2419:2475
> delist.com
>
>
>
>
>
> 12/12/00 05:56 AM
>
> Please respond to
>
> jdeowdev
>
>
>
>
>
>
>
>
>
> Thanks guys for all your answers. I did know I
> could use the delete IO
> statement ... but when you've got thousands of
> records in the file I didnt
> want to that as its not CPU effective.
>
> Zoltan, if u are reading this, then please answer
> this. Yes I did like
> your use of a key identifier .. but then how are you
> deleting / clearing
> the set of records belonging to a particular key???
> Using table IO delete
> statement in a loop?? I suppose thats the only way
> in this case.
>
>
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
> =&Board=OWDEV&Number=2475
>
*************************************************************
> This is the JDEList One World / XE Developers
> Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>
>
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=2492
>
>
*************************************************************
> This is the JDEList One World / XE Developers
> Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
 
Re: Clearing work files in UBE\'s

Call first the BSFN B8000007, ... then B8000002

Bye

-Claudio-
www.rtt.it


----- Original Message -----
From: "pcaenaro" <pcaenaro@mbox4.singnet.com.sg>
To: <jdeowdevml@jdelist.com>
Sent: Tuesday, December 12, 2000 4:59 PM
Subject: Re: Clearing work files in UBE's ~~2492:2498


> Hi Joseph
>
> The function is called "Delete all rows from Table" (B8000002) and accepts
> the Table name as a parameter.
>
> Regards
>
> Philippe
>
>
> ----- Original Message -----
> From: "Joseph_Sadler" <Joseph_Sadler@worldvision.ca>
> To: <jdeowdevml@jdelist.com>
> Sent: Tuesday, December 12, 2000 7:09 AM
> Subject: Re: Clearing work files in UBE's ~~0:2492
>
>
> >
> > Hi list.
> > I have followed this exchange closely, as we also wish to know how to
> > CLEAR a workfile. The delete method in a loop is simply not acceptable
> > for large files. Certainly there must be a business function that will
> > clear
> > the entire table.
> >
> > Does anybody out there know how to "clear" the table?
> >
> >
> >
> >
> > euroboy
> > <sabirpatankar@exc To:
> jdeowdevml@jdelist.com
> > ite.co.uk> cc:
> > Sent by: Subject: Re: Clearing
> work files in UBE's
> > owner-jdeowdevml@j ~~2419:2475
> > delist.com
> >
> >
> > 12/12/00 05:56 AM
> > Please respond to
> > jdeowdev
> >
> >
> >
> >
> >
> >
> > Thanks guys for all your answers. I did know I could use the delete IO
> > statement ... but when you've got thousands of records in the file I
didnt
> > want to that as its not CPU effective.
> >
> > Zoltan, if u are reading this, then please answer this. Yes I did like
> > your use of a key identifier .. but then how are you deleting / clearing
> > the set of records belonging to a particular key??? Using table IO
delete
> > statement in a loop?? I suppose thats the only way in this case.
> >
> >
> > --------------------------
> > Visit the forum to view this thread at:
> > http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
> > =&Board=OWDEV&Number=2475
> > *************************************************************
> > This is the JDEList One World / XE Developers Mailing List.
> > Archives and information on how to SUBSCRIBE, and
> > UNSUBSCRIBE can be found at http://www.JDELIST.com
> > *************************************************************
> >
> >
> >
> >
> >
> >
> >
> > --------------------------
> > To view this thread, visit the JDEList forum at:
> >
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Numb
> er=2492
> > *************************************************************
> > This is the JDEList One World / XE Developers Mailing List.
> > Archives and information on how to SUBSCRIBE, and
> > UNSUBSCRIBE can be found at http://www.JDELIST.com
> > *************************************************************
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Numb
er=2498
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
 
Top