Differance b/n COPY & INCLUDE, Nth Maximum SQL

dharmendra_kp · New User Joined: 10 Mar 2005 Posts: 33 Location: Lewiston

Hi! ALL,
1 CAN ANY ONE EXPLAIN THE DEFERACE BETBEEN KEYWORD 'COPY' & 'INCLUDE' ?
2> WRITE A SQL QUERY TO GET Nth Largest value of a column from a DB2 table ? n > 15.
THANKS IN ADVANCE

serious_mainframes · New User Joined: 10 Mar 2005 Posts: 2

copy used in cobol for copying some data what we want from ps or pds

include is used in db2 to include a communication areas and any dclgen members

ovreddy · Posted: Thu Mar 10, 2005 5:21 pm

Hi Dharmendra,

COPY is used to copy the contents of a Copy book ( which contains COBOL statements) into athe COBOL program.

INCLUDE is used to copy the contents of a COPYBOOK generated by DCLGEN for host variable declarations.

SELECT MAX(COLUMN) FROM TAB A WHERE 15=(SELECT COUNT(*) FROM TAB B WHERE A.COL<=B.COL);

Please search the FORUM before posting, Avoid posting the same ques twice.

Bye,
Reddy.

mcmillan · Site Admin Joined: 18 May 2003 Posts: 1210 Location: India

You are right Reddy, But a small correction, if you don't mind!

'COPY' and 'INCLUDE' (I believe it's not JCL Include) do the same function. You can Copy any set of statements using this statements.

But COPY Statement is honored by the Cobol Compiler while INCLUDE statement is identified by the DB2 PreCompiler.

You can use INCLUDE statement to copy the statements, not generated by DCLGEN also.

ovreddy · Posted: Fri Mar 11, 2005 10:47 am

Hi McMillan,

I agree with you. Thanks for correction

Thanks,
Reddy

kiranchinthapalli · New User Joined: 13 Mar 2005 Posts: 1

Hi,
the main difference between INCLUDE and COPY is that they perform the same operation but

INCLUDE------> It will expand only at the time of DB2 pre-compilation &

COPY----------->It will expand only at the time of COBOL compilation

bye.
kiran.

dharmendra_kp · New User Joined: 10 Mar 2005 Posts: 33 Location: Lewiston

hi! ALL,
thanks guys for answering about COPY & INCLUDE!
I would like to thank REDDY & KIRAN particularly for Answering both the questions.

I would like to MAKE A CORRECTION TO THE ANSWERE OF THE 2ND QUESTION ie. which i got after working on your code.
TO GET THE NTH LARGEST VALUE OF A COLUMN FROM A DB2 TABLE, where n > 15 ( becouse there can be a max of 15 level of non co-related subquery.

for if there is redundancy in the column that is if the column has more than one value which is equal to the nth largest THE MODIFIED CODE SHULD BE SOMETHING LIKE THIS:

i413678 · Posted: Sat Mar 19, 2005 11:02 am

hi dharmendra,

can you please explain the query how it works?

thanx in advance.

pavan

work is worship & duty is god