• 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 in Xe ??

Joseph_Sadler

Well Known Member
Hi all.
Prior to Xe, we used BSFN "B8000002 - DeleteAllRowsFromTable" to clear a
table.
I don't remember if there was a second parameter for this BSFN in B7332,
but now there is an "OutputEnvHandle" parameter.

The "Business Function Notes" identifies B8000007 as a prerequisite.
So now we have:
B8000007 - Get Input Output Env Handles, using SL LoginEnvironment as the
input parameters.
B8000007 - Free Input Output Env Handles
B8000002 - Delete All Rows From Table

Debug shows that SL LoginEnvironment = PY7333
and the new "OutputEnvHandle" parameter = 58
but the file is not being cleared.

Can anybody suggest a solution ?

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
Hi Joseph,

We used B8000002 with succes under XE. We retrieved the env. handle also via B8000007 the following way:

Get Input Output Env Handles
UNDEFINED X szInputEnvironment
UNDEFINED X idInputEnvHandle
SL LoginEnvironment -> szOutputEnvironment
VA rpt_GenericLong1 <- idOutputEnvHandle
UNDEFINED X szLoginEnvironment

Delete All Rows From Table
"Fxxxxyyy" -> szTableName
VA rpt_GenericLong1 -> idOutputEnvHandle

It worked for us, namly it deletes the records from the table succesfully.

Please, let us know that does it work for you too. Thnx.

Zoltán

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

raiym74

Member
Joseph,

What is the sequence that you are using these business functions? As far as I remember, I used it as
B8000007 - Get Input Output Env Handles, using SL LoginEnvironment as the
input parameters.
B8000002 - Delete All Rows From Table
B8000007 - Free Input Output Env Handles
and it worked perfectly.

Hope this helps
Yathindra

One World XE
DS:WInNT ES:AS/400


Hi all.
Prior to Xe, we used BSFN "B8000002 - DeleteAllRowsFromTable" to clear a
table.
I don't remember if there was a second parameter for this BSFN in B7332,
but now there is an "OutputEnvHandle" parameter.

The "Business Function Notes" identifies B8000007 as a prerequisite.
So now we have:
B8000007 - Get Input Output Env Handles, using SL LoginEnvironment as the
input parameters.
B8000007 - Free Input Output Env Handles
B8000002 - Delete All Rows From Table

Debug shows that SL LoginEnvironment = PY7333
and the new "OutputEnvHandle" parameter = 58
but the file is not being cleared.

Can anybody suggest a solution ?

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




--------------------------
 

AS400Guru

Well Known Member
Hello,
What are the parameters that we have to pass to B8000007 Free Input Output Env Handles?.
Please let me know.
AS/400 V4R5 XE SP15 Co-existence.
 

Joseph_Sadler

Well Known Member
Zoltan was kind enough to help me out with this last week.
The Knowledge Garden has a good "How To" about it:
Document ID ott-01-0019

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



AS400Guru
<as400ow@hotmail.c To: jdeowdevml@jdelist.com
om> cc:
Sent by: Subject: Re: Clear Table in Xe ??
owner-jdeowdevml@j
delist.com


04/09/01 07:00 PM
Please respond to
jdeowdev






Hello,
What are the parameters that we have to pass to B8000007 Free Input Output
Env Handles?.
Please let me know.
AS/400 V4R5 XE SP15 Co-existence.


--------------------------
Visit the forum to view this thread at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat
=&Board=OWDEV&Number=8849
 

Zoltan_Gyimesi

Legendary Poster
Hi AS400Guru,
We worked around how to call this BSFN some weeks ago and was able to
use it with success.
Further, I shared our results on the List/Forum in the near past
responding a totally same question.
Unfortunatelly I haven't an appropriate Internet access temporarily, so
I am not able to search and identify this post for you.
Please, if you have internet access then try it to search yourself. Try
to search for B8000007 in subject field on all Forums in the last month.

Best regards,
Zoltán






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

bazscott

Member
Thanks Zoltan,

Just had cause to try that myself and it worked no problem in Xe.

Barry

Working at Miller Group, Edinburgh, Scotland
OneWorld Xe sp13 - Oracle - on Solaris and NT
 
Top