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

VALIDATE option in BIND jcl


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Poha Eater

New User


Joined: 31 Aug 2016
Posts: 74
Location: India

PostPosted: Mon Feb 26, 2018 7:08 pm
Reply with quote

Hi All,

If there is a wrong column name is written in SQL query in my COBOL-DB2 program then this syntax will be happening during BIND time ?

If yes, then the job will be end with -206 error code ? And is this related with VALIDATE(RUN/BIND) option ? If No, then when this type of error will be checked.

I have searched a lot but couldn't find the proper discussion on this. Please explain if anyone has the information.


Thanks in Advance !
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Mon Feb 26, 2018 7:51 pm
Reply with quote

This literally took 10 seconds to find in an internet search:

www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/db2z_bindoptvalidate.html
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Mon Feb 26, 2018 9:22 pm
Reply with quote

and this is typical interview question and should be moved there.
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SCOPE PENDING option -check data DB2 2
No new posts OUTFIL with SAVE option DFSORT/ICETOOL 7
No new posts CICS vs LE: STORAGE option CICS 0
No new posts INSYNC option with same function as I... JCL & VSAM 0
No new posts Option DYNALLOC second parameter. DFSORT/ICETOOL 11
Search our Forums:

Back to Top