Delete All Rows From Table

[RAG]

Hi All,

Does anyone know how to use the bf Delete All Rows From Table or any bf which deletes all rows from a table ?

Thanks a lot,

Renato

 

[DBohner-(db)]

The most direct route - and easiest to remember:

Use a Table Conversion. The TC Director will provide you that option during
creation.



_____

From: [email protected] [mailto:[email protected]] On
Behalf Of RAG
Sent: Monday, October 31, 2005 4:07 AM
To: [email protected]
Subject: Delete All Rows From Table



Hi All,

Does anyone know how to use the bf Delete All Rows From Table or any bf
which deletes all rows from a table ?

Thanks a lot,

Renato

Renato A. Garcia

_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.


Looking for a job? Check out the Job
forum


This is the JDELIST EnterpriseOne Developers Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwardsR.

 

[Its not on sale]

Here you go

Call B8000007 to get the environment handles

parameters to pass

1. SL Login environment ->

2. varaible (Environment in) <-

3. SL Login Environment ->

4. variable Environment out <-

5. SL Login Environment ->

then call B8000002 Delete all rows from table

1. Table name ->

2. variable Environment out ->

Then call B8000007 free inputoutenvironment handles



1. SL Login environment ->

2. varaible (Environment in) <->

3. SL Login Environment ->

4. variable Environment out <->

5. SL Login Environment ->

Regards

 

[CCM]

On the iSeries, when I use this BSFN, my PF on the iSeries shows that the Total deleted records is 4000, and each time I perform the BSFN, the Total of member sizes on the PF continues to increase, even though the file attribute to Reuse deleted records is *YES... Does anyone have any experience or information about the member size?

 

[Its not on sale]

Why don't you try running RGZPFM on the file and see if it helps you.



_____

From: [email protected] [mailto:[email protected]] On
Behalf Of CCM
Sent: Monday, October 31, 2005 2:47 PM
To: [email protected]
Subject: Re: Delete All Rows From Table



On the iSeries, when I use this BSFN, my PF on the iSeries shows that the
Total deleted records is 4000, and each time I perform the BSFN, the Total
of member sizes on the PF continues to increase, even though the file
attribute to Reuse deleted records is *YES... Does anyone have any
experience or information about the member size?

E1 8.11 8.95, iseries V5R3

_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.


Looking for a job? Check out the Job
forum


This is the JDELIST EnterpriseOne Developers Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwardsR.

 

[schatzie]

All I have ever done was find a field that was always the same in all records - example of a blank in field xxxx
I than used a variable and set it to blanks
I ran a delete with a variable = field xxxx
delete worked great for me