Re: Sql Help Needed.

["Peter Dow" <pcdow@xxxxxxxxx>]

This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Sql Help Needed.Hi Tim,

Try doing STRDBG (no parameters), then running the SQL statement.  Afterwards, 
look at your job log. It should have a detailed explanation of why it did not 
use the index you expected it to use.

hth,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

  ----- Original Message -----
  From: Hatzenbeler, Tim
  To: 'rpg400-l@midrange.com'
  Sent: Thursday, August 23, 2001 1:54 PM
  Subject: Sql Help Needed.


  Below is a sql that works... But does not work the way I feel it should... 
But since I'm very new to the sql syntax, I must be missing something...

  Problem..

  Table A  (indexed by date) is linked to Table B, via a Transaction #.
  Table B (Indexed by Transaction #) but linked to Table C, by  Item#, Size 
Code, and a Requistion #.
  Table C (Indexed by Item#, Size Code, Req#)

  The problem is this... For some reason, it's not using the index for table C, 
its creating a copy of C, and creating an access path...

  I was hoping some one could take a few moments from their busy day, and offer 
a few helpful suggestions to get me going...

  SQL Code is as follows...

  select *
  from (prdjrnusg A join jpldcusgsm B on A.pjstr# = B.jpstr#)
    inner join pmlrd6 C on (C.rdicde = B.rdicde) and
                          (C.rdsize = B.rdsize) and
                          (C.rdrid  = B.rdrid)

  Thanks, tim...



--


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com