How to embed a DB2 copybook?

Sukhmeet Singh · New User Joined: 28 Dec 2007 Posts: 12 Location: kolkata

Ques

1. in a cobol-db2 program, if a procedure division copybook COPYDB2C with embedded db2 statements has to be added to the code, which of the folloeing method has to be used..??

a). EXEC SQL
INCLUDE COPYDB2C
END-EXEC in working storage section, after including SQLCA.

b). procedure division copybook cannot contained embedded db2
statements

c). COPY COPYDB2C. at the end of the code, in area A

d). EXEC SQL
INCLUDE COPYDB2C
END-EXEC in procedure division.

dbzTHEdinosauer · Posted: Fri May 23, 2008 3:32 pm Post subject:

a copybook that contains db2 statements - sql and not ddl?

if the db2 statements need to be precompiled, then d.
if the db2 statements are already precompiled, then e. copy statement at appropriate place.

db2 declares in data division do not have to be positioned before or after the sqlca.

a. is no good, there is executable code in the copybook, so it must be someplace in procedure division. again, position with sqlca is not a valid statement.

b. is an inaccurate statement.

c. makes no sense.

d. is the only answer that comes close.

this post reeks of classroom work.
RTFM

Sukhmeet Singh · New User Joined: 28 Dec 2007 Posts: 12 Location: kolkata

thanks a lot..