| View previous topic :: View next topic |
| Author |
Message |
mfuser
Banned
Joined: 01 Mar 2005
Posts: 105
Topics: 58
|
 Posted: Wed May 31, 2006 5:07 am Post subject: Unable to bind a DB2 program SQLCODE = -219 |
 |
|
Hai All,
I am trying to execute a DB2 program and i have got Precompiled successfully with RC=0.I am trying to BIND it and i am unable to bind as i get SQLCODE = -219.I created a table and inserted some values in the table and my program is simply selecting ? Can anybody help me out how can i resolve the problem ?
AFTER PRECOMPILE
| Code: |
SYSPRINT JS0010 PC
SYSPRINT JS0010 COB
SYSPRINT JS0010 LKED
SYSTERM JS0010 PC
|
AFTER BIND
| Code: |
DSNX105I @ BIND SQL WARNING
USING ABCD AUTHORITY
PLAN=PROG
DBRM=PROG
STATEMENT=75
SQLCODE=-219
SQLSTATE=42704
TOKENS=ABCD.PLAN_TABLE
DSNT252I @ DSNTBCM1 BIND OPTIONS FOR PLAN PROG
ACTION REPLACE
OWNER ABCD
VALIDATE RUN
ISOLATION CS
ACQUIRE USE
RELEASE COMMIT
EXPLAIN YES
DYNAMICRULES RUN
DSNT253I @ DSNTBCM1 BIND OPTIONS FOR PLAN PROG
NODEFER PREPARE
CACHESIZE 1024
QUALIFIER ABCD
CURRENTSERVER
CURRENTDATA YES
DEGREE 1
SQLRULES DB2
DISCONNECT EXPLICIT
NOREOPT VARS
KEEPDYNAMIC NO
IMMEDWRITE NO
DBPROTOCOL DRDA
OPTHINT
ENCODING EBCDIC(00037)
PATH
DSNT200I @ BIND FOR PLAN PROG SUCCESSFUL
DSN
END
READY
END |
|
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12382
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
