sqlcode=-843/SQL0843N why ....

[Kim Bundgaard]

Hi

I got a sqlcode=-843 (SQL0843N) in my PL/I-program running against DB2 z/OS
V7, when I issue RELEASE CURRENT.

I can't see why I get this error - and I can't reproduce it.

My program only do the implicit connect to local db2 subsystem, but it issue
a RELEASE CURRENT and get the SQL0843N/sqlcode=-843.

Can anyone explain under which circumstances the -843/SQL0843N come ?

Regards
Kim

[Mark Yudkin]

Re: sqlcode=-843/SQL0843N why ....

-843 means you're disconnecting without having connected in the first place.
Since you're implicitly connecting, this may well be an expected condition -
in which case, you should just catch and ignore it.

"Kim Bundgaard" <kib at kmd.dk> wrote in message
news:40e3f61d$0 $183$edfadb0f@d read11.news.tel e.dk...[color=blue]
> Hi
>
> I got a sqlcode=-843 (SQL0843N) in my PL/I-program running against DB2[/color]
z/OS[color=blue]
> V7, when I issue RELEASE CURRENT.
>
> I can't see why I get this error - and I can't reproduce it.
>
> My program only do the implicit connect to local db2 subsystem, but it[/color]
issue[color=blue]
> a RELEASE CURRENT and get the SQL0843N/sqlcode=-843.
>
> Can anyone explain under which circumstances the -843/SQL0843N come ?
>
> Regards
> Kim
>
>[/color]