regarding sqlca and copy sqlca

shriya reddy · New User Joined: 05 Jun 2004 Posts: 45

hi

what is the difference between copy sqlca and include sqlca when u are coded in program. i know the two are used for same purpose but please give the exact difference

anuradha · Global Moderator Joined: 06 Jan 2004 Posts: 257

Hello Shriya,

Generally Copy is used for cobol statements and Include is used for Sql code.

If you give Copy sqlca then it will be expanded in compilation time.

If you give Include Sqlca it will be expanded in precompilation time.

Just think whether Sql statements/variables/code need to be precompiled or compiled.Then you will get the answer for what you asked.

hope you got my point.

Thanks,
Anu