I have now the Iseries nav fully installed. where do I enter a query like this?
 
SELECT
    NOTEH6.UARIDC
 , NOTEH6.UANOTL
 , NOTEP1.UCCMT
 , OEORH41.OHORD#
 , OEORH41.OHOSTC
 , OEORH41.OHORDT
 , OEORH41.OHORDD
 , OEORH41.OHPO#
 , OEORH41.OHSHTC
 , OEORH41.OHSLR#
 , OETRA95.OTTRNC
 , REFER1.RFCAT
 , REFER1.RFDAT
 
FROM       OEORH41
 INNER JOIN REFER1
   ON   OEORH41.OHSHTC = REFER1.RFSLC
 INNER JOIN OETRA95
   ON   OEORH41.OHCOM# = OETRA95.OTCOM#
 
   AND OEORH41.OHORD# = OETRA95.OTORD#
 
INNER JOIN NOTEH6
   ON   OEORH41.OHENT# = NOTEH6.UAENT#
 
   AND OEORH41.OHSFX# = NOTEH6.UASFX#
 
INNER JOIN NOTEP1
   ON   NOTEH6.UANOTT  = NOTEP1.UCNOTT
 
   AND NOTEH6.UANTK   = NOTEP1.UCNTK
    AND NOTEH6.UANOT#  = NOTEP1.UCNOT#
 WHERE NOTEH6.UARIDC  = 'UA'
    and OETRA95.OTTRNC = '001'
        /* !! Note: use special reg 
below !! */
    and OEORH41.OHORDD = CURRENT DATE
        /* !! Note: use IN predicate below
!! */
    and OEORH41.OHORDT IN ('COC', 'COE', 'COF', 'COR', 'COS')
        /* !! Note: missing operator below
!! */
    AND OEORH41.OHOSTC <> 'CN'  /* <--
"AND" was presumed+added */
    and REFER1.RFCAT   = '0023'

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.