SQLCODE -206 received but the column is still there .....

Georg Peter

SQLCODE -206 received but the column is still there .....
Hi listers,

while binding a package one of our programmers received the following
SQLCODE -206:

BIND PACKAGE (E0OSSYENTW) OWNER(LEWIS) QUALIFIER(LEWIS) MEMBER(EA8KXE01)
.....
DSNX200I - BIND SQL ERROR

USING LEWIS AUTHORITY
SQLCODE=-206
SQLSTATE=42703
TOKENS=DEW64_DIGSTATUS
CSECT NAME=DSNXORSO
RDS CODE=-100
DSNT233I - UNSUCCESSFUL BIND PACKAGE =

DERRZD1DB21.E0OSSYENTW.EA8KXE01.(2001-02-01-17.55.25.462480)
DSN

After this SQLCODE we asked the catalog, if column DEW64_DIGSTATUS in table
LEWIS.DEW64 does not exist:

select colno, name
from sysibm.syscolumns
where tbname = 'DEW64'
and tbcreator = 'LEWIS'
and name = 'DEW64_DIGSTATUS'
;
---------+---------+---------+---------+---------+---------+--
COLNO NAME
---------+---------+---------+---------+---------+---------+--
22 DEW64_DIGSTATUS
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+--
---------+---------+---------+---------+---------+---------+--
DSNE617I COMMIT PERFORMED, SQLCODE IS 0

Any idea out there why the BIND PACKAGE why we received this damned -206
????

Thanks for any advice.

With kind regards - mit freundlichen Grüssen,
G e o r g H . P e t e r
DB2 Data Base Administrator c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Software Development & Technology Center
Knowledge Center Database Systems
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------



John Hardy

Re: SQLCODE -206 received but the column is still there .....
(in response to Scott Lindsey)
Hi,

What does the offending query look like?



On Fri, 9 Feb 2001 12:23:00 +0100, Peter, Georg <[login to unmask email]> wrote:

>Hi listers,
>
>while binding a package one of our programmers received the following
>SQLCODE -206:
>
>BIND PACKAGE (E0OSSYENTW) OWNER(LEWIS) QUALIFIER(LEWIS) MEMBER(EA8KXE01)
>.....
>DSNX200I - BIND SQL ERROR
>
>USING LEWIS AUTHORITY
>SQLCODE=-206
>SQLSTATE=42703
>TOKENS=DEW64_DIGSTATUS
>CSECT NAME=DSNXORSO
>RDS CODE=-100
>DSNT233I - UNSUCCESSFUL BIND PACKAGE =
>
>DERRZD1DB21.E0OSSYENTW.EA8KXE01.(2001-02-01-17.55.25.462480)
>DSN
>
>After this SQLCODE we asked the catalog, if column DEW64_DIGSTATUS in table
>LEWIS.DEW64 does not exist:
>
>select colno, name
> from sysibm.syscolumns
> where tbname = 'DEW64'
> and tbcreator = 'LEWIS'
> and name = 'DEW64_DIGSTATUS'
> ;
>---------+---------+---------+---------+---------+---------+--
> COLNO NAME
>---------+---------+---------+---------+---------+---------+--
> 22 DEW64_DIGSTATUS
>DSNE610I NUMBER OF ROWS DISPLAYED IS 1
>DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
>---------+---------+---------+---------+---------+---------+--
>---------+---------+---------+---------+---------+---------+--
>DSNE617I COMMIT PERFORMED, SQLCODE IS 0
>
>Any idea out there why the BIND PACKAGE why we received this damned -206
>????
>
>Thanks for any advice.
>
>With kind regards - mit freundlichen Grüssen,
>G e o r g H . P e t e r
>DB2 Data Base Administrator c/o
>-------------------------------------------------------------------
>Datenzentrale Baden-Wuerttemberg
>Software Development & Technology Center
>Knowledge Center Database Systems
>Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
>e:mail [login to unmask email]
>Phone 0049-711-8108-271
>PC-Fax 004971189696071
>Internet (only in german language):http://www.dzbw.de
>----------------------------------------------------------------------
>
>

http://www.ryci.com/db2-l. The owners of the list can be reached at DB2-L-
[login to unmask email]



Michael Ebert

Re: SQLCODE -206 received but the column is still there .....
(in response to Georg Peter)
Probably you're accessing the table through a view that does not contain the
column. For example, if the view is SELECT * but the column was later added to
the table, it will not be part of the view.

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany


Hi listers,

while binding a package one of our programmers received the following
SQLCODE -206:

