Quelltext anzeigen

<!--  **************************************  -->  
<!--  ********    Kunden Status     ********  -->
<!--  **************************************  -->  

  <PARM>
    <PATH>\\192.168.5.8\SAP\Datentransfer\ShopAbo-Transfer\WebOut\user</PATH> 
    <GROUP>VOLL</GROUP>
    <ACTIVE>*YES</ACTIVE>
    <FILENRKOBJ></FILENRKOBJ>
    <FILE>01_{DATE}_{JobTime}_shop3_userstatus.xml</FILE>
    <SQL>

       select
          OCPR.CardCode AS 'sap_user_id',
          OCPR.Name as 'AP_ID_SAP',
	    --OCPR.U_BOB_Shop3_userID  AS 'order_user_id',
          OCRD.U_BOB_Shop3_userID  AS 'order_user_id',
          OCPR.E_Mail AS 'bill_user_email',
          OCRD.U_BOB_AMPELS_PROFIT AS 'signal_lights_status_profit', 
          OCRD.U_BOB_AMPELSTATUS as 'signal_lights_status_nonprofit'
       from OCRD, OCPR
       where
       OCRD.CardCode = OCPR.CardCode and
       ---OCPR.U_BOB_Shop3_USerID is not Null and 
	 (OCRD.U_BOB_AMPEL_WECHSEL &gt; OCRD.U_BOB_WEB_TRANSFER or OCRD.U_BOB_WEB_TRANSFER is Null)
       --Datum der letzten Übertragung erfassen
       update OCRD 
 	 set OCRD.U_BOB_WEB_TRANSFER = getdate()
       --FROM OCPR
	 Where 
       ---OCPR.U_BOB_Shop3_USerID is not Null and 
        OCRD.U_BOB_Shop3_USerID is not Null and 
       (OCRD.U_BOB_AMPEL_WECHSEL &gt; OCRD.U_BOB_WEB_TRANSFER or OCRD.U_BOB_WEB_TRANSFER is Null)

    </SQL>
    
    <FMT>*XML</FMT>
    <OVERWRITE>*YES</OVERWRITE>
    <XMLROOT>shop3_user</XMLROOT>
  </PARM>