what to do if bind fails as column is not in table

In this Mainframe Forum - You can post your queries on JCL,VSAM,COBOL,DB2,IMS Abend codes , solutions etc..

Moderator: Moderator Group

Post Reply
devika
Member
Posts: 2
Joined: Sat Mar 13, 2010 7:39 pm

what to do if bind fails as column is not in table

Post by devika » Sat Mar 13, 2010 9:46 pm

If a query is performed on a column which no longer exists in table then the code fails in bind stage.I want to know if i can still execute the bind sucessfully without including the deleted column then how can i do it.is there any bind jcl parameter that can be changed for doing so

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Sun Mar 14, 2010 2:13 pm

Why column is a question here, you bind a table not column?
Regards,
Anuj

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

DB2 ERROR CODE

Post by Natarajan » Sun Mar 14, 2010 7:27 pm

If column is not there in the table. delete that from your program. db2 bind will be successful.

What sql code you are getting?
Natarajan
Chennai

devika
Member
Posts: 2
Joined: Sat Mar 13, 2010 7:39 pm

Post by devika » Mon Mar 15, 2010 8:55 am

what is the other alternative except deleting the column from the program .is there any bind parameter that can be changed?

sambit_mech
Member
Posts: 9
Joined: Wed Jul 14, 2010 11:17 am
Location: India

Post by sambit_mech » Wed Jul 14, 2010 11:45 am

do not use "VALIDATE(BIND)" in your bind card.
"By failiing to prepare, you are preparing to fail." - Benjamin Franklin

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Wed Jul 14, 2010 12:50 pm

sambit_mech wrote:do not use "VALIDATE(BIND)" in your bind card.
what kind of stupidity is that?

if there is sql which references a column that nolonger exists in the table,
remove the column reference from the sql.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Wed Jul 14, 2010 2:14 pm

sambit_mech wrote:do not use "VALIDATE(BIND)" in your bind card.
Why do you suggest this?
Regards,
Anuj

academyindia4

Topic deleted by Admin

Post by academyindia4 » Sat Jan 30, 2016 11:15 pm

<< Content deleted By Admin >>

academyindia4

Topic deleted by Admin

Post by academyindia4 » Wed Feb 03, 2016 10:45 pm

<< Content deleted By Admin >>

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others