<?xml version="1.0" encoding="UTF-8" ?> <JDERequest Distinct="N" Operation="SELECT" DBOperation="INSERT "> <TABLE LIBRARY="JDFDATA"> <ACTION>SPECIFIED</ACTION> <NAME>F4201</NAME> <ROW> <SHDOCO Visible="Y" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> <WHERE> <OPERATOR>=</OPERATOR> <VALUE>112891 </VALUE> </WHERE> </SHDOCO> <SHDCTO Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> <WHERE> <OPERATOR>=</OPERATOR> <VALUE>SO</VALUE> </WHERE> </SHDCTO> <SHVR01 Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </SHVR01> <SHSHAN Visible="" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> </SHSHAN> <SHAN8 Visible="Y" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> </SHAN8> </ROW> </TABLE>
<TABLE LIBRARY="JDFDATA"> <ACTION>SPECIFIED</ACTION> <NAME>F4211</NAME> <TABLEJOIN SIDE="">INNER</TABLEJOIN> <ROW> <SDDOCO Visible="Y" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> <FROM> <JOIN>F4201.SHDOCO</JOIN> </FROM> </SDDOCO> <SDDCTO Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> <FROM> <JOIN>F4201.SHDCTO</JOIN> </FROM> </SDDCTO> <SDRCD Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </SDRCD> <SDCARS Visible="Y" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> </SDCARS> <SDSOQS Visible="Y" order="" group=""> <NAME /> <TYPE>DECIMAL</TYPE> <VALUE /> </SDSOQS> <SDUORG Visible="Y" order="" group=""> <NAME /> <TYPE>DECIMAL</TYPE> <VALUE /> </SDUORG> <SDLITM Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </SDLITM> <SDDRQJ Visible="Y" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> </SDDRQJ> <SDLNID Visible="Y" order="" group=""> <NAME /> <TYPE>DECIMAL</TYPE> <VALUE /> <WHERE> <OPERATOR>=</OPERATOR> <VALUE>1000</VALUE> </WHERE> </SDLNID> <SDUPRC Visible="Y" order="" group=""> <NAME /> <TYPE>DECIMAL</TYPE> <VALUE /> </SDUPRC> <SDMCU Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </SDMCU> <SDADDJ Visible="Y" order="" group=""> <NAME /> <TYPE>NUM</TYPE> <VALUE /> </SDADDJ> <SDAEXP Visible="Y" order="" group=""> <NAME /> <TYPE>DECIMAL</TYPE> <VALUE /> </SDAEXP> <SDOGNO Visible="Y" order="" group=""> <NAME /> <TYPE>DECIMAL</TYPE> <VALUE /> </SDOGNO> <SDCNID Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </SDCNID> <SDSHAN Visible="Y" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> </SDSHAN> <SDAN8 Visible="" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> </SDAN8> </ROW> </TABLE> <TABLE LIBRARY="JDFDATA"> <ACTION>SPECIFIED</ACTION> <NAME>F0311</NAME> <TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN> <ROW> <RPDOC Visible="" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> <FROM> <JOIN>F4211.SDDOCO</JOIN> </FROM> </RPDOC> <RPDCT Visible="" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> <FROM> <JOIN>F4211.SDDCTO</JOIN> </FROM> </RPDCT> <RPSTAM Visible="Y" order="" group=""> <NAME /> <TYPE>DECIMAL</TYPE> <VALUE /> </RPSTAM> </ROW> </TABLE> <TABLE LIBRARY="JDFDATA"> <ACTION>SPECIFIED</ACTION> <NAME>F0101</NAME> <TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN> <ROW> <ABAN8 Visible="" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> <FROM> <JOIN>F4211.SDAN8</JOIN> </FROM> </ABAN8> <ABALPH Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </ABALPH> </ROW> </TABLE> <TABLE LIBRARY="JDFDATA"> <ACTION>SPECIFIED</ACTION> <NAME ALIAS="F0116A">F0116</NAME> <TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN> <ROW> <ALADD1 Visible="Y" order="" group=""> <NAME>ALADD1A</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADD1> <ALADD2 Visible="Y" order="" group=""> <NAME>ALADD2A</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADD2> <ALADD3 Visible="Y" order="" group=""> <NAME>ALADD3A</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADD3> <ALAN8 Visible="Y" order="" group=""> <NAME>ALAN8A</NAME> <TYPE>NUMERIC</TYPE> <VALUE /> <FROM> <JOIN>F4201.SHAN8</JOIN> </FROM> </ALAN8> <ALCTY1 Visible="Y" order="" group=""> <NAME>ALCTY1A</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALCTY1> <ALADDS Visible="Y" order="" group=""> <NAME>ALADDSA</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADDS> <ALADDZ Visible="Y" order="" group=""> <NAME>ALADDZA</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADDZ> <ALEFTB Visible="Y" order="" group=""> <NAME>ALEFTBA</NAME> <TYPE>NUMERIC</TYPE> <VALUE /> </ALEFTB> </ROW> <TABLEWHERE EXIST="NO"> <VALUE>(Select 1 From JDFDATA.F0116 F0116Z Where F0116A.ALAN8= F0116Z.ALAN8 and F0116Z.ALEFTB > F0116A.ALEFTB)</VALUE> </TABLEWHERE> </TABLE> <TABLE LIBRARY="JDFDATA"> <ACTION>SPECIFIED</ACTION> <NAME>F4006</NAME> <TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN> <ROW> <OADOCO Visible="Y" order="" group=""> <NAME /> <TYPE>NUMERIC</TYPE> <VALUE /> <FROM> <JOIN>F4211.SDDOCO</JOIN> </FROM> </OADOCO> <OADCTO Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> <FROM> <JOIN>F4211.SDDCTO</JOIN> </FROM> </OADCTO> <OAADD1 Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </OAADD1> <OAADD2 Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </OAADD2> <OAADD3 Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </OAADD3> <OAADD4 Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </OAADD4> <OAADDZ Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </OAADDZ> <OACTY1 Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </OACTY1> <OAADDS Visible="Y" order="" group=""> <NAME /> <TYPE>CHAR</TYPE> <VALUE /> </OAADDS> </ROW> </TABLE> <TABLE LIBRARY="JDFDATA"> <ACTION>SPECIFIED</ACTION> <NAME ALIAS="F0116B">F0116</NAME> <TABLEJOIN SIDE="LEFT">OUTER</TABLEJOIN> <ROW> <ALADD1 Visible="Y" order="" group=""> <NAME>ALADD1B</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADD1> <ALADD2 Visible="Y" order="" group=""> <NAME>ALADD2B</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADD2> <ALADD3 Visible="Y" order="" group=""> <NAME>ALADD3B</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADD3> <ALAN8 Visible="Y" order="" group=""> <NAME>ALAN8B</NAME> <TYPE>NUMERIC</TYPE> <VALUE /> <FROM> <JOIN>F4211.SDSHAN</JOIN> </FROM> </ALAN8> <ALCTY1 Visible="Y" order="" group=""> <NAME>ALCTY1B</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALCTY1> <ALADDS Visible="Y" order="" group=""> <NAME>ALADDSB</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADDS> <ALADDZ Visible="Y" order="" group=""> <NAME>ALADDZB</NAME> <TYPE>CHAR</TYPE> <VALUE /> </ALADDZ> <ALEFTB Visible="Y" order="" group=""> <NAME>ALEFTBB</NAME> <TYPE>NUMERIC</TYPE> <VALUE /> </ALEFTB> </ROW> <TABLEWHERE EXIST="NO"> <VALUE>(Select 1 From JDFDATA.F0116 F0116Z Where F0116B.ALAN8= F0116Z.ALAN8 and F0116Z.ALEFTB > F0116B.ALEFTB)</VALUE> </TABLEWHERE> </TABLE> </JDERequest>