Finding PLAN(or Package)

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Chandra Shekar G R
Member
Posts: 14
Joined: Fri Apr 06, 2007 11:22 pm

Finding PLAN(or Package)

Post by Chandra Shekar G R » Mon Apr 16, 2007 10:49 pm

I have an existing program and how can I know my particular program is using particular "PLAN" when my system has many plans already??

acevedo
Member
Posts: 12
Joined: Wed Mar 21, 2007 3:44 pm

Post by acevedo » Tue Apr 17, 2007 11:40 am

Code: Select all

SELECT * FROM SYSIBM.SYSPACKLIST WHERE NAME = 'yourprogramhere';  
will give you the PLANNAME where it's referenced.

acevedo
Member
Posts: 12
Joined: Wed Mar 21, 2007 3:44 pm

Post by acevedo » Thu Apr 19, 2007 8:59 pm

questions questions questions...but do you know what a feedback is?
Google is your friend!

Veera
Moderator
Posts: 111
Joined: Wed Feb 22, 2006 2:59 pm

Post by Veera » Fri Apr 20, 2007 6:45 am

Yeah acevedo..this is exactly was going on my mind tooo.....well i am thinking of initating a topic on FEEDBACK in GENERAL DISCUSSIONS FORUMN.

Wish ppl understand this is in right sense.

Thanks,
Veera.
Last edited by Veera on Fri Apr 20, 2007 8:54 pm, edited 1 time in total.

acevedo
Member
Posts: 12
Joined: Wed Mar 21, 2007 3:44 pm

Post by acevedo » Fri Apr 20, 2007 11:47 am

Veera I really had doubts about posting that... I thought my words could have been misunderstood, glad to see that's not the case.

I like, from time to time, re-read this article:

How To Ask Questions The Smart Way & How To Answer Questions in a helpful Way
http://www.catb.org/~esr/faqs/smart-questions.html


Best Regards.
Google is your friend!

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Fri Apr 20, 2007 7:20 pm

Good point you brought up . I am observing this trend on the forums.
I am not seeing any feedback from question posters which is really disappointing.

I will create a new announcement in the forums with the above article information in it. It may help.

Any suggestions are welcome.

Veera
Moderator
Posts: 111
Joined: Wed Feb 22, 2006 2:59 pm

Post by Veera » Fri Apr 20, 2007 8:58 pm

Yeah Krishna, acevedo that would be great.

As info:

I have also posted one thread in General Discussion

How important is Feedback in Techincal Sites.

Thanks,
Veera.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others