IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 Bind error -206
IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
raviprabhu

New User


Joined: 20 Oct 2006
Posts: 29
PostPosted: Wed Apr 09, 2014 10:35 pm
 Reply with quote
Hi,

I am getting DB2 Bind error -206. A new column was added to the table and program was modified accordingly.
When I try to comp/precomp/Bind getting -206 referring to new column.
Please let me know the resolution
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
PostPosted: Wed Apr 09, 2014 10:47 pm
 Reply with quote
As you can see, there's a little more to a -206 SQLCODE than you imply.
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
PostPosted: Wed Apr 09, 2014 11:41 pm
 Reply with quote
Quote:
A new column was added to the table and program was modified accordingly


You either did not modify the program correctly, or the DB2 Subsystem/Qualifier you are trying to Bind to did not have the table modified.

Please check your code and table more closely.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
PostPosted: Wed Apr 09, 2014 11:47 pm
 Reply with quote
Also check if you have used host variables correctly
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> COBOL Programming

 

Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us