IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Bind problem with production version


IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
PoojaMani

New User


Joined: 28 Jan 2010
Posts: 4
Location: pune

PostPosted: Thu Jan 28, 2010 3:37 pm
Reply with quote

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
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Thu Jan 28, 2010 5:13 pm
Reply with quote

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
View user's profile Send private message
PoojaMani

New User


Joined: 28 Jan 2010
Posts: 4
Location: pune

PostPosted: Thu Jan 28, 2010 5:24 pm
Reply with quote

Hello Ekta

Thank you!!!!!!!!!!! icon_biggrin.gif
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Thu Jan 28, 2010 7:27 pm
Reply with quote

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
View user's profile Send private message
PoojaMani

New User


Joined: 28 Jan 2010
Posts: 4
Location: pune

PostPosted: Thu Jan 28, 2010 10:28 pm
Reply with quote

Hey Kjeld

Thank you for ur reply!!!! icon_biggrin.gif

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
View user's profile Send private message
rockish

Active User


Joined: 05 Jun 2009
Posts: 185
Location: Planet Earth

PostPosted: Thu Jan 28, 2010 11:19 pm
Reply with quote

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
View user's profile Send private message
PoojaMani

New User


Joined: 28 Jan 2010
Posts: 4
Location: pune

PostPosted: Fri Jan 29, 2010 11:37 am
Reply with quote

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..
icon_biggrin.gif

Thanks
Pooja
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> COBOL Programming

 


Similar Topics
Topic Forum Replies
No new posts isfline didnt work in rexx at z/OS ve... CLIST & REXX 7
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Monitoring production job progress. N... JCL & VSAM 4
No new posts How to copy the -1 version of a membe... TSO/ISPF 4
No new posts z/vm installation problem All Other Mainframe Topics 0
Search our Forums:

Back to Top