What is copybook in DB2

praneethgokul · New User Joined: 06 May 2005 Posts: 20 Location: Bangalore

Hi

What is copybook in DB2?

vaduguru · New User Joined: 07 May 2005 Posts: 5

It may be dclgen...

srikn81 · New User Joined: 22 Apr 2005 Posts: 2 Location: Bangalore

It may be SQLCA also.These we will include b/n

EXEC SQL
Include copybook
END-EXEC.

These are extracted during precompilation time.

Thanks & Regards
Srikanth.

ovreddy · Posted: Sun May 15, 2005 12:48 pm

Hi Praneeth,

COPYBOOK is a cobol code. Generally copy books are used for common date conversions and report titles. Same copy book concept we can use to copy the host variable declarations into a cobol program. That is the COPY BOOK.

Thanks,
Reddy.

i413678 · Posted: Mon May 16, 2005 5:19 pm

Hi,

copybook in db2 is same as the copy book in cobol which will be expanded during pre compilation time.

normally db2 copy books are sqlca, dclgen members.

copybooks are used for error routines, data validations etc...........

pavan

vinoddevkar · New User Joined: 13 Apr 2005 Posts: 9 Location: pune

Hi,

Copybook in DB2 is a description of working-storage variables which are declared in a Host language program...for EG: DCLGEN

EXEC SQL
INCLUDE DCLGEN MEMBER NAME
END-EXEC

MEMBER NAME IS DESCRIPTION OF WORKING STORAGE VARIBLES