Error during bind

Musab Ahmed · New User Joined: 10 Dec 2012 Posts: 37 Location: India

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?

Gnanas N · Posted: Thu Mar 21, 2013 2:52 pm

GuyC · Posted: Thu Mar 21, 2013 2:57 pm

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

Musab Ahmed · New User Joined: 10 Dec 2012 Posts: 37 Location: India

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.

GuyC · Posted: Thu Mar 21, 2013 4:46 pm

maybe your site uses double quotes for literals.

Musab Ahmed · New User Joined: 10 Dec 2012 Posts: 37 Location: India

Hi Guyc,

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

Never thought the single quotes would be a problem.

don.leahy · Posted: Thu Mar 21, 2013 10:38 pm

Surprised to see a PLAN bind with no PKLIST these days.