ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

SQL Query..very urgent

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Query..very urgent

    hi all,
    Its very urgent...
    I`ve done dsppgmref on a library and made an outfile.
    Now in this same pgm is displaying or pointing to many pfs, data areas etc,
    so i want to make a list of those pgms only..not many time..one single entry...
    how i`ll do tht using STRSQL???
    Can any one pls help....

  • #2
    Re: SQL Query..very urgent

    Hi,

    I am not sure about what you have asked.

    I think you are asking about the distinct programs that are called by your program.

    If so, below is your query.

    Select distinct WHFNAM from
    where WHOTYP = '*PGM'


    If it is not, provide us with some more info.

    Comment


    • #3
      Re: SQL Query..very urgent

      hey surya...thts perfectly correct man..
      thx a lot...

      Comment

      Working...
      X