Kill command illegar in a user transaction

[Isabel Pérez]

Hi ,

We have an aplication in Power Builder 6.0 that lists all the processes
in the database and allows the user to eliminate them clicking a button that
constains a call to a stored procedure that issues a Kill command for the
indicated process id. This worked o.k. in the past but now we get a message
like this: "The kill command is not legal in a user transaction".

We have the idea that this may be caused for the version of Sybase we
are using Sybase Adaptive Server. Can anybody tell if this idea is correct?
If not, why can this be happening?

Thanks in advance.

[Mark A. Parsons]

What version of Sybase were you using? What version of Sybase are you using?

Have any changes been made in your PB code, e.g., issuing a 'begin tran' before
calling the 'kill' proc? maybe turning on (off?) AUTOCOMMIT? maybe running in
chained-transaction mode?

It appears that somewhere you're getting a 'begin tran' issued before your call
to the 'kill' proc.
--
Mark A. Parsons

Iron Horse, Inc. iron_...@compuserve.com
Pegasys (200), Ltd peg...@internet.co.nz

[gustavo....@gmail.com]

I have a same problem and my code is look like that

if of_conectar () =1 then
ls_sql="kill "+ string(al_param2)
EXECUTE IMMEDIATE :ls_sql USING SQLCA_WS;
end if

Where "al_param2" is then number proccess

Function "of_conectar"
Integer li_retorno
// Profile Developer
SQLCA_WS.DBMS = "SYC Adaptive Server Enterprise"
SQLCA_WS.Database = "database"
SQLCA_WS.LogPass = "User"
SQLCA_WS.ServerName = "Password"
SQLCA_WS.LogId = "UserId"
SQLCA_WS.AutoCommit = False
SQLCA_WS.DBParm = "Release='12'"

connect using SQLCA_WS;

if SQLCA_WS.sqldbcode <> 0 then
li_retorno= -1
else
li_retorno= 1
end if

return li_retorno;