Page 1 of 1

Basic doubt on BIND

PostPosted: Thu May 13, 2010 9:32 am
by ranga_subham
Hi,

I've modified an existing COBOL/DB2 batch program.

ACCEPT WS-DATE FROM DATE.

EXEC SQL
        SELECT NUM_NO FROM DB1.NUMTABL
          WHERE NUM_NO = :WS-NUM-NO
END-EXEC.


I am new to DB2/SQL. Does it require both PACKAGE and PLAN bind or PACKAGE bind alone is enough?

Please help.

Thanks.

Re: Basic doubt on BIND

PostPosted: Thu May 13, 2010 9:42 am
by dick scherrer
Hello,

Youn need to talk with your co-workers or your dba to learn how this is done on your system.

Compile/link/bind etc are standard (and are quite site-specific) and you should use only the standard process(es) for your environment.