Basic doubt on BIND



IBM's flagship relational database management system

Basic doubt on BIND

Postby ranga_subham » Thu May 13, 2010 9:32 am

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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Basic doubt on BIND

Postby dick scherrer » Thu May 13, 2010 9:42 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post