× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I have this sql statement, that works fine from ops-nav... 

I was wondering, if there is a flag I can set?  Or a conversion tool
available, to change what needs to be changed to work from rpg, or do I need
to walk through each query, and convert them to the native format?

I have about 50 of these things..

End-result: I would like to embed these sql statements within an RPG
program...

Thanks, Tim

SELECT 
    "MANFILPF"."MNACTC", 
    "MANFILPF"."MNMFG#", 
    "MANFILPF"."MNSIZE", 
    "MANFILPF"."MNDESC", 
    "MANFILPF"."MNUNIT", 
    "PRPPIL"."PILLOC", 
    "PRPPIL"."PILMNQ", 
    "PRPPIL"."PILMXQ", 
    "DANA2"."MONTHUSG", 
    "PRDINVEN"."MIQTY", 
    "PRDINVEN"."MITYPE", 
    "PRPPIL"."PILCO" 
FROM {oj (("EVCLFIN"."CADBFA"."MANFILPF" "MANFILPF" 
LEFT OUTER JOIN 
    "EVCLFIN"."CADBFA"."PRPPIL" "PRPPIL" 
    ON (("MANFILPF"."MNMFG#"="PRPPIL"."PILPRD") 
    AND ("MANFILPF"."MNSIZE"="PRPPIL"."PILSIZ")) 
    AND ("MANFILPF"."MNUNIT"="PRPPIL"."PILIUM")) 
LEFT OUTER JOIN 
    "EVCLFIN"."CADBFA"."PRDINVEN" "PRDINVEN" 
    ON (((("PRPPIL"."PILCO"="PRDINVEN"."MICO") 
    AND ("PRPPIL"."PILLOC"="PRDINVEN"."MILOC")) 
    AND ("PRPPIL"."PILPRD"="PRDINVEN"."MIPROD")) 
    AND ("PRPPIL"."PILSIZ"="PRDINVEN"."MISIZE")) 
    AND ("PRPPIL"."PILIUM"="PRDINVEN"."MIFUM")) 
LEFT OUTER JOIN 
    "EVCLFIN"."DEVTIMH"."DANA2" "DANA2" 
    ON (((("PRPPIL"."PILCO"="DANA2"."COMPANY") 
    AND ("PRPPIL"."PILLOC"="DANA2"."WAREHOUSE")) 
    AND ("PRPPIL"."PILPRD"="DANA2"."ITEM_CODE")) 
    AND ("PRPPIL"."PILSIZ"="DANA2"."SIZE_CODE")) 
    AND ("PRPPIL"."PILIUM"="DANA2"."UOM")} 
WHERE "PRDINVEN"."MITYPE"='AA' 
    AND "PRPPIL"."PILLOC"='FANK2' 
    AND "MANFILPF"."MNACTC"='A' 
    AND "PRPPIL"."PILCO"='  001'



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.