Is there is any limit for number of packages under a plan..

gokuldass · New User Joined: 18 Mar 2005 Posts: 48 Location: india

is there is any limit for number of packages under a plan.. if so then what it is.. also is it possible to create a single package for both main as well as subprogram.. if so explain it with sample code..

priya · Posted: Wed May 04, 2005 7:32 am

No, you can have any no of packages till your PLAN_TABLE getting full.

sivatechdrive · Posted: Mon May 09, 2005 1:55 pm

Hi murali

Plz post ur question in a seperate Subject

ibmmainframes.com/viewtopic.php?t=1736&highlight=correlated

Thanks & Regards
Siva Chaitanya

narayana · New User Joined: 22 Apr 2005 Posts: 2

select salary from emp a where n = (select count(distinct salary)
from emp b where b.salary >= a.salary);

I thought that this query is correct if any mistake correct it and send me back.

i413678 · Posted: Tue May 10, 2005 12:29 pm

HI All,

the query entered by narayana is excellent and it is correlated sub-query.

and this can be used for multiple purposes by replacing the = condition.

1. to get n highest salaries. ( n <= )
2. to get the rest of the salaries except n highest salaries ( n >= )

thanks narayana...........

Cheers............

pavan

gokuldass · New User Joined: 18 Mar 2005 Posts: 48 Location: india

hai all..
i asked two questions.. but no one replied answer for the second question.. is it possible.. then where this PLAN_TABLE will be stored.