Basic doubt on BIND
Posted: Thu May 13, 2010 9:32 am
Hi,
I've modified an existing COBOL/DB2 batch program.
I am new to DB2/SQL. Does it require both PACKAGE and PLAN bind or PACKAGE bind alone is enough?
Please help.
Thanks.
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.
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.