Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error during bind

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Musab Ahmed

New User


Joined: 10 Dec 2012
Posts: 37
Location: India

PostPosted: Thu Mar 21, 2013 2:46 pm    Post subject: Error during bind
Reply with quote

Hi All,

I am getting the following error during bind. Please find below the details.

Bind Statement:
DSN SYSTEM(DB2A)
BIND PLAN(MALSP061) -
MEMBER(MALSP061) -
OWNER(DB2MAA10) -
QUALIFIER(DB2MAA10) -
ACTION(REPLACE) -
RELEASE(COMMIT) -
ISOLATION(CS) -
DEGREE(ANY) -
VALIDATE(BIND) -
EXPLAIN(NO)

Output:
READY
DSN SYSTEM(DB2A)
DSN
BIND PLAN(MALSP061) MEMBER(MALSP061) OWNER(DB2MAA10) QUALIFIER(
COMMIT) ISOLATION(CS) DEGREE(ANY) VALIDATE(BIND)
DSNX200I ) BIND SQL ERROR
USING DB2MAA10 AUTHORITY
PLAN=MALSP061
DBRM=MALSP061
STATEMENT=2204
SQLCODE=-206
SQLSTATE=42703
TOKENS=MSFS_A
CSECT NAME=DSNXORSO
RDS CODE=-100
DSNX200I ) BIND SQL ERROR
USING DB2MAA10 AUTHORITY
PLAN=MALSP061
DBRM=MALSP061
STATEMENT=2231
SQLCODE=-206
SQLSTATE=42703
TOKENS=MSFS_P
CSECT NAME=DSNXORSO
RDS CODE=-100
DSNT201I ) BIND FOR PLAN MALSP061 NOT SUCCESSFUL
DSN
END

Could you please provide your inputs about what is wrong here?
Back to top
View user's profile Send private message

Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 785
Location: Chennai, India

PostPosted: Thu Mar 21, 2013 2:52 pm    Post subject:
Reply with quote

Code:
STATEMENT=2204
SQLCODE=-206
SQLSTATE=42703
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Thu Mar 21, 2013 2:57 pm    Post subject:
Reply with quote

My input on what is wrong, is that an inexperienced "IT Professional" with "Mainframe Skills: JCL, COBOL, DB2, Model204 " can't solve a -206

This is all the info you need:
STATEMENT=2204
SQLCODE=-206
SQLSTATE=42703
TOKENS=MSFS_A
Back to top
View user's profile Send private message
Musab Ahmed

New User


Joined: 10 Dec 2012
Posts: 37
Location: India

PostPosted: Thu Mar 21, 2013 3:17 pm    Post subject: nothing wrong with the column names
Reply with quote

I use the following SQL statement.

SELECT COUNT(*)
INTO :WS-CHECK-CUST-TYPE
FROM TMACUSTOMER_SOURCE
WHERE CUST_ID = :T043-CUST-ID
AND SRC_TYP_ID = 2
AND (SRC_STYP_ID = 'MSFS_A' OR
SRC_STYP_ID = 'MSFS_P')

I can confirm that the column names sppecified in the SQL do exist in the table.
I just can't make out why it is a problem?
Is the hard coded value MSFS_A or MSFS_P a problem?

I would appreciate if any one can help me on this.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1278
Location: Belgium

PostPosted: Thu Mar 21, 2013 4:46 pm    Post subject:
Reply with quote

maybe your site uses double quotes for literals.
Back to top
View user's profile Send private message
Musab Ahmed

New User


Joined: 10 Dec 2012
Posts: 37
Location: India

PostPosted: Thu Mar 21, 2013 5:04 pm    Post subject: Thankyou so much
Reply with quote

Hi Guyc,

Thanks so much for your input. It solved my problem.

Never thought the single quotes would be a problem.

icon_biggrin.gif
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Thu Mar 21, 2013 10:38 pm    Post subject:
Reply with quote

Surprised to see a PLAN bind with no PKLIST these days.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us