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.