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
DSNT201I + BIND FOR PLAN STYMF01 NOT SUCCESSFUL
What does it mean by TOKENS? I am unable to proceed from here.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Did you research the -407? IBM says the -407 is raised when
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.