View previous topic :: View next topic
|
Author |
Message |
srebba Warnings : 1 New User
Joined: 26 Apr 2007 Posts: 37 Location: USA
|
|
|
|
Hi,
I am trying to Bind package for new module i am gettgin error code -407.
and I am tryint to Bind plan directly but eventhough iam getting same error code below. Please help me
DSNX200I + BIND SQL ERROR
USING RUSRP AUTHORITY
PLAN=STYMF01
DBRM=STYMFDB2
STATEMENT=503
SQL CODE=-407
TOKENS=STYY_COLOR
CSECT NAME=DSNXODM
RDS CODE=12
DSNT201I + BIND FOR PLAN STYMF01 NOT SUCCESSFUL
***
What does it mean by TOKENS? I am unable to proceed from here.
Thank you,
Sree |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If you talk with your database support people, they will tell you what you need to change. |
|
Back to top |
|
|
srebba Warnings : 1 New User
Joined: 26 Apr 2007 Posts: 37 Location: USA
|
|
|
|
Frankly Speaking My porject is using DB2 very less and already i searched for this.
please let me know
Thank you
Sree |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Did you research the -407? IBM says the -407 is raised when
Quote: |
AN UPDATE OR INSERT VALUE IS NULL, BUT THE OBJECT COLUMN
column-name CANNOT CONTAIN NULL VALUES |
The concept of tokens takes more words than i'm able to present here. You might do a bit of research in the manuals linked to from this site.
What is at statement 503?
As i mentioned earlier, your best bet is to talk with the database admin or the most senior of the application developers that use DB2 - it shouldn't matter that your organization is "using DB2 very less " - i suspect there are some other binds that are working. You might compare one that works with the problem bind if you don't want to talk with the other people. |
|
Back to top |
|
|
srebba Warnings : 1 New User
Joined: 26 Apr 2007 Posts: 37 Location: USA
|
|
|
|
I got it got it got it
Thank you very much |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome |
|
Back to top |
|
|
|