Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
gokuldass

New User


Joined: 18 Mar 2005
Posts: 48
Location: india

PostPosted: Tue May 03, 2005 11:31 pm    Post subject: Is there is any limit for number of packages under a plan..
Reply with quote

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..
Back to top
View user's profile Send private message

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Wed May 04, 2005 7:32 am    Post subject:
Reply with quote

No, you can have any no of packages till your PLAN_TABLE getting full.
Back to top
View user's profile Send private message
sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 190
Location: hyderabad

PostPosted: Mon May 09, 2005 1:55 pm    Post subject: Re: Is there is any limit for number of packages under a pla
Reply with quote

Hi murali

Plz post ur question in a seperate Subject

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


Thanks & Regards
Siva Chaitanya
Back to top
View user's profile Send private message
narayana

New User


Joined: 22 Apr 2005
Posts: 2

PostPosted: Mon May 09, 2005 4:09 pm    Post subject: Re: QUERIES
Reply with quote


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.
Back to top
View user's profile Send private message
i413678
Currently Banned

Active User


Joined: 19 Feb 2005
Posts: 112
Location: chennai

PostPosted: Tue May 10, 2005 12:29 pm    Post subject: query
Reply with quote

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
Back to top
View user's profile Send private message
gokuldass

New User


Joined: 18 Mar 2005
Posts: 48
Location: india

PostPosted: Sat May 14, 2005 7:43 pm    Post subject: Re: Is there is any limit for number of packages under a pla
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Sequence number add in SORT pshongal SYNCSORT 3 Fri Sep 02, 2016 3:32 pm
No new posts Casting a Binary Number to Numeric in... Bob Steinkraus Java & MQSeries 6 Tue Aug 09, 2016 5:58 pm
No new posts GDG vsersion number change Raghu navaikulam JCL & VSAM 5 Fri May 27, 2016 4:49 pm
No new posts CPU time Vs Number of records Nileshkul JCL & VSAM 5 Mon May 09, 2016 4:05 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us