Connecting Tech Pros Worldwide Forums | Help | Site Map

getting sqlcode -206

Newbie
 
Join Date: May 2007
Posts: 1
#1: May 4 '07
i m working on mainframes, coding in cobol and db2
EXEC SQL
UPDATE BOOKS_STAT17
SET STATUS1 = 'O' , EMP_NUMBER=NULL
WHERE COPY_NUMBER = WS-COPY-NUM
AND ISBN_NUMBER = WS-ISBN-NUM
END-EXEC.
error i m getting:
DBH3 BIND SQL ERROR
USING TRG4SUSR AUTHORITY
PLAN=MONIKA
DBRM=RETURNS
STATEMENT=142
SQLCODE=-206
SQLSTATE=42703
TOKENS=WS-ISBN-NUM
CSECT NAME=DSNXORSO
RDS CODE=-100

how 2 fix it?

msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,886
#2: May 4 '07

re: getting sqlcode -206


This question is being moved to the DB2 forum.

ADMIN
Newbie
 
Join Date: Nov 2008
Posts: 1
#3: Nov 7 '08

re: getting sqlcode -206


i know this is months later, i was looking for some answers and came accross this question. it appears they forgot the : in front of the host var.
Reply