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

Clear Table - Thank You Zoltan !.... But...

Joseph_Sadler

Well Known Member
"Üdvozöljük" Zoltan.
And thank you most kindly.
We simply used the parameters on the B8000007 BSFN incorrectly.
It is now working great.

But still one more question, if you please:
The BSFN literally deletes the records.
It does not actually CLEAR the table.
These work tables will require maintenance on the AS/400
to reorg and compress out deleted records.
Is there not a BSFN that actually "Clears" the table, prior to populating
it?

And thank you once again for helping us get B8000002 working again.

Joseph Sadler,
World Vision Canada.
Helping the children of war and poverty, the world over.
Xe SP13, NT4 SQL 7, AS/400.
 

Zoltan_Gyimesi

Legendary Poster
Welcome Joseph,
Thank you, especially the Hungarian greetings: "Üdvözöljük!".

In response to your "BUT" question:

I have never tried but you can try to create a "dummy" Table Conversion UBE where your table is the Output and check the "Clear Output Table before Conversion" check box on the Table Conversion Properties sheet. Do not attach any logic and input/output to this UBE just the necessary declarations that need to create a valid TC UBE. Call this TC UBE at the place of your logic where do you want to clear the table.

I am very curious to that is it working and if it is working the is it CLEARing or DELETEing, SO Please, share your results wih us. Thnx.

Regards,
Zoltán



B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Joseph_Sadler

Well Known Member
Üdvözöljük Zoltan.

I just did wanted you to know that we have not yet had the time to try your
suggestion about the "dummy" Table Conversion UBE to clear the Z1 table.
Thanks to your help with B8000002 we have been able to go forward again.
But we will try your suggestion when time permits. I'm sure it will work.
Thank you once again. You are a valuable asset to the List.

Happy Easter weekend to all !

Joseph Sadler,
World Vision Canada.
Helping the children of war and poverty, the world over.
Xe SP13, NT4 SQL 7, AS/400.




Zoltan_Gyimesi
<zoltan.gyimesi@sy To: jdeowdevml@jdelist.com
nergon.hu> cc:
Sent by: Subject: Re: Clear Table - Thank You Zoltan
owner-jdeowdevml@j !.... But...
delist.com


03/29/01 04:19 PM
Please respond to
jdeowdev






Welcome Joseph,
Thank you, especially the Hungarian greetings: "Üdvözöljük!".

In response to your "BUT" question:

I have never tried but you can try to create a "dummy" Table Conversion UBE
where your table is the Output and check the "Clear Output Table before
Conversion" check box on the Table Conversion Properties sheet. Do not
attach any logic and input/output to this UBE just the necessary
declarations that need to create a valid TC UBE. Call this TC UBE at the
place of your logic where do you want to clear the table.

I am very curious to that is it working and if it is working the is it
CLEARing or DELETEing, SO Please, share your results wih us. Thnx.

Regards,
Zoltán



B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OWDEV&Number=8305
 

CHo

VIP Member
I don't know the original question, but the workaround that Zoltan proposed works.

The only problem is that a table conversion needs to be created for each table that is to be cleared. There is no option in the version to override the output table.
 

DBohner-(db)

Legendary Poster
C,

If you put the TC/Clear File in debug and look at the log, is it running a BSFN that does a CLRPFM or is it doing a SQL Delete * from... or is it doing a delete on each record?

My guess - and I'll have to review it some day - is that it is doing a delete on each record.

We have a tweaked BSFN that allows us to call AS400 commands from within JDE Applications and/or UBE/TC(s). Usually I create a parent UBE that will sub-call all the TC(s) or other UBE(s) that need tables cleared. Within the parent, I call the BSFN that will send the clrpfm command to the 400.

db
 

CHo

VIP Member
It sounds like a good solution.

I won't have time to implement it. It'll be faster writing a CL program.

Thanks.
 
Top