V
vignesh kumar
Guest
This is my query which am trying but not fetching the correct data. Please hep me to sort this out. OUTPUT TO "C:\Businesswise_Property_Jan2015_test.csv". EXPORT DELIMITER "," "Policy" "Start Date" "Gross Premium USD" "Gross commission USD" "Transcation date" "Cedco" "Cedant name" "Insured Id" "Insured Name" "Broker code" "Broker Name" "Country" " Exchange Rate" " RI Sum Insured" "RSA Share" "TSI" "Rate%". FOR EACH uwm100 WHERE COMDAT >= 12/29/2014 AND COMDAT <= 01/28/2015 AND poltyp begins "c" AND uwm100.releas = yes NO-LOCK BY uwm100.policy: Assign n_prem = 0 n_comm = 0. Find buwm100 no-lock where buwm100.policy = uwm100.policy and buwm100.rencnt = uwm100.rencnt and buwm100.endcnt = uwm100.endcnt no-error. If avail buwm100 then Assign n_prem = n_prem + buwm100.prem_t n_comm = n_comm + buwm100.com1_t. EXPORT DELIMITER "," uwm100.policy uwm100.accdat n_prem n_comm uwm100.trndat uwm100.cedco n_cednam uwm100.insref uwm100.name1 uwm100.acno1 n_bacnam n_ctydes uwm100.curate uwm100.sigr_p uwm100.riin_p uwm100.cedsi. END. OUTPUT CLOSE.
Continue reading...
Continue reading...