View previous topic :: View next topic
|
Author |
Message |
PoojaMani
New User
Joined: 28 Jan 2010 Posts: 4 Location: pune
|
|
|
|
Hi
I have problem with bind process when i m compliing my test program the plan is binding... however if i take the same producation version its not binding... and the program names are same in test and producation
test bind
DSNT252I -DBST DSNTBCM1 BIND OPTIONS FOR PLAN trybb617
ACTION REPLACE RETAIN
OWNER DB23
VALIDATE BIND
ISOLATION CS
ACQUIRE USE
RELEASE COMMIT
EXPLAIN NO
DYNAMICRULES RUN
DSNT253I -DBST DSNTBCM1 BIND OPTIONS FOR PLAN trybb617
NODEFER PREPARE
CACHESIZE 1024
QUALIFIER DB23
CURRENTSERVER
CURRENTDATA NO
DEGREE 1
SQLRULES DB2
DISCONNECT EXPLICIT
REOPT NONE
KEEPDYNAMIC NO
IMMEDWRITE NO
DBPROTOCOL DRDA
OPTHINT
ENCODING EBCDIC(00037)
PATH
DSNT200I -DBST BIND FOR PLAN trybb617 SUCCESSFUL
DSN
DSN
Producation bind
ETAIN
DSNX200I -DBST BIND SQL ERROR
USING DB23 AUTHORITY
PLAN=trybb617
DBRM=trybb617
STATEMENT=4993
SQLCODE=-401
SQLSTATE=42818
TOKENS=
CSECT NAME=DSNXOBFC
RDS CODE=930
DSNT201I -DBST BIND FOR PLAN trybb617 NOT SUCCESSFUL |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hello Pooja,
Its Seems the problem with the program as -401 states
Quote: |
THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE
Explanation
An arithmetic operation appearing within the SQL statement contains a mixture of numeric and non-numeric operands, or the operands of a comparison operation are not compatible.
One reason for this error is that a field procedure exists on one of the columns. If one column of arithmetic or comparison operation is defined with a field procedure, other columns in the operation must be defined with the same field procedure.
System action
The statement cannot be executed. |
Please double check that u are using Prod version & correct Libs |
|
Back to top |
|
|
PoojaMani
New User
Joined: 28 Jan 2010 Posts: 4 Location: pune
|
|
|
|
Hello Ekta
Thank you!!!!!!!!!!! |
|
Back to top |
|
|
Kjeld
Active User
Joined: 15 Dec 2009 Posts: 365 Location: Denmark
|
|
|
|
Hi Pooja,
Quote: |
DBRM=trybb617
STATEMENT=4993
SQLCODE=-401
SQLSTATE=42818 |
Your compilation checks only your SQL against the DCLGENs for the tables accessed.
If the properties of production tables columns are different from test tables you will get an error at bind time. Check statement 4993 in your code for reference to column names. |
|
Back to top |
|
|
PoojaMani
New User
Joined: 28 Jan 2010 Posts: 4 Location: pune
|
|
|
|
Hey Kjeld
Thank you for ur reply!!!!
u are rigth my test table has a different struct means i had to change one numeric variable to character..... however i had given the new dclgen override as well..however i dint realise in my sql query i m comparing character variable to comp-3 variable and than fetching the row so i think the bind is not successful.... with Ekta's help i could find this...
correct me if i m wrong |
|
Back to top |
|
|
rockish
Active User
Joined: 05 Jun 2009 Posts: 185 Location: Planet Earth
|
|
|
|
If i am understanding it right, do u mean to say your table structure is different in test and production environments ??? If yes, this should not be the case I suppose. Consider discussing with your site support people to understand why is it so, as this can cause repeated mistake. |
|
Back to top |
|
|
PoojaMani
New User
Joined: 28 Jan 2010 Posts: 4 Location: pune
|
|
|
|
Hello rockish,
We are in the processor of changing our table variable to char.. rigth now in producation it is numeric we want to implement it as char in producation after our testing is over.... so this problem.. our db2 tables are uploaded everday so its impossible to upload test tables everday so the way we test is we run our test program in test envi and prodcaution in test so the input data is same and than we match our files..
Thanks
Pooja |
|
Back to top |
|
|
|