Index: vhDeploy/Deploy20160823xUpdateDHLTransportDuurSpanje.cls.xml
===================================================================
diff -u
--- vhDeploy/Deploy20160823xUpdateDHLTransportDuurSpanje.cls.xml	(revision 0)
+++ vhDeploy/Deploy20160823xUpdateDHLTransportDuurSpanje.cls.xml	(revision 36267)
@@ -0,0 +1,49 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="vhDeploy.Deploy20160823xUpdateDHLTransportDuurSpanje">
+<ClassType/>
+<ProcedureBlock>1</ProcedureBlock>
+<Super>vhDeploy.Deploy</Super>
+
+<Parameter name="Omschrijving">
+<Type>%String</Type>
+<Default>Update DHL transportuur. postcodes spanje met voorloopnullen (5 lang).</Default>
+</Parameter>
+
+<Method name="ExecCode">
+<ClassMethod>1</ClassMethod>
+<Implementation><![CDATA[
+	#dim QueryAPI As TECH.Query.QueryAPI = ##class(TECH.Context).Instance().GeefQueryAPI()
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '1%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '2%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '3%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '4%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '5%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '6%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '7%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '8%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+	Set SQLStatement = "Update ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"" Set Postcode = RIGHT('00000' _ ""APPS_TRANSP_Offerte_impl_DHL"".""Transportduur"".""PostCode"",5) where Landcode = 'ES' and Postcode like '9%'"
+	w !,SQLStatement
+	Do QueryAPI.ExecuteDynamicQuery(SQLStatement)
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>