Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Bind problem with production version

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
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    Post subject: Bind problem with production version
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: 1187
Location: Bangalore,India

PostPosted: Thu Jan 28, 2010 5:13 pm    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts HALDB data refresh/copy from producti... vineetanand2007 IMS DB/DC 1 Mon Jan 02, 2017 11:16 am
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts COBOL Version 6.1 Virendra Shambharkar COBOL Programming 5 Tue Nov 01, 2016 11:24 am
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us