BIND PACKAGE (E0OSSYENTW) OWNER(LEWIS) QUALIFIER(LEWIS) MEMBER(EA8KXE01)
.....
DSNX200I - BIND SQL ERROR

USING LEWIS AUTHORITY
SQLCODE=-206
SQLSTATE=42703
TOKENS=DEW64_DIGSTATUS
CSECT NAME=DSNXORSO
RDS CODE=-100
DSNT233I - UNSUCCESSFUL BIND PACKAGE =

DERRZD1DB21.E0OSSYENTW.EA8KXE01.(2001-02-01-17.55.25.462480)
DSN

After this SQLCODE we asked the catalog, if column DEW64_DIGSTATUS in table
LEWIS.DEW64 does not exist:

select colno, name
from sysibm.syscolumns
where tbname = 'DEW64'
and tbcreator = 'LEWIS'
and name = 'DEW64_DIGSTATUS'
;
---------+---------+---------+---------+---------+---------+--
COLNO NAME
---------+---------+---------+---------+---------+---------+--
22 DEW64_DIGSTATUS
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+--
---------+---------+---------+---------+---------+---------+--
DSNE617I COMMIT PERFORMED, SQLCODE IS 0

Any idea out there why the BIND PACKAGE why we received this damned -206
????

Thanks for any advice.

With kind regards - mit freundlichen Grüssen,
G e o r g H . P e t e r
DB2 Data Base Administrator c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Software Development & Technology Center
Knowledge Center Database Systems
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------



Scott Lindsey

Re: SQLCODE -206 received but the column is still there .....
(in response to Michael Ebert)
Are you sure that a hard-coded qualifier different from "LEWIS" has not been coded on
the FROM clause??

Scott Lindsey
Sr. DBA, Highlights for Children

Peter, Georg wrote:
>
> Hi listers,
>
> while binding a package one of our programmers received the following
> SQLCODE -206:
>
> BIND PACKAGE (E0OSSYENTW) OWNER(LEWIS) QUALIFIER(LEWIS) MEMBER(EA8KXE01)
> .....
> DSNX200I - BIND SQL ERROR
>
> USING LEWIS AUTHORITY
> SQLCODE=-206
> SQLSTATE=42703
> TOKENS=DEW64_DIGSTATUS
> CSECT NAME=DSNXORSO
> RDS CODE=-100
> DSNT233I - UNSUCCESSFUL BIND PACKAGE =
>
> DERRZD1DB21.E0OSSYENTW.EA8KXE01.(2001-02-01-17.55.25.462480)
> DSN
>
> After this SQLCODE we asked the catalog, if column DEW64_DIGSTATUS in table
> LEWIS.DEW64 does not exist:
>
> select colno, name
> from sysibm.syscolumns
> where tbname = 'DEW64'
> and tbcreator = 'LEWIS'
> and name = 'DEW64_DIGSTATUS'
> ;
> ---------+---------+---------+---------+---------+---------+--
> COLNO NAME
> ---------+---------+---------+---------+---------+---------+--
> 22 DEW64_DIGSTATUS
> DSNE610I NUMBER OF ROWS DISPLAYED IS 1
> DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
> ---------+---------+---------+---------+---------+---------+--
> ---------+---------+---------+---------+---------+---------+--
> DSNE617I COMMIT PERFORMED, SQLCODE IS 0
>
> Any idea out there why the BIND PACKAGE why we received this damned -206
> ????
>
> Thanks for any advice.
>
> With kind regards - mit freundlichen Grüssen,
> G e o r g H . P e t e r
> DB2 Data Base Administrator c/o
> -------------------------------------------------------------------
> Datenzentrale Baden-Wuerttemberg
> Software Development & Technology Center
> Knowledge Center Database Systems
> Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
> e:mail [login to unmask email]
> Phone 0049-711-8108-271
> PC-Fax 004971189696071
> Internet (only in german language):http://www.dzbw.de
> ----------------------------------------------------------------------
>
>
>
>
>

--
If you have any questions, please feel free to consult me!



Georg Peter

AW: SQLCODE -206 received but the column is still there .....
(in response to John Hardy)
Hi Scott, Dr. Mebert, John.

The reason was that the column DEW64_DIGSTATUS was later added to the table
LEWIS.DEW64. And yesterday someone dropped a view and re-created this view.
But unfortunately he works with an older version of the view and so the
column was not part of the view. And the program EA8KXE01 already works with
the column DEW64_DIGSTATUS....

Thanks to all of you - and a nice weekend.

With kind regards - mit freundlichen Grüssen,
G e o r g