Slide 1

Click to edit Master title style

Click to edit Master subtitle styl= e

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/master05.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/master05_image002.wmz Content-Transfer-Encoding: base64 Content-Type: image/x-wmz H4sIAAAAAAACC63bCXRT1foo8EPO/O0v0DGUpknbpEmaQNKQZmhaUrBACxUFQcSJGQUBBQSRSUEG BUVArjigKCByEQuUuczzJLRAKWNbKIUyT4qAlOJ9X3N99/3fetNaD2H9erL3/vZ39t7Z5ySnC04W 753LcaOvv/mnPWaMfIXn6M/Wzg04leP4WfEcJ3CZmvo6gfANFE6kIwvX1L9CTQOuwf+17d+vrmgn ZP/PrVKDBvRTJnVU13/uvr/O4aRqhY61GpGrj+D+U9/gv/RrSD9S+CnccHxJ/BCHiF/jFPEnnCdu wDXiPiwWy/CSWIX/Eq9jE+l39Ep12FHitQMlVTtF0moXSBHazVKU9pQUrf2djhFyhLaZrNXmyaq2 r8xr35fr8Gv5d1wjX8fDchVelctQo+xDvbIBvcpP+LTyNfZVPsTRynCcqaCSrX0gd9ZWy69rD8mj tOvkqdrv5a+0H8mLtUPkVdpu8hZttrxPa5GPaJl8UvubVElnrtZulWq0i6TL2mnSFe0QOnalchbV J1O7LJ3U3hKPaI+L+7SbxS3aReIq7SfiYu0I8Sttd3GqNk8cpW0uvq5NEDtrZTFbO5+bqXzKjVbG cn2VgVwH5WXOq3Tg9Eo2p1HSuatyKndYTuTWyDruazmCe18Grq8scXmyhmsmN+Ai6G34XWrAnZI0 3GZJ4hZIwE2RIriBko7rKCVyXimVi5fSafGzuUtiB65YfJlbKw7k5oljuQ/FT7kh4nzuJVEWl3IJ 4hdcc3EilycO5bqLvbgRYiduupjDLRL93GaxKXdcTOZuiXGcLEVyyRLjsuhsXSWeG0JnnyZx3CI6 bqXyKar/jdqZHMlZ5DguW07muslNuSGyn/tIzuG+lztx6+Re3CF5KFctT+QeyF9wqCwN74d/7x7u P3/+vXs0/9lr//rXv/5Ty4ePdxr8j53oMLz6X3bi/7rz6JKgnce4H6KG8h9HD+Xj4hrIcXFD+bwm 9UqUXnElSlm0WyyLLlF+iKo3lP/vI/j/PWcSyRDr+6tcQcJi6bxhoGBKXCzVvzbFlyjD9CWKIWG+ /HPifLlbUolyJLlE+YdxKN/ZMJSvb3/S80eF5yxz7R1D+W+a1iuRS9PClPaOek8+R2P4HFpulnso 38Vfr69Q3bzeDHG0t944qbp5vRK5rz9MmeWu9/ed+6nAOWV/xjnln5nF0roWJcqE7BJlbNYl8VZo KD+oxVC+KNMpXssYyjsCQ/mzQa1UH/+k5/44fO7W3PjII0pixBElKWIzWaQkR0wjgxRTRDvFHGEm D+WUiGLZEvGtbI14jThkW8RVyRaxiLwkpUaoZI2YGjFTtEW8QVqSaHJRsEWsFqwR40k7wRLRiJzg UyLm8eaIvrwpIpVPjripSYpYqUmMeEczPvIdzfuRC8kRzXuRHD8u0sOPjXydfMOPiSzlR0cyYXRk a2FU5Cjys/BuZAVRxXcjvaQ7mUgqiFt6N3K8NCryAGkoj458hnwkj4ncIo+NvCmPi4xXxkXmKO9F vq68H/kR+UEZH7lJqV+HJ13T+k+s+uvlE24mN982UZxt+1ScbPtSHGFbIPaz/Sw+b1sj5ti2iG7b XtFgKxFV20nxnvWsWGW9JP5ivSl+Y30kDrTKUgdrQ8lpjZXQqpeuWZKkvRaLtMBil8ZanFIXi1ty WDySxuKVylP80pqUDGlGSlB6IyVTakMSSWOiJTy5b86UrpGz5Bg5ENaUNCKXxAPmQjKbvENeItnE QpD8LhwwV5JdZInwi/lj8oZw0JxHTMIhcx1fbD7Gl5h/5g+bp/JHzAPJc/xRc4i4iJkY+Qpyidwh tURIMfINSWOSTNqToeTLlER+a0oSX5OSzDOLiW9uMfPdLBb+PYuNX2Bx8HssLv6qJZ1n1gzeac3m O1rb8kOsz/DTrF34hdaX+Y3W3vxR6wD+snUo/9g6io+yTeAttml8hm02n2/7hn/VtogfbFvOj7MV 8Z/YdvJf2Q7xi20n+VW2an6L7Ra/3/aQL7WJQrktUrhgMwrXbQ7hN1tAeGBrKzy2dRYapPYShNS3 BDn1PUFNnS5A6jcCS11Kx41U/oXqT1P7FYFLfSDU2UTxvi1avGNLFq/aXOJ5W5Z4ytZOPGx7Xtxt 6yVusA0Wl9neFev3SYx9Pi/bZ/MPU6fw11JH8eWpg/iDqT35jald+CWpefwXqVn8pFQ3PyTVyr+S qufbpkby7lSZb5L6p6ZB6j3NVdsNzSZbheYTW4nmRdsOjcm2VnPNulSzwrpA87b1K43H+pnmtuUT zRLLFE0PyweaSMt7mu0pYzSDUkZpYlJGaorMIzVzySjSmdhIJKk1jdRcJMVkHfmeTCXDyNumQs0I 0xXNO6ZE/h1TV36kaRr/rmkLP8p0iyQKo0zPCqNNY8licpg8EMaYEsQxppakN9kjjjaZpNGmUWS/ NMoUKY8ydZHfNc2QR5p2ye+YfiNGZYSprTLc9AaZprxtWkQ2K8NMR5Wj5qPKAfNR6U/SPOWI1I/M STks7Ukplu6mHJKSLb9Iz1gor2WPtNCyUzpk2Sb9btkkJVjXS62tq6Q3rMulGdYlUpF1oXTeOldS bbMlt22a9IJtvDTW9o70nW2gtMPWQ6q2PSfxqW0kU6pfeirVJvVIjZPGpCrSnNQH4orUGnF/6jHx XOoO8V7qclG1fyPq7VPFZvZ3xCx7b7G9/Rmxqz0o9rSniAPsEeIQe60wwl4jjLIfEcbaNwrj7Ivo +Jkwxj6e6t4U3rG/Krxtf1p4054pDLDbhT72JsIrdlXoYn/IP22/yufYz/AB+0Head/CJ9uX8/X7 5v91z/qv3zr+d/esXxr8+541i+vMDcYVYr3u+L3YAWeKWThedOBQsTH2EQXsIt5hbcVyliHuYU3F FcwofsmixPFMEvuzR8Iz7I6Qzi4JcaxCuAoHhfWwWZgIK4SnYaEQCV8Kx9XpwhfqZKGrOk6IVkcK JcpQYYoyWAgqA4Rr8mvCV3JfIUfuI1yTegs9SV+xnkXoJ17hXxML+NfFEXx/sTUx8ANEgTzSnBNq NTP5Wo1MGvF5YiO+GxkvRvDryR8kKEXyw8jXZImk5VcqWn6HgvxNhfHNVOCHqyq/UZX5P0gKSLwP ZpI00Qd28Vu2UpzHPpbrfcqmyX3YVDmFfSSfgg/lKTBZ9sAk+ZI6UV6iLpMXqyflH1VOWaRalB/U tqSHslB9i4xQFqjfKd+r+5Vv1V+Vr9Qm6hz1KfUzdYA6XZ2hfqSuVieq59SxKsBw1QsD1e7QS50C XdUCyFdLIVt9AM1VPTOrIRaj9mSiOp7dU75nF5UtrFQ5w7YrD1iBEotfKM1xvNIB+yv9sKMyFv3K TDQoC5FXVtNTxA4skUtwtXwav5Srcax8Cd+Ur2JP+QZ2km9hjvwrpsi/oUTHW9IdPCHdxG3SVVwi 1eBn0jkcI53CftIRepLZh5nSFrRIqzBC+ifW0dPPFfETPC6Ow53hfTMFUJ4MCfJEaCq/D0F5FOTJ w6CLPAB6yt1hkNwJ3pVzYbycRSuYBjNkM8yRVfhBvqEWysXqFnmpekD+UD0m91Ar5TbqRTlVvSaj elu+pfwulyh/yMuVOnm68i/5DUWj9CGdiE/hlWhFVG7JkrJPlpWFsqJMkIFw5Io8Qd5PfiDvk+4k j2TLk+VsabKcRTzSFDmFREmL5Ghpvxwj3ZZjpVhFJ2UojaWu5A0lThpKZinx0grFIB1WkqSbSorE VLtkV11SW9Ur9VazpLHqU9JstZ20RO0obVFfkKrVflIDGCYlwHjJA9OlNvC11BkWST2gUHoDNkvD gO5PUCa9D+eliXBbmgyPpfo1/Lu+250TJvAz+Qn8LH4T/xl/j5/Nu4R/8P2Fz/n55JQwh28kzuFz xS/4cWQFOSd+yaP0JR8gPckUsoQ8Iu3lL/nZ8hf8CRKrzOE7kknK5/xq5R/8OWU2L6uz6Zr6jH9G ncUPIlPUmfy3ZIV6Tqj3jXpWmEwGqJVCe2JRK4Q/lXLhGPlBOSMMVU4LAfJQPiWsI2+RZPmkcFg6 KYwiz0unhGaEJyfEU8I/xdPCSJIjnhEYKRPKhe+ECmEQyRAqBUU4K5zmzwkFfP06POma+v/6bjeT m8apCFIdqxNvs9vieVYtlrIT4i72i7iKbRUXstXiLLZEfJ/NEwex2WI3NlVszd4XXewdsQkbLGpY X/E6vCxug6fFzyAk9oLmohMs4gM1XtymRoqTVVXMUzWirNYJu5X7wnvKb0K6cku4JF8X5shXhafk K3SPvCIUkwIylfQk+cRLEolK7opXhEqyj6wkq8UkcY3YTVwrTifbxXXi7+J60SKtF1+QisQpZLW0 QTxHFHmD2Jx0I2PJd2QrSVI2iGNICUlQi8S+5Ad1vViprhMjYK2YTQbAGnEmrBZXkiOwima6SuTp PqpjGlnHaiWL2ky2qD3kFJWufrriTXSFJ6uNlUQ1RzGogxW9Okdpom5VdGqNEq2i2kj1qEztpsp0 h9So36uPlX3qfeWWeluJhctKJpxVesBx5QM4qPwA25XdsEa5CEsUgX2jmNgMpSUbr7zChiojWW9l JuukLGEtle3MpZxgCcp1Bsqf7IHcCGvkRCyVXbhVzsKf5Vy6R3bCSfKLOETuia/Ir2GuPACby4Mw gUjkd2kgXpAG4FHpNdwu9cFCqQd+L72EM6UuOF7qgEOktthLCuFzkhdzJAd6pSS6Z8ZiY6l+3/wI 5+Sv4Kr8MdyVx8JjeTBIyqvQSHka4mg+yUoq2GluzZUGEFRuqq2UU2qeUqA+r7yn9lJ6q/2V1uqb ilkdrvDqKOW88p6yRflA+UqZorytTFWeVj5WLMp0hVNmKOXyTGWdPEuZLX+mDJFnKx1IG5JFmhML aUIaEp7USvUmkQGkFWHkllwrlZL1ZB6ZTAaR50k2sRAgN6VHUgkpkOqkqdJjqa/0p5Ql/UuKkTj5 N5GTj4sN5C3kJ1EjzyWzyCciEh1JInbiIVmkLXmWjCBzyTZ5unhR/lRUlRmiS5kpdlZmiSOV2eJc 5XNxi/KlWKV8IzZQvxdN6iKxtbqUduZKcSLtzlXqHvGceky8p5aLKlwQDXBddMNdMQceiV1AkPqB VhoOjenemyTNAof0HfikpdBSWgf50g7oKh2EXtJxGCxVwiipBiZLN2CWdBfmSQ9hqfQY1ksatkcS WamksCoJ2G2JsccEZcYSZJU1lWWWKYusvdyAdZMfw2vyHzBc/g0myNfhU/kCzJXLYbFcCqvk/bBV 3gIH5JVQJtfvjye9VzUM3/9FLjXCCf8Iy8XUMCc8ae6h4dx+bkdkISRG1TsEJtIsai8EorZD66iN 0DlqLfSOWglvRy2HyVEF8CVZTNZELYPtUSvgELWdjFoN56PWwzWK/zVqK/wRtRP+jNoHfPQhkKNL AaJPgja6EhpGXyBXSS4ujar3CH6Kugv/jLoBP0ZdhYVRNfB91AX4NqoK/hFVAVOjTsHYqBMwiLxC OkSdhlZRlTS2akiLugKOqFuQGvUr2KJ+B2vUH+QRycUdkfUKn3h9Xgivj53zxbwOvpie4I95CQIx nSEz5hkIxeRBTkwO5MWE4JmYIHSN8UGPGA8MiEmDETHN4IOYpjArxg7zY1JhNakKewYOku0xz8K6 mI6wPOY5WBzzPCyIeRG+jekO38T0grkx/eDrmAFkMCmkPvVO0Ot6uegLOwGasEIaV73Xn3iu1X/9 fjCdy+K26OrYFp0GN+tk3KhjWKRrhOt00bhap8MVuib4sy4BF+iS8AudGafpLDiWDCY9qfw81edT ey7Ftab4VtQvRP2zKE+Q8gUpbwblz9DVQlB3j9yBLN11COkuQyvdBWitq4JcXSXk687A87oT0FN3 DAbrSmGs7ihMo+MXVF5A9T9T+wqKW03x66hfEfXfSHk2U74tlHcL5a+fR1lsHTseK+Op2EisiI3H 6lgzXo114G+xbqyL9aOsy8JoXUtM0uWgS9cWW+jy8BVdPs0pH+eSDVTeR/XHqb2a4m5R/EOdH/nG bsTGDoxubMYmjePR0DgSkxrLmNy4jiU3roWkxrfB0LgGmjSugOjGZYCNi4FvvBce6nbALd1mqNYV wXHdGtinWwUbdCtgrm4ZzbEAXqFjCyq7qD6J2qMpTqb4utgd8FvsXrgaWwzVsWVQEVsBp2Jr4Hjs bSiLrYX6eT7pHmgV3u9GLhBXCHPCiuErsihuD6yM2wrb4zbA4bg1UEVtd+OWg9KkAIxhZ+BxXDmc j6uE43Hn4Je4atgRVwMb4q5Qvxvwc9wdWBx3DxbG1cL3cRybFyezb+Masm/idCQXA2FPfr2uC4// JY7FF8IbYYdgMHk3fjdMit8Ks+I3wLz4NVBAbZvjl0NxfAFUkVukLn4ZqPpCiNWvgmT9Omim3wg+ /TbI1u+Bdvrt8Lx+E/Sk+sH61TCa4j7SL4cv9AXwI1lDduqXwWH9CijXr4RLFHNbvx7+oBxcwlaQ E3aCNmEfRCUcAl1CKTRJOAn6hEowJFwgV0kubtDXewhF+l9hnf4arNZfhOX6c/BPfTl8pz8F/9Cf oHOegFFksP409NJXQDf9eeikvwT5+hs0xjuQp78LufoH5BHJxer4eg/hfPyvcC7+GlTEX4ST8efg SHw57Is/RWtwAgrJAvJ5/GmYFl8BE+LPw+j4SzA8/gYMi78DQ+PvwpD4B+QRyUUW9uTvVcpfv6uw cQO4ZGMdSzJymGQU0WhUMcGoxSbGSNQZYzHaGIcNjfEoGBPxocGM1w0WLCcHyCaDCdcakrHQkIg/ Gwy4xBCPPxoa40JDDM43ROD3BsR5Bh6/NTxk3xq+ZfMMX7D5hs/YIsN0ttTwEVtpmMSKDOPZDsM4 dtAwmlUZ3mH3DW8zNA5jycahrH5cycanmUCuGjqwI4Zn2UZDJ/ajoQv7zNCNTTC8woYZerK+htfY i4aB7FnDMJZrGMVaUc4syh80zGIZhq+JjBmGRphp0GELGmcrmkcbgx3bG9Kwk8GL3QwZ2NPQAgcY WuEwQ2scZ8jFqYZ2+LmhPS4w5NP88nEPOUnly9R2n2J4YytsZMzCeKMfU4xutIXl4pSwuzDZeBUm Gs/DeONpGGMshXeMB+FN4x54zbgdXjVuhueMRZBrXANB4ypoaiyEBONyQOMyqDMUwDVymuw3LIMi w3L4yVAIcw2rYbphHYw3bIThhq0wwLATehr2wQuGYuhoOAbtDaehraEKWhsuQ47hNjGyxWEPYbHh DiwxXKE8NfCzoRqWG87BSkMFrKU+GwwnYavhOOwxlEGZoRQuG47CPTo2MB4DZjwO0TR+nbEcmhjP gt5YBQbjRUgyXodkmmP4vXnCfdg5fM+wcT8njoFGSQNIIXQLO0Gv6wFGJGlJBEYlRWN0UizGJTVB Y1ICWpKM6ExKwkBSMuaQbmG5aCVqUlu8ndgaLyY+hWcSs/FoYgs8kBjEnYk+3JzowfWJLlydaMcV iSm4LDERCxLj8efEGHICRocVws9hY574Wov/67NdpL9dkl+DrWFO6BL2GryQnIsbwwrpdWG4/Hd+ n9htrmO7zRrcZZZxp5nhdnMj3GKOxo1mHa43N8FV5gT8yZyE35nN+JnZghPJCNKfyq9QfWdqf5bi 8ik+j/q1pf6tKc9TlK8V5W1F+VuZa6GV+R48Zb4Drc3Xoa35MuSZL0C+uQqeNVdCZ/MZeMV8Avqb j8EIcylMNB+Fz+j4HZV/ovpV1L6e4jZS/Bbqt53676Q8uyjfbsq7m/LXz6PCVMcqTTKeM0XiRVM8 XjOZ8VeTA2tNbhTMfmxkzkK9uSWmmnPQb26Lbcx52MecT3PKx4VkO5UPU30ltV+juPsU3yDFjyzF jdEpDtSnmDE5JR4tKZGYmiKjPaWO2VNqITXlNlhSaiA5pQL0KWUQnVIMLGUvNEjZAffNm+GauQgq zWvgsHkVjX0FLDQvozkWQB86tqGyn+pTqV1PcY0oXjDvgFrTXvjVVAzXTGVw0VQB50w1UGm6DRWm Wqif55PugcHha8vLtbQUwrywQzCf/GTZC2ss22GHZSMctqyFc5aVcNuyHBpYCyCGmElz6zLItq6A fOtK6GpdDT2s66G/dSMMsW6FkdadMM66Dz6wHoIp1lKYaj0JH1sr4RPrBZhuvUro+SjsEdisdyHF egNMVJ9krQEDxTSxVkGEtQIk6yn4w3ICrpJT5BfLadhqqaSxVcMyyxX4p+UWLLL8Dj9YHpFcbBn2 5J99M/66Ngz06bfY7mCL7S/AaXLd3g0e2V8E1fEyxDq6Q7yjJyQ6eoPJ0Q+sjv6Q6hgIDsdb0NQx HJo5RhF6MnU0ZA5HFEt16JjVEc9MDgNLdCSxeIeJxTpSmOqwsUd2O7tO5zkdPpeDZdlzcXHY86yG PCYxji6UozPLdHRiTzueYS858tnrjjw2zJHDxjpCbJIjwKY53GyGw85mU/45jsbsC4eWfenQkPfh CxrTHMcbMNvRC2Y4XoRpjk4wyZEPYx1tYJijJbzuyISXHH542pEOmY7mNJc0iHG44LHdCTUkK+zJ 7zv//Tvsh00L4WJYMVwmd5vuAa7ZVmjYbAMYm62BtGaFkNNsObzQrADeDDsDHZqVg7tZJaQ0OwdN mlVDo2Y1IDe7Qv1uQG3TO3Cv6T34tWkt3GrKsRtNZXa9aUN2ramO5OKHYYV/63NYyFXHQi4NtnDJ mOWi5ydXI/S7ojHdpcM0VxNs6kpAkysJdS4zgsuCj5wWvEmqnGYscybhQWcC7nM2wV1OHW53RuMW ZyPc5GS40SnjBqeG1LENzlrY4LwHG513YJPzOmxxXobtzguwy1kF+5yVcNB5BsqcJ6DKeQxuOkvh kfMogKsUdK5jYHKdgKauM5DmqoR0VxX4XRcg6LoMWa7r0MJ1B0Kue6QW6ufR1VlPxhedkdjdGY99 aIwDnQ4c7nTje04/TnVm4efOlrjAmYPLnW1prHlY7synOeWj3pVPc8/Ddq622NWVg31cLfEtVxaO cflxksuN010O/JzWYK4rHr9zReICWq+FdM6FdO4FrtvwnasG5roq4HNXGUx3FcMk114Y49oBb7k2 Qx9XEXR1rYF2rlU09hWgdy2jORZAuXMZrcUKWO5cBQuca+BzZxFMdW6G95w7YLhzLwx0FkMfZxl0 d1bAi84a6Oq8TWqhfp5PugdKw3u4PzfRfRc+cF+D8e4LMNZdCSPdp2Co+zgMcB+DHu6j0IXkuUuh BZXT3fReuE9DivssJLkvgtF9GQzUN8F9i9wlMhrcDdHojkGTOx5tbiO63Mnod5vxKbcFnyWvkNep PITqR7oNONbdBMe7o/EDtxYnUv+J7j3sUpiENZTroluHVRRXQX1Ouu14xJ2G+91e3OYO4lp3CJe6 W+E8d2uc5c6lvu3wbXd77O3Ox07EQ3TuPFTdbbEuLQfvpLXEmrQWWJ6WgaVp6XgwzYW70+y4Lc2M m9ISsCgtlmgJ7de027AprQa2p1XA3rQyKE4rhhNpe6EqbQdcT9sMD9KKQHCvgSg3PUO7V0C2exmt VwG8Rd6j15+4l8NX7kJYRO2F7rWw0V0Eu9yb4aB7O5S698Ap90GopLU97z4JF2k9a9w1cMl9kzRn E8PuPvF1fuuv6zyBe5Gr8XRnvcJqobfnHrkDfT3X4TXPZejvuQCDPFXwlqcS3vacgXEeeg70HIPP PaXwg+corKTjViofoPpj1H6S4sop/iz1q6L+1ZTnIuWrobw1lL/+XDWeOqLBix4Zqz0MqzyN8Kwn Gss9OjzpaYLHPAl4wJOEWz1mXOmx4A/kc/IRlcdR/dvU/hbFDaL4/tTvNerfl/L0pny9KW8vyt/L 8xFrn16vFtql34a26TXwVHoFZKWXgTe9GJqm74Xk9B2gS98MkF4Ejz1r4LZnFZz3rICdnmU0twKY RMd+VH6B6ttRe5anCNI8myHFswPiPXsh0lMM4CkDwVMBnKcGHje/DXXNa0kde9xcRs4TiYInHoHG HelxYLzHjSkeP6Z5sjDL0xLbeXLwBU9b7OfJw0mefJpnPu4k56l8m+ofUzukt0RdehYmp/uxabob vekOzEqnayY9HtumR2K7dBnbp9fRPHfRmu4Kr+2T7g1d+F+mTuOcvpvQzHcJ7L4qsPgqINF3Chr7 jkMj3zEQfEfhofcoXPeWQpX3GJz0noAj3jNw0HsW9nkvwF7vFdjjvUUS2F5vEtvnTWG/eO2sxOti p70Z7Jq3DRvgm8OG+eayUb757H3fj2ySbyn7yLeCfexbyz7xbWLTfTuJhJ/4GuI0nw4/9Blwos+M 7/nsONKXhm/5vPiaL4iv+ELYydcKW/tao9+XizZfO4zztUfZl4/3vfTcSjZ583C5ty0u9Obgl96W ON3bAid5M3CMNx2He1042JuK/b0m7OfVYx9vNPb20n7y7mZ7wnjc4wXc543AA14dllBMmTcRK71m vOK14AMi+iwY4TPReRMx0adHM43X6ougsaiY6tOQo8zmO8Qsvr3M5NvOjDS/JjTPaF8hYzRvjW8R m+V9lU3xvsDGeTuyEd727E1vazbA24L18/pYH1q33l4r+Q36eK9BP281DPCWw5veMhjuLYGx3v0w ybsLPvVuha+8G2GRdx2s9K6Gbd5CKPEuh0rvMrjpLYA/SaSvAEy+ZeDxrYCnfCvhWd8aeMlXBH19 m2GwbzuM8O2GMb4DMN5XApN8pfCh7yRMo/f/Y995conYmTPsJvxde21Y4CYMDVyCNwNV8EagAvoG TsGrgePQJUDP9oGjECJpgVJIobI+cAJiAmegUeAsYOACQOAKqIFbJIFBIIlhIIU1DNhZVMDFjIEM lhZow5YF5rC1gblsS2A+2xX4ke0PLGUHAytYSWAtOxLYRHYSCY8EGmJJQIcHAwbcGzDjjoAdNwbS cFXAiz8Fgvh9IISfB1rh1EBrHBPIxcGBdvhqoD12CORjJkkgXCAP7/rb4mV/Dpb7W+JRfwvc58/A rf50XO934Up/Khb4TbjEr8fF/mj80c/IbqYG6vEIAUAWiMCGNI6ogB7jAomYTGNxBizYgrQnzwdM 2J3q+1J7f4obSPGDAyrRkKNsUOAQGxjYy/oHtrO+NL/uNM9ugULWkeadF1jEyvyvsl/8L7Dt/o6s yN+erfK3ZgX+FmyJ38cW+13sR7+V/AaL/ddgib8aCvzlsNJfBuv9JbDNvx/2+3dBqX8rVPo3wlX/ OrjvXw18oBCiAsshObAMmgcKIId0Jf2p/G5gBUwJrITZgTUwL1AESwKboTCwHYoCu2Fr4ADsDpTA fnp/DwZOQjG9/yWB83CY9sNheh+Hhd38W7/bHg3WsSNBDR4JylgSZHgo2Ah/CUbj3qAOdwWb4LZg Aq4NJuHSoBnnBS04g0wgw6k8gOp7UPvLFNeN4rtQv+eof0fK8wzle4bydqD8HYK18EzwHrkDHYPX 4bngZegSvADdglXwcrASegTPwIDgCRgePAYTgqUwI3gU5tFxKZXXUv02at9FcXsp/hfqd4j6l1Ce I5TvCOU9Svnr53Elo45dzZDxRkYk3smIx/sZZnyc4UAp6MaIoB/1wSy0BVuiN5iDOcG22CmYh0OC +TSnfFxOiqlcTvVXqf0+xWkys1Cb6cfGmW5MynSgLZP2XmY8Ns+MRG+mjL7MOubLrAVv5m1onlkD zswKsGWWQVJmMTTO3AvazB2gydwM94NFcDW4BsqDq6A4SN9lg8tojgUwhI6dqJxD9V5qt1GcPrgZ IoI7QAruhccZxXA/owzuZFTAjYwauJpxG65k1EL9PP+u57Onswrhp7BiKCBFWXtgT9ZWOJa1AS5k rYHfqU1usRwSWhSAJ+wMRLYoh3tZlXA16xyczaqG41k1cCiLPueybsC2rDuwMeserMuqhdVZHFuZ JbPCrIZsRZaO5OLTYYV/2/3ycoi+D4YuwcVQFZwLVcDp0CkoDR2HA6FjsC10FFaTxaFSmEvlz0In 4OPQGZgSOgsTQxdgQugKuUUS2IRQEpsYSmFTQnY2LeRin4cy2I+hNsycPYc1zZ7L0rPns2D2jyw7 eynLyV7B2mSvZbnZm8hOImFudkNsk63Dp7INGMo2YyDbju7sNLRnezEpO4i67BBCdiv8M9Qafw3l YnWoHZaG2uPOUD4WktlkZCgP3wi1xe6hHHwu1BLzQi0wFMpAXygdnSEX2kKpaAqZ0BjSY0IoGvUh RnbT2OvxOCEE+EEoAieHdDiVYmaGEvGrkBl/CFlwFdlGfqH+x6j+NLWfpbgqiq8OqURDjrLq0CFW FdrLKkPb2enQJnYstJYVhwrZ3tBStiW0iOWHXmWtQi+wQKgjSwu1Z6mh1swcasESQz6WQOumD1nJ b5AQugbGUDWYQuVgC5WBK1QCvtB+yA7tgnahrdAltBF6htbB4NBqGBMqhKmh5fBlaBksCRVAETlI Kql8M7QCHoVWgpK9BmKyi8CYvRls2dvBlb0bvNkHIDO7BLKzS+Gp7JPQOrsC2mSfh7bZl4idXQ7V +z/fL8P/QYr7bzM0Da42NQAA ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/pres.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0001.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Inaport Training<= /span>

SQL Matching

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/master05_background.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODdhFgKQAXcAACH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACwAAAAAFgKQAYccPp8b Pp8aPp8aPZ8ZPZ4ZPJ4YPJ4XO54XO50XOp0WOp0VOp0VOZwTOJwSOJwSOJsSN5sQN5sPN5sPNpsP NpoMNpoLNpoLNZoLNJoINJoBNJoANJkAM5kdP6AcP6AfQqIfQaEeQaEeQKEeQKA6X7g6Xrc5Xrc5 XrY4XbY4XLU3W7U3W7Q2WrQ2WrM2WbM1WbI1WLI0WLIzV7EyVrAyVbAyVa8xVK8wVK4wU64vUq0v Ua0uUa0uUawtUKwtUKstT6ssTqorTqorTakqTKkqTKgpS6gpSqgoSqcoSacnSacnSaYnSKYmSKYl SKYlR6UkR6UkRqUjRqQjRaQiRaMiRKMhRKMgRKMgQ6IgQqI/Zr4/Zr0/Zb0+ZLw+Y7w+Y7s9Y7s9 Yrs8Yro8Ybo8Ybk7YLk6YLhBZ79AZr5RfNNRe9JQe9JQe9FQetFPetFPedFPedBOec9OeM9Od89N d85Nds1Mds1Mdc1MdcxLdcxLdMxLdMtKc8tKc8pJcspJcslJcclJcchIcchIcMhIcMdHcMdHb8ZG bsZGbsVGbcVFbcRFbMRFbMNEa8NEa8JEasJDasJDasFCacFCacBCaMBBaMABAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMI/wDRCBxIsKDBgwgTKlzIsKHDhxAjSpxIsaLFixgzatzI saPHjyBDihxJsqTJkyhTqlzJsqXLlzBjypxJs6bNmzhz6tzJs6fPn0CDCh1KtKjRo0iTKl3KtKnT p1CjSp1KtarVq1izat3KtavXr2DDih1LtqzZs2jTql3Ltq3bt3Djyp1Lt67du3jz6t3Lt6/fv4AD C+6YprDhw4gTK17MuLHjx5AjS55MubLly5gza97MubPnz6BDix5NurTp06hTq17NurXr17Bjy55N u7bt27hz697Nu7fv38CDCx9OvLjx48iTK1/OvLnz59CjS59Ovbr169iza9/Ovbv37+DDi/8fT768 +fPo02tXw769+/fw48ufT7++/fv48+vfz7+///8ABijggAQWaOCBCCao4IIMNujggxBGKOGEFFZo 4YUYZqjhhhx26OGHIIYo4ogklmjiiSimqOKKLLbo4oswxijjjDTWaOONOOao44489ujjj0AGKeSQ RBZp5JFIJqnkkkw26eSTUEYp5ZRUVmnllVhmqaWOa3Tp5ZdghinmmGSWaeaZaKap5ppstunmm3DG KeecdNZp55145qnnnnz26eefgAYq6KCEFmrooYjyycaijDbq6KOQRirppJRWaumlmGaq6aacdurp p6CGKuqopJZq6qmopqrqqqy26uqrsMb/KuustNZq66245qrrrrz26uuvwAYr7LDEFmvsscgmq+yy zDbr7LPQRivttNRWa+212Gar7bbcduvtt+CGK+645H7bxrnopqvuuuy26+678MYr77z01mvvvfjm q+++/Pbr778AByzwwAQXbPDBCCes8MIMN+zwwxBHLPHEFFds8cUYZ6zxxhx37PHHIIcs8sgkl9yx GyinrPLKLLfs8sswxyzzzDTXbPPNOOes88489+zzz0AHLfTQRBdt9NFIJ6300kw37fTTUEct9dRH v2H11VhnrfXWXHft9ddghy322GSXbfbZaKet9tpst+3223DHLffcdNdt991456333nz3/+3334AH LvjghBdu+OGIJ6744ow37vjjkEcu+eSUV2755ZhnrvnmnHfu+eeghy766KSXbvrpqKeu+uqst+76 67DHLvvstNdu++2456777rz37vvvtMMh/PDEF2/88cgnr/zyzDfv/PPQRy/99NRXb/312Gev/fbc d+/99+AbH8f45Jdv/vnop6/++uy37/778Mcv//z012///fjnr//+/Pfv//8ADKAAB0jAAhrwgAhM oAIXyMAGOvCBEIygBCdIwQpa8IIYzKAGN8jBDnrwgyAMoQhHSMISmvCEKEyhClfIwha68IUwjKEM Z0jDGtrwhjjMoQ53yMMe+vCHQAyiEP+HSMQiGvGIOJSDEpfIxCY68YlQjKIUp0jFKlrxiljMoha3 yMUuevGLYAyjGMdIxjKa8YxodOIc1sjGNrrxjXCMoxznSMc62vGOeMyjHvfIxz768Y+ADKQgB0nI QhrykIhMpCIXychGOvKRkIykJCdJyUpa8pKYzKQmN8nJTnryk6AMpShHScpSmvKUqEylKlfJyla6 8pWwjKUsZ0nLWtrylrjMpS53ycte+vKXwAymMIdJzGIa85jITKYyl8nMZjrzmcCkgzSnSc1qWvOa 2MymNrfJzW5685vgDKc4x0nOcprznOhMpzrXyc52uvOd8IynPOdJz3ra8574zKc+98n/z376858A DahAB0rQghr0oAi1Zh0WytCGOvShEI2oRCdK0Ypa9KIYzahGN8rRjnr0oyANqUhHStKSmvSkKE2p SlfK0pa69KUwjalMZ0rTmtr0pjjNqU53ytOe+vSnQA2qUIdK1KIa9ahITapSl8rUpjr1qVCN6kzt QNWqWvWqWM2qVrfK1a569atgDatYx0rWspr1rGhNq1rXyta2uvWtcI2rXLF6h7ra9a54zate98rX vvr1r4ANrGAHS9jCGvawiE2sYhfL2MY69rGQjaxkJ0vZylr2spjNrGY3y9nOevazoA2taEdL2tKa 9rSoTa1qV5tXPLj2tbCNrWxnS9va/9r2trjNrW53y9ve+va3wA2ucIdL3OIa97jITa5yl8vc5jr3 udCNrnSnS93qWve62M2udrfL3e5697vgDa94x0te2ebhvOhNr3rXy972uve98I2vfOdL3/ra9774 za9+98vf/vr3vwAOsIAHTOACG/jACE6wghfM4AY7+MEQjrCEDayHClv4whjOsIY3zOEOe/jDIA6x iEdM4hKb+MQoTrGKV8ziFrv4xTCOsYxnTOMa2/jGOM6xjnfM4x77+MdADrKQh0zkIhv5yEhOspKX zOQmO/nJUI6ylKdM5Spb+cpYzrKWt9zjPXj5y2AOs5jHTOYym/nMaE6zmtfM5ja7+f/NcI6znOdM 5zrb+c54zrOe98xnMfPhz4AOtKAHTehCG/rQiE60ohfN6EY7+tGQjrSkJ03pSlv60pjOtKY3zelO e/rToA61qEdN6lKb+tSoTrWqV83qVrv61bCOtaxnTeta2/rWuM61rnfN6177+tfADrawh03sYhv7 2MhOtrKXzexU9+HZ0I62tKdN7Wpb+9rYzra2t83tbnv72+AOt7jHTe5ym/vc6E63utfN7na7+93w jre8503vetv73vjOt77d7Yd++/vfAA+4wAdO8IIb/OAIT7jCF87whjv84RCPuMQnTvGKW/ziGM+4 xjfO8Y57/OMgD7nIR07ykpv85Cj/T7nKV87ylrv85TCPucxnTvOa2/zmOM+5znfO8577/OdAD7rQ h17yPxj96EhPutKXzvSmO/3pUI+61KdO9apb/epYz7rWt871rnv962APu9jHTnalA+LsaE+72tfO 9ra7/e1wj7vc5073utv97njPu973zve++/3vgA+84AdP+MIb/vCIT7ziF8/4xjv+8ZCPvOQNH4jK W/7ymM+85jfP+c57/vOgD73oR0/60pv+9KhPvepXz/rWu/71sI+97GefeUHY/va4z73ud8/73vv+ 98APvvCHT/ziG//4yE++8pfP/OY7//nQj770p0/96lv/+tjPvva3z/3ue//74A9///UHQf7ym//8 6E+/+tfP/va7//3wj7/850//+tv//vjPv/73z//++///ABiAAjiABFiABniACJiACriADNiADviA EBiBEjiBFFiBFniBGJiBGoh+hNCBHviBIBiCIjiCJFiCJniCKJiCKriCLNiCLviCMBiDMjiDNFiD NniDOJiDOriDPNiDPviDQBiEQjiERFiERniESJiESriETNiETviEUBiFUjiFIVgIVniFWJiFWriF XNiFXviFYBiGYjiGZFiGZniGaJiGariGbNiGbviGcBiHcjiHdFiHdniHeJiHeriHfNiHfviHgBiI gjiIhFiIhniIiJiIiriIjNiIjv/4iJAYiZI4iZRYiZZ4iZiYiZq4iZzoh4bwiaAYiqI4iqRYiqZ4 iqiYiqq4iqzYiq74irAYi7I4i7RYi7Z4i7iYi7q4i7zYi6N4CMAYjMI4jMRYjMZ4jMiYjMq4jMzY jM74jNAYjdI4jdRYjdZ4jdiYjdq4jdzYjd74jeAYjuI4juRYjuZ4juiYjuq4juzYju74jvAYj/I4 j/RYj/Z4j/iYj/q4j/zYj/5oj4gQkAI5kARZkAZ5kAiZkAq5kAzZkA75kBAZkRI5kRRZkRZ5kRiZ kRq5kRzZkR75kQWZCCI5kiRZkiZ5kiiZkiq5kizZki75kjAZkzI5kzRZkzZ5kzj/mZM6uZM82ZM+ +ZNAGZRCOZREWZRGeZRImZRKuZRM2ZRO+ZRQGZVSOZVUWZVWeZVYaZKKsJVc2ZVe+ZVgGZZiOZZk WZZmeZZomZZquZZs2ZZu+ZZwGZdyOZd0WZd2eZd4mZd6uZd82Zd++ZeAGZiCOZiEWZiGqZeLkJiK uZiM2ZiO+ZiQGZmSOZmUWZmWeZmYmZmauZmc2Zme+ZmgGZqiOZqkWZqmeZqomZqquZqs2Zqu+Zqw GZuyOZu0WZu2eZu4mZu6uZu82Zu++ZuNyQjCOZzEWZzGeZzImZzKuZzM2ZzO+ZzQGZ3SOZ3UWZ3W eZ3YmZ3auZ3c2Z3e+Z3gGZ7i/zme5Fme5nme6Jme6rme7Nme7vme8Bmf8jmf9Fmf9nmf+GmcjbCf /Nmf/vmfABqgAjqgBFqgBnqgCJqgCrqgDNqgDvqgEBqhEjqhFFqhFnqhGJqhGrqhHNqhHvqhIBqi IjqiJFqiJqqhjpCiKrqiLNqiLvqiMBqjMjqjNFqjNnqjOJqjOrqjPNqjPvqjQBqkQjqkRFqkRnqk LfoISrqkTNqkTvqkUBqlUjqlVFqlVnqlWJqlWrqlXNqlXvqlYBqmYjqmZFqmZnqmaJqmarqmbNqm bvqmcBqncjqndFqnaQoJeJqnerqnfNqnfvqngBqogjqohFqohnqoiJqoirqojP/aqI76qJAaqZI6 qZRaqZbKp5GQqZq6qZzaqZ76qaAaqqI6qqRaqqZ6qqiaqqq6qqzaqq76qrAaq7I6q7Raq7Z6q7ia q7q6q7zaq776q8AarMI6rMRarMZ6rMiarMq6rMzarM76rJ0qCdI6rdRardZ6rdiardq6rdzard76 reAaruI6ruRaruZ6ruiaruq6ruzaru76rvAar/I6r/Rar/Z6r/iar/q6r/zar/E6CQAbsAI7sARb sAZ7sAibsAq7sAzbsA77sBAbsRI7sRRbsRZ7sRibsRq7sRzbsR77sSAbsiI7siRbsiZ7siibsiq7 sh9LCS77sjAbszI7szRbszb/e7M4m7M6u7M827M++7NAG7RCO7REW7RGe7RIm7RKu7RMK7Nm8LRQ G7VSO7VUW7VWe7VYm7Vau7Vc27Ve+7VgG7ZiO7ZkW7Zme7Zom7Zqu7Zs27Zu+7ZwG7dyO7d0W7d2 e7d4m7d6u7d827d++7eAG7iCO7iEW7iGe7iIm7iKu7iM27iO+7iQG7mSO7mUW7l3ewaYm7mau7mc 27me+7mgG7qiO7qkW7qme7qom7qqu7qs27qu+7qwG7uyO7u0W7u2y7lZkLu6u7u827u++7vAG7zC O7zEW7zGe7zIm7zKu7zM27zO+7zQG73SO73UW73We73Ym73au73c273e+73g/xu+4ju+5Iu9WnC+ 6Ju+6ru+7Nu+7vu+8Bu/8ju/9Fu/9nu/+Ju/+ru//Nu//vu/ABzAAjzABFzA67sFCJzACrzADNzA DvzAEBzBEjzBFFzBFnzBGJzBGrzBHNzBHvzBIBzCIjzCJFzCJnzCKJzCKrzCLNzCLvzCMBzDMjzD NFzDNnzDOJzDOrzDPNzDPvzDQBzEQjzERFzERuzDXJDESrzETNzETvzEUBzFUjzFVFzFVnzFWJzF WrzFXNzFXvzFYBzGYjzGZFzGZnzGaJzGarzGbNzGbvzGcBzHcjzHdFzHdnzHeJzHerzHfNzHfvzH TdwFgjzIhFzIhnzIiJzIiv+8yIzcyI78yJAcyZI8yZRcyZZ8yZicyZq8yZzcyZ78yaBsyF4wyqRc yqZ8yqicyqq8yqzcyq78yrAcy7I8y7Rcy7Z8y7icy7q8y7zcy778y8AczMI8zMRczMZ8zMiczMq8 zMzczM4szF8QzdI8zdRczdZ8zdiczdq8zdzczd78zeAczuI8zuRczuZ8zuiczuq8zuzczu78ztUM BvI8z/Rcz/Z8z/icz/q8z/zcz/78zwAd0AI90ARd0AZ90Aid0Aq90Azd0A790BAd0RI90RRd0RZ9 0Rid0Rq90Rzd0REdBiAd0iI90iRd0iZ90iid0iq90izd0i790jAd0zI90zT/XdM2fdM4ndM6vdM8 3dM+/dNAHdRCPdREXdRGfdRIndRKvdQ/LQZO/dRQHdVSPdVUXdVWfdVYndVavdVc3dVe/dVgHdZi PdZkXdZmfdZondZqvdZs3dZu/dZwHddyPdd0Xdd2fdd4ndd6vdd83dd+/deAHdiCPdiELdVjcNiI ndiKvdiM3diO/diQHdmSPdmUXdmWfdmYndmavdmc3dme/dmgHdqiPdqkXdqLTQaondqqvdqs3dqu /dqwHduyPdu0Xdu2fdu4ndu6vdu83du+/dvAHdzCPdzEXdzGfdzIndzKvdzM3dzO/dzQHd3SPd3H XQbWfd3Ynd3avd3c3d3e//3d4B3e4j3e5F3e5n3e6J3e6r3e7N3e7v3e8B3f8j3f9K3dJHDf+J3f +r3f/N3f/v3fAB7gAj7gBF7gBn7gCJ7gCr7gDN7gDv7gEB7hEj7hFF7hFn7hGJ7hGr7hHN7hHv7h IB7iIj7iJF7iJn7iKJ7iKr7iLN7i+10CMB7jMj7jNF7jNn7jOJ7jOr7jPN7jPv7jQB7kQj7kRF7k Rn7kSJ7kSr7kTN7kTv7kUB7lUj7lVF7lVn7lWJ7lWr7lT24CXv7lYB7mYj7mZF7mZn7maJ7mar7m bN7mbv7mcB7ncj7ndF7ndn7neJ7ner7nfN7nfv7ngB7ogj7ohF7ohn7oiP+e6H1+Aoze6I7+6JAe 6ZI+6ZRe6ZZ+6Zie6Zq+6Zze6Z7+6aAe6qI+6qRe6qZ+6qie6qoO6SjQ6q7+6rAe67I+67Re67Z+ 67ie67q+67ze677+68Ae7MI+7MRe7MZ+7Mie7Mq+7Mze7M7+7NAe7dI+7dRe7dZ+7die7dq+7dze 7d7+7eAe7uI+7rGeAuZ+7uie7uq+7uze7u7+7vAe7/I+7/Re7/Z+7/ie7/q+7/ze7/7+7wAf8AI/ 8ARf8AZ/8Aif8Aq/8Azf8A7/8BAf8RI/8RRf8RZ/8Rif8Rq/8Ryv7irw8SAf8iI/8iRf8iZ/8iif 8iq/8izf8i7/8jAf8zL/P/M0X/M2f/M4n/M6v/M83/M+//NAH/RCP/REX/RGf/RIn/RK7/Mr0PRO //RQH/VSP/VUX/VWf/VYn/Vav/Vc3/Ve//VgH/ZiP/ZkX/Zmf/Zon/Zqv/Zs3/Zu//ZwH/dyP/d0 X/d2f/d4z/YssPd83/d+//eAH/iCP/iEX/iGf/iIn/iKv/iM3/iO//iQH/mSP/mUX/mWf/mYn/l/ 3wKc3/me//mgH/qiP/qkX/qmf/qon/qqv/qs3/qu//qwH/uyP/u0X/u2f/u4n/u6v/u83/u+//vA H/zCP/zEX/zGf/y77wLKv/zM3/zO//zQH/3SP/3UX/3Wf/3Yn/3av/3c/9/93v/94B/+4j/+5F/+ 5n/+6J/+6r/+7N/+7v/+8B//8j//9F//9n//+J//+r///N///v//AOFC4ECCBQ0eRJhQ4cEXDR0+ hBhR4kSKFS1exJhR40aOHT1+BBlS5EiSJU2eRJlS5cqIMFy+hBlT5kyaNW3exJlT506ePX3+BBpU 6FCiRY0eRZpU6VKmTZ0+hRpV6lSqVa1exZq1aQyuXb1+BRtW7FiyZc2eRZtW7Vq2bd2+hRtX7ly6 de3exZtXL1gZff3+BRxY8GDChQ0fRpxY8WLGjR0/hhxZ8mTKlS1fxpxZ82bOnT1/Bh1a9GjSpU2f Rp1a9WrWrV2/hh1b9v9s2rVt38adW/fu2TN8/wYeXPhw4sWNH0eeXPly5s2dP4ceXfp06tWtX8ee Xft27t29fwcfXvx48uXNn0efXv169u3dv4cfX/58+sJp3MefX/9+/v39/wcwQAEHJLBAAw9EMEEF F2SwQQcfhDBCCSeksML9asAwQw035LBDDz8EMUQRRySxRBNPRDFFFVdksUUXX4QxRhlnpLFGG2/E MUcdd+SxRx9/BDJIIYe80QYjj0QySSWXZLJJJ5+EMkopp6SySiuvxDJLLbfksksvvwQzTDHHJLNM M89EM00112SzTTffhDNOOeeks04778QzTz335FPJG/4ENFBBByW0UEP/D0U0UUUXZbRRRx+FNFJJ J6W0UksvxTRTTTfltFNPPwU1VFFHJbVUU09FNVVVPcWhVVdfhTVWWWeltVZbb8U1V1135bVXX38F NlhhhyW2WGOPRTZZZZdltllnn4U2WmmnpbZaa6/FNlttt+W2W2+/BTdccceNNQdzz0U3XXXXZbdd d9+FN15556W3XnvvxTdfffflt19//wU4YIEHJlhdHQ5GOGGFF2a4YYcfhjhiiSemuGKLL8Y4Y403 5rhjjz8GOWSRRya5ZJNPRjlllVdmuWWXX4Y5ZplN3qFmm2/GOWedd+a5Z59/BjpooYcmumijj0Y6 aaWXZrppp5+GOmqp/6fOmQerr8Y6a6235rprr78GO2yxxya7bLPPRjtttddmu22334Y7brnnprtu u+/GO2+99+a7b7//BjzwunsgvHDDD0c8ccUXZ7xxxx+HPHLJJ6e8cssvxzxzzTfnvHPPPwc9dNER 96F0009HPXXVV2e9dddfhz122WenvXbbb8c9d9135713338HPnjhhye+eOOPRz555Zdnvnnnn4ee +B+mp75666/HPnvtt+e+e++/Bz988ccnv3zzz0c/ffXXZ79999+HP37556e/fvvvxz9//ffnv3// /wdgAAU4QAIW0IAHRGACrwcEBjbQgQ+EYAQlOEEKVtCCF8RgBjW4Qf8OdtCDHwRhCEU4QhKW0IQn RGEKVbhCFrbQhS+EYQxlOEMa1tCGN8RhDnW4Qx720Ic/BGIQhQjBIBTRiEdEYhKVuEQmNtGJT4Ri FKU4RSpW0YpXxGIWtbhFLnbRi18EYxjFOEYyltGMZ0RjGtW4Rja20Y1vhCMZhTBHOtbRjnfEYx71 uEc+9tGPfwRkIAU5SEIW0pCHRGQiFblIRjbSkY+EZCQlOUlKVtKSl8RkJjW5SU520pOfBGUoRTlK UpbSlKdEZSrvOARWttKVr4RlLGU5S1rW0pa3xGUudblLXvbSl78EZjCFOUxiFtOYx0RmMpW5TGY2 05nPhGY0pTlNalb/05rXXCYRtLlNbnbTm98EZzjFOU5yltOc50RnOtW5Tna2053vhGc85TlPetbT nvfEpzeLsE9+9tOf/wRoQAU6UIIW1KAHRWhCFbpQhjbUoQ+FaEQlOlGKVtSiF8VoRjW6UY521KMf BWlIRTpSkpbUpCdFaUpVulKWttSlL4VpTP9pBJrW1KY3xWlOdbpTnvbUpz8FalCFOlSiFtWoR0Vq UpW6VKY21alPhWpUpTpVqlbVqlfFala1ulWudtWrX53qEcQ6VrKW1axnRWta1bpWtrbVrW+Fa1zl Ole61tWud8VrXvW6V7721a9/BaxZkTBYwhbWsIdFbGIVu1jGNtax/4+FbGQlO1nKVtayl8VsZjW7 Wc521rOfBW1oRTta0pbWtKdFbWpVu1rWtta1ok1CbGU7W9rW1ra3xW1udbtb3vbWt78FbnCFO1zi Fte4x0VucpW7XOY217nPra0SpDtd6lbXutfFbna1u13udte73wVveMU7XvKW17znRW961bte9rbX ve+Fb3zlO1/61te+98VvfvW7X/72N75LAHCABTxgAhfYwAdGcIIVvGAGN9jBD4ZwhCU8YQpX2MIX xnCGNbxhDnfYwwRmQohFPGISl9jEJ0ZxilW8Yha32MUvhnGMZTxjGtfYxjfGcY51vGMe99jHPy5x E4Q8ZCIX2chHRv9ykpW8ZCY32clPhnKUpTxlKlfZylfGcpa1vGUud9nLXwazkZ0wZjKX2cxnRnOa 1bxmNrfZzW+Gc5zlPGc619nOd8ZznvW8Zz732c9/BnSgBT1oQhfa0IdGdKIVvWhGN9rRgn5CpCU9 aUpX2tKXxnSmNb1pTnfa058GdahFPWpSl9rUp0Z1qlW9ala32tWvhnWsZT1rWtfa1rfGda51vWte 99rXvwZ2sIU9bGIX29jHrjQUlL1sZjfb2c+GdrSlPW1qV9va18Z2trW9bW5329vfBne4xT1ucpfb 3OdGt7OjsG52t9vd74Z3vOU9b3rX2973xne+9b1vfvfb3/8GeMD/BT5wghfc4AdHeMIVvnCGN9zh D4d4xCU+cYpX3OIKl0LGNb5xjnfc4x8HechFPnKSl9zkJ0d5ylW+cpa33OUvh3nMZT5zmtfc5jfH ec51vnOe99znPwd60IU+dKIX3ehHR3rSlb50pjfd6U/v+BSkPnWqV93qV8d61rW+da533etfB3vY xT52spfd7GdHe9rVvna2t93tb4d73OU+d7rX3e53x3ve9b53vvc97lQAfOAFP3jCF97wh0d84hW/ eMY33vGPh3zkJT95ylfe8pfHfOY1v3nOd97znwd96EU/etKX3vSnR33qVb/6z1fB9a+HfexlP3va 1972t8d97nW//3ve9973vwd+8IU/fOIX3/jHR37ylb985sveCs+HfvSlP33qV9/618d+9rW/fe53 3/vfB3/4xT9+8pff/OdHf/rVv372t3/6V4B//OU/f/rX3/73x3/+9b9//vff//8HwAAUwAEkwAI0 wANEwARUwAVkwAZ0wAeEwAiUwAmkwAq0wAvEwAzUwA18QCzwwA8EwRAUwREkwRI0wRNEwRRUwRVk wRZ0wReEwRiUwRmkwRq0wRvEwRzUwR3kQRH8gB8EwiAUwiEkwiI0wiNEwiRUwiVkwiZ0wieEwiiU wimkwiq0wivEwizUwi3kwi70wi8EwzAUwzEkwzI0wzNEwzRUw/81ZMM2dMM3hMM4lMM5pMM6tMM7 xMM81MM95MM+rEMQAMRAFMRBJMRCNMRDRMREVMRFZMRGdMRHhMRIlMRJpMRKtMRLxMRM1MRN5MRO 9MRPBMVQFMVRJMVSNMVTRMVUVMVVZMVWdMVXhMVYlMVZpMVatEVCDIFc1MVd5MVe9MVfBMZgFMZh JMZiNMZjRMZkVMZlZMZmdMZnhMZolMZppMZqtMZr7EUR0MZt5MZu9MZvBMdwFMdxJMdyNMdzRMd0 VMd1ZMd2dMd3hMd4lMd5pMd6tMd7xMd81Md95Md+9Md/BMiAFMiBJMiCzMcRQMiEVMiFZMiGdMiH hMiIlMiJpMj/irTIi8TIjNTIjeTIjvTIjwTJkBTJkSTJkjRJhuyAlFTJlWTJlnTJl4TJmJTJmaTJ mrTJm8TJnNTJneTJnvTJnwTKoBTKoSTKojTKo2xJD1DKpWTKpnTKp4TKqJTKqaTKqrTKq8TKrNTK reTKrvTKrwTLsBTLsSTLsjTLs0TLtFTLtWTLtnTLt4TLuJTLuaTLurTLu8TLvNTLveTLvvTLvwTM wBTMwSTMwjTMw0RMwASAxWTMxnTMx4TMyJTMyaTMyrTMy8TMzNTMzeTMzvTMzwTN0BTN0STN0jTN 00TN1HzMAGDN1nTN14TN2JTN2aTN2rTN28TN3NTN3eTN3vTN/98EzuAUzuEkzuI0zuNEzuRUTtgU gOZ0zueEzuiUzumkzuq0zuvEzuzUzu3kzu70zu8Ez/AUz/Ekz/I0z/NEz/RUz/Vkz/Z0z/eEz/iU z/mkz/q0z/vEz/zUz/3kz/70z/8E0AAV0AEl0AI10ANF0ARV0AUd0AFw0AeF0AiV0Aml0Aq10AvF 0AzV0A3l0A710A8F0RAV0REl0RI10RNF0RRV0RVl0RZ10ReF0RiV0Rml0Rq10RvF0RxtUQLg0R71 0R8F0iAV0iEl0iI10iNF0iRV0iVl0iZ10ieF0iiV0iml0iq10ivF0izVUiAtgC710i8F0zAV0zEl 0zI10zNF0/80VdM1ZdM2ddM3hdM4ldM5pdM6tdM7xdM81dM95dM+9dM/BdRAFdRBJdRCNdRDRdRE VdRFZdRGddRHhdRIldRJpdRKtdRLxdRM1dRN5dRO9dRPBdVQFdVRJdVSNdVTRdVUVdVDNYBWddVX hdVYldVZpdVatdVbxdVc1dVd5dVe9dVfBdZgFdZhJdZiNdZjRdZkVdZljdUDcNZnhdZoldZppdZq tdZrxdZs1dZt5dZu9dZvBddwFddxJddyNddzRdd0Vdd1ZVdpRYB3hdd4ldd5pdd6tdd7xdd81dd9 5dd+9dd/BdiAFdiBJdiCNdiDRdiEVdiFZdiGddiHhdiIldj/iaXYirXYi8XYjNVYh02AjvXYjwXZ kBXZkSXZkjXZk0XZlFXZlWXZlnXZl4XZmJXZmaXZmrXZm8XZnNXZneXZnvXZnwXaoBXaoSXaojXa o0XapFXapWXapnXap4XaqJXaqaXaqrXaq8XarNXarZ1aBfDarwXbsBXbsSXbsjXbs0XbtFXbtWXb tnXbt4XbuJXbuaXburXbu8XbvNXbveVbsV2AvwXcwBXcwSXcwjXcw0XcxFXcxWXcxnXcx4XcyJXc yaXcyrXcy8XczNXczeXczvXczwXd0BXd0SXd0jXd00Xd1FXd1WXd1nXd14Xd2JXd2aXd2h1cBsDd 3NXd3eXd/9713d8F3uAV3uEl3uI13uNF3uRV3uVl3uZ13ueF3uiV3uml3uq13uvF3uzV3u3l3u71 3u8F3/AV3/El3/I13/NF3/RV3/Vl3/Z13/eF3/iV3/ml3/q1X/dtgPzV3/3l3/713/8F4AAW4AEm 4AI24ANG4ARW4AVm4AZ24AeG4AiW4Amm4Aq24AvuXwfQ4A3m4A724A8G4RAW4REm4RI24RNG4RRW 4RVm4RZ24ReG4RiW4Rmm4Rq24RvG4RzW4R3m4R724R8G4iAW4iEm4iI24iNG4iRW4iVm4iZ24ieG 4iiW4imm4iq24ivG4izW4i3m4i724i8G4zAW4zEm4zI24/8zJuIHUOM1ZuM2duM3huM4luM5puM6 tuM7xuM81uM95uM+9uM/BuRAFuRBJuRCNuRDRmQ3hoBFZuRGduRHhuRIluRJpuRKtuRLxuRM1uRN 5uRO9uRPBuVQFuVRJuVSNuVTRuVUVuVVZuVWduVXhuVYluVZpuVatuVbxuVc1uVd5uVe9uVfBuZg fuQIIOZiNuZjRuZkVuZlZuZmduZnhuZoluZppuZqtuZrxuZs1uZt5uZu9uZvBudwFmdkloByNudz Rud0Vud1Zud2dud3hud4lud5pud6tud7xud81ud95ud+9ud/BuiAFuiBJuiCNuiDRuiEVuiFZuiG duiHhmj/gp6Aiaboirboi8bojNbojebojvbojwbpkBbpkSbpkjbpk0bplFbplWbplnbpl4bpmJbp mabpmrbpm8bpnNbpnebpnvbpnwbqoBbqoSbqojbqo0bqpFbqpWbqpnbqp4bqqJbqqabqqrbqq8bq rNbqrebqrvbqrwbrsBbrsSbrsjZrsqaAtFbrtWbrtnbrt4bruJbruabrurbru8brvNbrvebrvvbr vwbswBbswSbswjbsw27rClDsxWbsxnbsx4bsyJbsyabsyrbsy8bszNbszebszvbszwbt0Bbt0Sbt 0jbt00Ztx7aA1Wbt1nbt14bt2Jbt2abt2rbt28bt3Nbt/93m7d727d8G7uAW7uEm7uI27uNG7uRW 7uVm7uZ27ueG7uiW7umm7uq2buW+gOzW7u3m7u727u8G7/AW7/Em7/I27/NG7/RW7/Vm7/Z27/eG 7/iW7/mm7/q27/vG7/zW7/3m7/727/8G8AAX8AEn8AI38ANH8ARX8AVn8AZ38AeH8AiX8Amn8Aq3 8AvH8AzX8A3n8A738A8H8RAX8REn8RI38RNH8RRX8RVn8RZ38ReH8RiX8RbHgBq38RvH8RzX8R3n 8R738R8H8iAX8iEn8iI38iNH8iRX8iVn8iZ38ieH8iiX8imn8iq38ivH8izX8i3n8i738i8H8zAX 8zEn8/8yN/MzR/M0V/M1Z/M2d/M3h/M4l/M5X/MMsPM7x/M81/M95/M+9/M/B/RAF/RBJ/RCN/RD R/REV/RFZ/RGd/RHh/RIl/RJp3Q914BLx/RM1/RN5/RO9/RPB/VQF/VRJ/VSN/VTR/VUV/VVZ/VW d/VXh/VYl/VZp/Va3/QNwPVc1/Vd5/Ve9/VfB/ZgF/ZhJ/ZiN/ZjR/ZkV/ZlZ/Zmd/Znh/Zol/Zp p/Zqt/Zrx/Zs1/Zt5/Zu9/ZvB/dwF/dxv3YOMPdzR/d0V/d1Z/d2d/d3h/d4l/d5p/d6t/d7x/d8 1/d95/d+9/d/B/iAF/iBJ/iCN/iDR/iEV/iFZ/iGd/hEh4f4iJf4iaf4irf4i8f4jNf4jef4jvf4 jwf5kBf5kSf5kjf5k0f5lFf5lWf5lnf5l4f5mJf5maf5mrf5m8f5nL/5gAAAOw== ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/master05_image003.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhBwE7AHcAMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAAALAEAAQAG AToAgwAAACodXFF801F70lB70lB70VB60U960U950U950Geax////wECAwECAwECAwECAwT/UMhJ q6Uq58u7/2AojmRpnmiqrlq7rXAsz3Rt35erK3jv/8CgsLLTDY/IpHJZNC6f0KiU1NxNr9isslrU er/gGLcZLpvPuTEZzW4DB/C4fD5Qc+n4vH7P7/v/gIGCg4SFhoZ2Y4dzAY2Ni5CQjpOUAZGXmJl+ iWqXlJqgfZWjo6Gmp4ALqqusnC2Rn6iyA6S1pbO4pgqsvAuur4uxuaGVe7bDyJAZva2/GsGTjI6E wn/Votd5tdLRhbbf03Ck1sV8GqqUq87A3t1x5YDZfPDY7vX2tPLk4Mdyt/P65LRAN0ndumftwr2j d89SvH8NBdFjGIjfNzoQ8VCk44KgI4MH/zMkfOQvozF8ADdqQ5nSnUo/FvtxYykuYBwdHhsx2+lL 0aBrMk8qbGiz5NB9Cl9G9LSRIoGnUHfkDMCzajMXULNq3UpJ67etXCeBHSu20livYs+S7frUrFq1 bN/KhToKbVq1RaayqmS1V4u5WeO2/Qr37tu7gs8mnuuWQGPAgQ1DLhz38dgmelfFLMhLw+TE/Cg3 Aox4cVhHkx0LtvxZcuq1XVlvrZJ56maqrVqjjhwarOnTAeyOPuyauGHZpIu/Bk5KLpfaC9LttJU7 +W66aWv5Vs57OHbug68zBv17vMXl4eu+HQNdulVS6qx7Tx+cvuvy3+sLn89cvnj76Kl2Xv+AzTn3 XHSc1TYQM6OoooB/+3VH3n/9bUehhKL9hpx5vRGIX1TsIfiRZgliRmKCEGK4X2kXdqdYebfht6Fc mwVoH3+zheieiDo5SJttDnKoH30WuiUjeDDGKOSQqX1ooy146Zggj7j19CNfvggZYZGxIRkjjkTa KCGTuoEp5o3lqdFeiQdi+SCNkiUJzotfgukkZDMaZ6aYZqmXY5tTSqcmlbi9qSeTH87J5Zdcnpnf nnC2+GRlsg26o6AHEupgAZx26mmnlHwa6qekfkMqp3WO6qmqp7bqaiWuxorqJLLWWiqrBYxyqpQj ZvYjkKrYmiutqxIrqy2n4horrMUaK+z/sso+G+2ztzoLKrOdGsBrj77uUhWWvhgg7rjkkktJueeW q664tayb7rruvmtAJfDWa2+qjZiLbwDw0tuvv+QC2iuVfRFapQL2ojuJwo4kzPDCD/PrcMQSzyvv xPfiq6/G6gL878UCc0swg7U0g7HFDW+c78kop6xyxScD7DHL8ab68pcdX/wxxONeGWidnSEcM8/s Eo3xxTofne7MNFN8280xUjw0yHmNbNs3zLTQ9NZcd+3112CHLTbNVV86ZcEujK322my37fbb60pl 9dw8FQH33XjnrffeOH3LZiJ7By744ITDe8DhiB/ekd+9cpL445BHLvnklFdu+eWYZ675/+acd+55 5wvy5F4inzeiuemfpy55AKpP7kjrsMf++bYHq5E66pezLvvuvB+OOu69B997yLVzoTrwlesufO7L Q/678s1HXzkC1FdvPfU+N87F9dx3z30j1oOPgPjVB/A99eSjb37464Of/vjqX79++PK3P//49ntf fv7q348/+vX7H/0EWD4Aso+ABnyfAtunv+uZaCfba6AE93dABMJPfvEbYAX59z3/+e+CFESg+N7X QRF+cIT3c58HM1hAEMZPgSw04AYRkIAa2vCGN6waBJuAwx768IeNuGEQEzBEGwagh0ckYhKNiMQk OnGJNaQEDqEYxSk+UYhX/GEUqbjFJu920Yhc3KIjrAjEMipxij4MoxZtGJIWrPGNXgTjF5mIxjMK MY5ZpGMRq1hHOdrxi3tMYxgDacc9EpKPQDzkGO/4R0RaUY1abKMC4EhJPwKSilzMoyMBOUc+BjKT ZGzkEA+JRUHiEYpB/GQnibjJVGJylZk8IinXGJJK2tKQmmRlHVUZylz68pWlFGUu4xjKYGJSlsDk 5TEbqUtelnKWtHSGLadJzWpa85rYzKY2t8lNbf6im+AMpzjHSc5ymjOSiTinOtfJzna6M5x2eKc8 50nPerZTDfbMpz73yc9p8rCfAA2oQPWpg4Ea9KAIXWMEAAA7 ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0007.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Matching

&#= 8226;Process of deciding which record or set of records in the target table(s) should be updated

&#= 8226;Alternatively, decide if record already exists and take appropriate action

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/master04_background.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODdhFgKQAXcAACH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACwAAAAAFgKQAYccPp8b Pp8aPp8aPZ8ZPZ4ZPJ4YPJ4XO54XO50XOp0WOp0VOp0VOZwTOJwSOJwSOJsSN5sQN5sPN5sPNpsP NpoMNpoLNpoLNZoLNJoINJoBNJoANJkAM5kdP6AcP6AfQqIfQaEeQaEeQKEeQKA6X7g6Xrc5Xrc5 XrY4XbY4XLU3W7U3W7Q2WrQ2WrM2WbM1WbI1WLI0WLIzV7EyVrAyVbAyVa8xVK8wVK4wU64vUq0v Ua0uUa0uUawtUKwtUKstT6ssTqorTqorTakqTKkqTKgpS6gpSqgoSqcoSacnSacnSaYnSKYmSKYl SKYlR6UkR6UkRqUjRqQjRaQiRaMiRKMhRKMgRKMgQ6IgQqI/Zr4/Zr0/Zb0+ZLw+Y7w+Y7s9Y7s9 Yrs8Yro8Ybo8Ybk7YLk6YLhBZ79AZr5RfNNRe9JQe9JQe9FQetFPetFPedFPedBOec9OeM9Od89N d85Nds1Mds1Mdc1MdcxLdcxLdMxLdMtKc8tKc8pJcspJcslJcclJcchIcchIcMhIcMdHcMdHb8ZG bsZGbsVGbcVFbcRFbMRFbMNEa8NEa8JEasJDasJDasFCacFCacBCaMBBaMABAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMI/wDRCBxIsKDBgwgTKlzIsKHDhxAjSpxIsaLFixgzatzI saPHjyBDihxJsqTJkyhTqlzJsqXLlzBjypxJs6bNmzhz6tzJs6fPn0CDCh1KtKjRo0iTKl3KtKnT p1CjSp1KtarVq1izat3KtavXr2DDih1LtqzZs2jTql3Ltq3bt3Djyp1Lt67du3jz6t3Lt6/fv4AD C+6YprDhw4gTK17MuLHjx5AjS55MubLly5gza97MubPnz6BDix5NurTp06hTq17NurXr17Bjy55N u7bt27hz697Nu7fv38CDCx9OvLjx48iTK1/OvLnz59CjS59Ovbr169iza9/Ovbv37+DDi/8fT768 +fPo02tXw769+/fw48ufT7++/fv48+vfz7+///8ABijggAQWaOCBCCao4IIMNujggxBGKOGEFFZo 4YUYZqjhhhx26OGHIIYo4ogklmjiiSimqOKKLLbo4oswxijjjDTWaOONOOao44489ujjj0AGKeSQ RBZp5JFIJqnkkkw26eSTUEYp5ZRUVmnllVhmqaWOa3Tp5ZdghinmmGSWaeaZaKap5ppstunmm3DG KeecdNZp55145qnnnnz26eefgAYq6KCEFmrooYjyycaijDbq6KOQRirppJRWaumlmGaq6aacdurp p6CGKuqopJZq6qmopqrqqqy26uqrsMb/KuustNZq66245qrrrrz26uuvwAYr7LDEFmvsscgmq+yy zDbr7LPQRivttNRWa+212Gar7bbcduvtt+CGK+645H7bxrnopqvuuuy26+678MYr77z01mvvvfjm q+++/Pbr778AByzwwAQXbPDBCCes8MIMN+zwwxBHLPHEFFds8cUYZ6zxxhx37PHHIIcs8sgkl9yx GyinrPLKLLfs8sswxyzzzDTXbPPNOOes88489+zzz0AHLfTQRBdt9NFIJ6300kw37fTTUEct9dRH v2H11VhnrfXWXHft9ddghy322GSXbfbZaKet9tpst+3223DHLffcdNdt991456333nz3/+3334AH LvjghBdu+OGIJ6744ow37vjjkEcu+eSUV2755ZhnrvnmnHfu+eeghy766KSXbvrpqKeu+uqst+76 67DHLvvstNdu++2456777rz37vvvtMMh/PDEF2/88cgnr/zyzDfv/PPQRy/99NRXb/312Gev/fbc d+/99+AbH8f45Jdv/vnop6/++uy37/778Mcv//z012///fjnr//+/Pfv//8ADKAAB0jAAhrwgAhM oAIXyMAGOvCBEIygBCdIwQpa8IIYzKAGN8jBDnrwgyAMoQhHSMISmvCEKEyhClfIwha68IUwjKEM Z0jDGtrwhjjMoQ53yMMe+vCHQAyiEP+HSMQiGvGIOJSDEpfIxCY68YlQjKIUp0jFKlrxiljMoha3 yMUuevGLYAyjGMdIxjKa8YxodOIc1sjGNrrxjXCMoxznSMc62vGOeMyjHvfIxz768Y+ADKQgB0nI QhrykIhMpCIXychGOvKRkIykJCdJyUpa8pKYzKQmN8nJTnryk6AMpShHScpSmvKUqEylKlfJyla6 8pWwjKUsZ0nLWtrylrjMpS53ycte+vKXwAymMIdJzGIa85jITKYyl8nMZjrzmcCkgzSnSc1qWvOa 2MymNrfJzW5685vgDKc4x0nOcprznOhMpzrXyc52uvOd8IynPOdJz3ra8574zKc+98n/z376858A DahAB0rQghr0oAi1Zh0WytCGOvShEI2oRCdK0Ypa9KIYzahGN8rRjnr0oyANqUhHStKSmvSkKE2p SlfK0pa69KUwjalMZ0rTmtr0pjjNqU53ytOe+vSnQA2qUIdK1KIa9ahITapSl8rUpjr1qVCN6kzt QNWqWvWqWM2qVrfK1a569atgDatYx0rWspr1rGhNq1rXyta2uvWtcI2rXLF6h7ra9a54zate98rX vvr1r4ANrGAHS9jCGvawiE2sYhfL2MY69rGQjaxkJ0vZylr2spjNrGY3y9nOevazoA2taEdL2tKa 9rSoTa1qV5tXPLj2tbCNrWxnS9va/9r2trjNrW53y9ve+va3wA2ucIdL3OIa97jITa5yl8vc5jr3 udCNrnSnS93qWve62M2udrfL3e5697vgDa94x0te2ebhvOhNr3rXy972uve98I2vfOdL3/ra9774 za9+98vf/vr3vwAOsIAHTOACG/jACE6wghfM4AY7+MEQjrCEDayHClv4whjOsIY3zOEOe/jDIA6x iEdM4hKb+MQoTrGKV8ziFrv4xTCOsYxnTOMa2/jGOM6xjnfM4x77+MdADrKQh0zkIhv5yEhOspKX zOQmO/nJUI6ylKdM5Spb+cpYzrKWt9zjPXj5y2AOs5jHTOYym/nMaE6zmtfM5ja7+f/NcI6znOdM 5zrb+c54zrOe98xnMfPhz4AOtKAHTehCG/rQiE60ohfN6EY7+tGQjrSkJ03pSlv60pjOtKY3zelO e/rToA61qEdN6lKb+tSoTrWqV83qVrv61bCOtaxnTeta2/rWuM61rnfN6177+tfADrawh03sYhv7 2MhOtrKXzexU9+HZ0I62tKdN7Wpb+9rYzra2t83tbnv72+AOt7jHTe5ym/vc6E63utfN7na7+93w jre8503vetv73vjOt77d7Yd++/vfAA+4wAdO8IIb/OAIT7jCF87whjv84RCPuMQnTvGKW/ziGM+4 xjfO8Y57/OMgD7nIR07ykpv85Cj/T7nKV87ylrv85TCPucxnTvOa2/zmOM+5znfO8577/OdAD7rQ h17yPxj96EhPutKXzvSmO/3pUI+61KdO9apb/epYz7rWt871rnv962APu9jHTnalA+LsaE+72tfO 9ra7/e1wj7vc5073utv97njPu973zve++/3vgA+84AdP+MIb/vCIT7ziF8/4xjv+8ZCPvOQNH4jK W/7ymM+85jfP+c57/vOgD73oR0/60pv+9KhPvepXz/rWu/71sI+97GefeUHY/va4z73ud8/73vv+ 98APvvCHT/ziG//4yE++8pfP/OY7//nQj770p0/96lv/+tjPvva3z/3ue//74A9///UHQf7ym//8 6E+/+tfP/va7//3wj7/850//+tv//vjPv/73z//++///ABiAAjiABFiABniACJiACriADNiADviA EBiBEjiBFFiBFniBGJiBGoh+hNCBHviBIBiCIjiCJFiCJniCKJiCKriCLNiCLviCMBiDMjiDNFiD NniDOJiDOriDPNiDPviDQBiEQjiERFiERniESJiESriETNiETviEUBiFUjiFIVgIVniFWJiFWriF XNiFXviFYBiGYjiGZFiGZniGaJiGariGbNiGbviGcBiHcjiHdFiHdniHeJiHeriHfNiHfviHgBiI gjiIhFiIhniIiJiIiriIjNiIjv/4iJAYiZI4iZRYiZZ4iZiYiZq4iZzoh4bwiaAYiqI4iqRYiqZ4 iqiYiqq4iqzYiq74irAYi7I4i7RYi7Z4i7iYi7q4i7zYi6N4CMAYjMI4jMRYjMZ4jMiYjMq4jMzY jM74jNAYjdI4jdRYjdZ4jdiYjdq4jdzYjd74jeAYjuI4juRYjuZ4juiYjuq4juzYju74jvAYj/I4 j/RYj/Z4j/iYj/q4j/zYj/5oj4gQkAI5kARZkAZ5kAiZkAq5kAzZkA75kBAZkRI5kRRZkRZ5kRiZ kRq5kRzZkR75kQWZCCI5kiRZkiZ5kiiZkiq5kizZki75kjAZkzI5kzRZkzZ5kzj/mZM6uZM82ZM+ +ZNAGZRCOZREWZRGeZRImZRKuZRM2ZRO+ZRQGZVSOZVUWZVWeZVYaZKKsJVc2ZVe+ZVgGZZiOZZk WZZmeZZomZZquZZs2ZZu+ZZwGZdyOZd0WZd2eZd4mZd6uZd82Zd++ZeAGZiCOZiEWZiGqZeLkJiK uZiM2ZiO+ZiQGZmSOZmUWZmWeZmYmZmauZmc2Zme+ZmgGZqiOZqkWZqmeZqomZqquZqs2Zqu+Zqw GZuyOZu0WZu2eZu4mZu6uZu82Zu++ZuNyQjCOZzEWZzGeZzImZzKuZzM2ZzO+ZzQGZ3SOZ3UWZ3W eZ3YmZ3auZ3c2Z3e+Z3gGZ7i/zme5Fme5nme6Jme6rme7Nme7vme8Bmf8jmf9Fmf9nmf+GmcjbCf /Nmf/vmfABqgAjqgBFqgBnqgCJqgCrqgDNqgDvqgEBqhEjqhFFqhFnqhGJqhGrqhHNqhHvqhIBqi IjqiJFqiJqqhjpCiKrqiLNqiLvqiMBqjMjqjNFqjNnqjOJqjOrqjPNqjPvqjQBqkQjqkRFqkRnqk LfoISrqkTNqkTvqkUBqlUjqlVFqlVnqlWJqlWrqlXNqlXvqlYBqmYjqmZFqmZnqmaJqmarqmbNqm bvqmcBqncjqndFqnaQoJeJqnerqnfNqnfvqngBqogjqohFqohnqoiJqoirqojP/aqI76qJAaqZI6 qZRaqZbKp5GQqZq6qZzaqZ76qaAaqqI6qqRaqqZ6qqiaqqq6qqzaqq76qrAaq7I6q7Raq7Z6q7ia q7q6q7zaq776q8AarMI6rMRarMZ6rMiarMq6rMzarM76rJ0qCdI6rdRardZ6rdiardq6rdzard76 reAaruI6ruRaruZ6ruiaruq6ruzaru76rvAar/I6r/Rar/Z6r/iar/q6r/zar/E6CQAbsAI7sARb sAZ7sAibsAq7sAzbsA77sBAbsRI7sRRbsRZ7sRibsRq7sRzbsR77sSAbsiI7siRbsiZ7siibsiq7 sh9LCS77sjAbszI7szRbszb/e7M4m7M6u7M827M++7NAG7RCO7REW7RGe7RIm7RKu7RMK7Nm8LRQ G7VSO7VUW7VWe7VYm7Vau7Vc27Ve+7VgG7ZiO7ZkW7Zme7Zom7Zqu7Zs27Zu+7ZwG7dyO7d0W7d2 e7d4m7d6u7d827d++7eAG7iCO7iEW7iGe7iIm7iKu7iM27iO+7iQG7mSO7mUW7l3ewaYm7mau7mc 27me+7mgG7qiO7qkW7qme7qom7qqu7qs27qu+7qwG7uyO7u0W7u2y7lZkLu6u7u827u++7vAG7zC O7zEW7zGe7zIm7zKu7zM27zO+7zQG73SO73UW73We73Ym73au73c273e+73g/xu+4ju+5Iu9WnC+ 6Ju+6ru+7Nu+7vu+8Bu/8ju/9Fu/9nu/+Ju/+ru//Nu//vu/ABzAAjzABFzA67sFCJzACrzADNzA DvzAEBzBEjzBFFzBFnzBGJzBGrzBHNzBHvzBIBzCIjzCJFzCJnzCKJzCKrzCLNzCLvzCMBzDMjzD NFzDNnzDOJzDOrzDPNzDPvzDQBzEQjzERFzERuzDXJDESrzETNzETvzEUBzFUjzFVFzFVnzFWJzF WrzFXNzFXvzFYBzGYjzGZFzGZnzGaJzGarzGbNzGbvzGcBzHcjzHdFzHdnzHeJzHerzHfNzHfvzH TdwFgjzIhFzIhnzIiJzIiv+8yIzcyI78yJAcyZI8yZRcyZZ8yZicyZq8yZzcyZ78yaBsyF4wyqRc yqZ8yqicyqq8yqzcyq78yrAcy7I8y7Rcy7Z8y7icy7q8y7zcy778y8AczMI8zMRczMZ8zMiczMq8 zMzczM4szF8QzdI8zdRczdZ8zdiczdq8zdzczd78zeAczuI8zuRczuZ8zuiczuq8zuzczu78ztUM BvI8z/Rcz/Z8z/icz/q8z/zcz/78zwAd0AI90ARd0AZ90Aid0Aq90Azd0A790BAd0RI90RRd0RZ9 0Rid0Rq90Rzd0REdBiAd0iI90iRd0iZ90iid0iq90izd0i790jAd0zI90zT/XdM2fdM4ndM6vdM8 3dM+/dNAHdRCPdREXdRGfdRIndRKvdQ/LQZO/dRQHdVSPdVUXdVWfdVYndVavdVc3dVe/dVgHdZi PdZkXdZmfdZondZqvdZs3dZu/dZwHddyPdd0Xdd2fdd4ndd6vdd83dd+/deAHdiCPdiELdVjcNiI ndiKvdiM3diO/diQHdmSPdmUXdmWfdmYndmavdmc3dme/dmgHdqiPdqkXdqLTQaondqqvdqs3dqu /dqwHduyPdu0Xdu2fdu4ndu6vdu83du+/dvAHdzCPdzEXdzGfdzIndzKvdzM3dzO/dzQHd3SPd3H XQbWfd3Ynd3avd3c3d3e//3d4B3e4j3e5F3e5n3e6J3e6r3e7N3e7v3e8B3f8j3f9K3dJHDf+J3f +r3f/N3f/v3fAB7gAj7gBF7gBn7gCJ7gCr7gDN7gDv7gEB7hEj7hFF7hFn7hGJ7hGr7hHN7hHv7h IB7iIj7iJF7iJn7iKJ7iKr7iLN7i+10CMB7jMj7jNF7jNn7jOJ7jOr7jPN7jPv7jQB7kQj7kRF7k Rn7kSJ7kSr7kTN7kTv7kUB7lUj7lVF7lVn7lWJ7lWr7lT24CXv7lYB7mYj7mZF7mZn7maJ7mar7m bN7mbv7mcB7ncj7ndF7ndn7neJ7ner7nfN7nfv7ngB7ogj7ohF7ohn7oiP+e6H1+Aoze6I7+6JAe 6ZI+6ZRe6ZZ+6Zie6Zq+6Zze6Z7+6aAe6qI+6qRe6qZ+6qie6qoO6SjQ6q7+6rAe67I+67Re67Z+ 67ie67q+67ze677+68Ae7MI+7MRe7MZ+7Mie7Mq+7Mze7M7+7NAe7dI+7dRe7dZ+7die7dq+7dze 7d7+7eAe7uI+7rGeAuZ+7uie7uq+7uze7u7+7vAe7/I+7/Re7/Z+7/ie7/q+7/ze7/7+7wAf8AI/ 8ARf8AZ/8Aif8Aq/8Azf8A7/8BAf8RI/8RRf8RZ/8Rif8Rq/8Ryv7irw8SAf8iI/8iRf8iZ/8iif 8iq/8izf8i7/8jAf8zL/P/M0X/M2f/M4n/M6v/M83/M+//NAH/RCP/REX/RGf/RIn/RK7/Mr0PRO //RQH/VSP/VUX/VWf/VYn/Vav/Vc3/Ve//VgH/ZiP/ZkX/Zmf/Zon/Zqv/Zs3/Zu//ZwH/dyP/d0 X/d2f/d4z/YssPd83/d+//eAH/iCP/iEX/iGf/iIn/iKv/iM3/iO//iQH/mSP/mUX/mWf/mYn/l/ 3wKc3/me//mgH/qiP/qkX/qmf/qon/qqv/qs3/qu//qwH/uyP/u0X/u2f/u4n/u6v/u83/u+//vA H/zCP/zEX/zGf/y77wLKv/zM3/zO//zQH/3SP/3UX/3Wf/3Yn/3av/3c/9/93v/94B/+4j/+5F/+ 5n/+6J/+6r/+7N/+7v/+8B//8j//9F//9n//+J//+r///N///v//AOFC4ECCBQ0eRJhQ4cEXDR0+ hBhR4kSKFS1exJhR40aOHT1+BBlS5EiSJU2eRJlS5cqIMFy+hBlT5kyaNW3exJlT506ePX3+BBpU 6FCiRY0eRZpU6VKmTZ0+hRpV6lSqVa1exZq1aQyuXb1+BRtW7FiyZc2eRZtW7Vq2bd2+hRtX7ly6 de3exZtXL1gZff3+BRxY8GDChQ0fRpxY8WLGjR0/hhxZ8mTKlS1fxpxZ82bOnT1/Bh1a9GjSpU2f Rp1a9WrWrV2/hh1b9v9s2rVt38adW/fu2TN8/wYeXPhw4sWNH0eeXPly5s2dP4ceXfp06tWtX8ee Xft27t29fwcfXvx48uXNn0efXv169u3dv4cfX/58+sJp3MefX/9+/v39/wcwQAEHJLBAAw9EMEEF F2SwQQcfhDBCCSeksML9asAwQw035LBDDz8EMUQRRySxRBNPRDFFFVdksUUXX4QxRhlnpLFGG2/E MUcdd+SxRx9/BDJIIYe80QYjj0QySSWXZLJJJ5+EMkopp6SySiuvxDJLLbfksksvvwQzTDHHJLNM M89EM00112SzTTffhDNOOeeks04778QzTz335FPJG/4ENFBBByW0UEP/D0U0UUUXZbRRRx+FNFJJ J6W0UksvxTRTTTfltFNPPwU1VFFHJbVUU09FNVVVPcWhVVdfhTVWWWeltVZbb8U1V1135bVXX38F NlhhhyW2WGOPRTZZZZdltllnn4U2WmmnpbZaa6/FNlttt+W2W2+/BTdccceNNQdzz0U3XXXXZbdd d9+FN15556W3XnvvxTdfffflt19//wU4YIEHJlhdHQ5GOGGFF2a4YYcfhjhiiSemuGKLL8Y4Y403 5rhjjz8GOWSRRya5ZJNPRjlllVdmuWWXX4Y5ZplN3qFmm2/GOWedd+a5Z59/BjpooYcmumijj0Y6 aaWXZrppp5+GOmqp/6fOmQerr8Y6a6235rprr78GO2yxxya7bLPPRjtttddmu22334Y7brnnprtu u+/GO2+99+a7b7//BjzwunsgvHDDD0c8ccUXZ7xxxx+HPHLJJ6e8cssvxzxzzTfnvHPPPwc9dNER 96F0009HPXXVV2e9dddfhz122WenvXbbb8c9d9135713338HPnjhhye+eOOPRz555Zdnvnnnn4ee +B+mp75666/HPnvtt+e+e++/Bz988ccnv3zzz0c/ffXXZ79999+HP37556e/fvvvxz9//ffnv3// /wdgAAU4QAIW0IAHRGACrwcEBjbQgQ+EYAQlOEEKVtCCF8RgBjW4Qf8OdtCDHwRhCEU4QhKW0IQn RGEKVbhCFrbQhS+EYQxlOEMa1tCGN8RhDnW4Qx720Ic/BGIQhQjBIBTRiEdEYhKVuEQmNtGJT4Ri FKU4RSpW0YpXxGIWtbhFLnbRi18EYxjFOEYyltGMZ0RjGtW4Rja20Y1vhCMZhTBHOtbRjnfEYx71 uEc+9tGPfwRkIAU5SEIW0pCHRGQiFblIRjbSkY+EZCQlOUlKVtKSl8RkJjW5SU520pOfBGUoRTlK UpbSlKdEZSrvOARWttKVr4RlLGU5S1rW0pa3xGUudblLXvbSl78EZjCFOUxiFtOYx0RmMpW5TGY2 05nPhGY0pTlNalb/05rXXCYRtLlNbnbTm98EZzjFOU5yltOc50RnOtW5Tna2053vhGc85TlPetbT nvfEpzeLsE9+9tOf/wRoQAU6UIIW1KAHRWhCFbpQhjbUoQ+FaEQlOlGKVtSiF8VoRjW6UY521KMf BWlIRTpSkpbUpCdFaUpVulKWttSlL4VpTP9pBJrW1KY3xWlOdbpTnvbUpz8FalCFOlSiFtWoR0Vq UpW6VKY21alPhWpUpTpVqlbVqlfFala1ulWudtWrX53qEcQ6VrKW1axnRWta1bpWtrbVrW+Fa1zl Ole61tWud8VrXvW6V7721a9/BaxZkTBYwhbWsIdFbGIVu1jGNtax/4+FbGQlO1nKVtayl8VsZjW7 Wc521rOfBW1oRTta0pbWtKdFbWpVu1rWtta1ok1CbGU7W9rW1ra3xW1udbtb3vbWt78FbnCFO1zi Fte4x0VucpW7XOY217nPra0SpDtd6lbXutfFbna1u13udte73wVveMU7XvKW17znRW961bte9rbX ve+Fb3zlO1/61te+98VvfvW7X/72N75LAHCABTxgAhfYwAdGcIIVvGAGN9jBD4ZwhCU8YQpX2MIX xnCGNbxhDnfYwwRmQohFPGISl9jEJ0ZxilW8Yha32MUvhnGMZTxjGtfYxjfGcY51vGMe99jHPy5x E4Q8ZCIX2chHRv9ykpW8ZCY32clPhnKUpTxlKlfZylfGcpa1vGUud9nLXwazkZ0wZjKX2cxnRnOa 1bxmNrfZzW+Gc5zlPGc619nOd8ZznvW8Zz732c9/BnSgBT1oQhfa0IdGdKIVvWhGN9rRgn5CpCU9 aUpX2tKXxnSmNb1pTnfa058GdahFPWpSl9rUp0Z1qlW9ala32tWvhnWsZT1rWtfa1rfGda51vWte 99rXvwZ2sIU9bGIX29jHrjQUlL1sZjfb2c+GdrSlPW1qV9va18Z2trW9bW5329vfBne4xT1ucpfb 3OdGt7OjsG52t9vd74Z3vOU9b3rX2973xne+9b1vfvfb3/8GeMD/BT5wghfc4AdHeMIVvnCGN9zh D4d4xCU+cYpX3OIKl0LGNb5xjnfc4x8HechFPnKSl9zkJ0d5ylW+cpa33OUvh3nMZT5zmtfc5jfH ec51vnOe99znPwd60IU+dKIX3ehHR3rSlb50pjfd6U/v+BSkPnWqV93qV8d61rW+da533etfB3vY xT52spfd7GdHe9rVvna2t93tb4d73OU+d7rX3e53x3ve9b53vvc97lQAfOAFP3jCF97wh0d84hW/ eMY33vGPh3zkJT95ylfe8pfHfOY1v3nOd97znwd96EU/etKX3vSnR33qVb/6z1fB9a+HfexlP3va 1972t8d97nW//3ve9973vwd+8IU/fOIX3/jHR37ylb985sveCs+HfvSlP33qV9/618d+9rW/fe53 3/vfB3/4xT9+8pff/OdHf/rVv372t3/6V4B//OU/f/rX3/73x3/+9b9//vff//8HwAAUwAEkwAI0 wANEwARUwAVkwAZ0wAeEwAiUwAmkwAq0wAvEwAzUwA18QCzwwA8EwRAUwREkwRI0wRNEwRRUwRVk wRZ0wReEwRiUwRmkwRq0wRvEwRzUwR3kQRH8gB8EwiAUwiEkwiI0wiNEwiRUwiVkwiZ0wieEwiiU wimkwiq0wivEwizUwi3kwi70wi8EwzAUwzEkwzI0wzNEwzRUw/81ZMM2dMM3hMM4lMM5pMM6tMM7 xMM81MM95MM+rEMQAMRAFMRBJMRCNMRDRMREVMRFZMRGdMRHhMRIlMRJpMRKtMRLxMRM1MRN5MRO 9MRPBMVQFMVRJMVSNMVTRMVUVMVVZMVWdMVXhMVYlMVZpMVatEVCDIFc1MVd5MVe9MVfBMZgFMZh JMZiNMZjRMZkVMZlZMZmdMZnhMZolMZppMZqtMZr7EUR0MZt5MZu9MZvBMdwFMdxJMdyNMdzRMd0 VMd1ZMd2dMd3hMd4lMd5pMd6tMd7xMd81Md95Md+9Md/BMiAFMiBJMiCzMcRQMiEVMiFZMiGdMiH hMiIlMiJpMj/irTIi8TIjNTIjeTIjvTIjwTJkBTJkSTJkjRJhuyAlFTJlWTJlnTJl4TJmJTJmaTJ mrTJm8TJnNTJneTJnvTJnwTKoBTKoSTKojTKo2xJD1DKpWTKpnTKp4TKqJTKqaTKqrTKq8TKrNTK reTKrvTKrwTLsBTLsSTLsjTLs0TLtFTLtWTLtnTLt4TLuJTLuaTLurTLu8TLvNTLveTLvvTLvwTM wBTMwSTMwjTMw0RMwASAxWTMxnTMx4TMyJTMyaTMyrTMy8TMzNTMzeTMzvTMzwTN0BTN0STN0jTN 00TN1HzMAGDN1nTN14TN2JTN2aTN2rTN28TN3NTN3eTN3vTN/98EzuAUzuEkzuI0zuNEzuRUTtgU gOZ0zueEzuiUzumkzuq0zuvEzuzUzu3kzu70zu8Ez/AUz/Ekz/I0z/NEz/RUz/Vkz/Z0z/eEz/iU z/mkz/q0z/vEz/zUz/3kz/70z/8E0AAV0AEl0AI10ANF0ARV0AUd0AFw0AeF0AiV0Aml0Aq10AvF 0AzV0A3l0A710A8F0RAV0REl0RI10RNF0RRV0RVl0RZ10ReF0RiV0Rml0Rq10RvF0RxtUQLg0R71 0R8F0iAV0iEl0iI10iNF0iRV0iVl0iZ10ieF0iiV0iml0iq10ivF0izVUiAtgC710i8F0zAV0zEl 0zI10zNF0/80VdM1ZdM2ddM3hdM4ldM5pdM6tdM7xdM81dM95dM+9dM/BdRAFdRBJdRCNdRDRdRE VdRFZdRGddRHhdRIldRJpdRKtdRLxdRM1dRN5dRO9dRPBdVQFdVRJdVSNdVTRdVUVdVDNYBWddVX hdVYldVZpdVatdVbxdVc1dVd5dVe9dVfBdZgFdZhJdZiNdZjRdZkVdZljdUDcNZnhdZoldZppdZq tdZrxdZs1dZt5dZu9dZvBddwFddxJddyNddzRdd0Vdd1ZVdpRYB3hdd4ldd5pdd6tdd7xdd81dd9 5dd+9dd/BdiAFdiBJdiCNdiDRdiEVdiFZdiGddiHhdiIldj/iaXYirXYi8XYjNVYh02AjvXYjwXZ kBXZkSXZkjXZk0XZlFXZlWXZlnXZl4XZmJXZmaXZmrXZm8XZnNXZneXZnvXZnwXaoBXaoSXaojXa o0XapFXapWXapnXap4XaqJXaqaXaqrXaq8XarNXarZ1aBfDarwXbsBXbsSXbsjXbs0XbtFXbtWXb tnXbt4XbuJXbuaXburXbu8XbvNXbveVbsV2AvwXcwBXcwSXcwjXcw0XcxFXcxWXcxnXcx4XcyJXc yaXcyrXcy8XczNXczeXczvXczwXd0BXd0SXd0jXd00Xd1FXd1WXd1nXd14Xd2JXd2aXd2h1cBsDd 3NXd3eXd/9713d8F3uAV3uEl3uI13uNF3uRV3uVl3uZ13ueF3uiV3uml3uq13uvF3uzV3u3l3u71 3u8F3/AV3/El3/I13/NF3/RV3/Vl3/Z13/eF3/iV3/ml3/q1X/dtgPzV3/3l3/713/8F4AAW4AEm 4AI24ANG4ARW4AVm4AZ24AeG4AiW4Amm4Aq24AvuXwfQ4A3m4A724A8G4RAW4REm4RI24RNG4RRW 4RVm4RZ24ReG4RiW4Rmm4Rq24RvG4RzW4R3m4R724R8G4iAW4iEm4iI24iNG4iRW4iVm4iZ24ieG 4iiW4imm4iq24ivG4izW4i3m4i724i8G4zAW4zEm4zI24/8zJuIHUOM1ZuM2duM3huM4luM5puM6 tuM7xuM81uM95uM+9uM/BuRAFuRBJuRCNuRDRmQ3hoBFZuRGduRHhuRIluRJpuRKtuRLxuRM1uRN 5uRO9uRPBuVQFuVRJuVSNuVTRuVUVuVVZuVWduVXhuVYluVZpuVatuVbxuVc1uVd5uVe9uVfBuZg fuQIIOZiNuZjRuZkVuZlZuZmduZnhuZoluZppuZqtuZrxuZs1uZt5uZu9uZvBudwFmdkloByNudz Rud0Vud1Zud2dud3hud4lud5pud6tud7xud81ud95ud+9ud/BuiAFuiBJuiCNuiDRuiEVuiFZuiG duiHhmj/gp6Aiaboirboi8bojNbojebojvbojwbpkBbpkSbpkjbpk0bplFbplWbplnbpl4bpmJbp mabpmrbpm8bpnNbpnebpnvbpnwbqoBbqoSbqojbqo0bqpFbqpWbqpnbqp4bqqJbqqabqqrbqq8bq rNbqrebqrvbqrwbrsBbrsSbrsjZrsqaAtFbrtWbrtnbrt4bruJbruabrurbru8brvNbrvebrvvbr vwbswBbswSbswjbsw27rClDsxWbsxnbsx4bsyJbsyabsyrbsy8bszNbszebszvbszwbt0Bbt0Sbt 0jbt00Ztx7aA1Wbt1nbt14bt2Jbt2abt2rbt28bt3Nbt/93m7d727d8G7uAW7uEm7uI27uNG7uRW 7uVm7uZ27ueG7uiW7umm7uq2buW+gOzW7u3m7u727u8G7/AW7/Em7/I27/NG7/RW7/Vm7/Z27/eG 7/iW7/mm7/q27/vG7/zW7/3m7/727/8G8AAX8AEn8AI38ANH8ARX8AVn8AZ38AeH8AiX8Amn8Aq3 8AvH8AzX8A3n8A738A8H8RAX8REn8RI38RNH8RRX8RVn8RZ38ReH8RiX8RbHgBq38RvH8RzX8R3n 8R738R8H8iAX8iEn8iI38iNH8iRX8iVn8iZ38ieH8iiX8imn8iq38ivH8izX8i3n8i738i8H8zAX 8zEn8/8yN/MzR/M0V/M1Z/M2d/M3h/M4l/M5X/MMsPM7x/M81/M95/M+9/M/B/RAF/RBJ/RCN/RD R/REV/RFZ/RGd/RHh/RIl/RJp3Q914BLx/RM1/RN5/RO9/RPB/VQF/VRJ/VSN/VTR/VUV/VVZ/VW d/VXh/VYl/VZp/Va3/QNwPVc1/Vd5/Ve9/VfB/ZgF/ZhJ/ZiN/ZjR/ZkV/ZlZ/Zmd/Znh/Zol/Zp p/Zqt/Zrx/Zs1/Zt5/Zu9/ZvB/dwF/dxv3YOMPdzR/d0V/d1Z/d2d/d3h/d4l/d5p/d6t/d7x/d8 1/d95/d+9/d/B/iAF/iBJ/iCN/iDR/iEV/iFZ/iGd/hEh4f4iJf4iaf4irf4i8f4jNf4jef4jvf4 jwf5kBf5kSf5kjf5k0f5lFf5lWf5lnf5l4f5mJf5maf5mrf5m8f5nL/5gAAAOw== ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/master04_image004.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhQgBGAHcAMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAAALAEAAQBB AEUAgQAAACodXGeax////wL/hI+pa+LPopx0veuq3hT7zIXhR4pmRZbnqqQpCwOuG5/zXI83nqP7 3Zv8fkHGcFhMHI/JxpJZfD6DgoH1irVKMdSsd7Dl1hzXgPl8DYtZj/LZnFZf2G3rG66Vz00Y9zuu B6Fz4YeWFyio8VGI9+X4RePjwRjwaGnp0UFCiXXn2XgJlmiRwkn5iVoJCdLiYmqXGuvpxeo08zog q3uXVbuD+xmam4olcPADPCs8HJxmewv7d3pI+IXqPJTMK1ra2cz9G20obohM3nikLZ19rpp+7r3N zrw+r9xODU1fbr+ND66v2bt9qv6ZI1jQ2MF7CPMtiidtwDNX8KYBJGPtm7GJlZsq/lt2Lc+xG+rG WSIWR0lAfw1PoUzZqhtBiLtCFquFgOJMl7sc7THScefHZYBwkprksSXRD4qQClXqk0fTapcEShHR J5TVJTbqVFU2ZYW5rURghCMLZAw0tJHUUmSrooe+qGmpyKTbNkrQR1KbIPrZhKOawDHlED4a5jDQ LYojMG7smCtkCVAmR95hWVLczJpH1SgAADs= ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0018.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Matching Techniqu= es

Inaport supports different ways to match

•Standard

•build expressions on source and target

•Fuzzy

•Refine Standard to allow for poor data

•SQL

•Use SQL SELECT instead of expressions

•External

•Use an external match file generated by another application such as Paribus

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0051.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Matching

Both Standard and Fuzzy matching

•Are flexible, powerful, easy to use

•Bui= ld an in memory index

•

The in memory index has benefits and drawbacks

•Fas= t once it is built, BUT

•Up = front cost of building (read data, build index) - and

•On-= going memory cost

For large (>2-400,000 records) these up front c= osts = may be significant

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0012.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

SQL Matching

SQL matching is an alternative scheme = ;

&#= 8226;Executes SQL SELECT against the target table for each incoming record

&= #8226;Benefits

&= #8226;No up front cost

&= #8226;No memory cost

&= #8226;Drawbacks

&= #8226;Not as flexible – restricted to SQL <= /div>

&= #8226;SQL cost per incoming record

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0052.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

How it Works

You specify a SQL SELECT statement that will

&= #8226;read the primary key of the target table, =

•with a WHERE clause that implements your match criteria

SELECT accountid = FROM account
WHERE account =3D ‘#CompanyName’

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0053.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

How it Works

SELECT accountid = FROM account
WHERE account =3D ‘#CompanyName’

At run time, Inaport will:

&#= 8226;Parse the SQL and replace any field names with the field value

&= #8226;‘#CompanyName’ becomes ‘InaPlex’ =

&= #8226;Run SQL against target

&= #8226;Use primary keys found as matches

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0054.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

How it Works

When working with a child table, WHERE clause must include match on foreign = key

SELECT contactid FROM contact
WHERE= accountid =3D ‘#PARENTKEY&#= 8217;
AND lastname =3D ‘#LastNameR= 17;

Inaport will replace ‘#PARENTKEY’ with= the primary key o= f the matched parent record (e.g. accountid)

SELECT contactid FROM contact
WHERE= accountid =3D ‘A12345678= 217;
AND lastname =3D ‘Smith’<= /span>

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0055.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Example – Operations Tab

Select SQL Match = from the Match type

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0055_image005.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhAwJzAHcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G RklDRTkuMBMAAAAHdElNRQfYAxgJHygXiqypACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAHgfNAGQAsAAAAAAMCcwCDAAAAMWrFcW9krKiZ7OnY8e/i ////AQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDA/9IZNz+MMpJq70466q6/2AojmRpnmiqrmzr vnAsz/RqFHiu73zv/8CgcEgsGoOCmnLJbDqf0Kh0erpRr1jmQLDper8TD3hM5nTK6LR6zcjGrO64 fLU92u/4X3KR7/uRCjd/g4SFhgV7cypwio2OHluPUFuMkjKUBZaaS5GbIpWeoZOJopdcmaUtmKms KZ2toK2yL6+zLKu2J7i5vAS1qbEdAMNOAC7GKMgKw8rLxMIfxszT0NHP08wEzR2/vSa73iHg4a3d osHa1TTbK+wkyvDq8M30INvx6ukg5uTip/3+0AHcxM9TsHs13KVQKAIZQoTp8C2Lpq/ixIsYIZHS hu3/nQmGJ9iBFDHO3cgQIx1m87Ayo0Vu/1iiPNbuGRNpFD/CKLjpYE5qwmzi5KhyKFFoNp0VRTrT 3s+K9WRKdFriF8SmWGGc1BUzn1eZWalGhfqVXcmwydp9TTvCqMuGbb9tLOUTLL67Ii86rHbtqV6F Jv3uzXc3btWNV6mibbFVLqikHA0rbhoVYt4PJe81zsl2rU64L7cyPMlTU12+fIHSWzm4sMvB+kaH he12LOzJJBFzbjlvaW+kq4GnTgrZV9eJ8X4fXS7t8svXb1+eTR60t+alyMFSxK60+/LYP1sSVc66 eGlLp/Wi3r2eNkbL62eHfm9xNWv2h60BJfu8Nf3I/+DF5h9/txn3GFmXudeXduN5VaBL0zHl13wE JhbUf3b9V6B7/GXYoQLnSYKORK4FSKB6KFJYIlYkEmbbhGONYJV2HUF1n4kc1teePAGhghptN15l YXwpMmigj+oBuaCKREZnnXV/BQkjhqopBVmIjwgk3n7f2Ueddx/aOBVKkG3JWZjKeabRmSbGN2CJ L6I4lVnHgTdggELil+JQgWl0YER7Yhhof9uVteOEg8JZJGZznYPkZwOJMqOHeB6qaKVyHgrTnydm mh10GbXoJKOcXjomh33i6GagcXaq6qswzSLQYpFKMqk8QlX3ZZe48iggcXRySiNv3o0p5nW/ZhPs o/+pqibee7mSOSew0d5YHUtb8kbsd7HKMmuttmC5yWbjULFZCcvGcG4q66ogbiPfgivLu5aQW+cV 7eIG4r1qRZovCvTOEa+8rATMS7kAIUywIwbHMfDCkjYqr8LkUAyxHA278fDFBHHBxscghyzyyCSX bPLJbDzKsS2HtOzyyzDHLPPMNNd8yMYr56zzzjwvjHPPQAct9NCmqUz00UgnrfQUPy/t9NNQR82H 1FRXbfXT8dqs9dZcd+3112CHLfYfGhv9wdhop6322my37bbNZZvw9tx012333XjDnUXWefft99+A B0533CX4EMDhAQCRuB+Lj934IY+7HDnkg0w+eRH/lrd8ueBhL+65y4ST0MPjmxdQOg+Rf955H6fj 0DrjMr+uuOt2lJ455UfIHjvXsqv+cugjjK6D7Zjv4PvXuhsuRPJ3MN8867Tn/sPthjhvutjW/9F7 9L/vbbYHwo9+eA6NIz78+Oa7jr7ppI+Puvvswx8/+dfPP3/58Ccuv/3pny9//+QDYP/0l74BXo+A 6vOf/yyXP/YZb30NTKAC7Re/8gXwcgb8HwAlqD7PafCD9POgBd0HQv410IPiw98IRXjADtKvfp/7 oPOAJwLDGTB6vsth/V5IQu6ljodAxOHtVGdBB+4Qhy9Mog6HF0QYEpGHKDTiEouoRAn+UIpIPKIW /2EYRCqizoo+NF4WuchE7kHxi1J8YhaL2EMtjvCMZGxjHIU4xhl6T25BEGEbESdHM5LRiRtkIxQL uMA1NvGKXtyhHq8ISDlOsYpCJKQfBTnJMCoyfBW05CLf50hLlrGDfbwkKM3IR09uspHHw6AY68hK Q/5xiUWgYQgw+ccmJrGSoiReK6lHyUfiMpGUxOTxNHlISPJyla9cZTC36Ms5Km+Xt4TkJ4nZymSO 0Za4nGYuu2hMV1ozlncsHBqhuU3aIbKYn2wmLNUYzHNmE5bUtGY7u1nNeLrTmff0JTDRuU95IlOd 6PRnOWt5yXl+k532PIIsQWDDEirSoT+k4gZdOP/KC96ylOa0qCcHycn2MRCiSoygKB/q0Y9KM4SH VGUmV0rSFK5zog49IkYrWlJTajSSF8Vg/kT6xpsi1IcTDcJCzya47M3NqJxL6jOV6jU7YoFvgUOq 26TK1KpStaq5C6pQwyk6rHr1q2ANK+CGCj6xmvWsaE1r18jaAbW69a1wjesd2KoAudr1rniFK10J kNe++vWvSt0rYAdL2MK+TbCGTaxiF6s1xDL2sZCNrB/2erXKWvayAGkaZjfL2c5m6XueDa1oR0tZ 0pr2tKiFgWZTy9rWuna1ro2tbEML29kSZAC4za1ud8vb3vr2t8ANrnCHS9ziGve4yE2ucpfL3Ob/ Ore3BggEaG0bLgFY97rYza52t8vd7nr3u+ANr3jHS97ymve86E2vetfLXu0WILpTo27CPIay+tr3 vvjNr8mMIID3Sle+89WvgAdM4AIbuAHvvUAd4FtbADOMvgeOsIQnTOEv+FcuF26wgxVBiQp7+MMg 9vCFD5Ph6W64FB0OsYpXzOL6jpgEC/7viXuR4hbb+MY4JsOLZdRfBpt4xp6osQGYkeMyAOABR2ZA kkm2ZAk0ucgT3nFuSlyTf0GqX+rSV9BqvOQnZ8DLLQbzkL0gZjJDOcRS9geVF6ImxmhFBbJhk9BS /OQyU8DOIRYznp2shj2fecAjxoZNYhzfkMj5/wVWfo5HQGOkOdMXzEdOMpEbMOlKDwMCkW5ypSnN aU5L+tKUBvWQRR1pJU/a06Iec6otXWdQa3rMpjZ1qVWt6VP/+WQvrtG+1mxou2TrS+UxCrHKdI1c kUco2+LWzugcAVd32gGSVvKzYw3rLsP62rWWtratbe1Ra/va20ZytLH97W+P+9zhrja6y33rku34 WYTeGHwSlSB6gwovckaVoHTGbEyH+tTT2HbAod1pbEi71HX+t7MJnm5yMzzhDR+3wrvcbXCvu9rT bjfJpEwnXl/5VTXykqdglSjFVElOXOL3o5HscIZjHNwsb7inVR1zmMO82xWHOMRfznN2U9viBf83 t9A1vl/4ktjHbKbUg0R1pxyVfEqdSnQ/uBz0oeN86M+WeLQRXvOrH7zqLZe5w72e9XSv++JaJ3rR ueJxSDF9VZ66FNzr/XRjrUzIAIf2qvM+ai/nfNUZt/jeKV7xvuu86/92uazLPWtvz7zlA1f7yNK8 jx7LeCHUso+LjH2tfaepT86KlrJVLvnSb8DPprew0WFs+UIjGshYEHLqZy9r1NN+A5RnVNvdDHsq yP72wA++GgpQ3NZruPdX+L3wl8/8DZR398iXlGSnj1akRx8Wzc++9kl2+et7//scOz74x09+Ef24 /OhPf0/Or/72u99h7H+//Of/BPHT//74r0L//PNPg+f6//8AGIACOIAEWIAGOFzWx3/J114M2IAO +IAQGIESOIEU+F3Qp4BPoHzbt4Hbx18XiIFNoIEcOILLl2AWEG/7B4K0AGEk2ILMl3sa8YEqqAQi 6II2WHowCBMyOIP9x4I3+IOml4O7loAfFx3o0hCC9n01CIRMCGVCaBw72GiKZoQpQX5cZmt9p3gh 43dN2IUW8IQoiHnWIBmHJoXI129YV3hkoGde2IYZAIbGx37CJibF0hfFQSUN0nmuhYY914djwIZu GIgUEGhJOITdd4S7oinNMSr0IXesxYcZJ3H+5mq19mmWeHBXN3i2J4i0l2tcEoZswSe6sih2/1cP qJJyqHWFpBZzZUaJPod2jndusMiJI/huVxKHSSeKUacnDKKLbRJbyieJflh25rZpN1d1ZLeJtBiE q/cWoNhrrtJ0YQIq0QiMKwd2s9aKxOh1OzeLariMzQeHUbgWUBIl+0aNXPIsqcWHORd4xMhzsMiN 2AiOGyiORBgKMeJgqthq2Whw70h4OLdwL/d3qUaPL9iMU3aPmlAmQLaEN6aMBqlx9niIPKgFPphj kReRB8l2ClmRNHiRGhmS90V8xIWLHukEDimSKhkyz9eRJzkDA0B9MhlWLvmSb7CSOKliFGmTPKmA 9teTQAlkPxmURAlgQ1mUSClbR5mUTJlaCQEAADs= ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0056.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Example – Relationships Tab

Set the primary and foreign keys on the Relati= onships Tab

Normally accept the Inaport defaults

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0056_image006.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhDgL1AHcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G RklDRTkuMBMAAAAHdElNRQfYAxgJIQ/zRQK/ACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAHgfNAGQAsAAAAAA4C9QCDAAAAMWrFcW9krKiZ7OnY8e/i ////AQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDA/9Iutz+MMpJq70Yms27/2AojmQpZmiqrmzr vnAsz3Rt35VR7Hzv/8CgcEgsCgW4pHLJbDqTpqh0Sq1ar6TCc8sYCLDgMIkhLpvP6A13aWy73/C4 fD7Urbleun5PRBJ0fIGCg4QFfneIiYo3dotLXo4xXo2RlZKHlpmampSbMpCeKZNaoaUWoKapqlCk qyyorhKjsbQEsLW4uRSdCwC+vxIAFMIrxAzGGbe6CrPLpsrO0bm8CsgE1scR2CnbKtC6zdKb3+LX vjbdwxfIwMfnvQ3Cv/Pw8e/zwNbU1/Ha/i7pUNzaFhBCQWL03LHr5yBctQcF/617R0MewwkRZWEq V4//X4yMEisYG9lx5MKOKD2qXKmvVbaX5khWu3fOJEmK5uBRRNhuJoSBEEPCDMqyZMqVzL64RPoQ BUij3IIhzZguIrlo1p6qK4YBYb+sD2U21ZlSLNJ9+MR6ZbhW5r2mPOGObftgYNaqBqUWnTr2qMOc 7qKuu9j1H9itRDVyJOwx4cybjyPb1HmXJ2QHBNmqPEm2L+MGaGHim9uOrty5ok9vjgD0cszIr/nh RI1Zc+0uSr92jh2zMmzZQzv3jF16p2fL7HoWt9xwI8fDbuvNbqw6Lt/VgG8zNs0ZO94IoV9iW0u9 vHnO0bF7XtB6t3TUb4c6hp44KS+LYW+bPe8zeP/9/+WlR191+tHGnnPlDNhYQsnFR96DtpmnXXAQ dpdefQ6E995pAtLWoXcermfLRl49WNpxZeV1XWa43ZffZieiCOJnMCoX42gS8qceg4/NdpUzCpIH VYAhynjhhMCJ516D8Q35gIakqaVcjUMax+Fw0yWlmWlEpuYlgUKm9FeJBKpX5ni6rfehkmzquGZz i12kVpEzQmimm3rtiBJO+9kp4gL7qKLViHJu2GWS1+2lJ5JjQnVhkCI+aiiX+BkoaZ1iIvgcn1ha 2eNuU8rI20GzYUlYn72UKkGgqQwKlHbzwQagTb4hV1NzLsK6HJq/dRPqb71J1ySwjgX7KVzT/Rgn U//LbsHqYsrWMKhQIz4rkjTTXhDtYtk2K4O15WxbEUB15cZCt5mgS4G43rbrBLjisJvKX+7ioWm9 +D4BrzTyPmNuvvYulsbABBeMxVLeTmLwwgw37PDDEEdcyMQUVzwHwAtYrPHGHHfs8ccgI4zxyCSX bPLJKKes8sost+zyyzDHLPPMNNds880456wzzCH37PPPQAct9NBEF200DxkcrfTSTDft9NNQR+1D 0lJXbfXVWGetddRUb+3112CHLfbYQ2QQwNloB1CA2j6wLYfbP8BNsdwfu003D3d7THfePfPdht9F 8A24EIMLUnjcZBfdNdyH9yA40HI3bvgQkr9NOOL/RD8euNKRVyw525UnXvHijsehuc+dg+x36HCc jnfRrl9+dOoTf74D66IXQvrrZ79+e+S9rx288MP7Ljzma+PNePFpOx482kAM37zyy4NOvN2lM/+8 8cB3/7vd0N9OvfPRS5888YiDbv737KNPveDmMz6++MlrX3317bdtv/PWFz8/9Grbn/hwlzsi7O53 9LPe+YznO+yV7ny0U6ACIchACtKvgRecoAYp6EAEWrB+3AsC7TCYwAyWUIQe7GAKSfjADS4wbw70 nwvVd8IPpk6FL8Qc9rb3QAvyMIYELGDZMMDAGFYwg+HDIQ5NeMHruZCFe+uh+pLYthJGkIkBBKH+ /2T4Pix+b31xo+IXIzg98P2wjEf0YhVzaMMxMhGKW5SeGEMoxRpOkYdC1B0Rm2jEI86wgvJb4wLZ WMcWprGDEwSkFQX5xyxe0ZB2rKEg6bhEOkLSh8iDIQvh2MZBvjGSPaQkI0fZySjmUY8XKCIJE1lK RX4wgRJUoyefeMI+tpGWsuyfFi0Jyj76kpSIJCUma8nJTDaxl7n8ZCdFGUklrpKTQTwlEA7IRvBF 74vYZOTdemfN+WWzhf7z4PX4R85lWjJ8yvxmA5OITjOSL4x4dF8o29lFWN7vmPI0ZT7fiM5xrrGf 3vSn+5bYzywiMZjS3EPXEkqHaOKToUHDnUMhSv/ROCy0om+IZjgxarWJcvSjQ0wlSEdK0pKa1GMX PalKV8rSlgohpS6NqUxnilGY0vSmOM1p2FI6wjlIFHl6eyjkfEo5N3jUqEKdpE6XagSeKtVyUA1l x1gZ1Eu2TnZ/S2ohbMfUrhYBppU0HVGfujGqTvWfY70mUj1pMa569a3T3GP6yklI5fEOf7kEaADx CsK9inOfu/SeN9spx+cVtn585Z87BwrG/hm2fJQk7PoWq064WlZkEsBqNV1Jw1YS85g/XGcKqRrL sG5wh9D8ZyxBm1q0fpaVq/XsMG151MuO1KaDpC1QdbvZuvZ2mYgUoy7jyFrF/vGSd3xk2jQ4x9j/ apKZnk1uOm3bVdwG0pznTCZ2eYvQ6A4QmErVJ2xlaUy2HneYQkUodyU5Xeou1bqF7OwzkXm87baW kMclKBxRS9/7Kne+PlzteAOsXee21705hS9dj7e37hbUoGZ8JGDxW09cflOygy1oFYO7TQwf1Joz 7DD57lhPG9rPrAimKW5lWluyJlSfKY7xV+WK040OosVVg7GMdxxXkfL4x0BO8YqDTOQiq5jGRk6y kmM65CU7+ckUBatUh1a56aFQDziGspZFJ2WtVjWNmkUxljV75S2bOXddzrJYp1zUTU6uzGQ+s5zB JuUGhzh98g1u/gQqTz9yU4t+LXGJ2TlF4g7w/8FqnrOi9QBWLn730cBbYW8HjF2BdvbSytSveTfM u2Iu+tNBS7NxH81WCpu6uBC0slrPi0sOM9fREF4nQEFNa5B12be73LR2M+3mefa31a11JqB7Xeti f+zWwHWzeiVNaWADmNXg/ewss4trY1ubYshO9XXrW8gXGpTbuUV0+Zj32wjD09z2NCW693ztdk+s yW2maKL56O562xrJRp337GZNCEfb+98a25nAB07wghv84AhPuMIXzvCGO/zhEI+4xCdO8YqHAuAY z7gcVqDxjns8pCj4uMhHjtkKkPzkGuf4cpNrS1+/L565BWfzeho6HWcUqJRbeanTulWee7nM3/+u W+bWygebkznLYoaDyjkNyW26vNNP17Qq11rzOFeZzZy78c2xztKk43zKjSN37X7ehqVnz7Uy5O+0 fZtIp6PaCF5Xq9zBHOaoHdWtZC9p3LludBSGdQ97b6oKpn1DUn/78KOMYk+h/r/4jS/Q3t5i/qxM WThDvs8XHvZjB8vtQC5Wheump2Ed+ec9b3TWRmxscwMKaTyC/tCSv7xeRz9o1p/9oJ0OtAA56EdZ 403lyx1j6qEORFWXevZ6XbVowfnap+aX7uEGZWRhKWnmvz6Yry83s5svbZwDUdrQfqfasw9zTLNd h8++soHru3l1G96YMTT7JH+5/m0fn95wvq//f+WOxloaf/6y5m/h522uN0v3M1zQ1H+zlW6mlXz0 xV3Gt2yO5FprV3wCuHraZmP8xVv4JVykxnTxN3huN1+x5kRvN4J/53Yt11+6tl47t1vEVmDQdVpM t2mFx16T1n1g50rexYLCpEtBZ1+/hX4PuDmQVkwuiIAg2EDyJ1Xrl2tQaH/4Fzs+2IM32IMvGHPS J4NciE9P6H6/xn2/1G3Ul4P+x2teNIHIRYHOloRgtjy75oZapV5NyFkPFYR4yGado3OHxHlzZUcq SGgc1ofnFE6Uh4QVtoP2pIiW1ljEh3t2dW5hJFuUd3iGuGCapl+DqEOCyD1ghGr0xE+JeGpF/1Q8 HIdyczc3PsdQ+mZZUvdSg4eKX3djrGNj0tSKXmWLttgDpyiLvmhtvfiLwghqwTiMxihnxXiMyghl yXhWUZWK8UZlEUV2uLiMaBaLnkOBV5V/RBB4eYR31qhTzah1VrV10Nhm1eg04BiOOHWK4jZ5hVVo 7CN7p+dhhCZKyEdvhyiPf6V6OyRiWCRZtHVi7MhUxUiD7zeEqbaF2teCAKZGd2aGArZ8N+iCC8iQ BXlkKZBNNKeAA2aByuWRGAhblTiDh+hyHDh1lOh/GJiR7SiCyuZ8MamQ8UWEWHiHy5Ze0VZppiaH 4uWSCQaTzcR45xWGNQl+ZdhsSNmTYuhps/8VfvUHfUCpUu7oYfkUj07YgR12WB9mV60WT3v1iQ/2 TgTIS/0IYQIJRQSZhVNJUuP4jN+YY7PYlkKGjUXHinLpYnTpXm+5l34ZlBv5l4JZXXY5mIapkSF3 mIo5U325mI4JUhgwAJI5mZRZmZZ5mZiZmZq5mZzZmZ75maAZmqI5mqRZmqZ5mqiZmqq5mqwZmgag AhHTAffyCQJQm7Z5m7iZm7q5m7zZm775m8AZnMI5nMRZnMZ5nMiZnMq5nMzZnM75nMJZAK+ZAtPp BP0iCl8Qm9q5ndzZnd75neAZnlEgnbC5BdcpENkpnuq5nuzZnu75nt9JntRpnrN5CfB5n/j/mZ/6 uZ/8KZ8oUJ1NcJ7JkJ78WaAGeqAImqBi4J8ZAKBMIKCRSaAKOqEUWqEWqp8MigEO+gj1CQMKswEA YAAhygG/4AElSqImKqJpgaIm6gsguqIjig8XOqM0WqPemaEXsKFKAKHaQqAhOqIiyqJBCqIkCqRD SqQp2gFAaqRMiqROaqNQGqVSagY4agE6mgQ8egrZCaMpaqRD+qNCeqREuqRJKqYxWqZTmqZquqYi UKU5QJ8ciqJk+gFeeqZz+qRBeqd0qqR46qVs+qeAGqVuugtwuqPpCaZ42qdIeqZhOqd+2qiKGqiS OqkzOqgTcKU4kKUV8KGIKqZh+qVyyqdC/8qoINCknvqolJqqqpqflroqhYqlX7CipzqrR9qpZjoP kWqmubqqvNqr7tmq4PGqmbqltFqro6qkpkqremqqyeqrzvqs8Ympl+oUqqGlcZqndOqiyNqsupqr JwqpKvqt0Dqu5AoxwKoBwnoDH1qu7Nqu43quT5KuNrCu7lqv9kqp8Joh8loD9Hqv/vqvU5qvoNGa ntmhLzAAj5mwbiCtEgCdw7kEABuxEjulFlexFnuxGJuxGruxHNuxHvuxIBuyIosvCluyBaQEJpuy ZIOyKtuyX8OyLhuzWIOyfMh1gNdQa2az3TiXOruNwfdy47VypFezebeNPDtmbFm0X7ZjNP+rlz0H lzubtDzbd22Ff8e3bVjLg1JrhOd4l1JbixqTjjWVBGvHMT9FdTn7dWL7SmybkFarhWWLtF17s18L tf32Y017drG2eZPXechVgO0jeo/nt3/FWKFne90kebCnjW0bWE9HeIaGWLtXinpme1c5kPekuDl0 j4u7WXy7tYSJA05kfu3HiXWFeG5bSjc0kXFbhMUlZuY3kz+LXnCrazWIusKGdgwpbFGZVM+XlAFZ fWsLUXm7k65mQpH2ch8oW/uXSSPpRmSoWGh4hXWUtb2HfiHmgBypkovXf9KFax5plBz4d5dVvEfZ kGqXustblCwIhjcJgMbLuGaVvtarh0f/iIPUdl25C5FeyIO/u5KnNrwMZb4zqH9g2F3657pX+L8V Gb9WVUlwqJK2220pyZTodUVjWMG+1LsEFsA8RsBxOIr9u4jXO2G3Z2Kr1omQKEVb2YaqxocjVL9v 2JWWi26Ji3nwGFqmh3qEVU2OiEBPZGHlS7bOmLb/JoVRu1QCPMBEHLa1uMS25W9EV2NABrMye8Vc 08RYvMVNY8Vc/MVG48VgPMahlgRCu3OLZ45SebRVS46BoGYEBMVvfDVyLEQwWzgT5Y1xVsRIW8dw t4pwhcdM28SC7LUOJcB5rLQ/c7bUVcgxdscszLr0uD+Qd8P/A26il7l9dokC5GB/NrmZ/7e38rVP YgmJmyi4d1VOCIyWQVy4kSeJfbt7rBy4a/nIhLyGuPuEwEu7m0ta2+e6kYiQp/vLZUu6sSta1xdC 5Ld8wYy8vFSA2Pe6oBi8qkuEFcyXt6xsnueUA5iVNAyBoejAE7jA0FvAAbx6yQu9eUiTIPld6+y5 jltewBS+JhhuZ9SSdSm6U3i7u9a+3te8K1jCjRSF5CXO5py+8XzCVRjQ4/yD7ly7b1vQ7MxMPylj kLxfS8m7JJh4AB1sBq2GzXvQIn29rcyGI9xKIC2KfcXLsdWFA8jBfnyN+gy36MxPqFduW2nTgNuI EUzBYnd/myi9Iby9Am16zit1lfeKGv/GR+LVwn5Ylkw9WWsZ02MjxqqojnRcVoBcUVRt0Vq8VfxG ZWGN1Z7zxCD1fyRn1WS81vc202z91m19A3A918f21XR91+9mxk6bVVC7tnpstltdtPq2d119jEqQ xkab2IpsyKjDuFO81479ZnyN18WbyH0dMn8t2fj7x9yIjtn42HPNskEXzg2Wyk/9anvIV+M8yqGI ugFllWl5uYi1YINGexPmWOlsgbUH1ZUV2tnczx0MlZlWf5fmy7ynk5tLlAVNuv4r0f+b0R7dkJT9 29LNvVyYuy/tiTochP7Ukc+7hvUcWc313TBmkQJGz9M90/o7XTmJhf8lfT5ZzG9nux//GYMTjb53 ONIXGb2+rd5HCWvXrcv4rdJjSN/OnJAr2M0DvsHsdd7XDdz9LdegpT3m5clwiNo/+MNaKeAXxpWX a3+uzW+VeLxAPNwj1uGT9dpzBNdqvVKJVtht3LN4XXZ27eLzBuOfLeMzPmNuveM+rlA1/uNC/gYt PuRGDnI2cORK7gZFvuROXnIjG+VSPuVUXuVWfuVYnuVavuVc3uVe/uUT9+RizmiFOeZmLniBeeZq zuOJueZuHgTAN+LGFWFg+dMnKHytW3WQbXXdqHNUm3dXR4WIDY1xzMY6rsZeK7dS8+ejI5QOXY4q jcmP7s1Km9mCPtmgi7agrbZrpueE/26EjszZc8u1P5fZY8d3hp7XG6lj9W2TiyTNhNi6UevpnC7q mc7X61jrW0frMjnrtk7qe55/g2PqT0t3jI5tjm6HkN64Cb2+fqe4qIw+lRyJjXe47KZKque8sYfJ aWeJJI5B3T7bSATtWLnC88jt/Aho/kjLPX1XnxfukwzLsRzL/Mi5lma5qBRyP7u6I57igdvg3S7F Caha3EfS6bdbkqy7zCeEDEzwFZjwiljgqzvCycvQwNzg0yvgmRiRlBbdt25RyQ7r7C3y64zE+X3f 10yA+YXW611tEByQDvi9bajsPGnDqxSBOt1sInnPnyi7NP+9heh69ExGgAv0jb7q//9cgcqHy5M+ i+zLvO773HPXcuVtk7CLgzNP8hENwFc/4Gb5vgYP3gl8vhaW4A+OUiEf6fhbue2uhVTIvAps0mZ4 fxQN6+R8fu4t99F99xIv92bPv9Ct9GJvlPptkeJ7YIJQh6+tWgoo7fOd2i/Mfz2P4NQucyS2wvXL XNr+h7ytlt+Okbhb+QGYedee0CcZ1dpdfGRplumu3Nf+witO2pylwrytZo355ouG4z5z+7g/Z7rf M7zf+08e/MK/5MRf/Ed+/Mg/5Mq//D8emQQb/dI//dRf/dZ//dif/dp//QwLHttpsC7gBQ47/uRf /uZ//uif/uq//ux//gJLBvtKA/3/OrH0X//92f3o+gSaui4Sav/+//8IYLrc/jDKYoi9OOequ/8g MQhhaYqCpK5s675wLM90bd94ru98T50aDnD4GRGPllFvyWw6n9CodEp9/pBCpNaoHSqr4LB4TC6b z63rMdslctumrwJgoC/sDIC+ocfP93d8c4J9hXV/fWiKi4yNjktqRGxwJ2+UIHKHfn6Hg56doHic doCfoJ2bj6qrrK2OkUOTlyGWsx1fhYB0ooS9eaaoob+Bp8Wux8jJyjewQLK2HrXQGHK7v7wOnMCk gprEptzDy+Pk5eYKzSfP0xnS7CiB2MHZD6PbnuHg9+f8/f6M6Uyse5eEBEFqKQbJ/8snruE8YrxS Qez2r6LFi1AClhhI0B07JblIGSpm7Vo3e8Ik4qOIsaXLlzI0huD4zuM0XMKGLfwmL+epUj/1wRxK tKgDmSBoagBggSkBp0BsQsPZMxTQOlcT8QGKUmguo2DDvkT6QelNgwcLil3Ltm0jsh7MTkWbNpPb u3jzOoHbQa4tqX8T6h1MuPAMvkEGKF7MuLHjx5Af0z04oIDly5gza97MubPnz6BDix5NurTp06hT q17NurXr17BJ+8UgoLbt27hz697NO+0Fw8CDC5fgu7jx48iTK1/OvLnz59CjS59Ovbr169iza9/O vbv37+DDix9Pvrz58+jTq1/Pvje9+/fw48ufT7++/fv48+vfz7+///8ABijggAQWaOCBCMYX24IM NujggxBGKOGEFFZo4YWcWZAAADs= ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0057.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Example – M= atch Tab

On Matc= h Tab, click “Enter Initial SQL” and Inaport will write SQL

Then complete the WHERE clause

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0057_image007.png Content-Transfer-Encoding: base64 Content-Type: image/png iVBORw0KGgoAAAANSUhEUgAAAg8AAAEWCAMAAADWyoReAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA B3RJTUUH2AMYCSsp26dvyAAAAAd0RVh0QXV0aG9yAKmuzEgAAAAMdEVYdERlc2NyaXB0aW9uABMJ ISMAAAAKdEVYdENvcHlyaWdodACsD8w6AAAADnRFWHRDcmVhdGlvbiB0aW1lADX3DwkAAAAJdEVY dFNvZnR3YXJlAF1w/zoAAAALdEVYdERpc2NsYWltZXIAt8C0jwAAAAh0RVh0V2FybmluZwDAG+aH AAAAB3RFWHRTb3VyY2UA9f+D6wAAAAh0RVh0Q29tbWVudAD2zJa/AAAABnRFWHRUaXRsZQCo7tIn AAAAw1BMVEUAAAAxasVxb2SKig+sqJnPz77NzbzMzLrMzLnJybbFxbHExK/ExLDGxrPQ0L/f39LY 2MnT08LJycLS0sHa2s3X18js6djo6N/n597m5t3k5Nnl5dvm5tzi4tfj49j6+tLx7+Lu7eX8/Prs 7OX39/Tx8evu7ufr6+Pq6uLz8+739/P19fHy8u3x8ezw8Orv7+ns7OT09PDt7ebp6eDz8ez08ez0 8+719O/29fD5+PT5+ff7+/j7+/n9/fr+/vv9/ej///9mXV36AAAQE0lEQVR42u2dCXvcthGGMY7b 9D7UVpYiJ0Kq6nDsSKrSu2my//9XdU9yZjC4SC7FJb/vsbW7PEAQeAEMMQTg/Pm09PbN6hhROkKg b99MI70GDc6BB/CwZB6c+uRpIb+7tXbfd59OHQQe5smDM3hw+19O/edHzZuHQ2FIHVuy0fHAVMly O7G0dftyuPniJA/NsdaFXDKGLsWD4x8FPDixIeTB1aROYTo742Q3Kg8ufsWSHJAbgv8tFSJRndiq eYgV40Q8XUn94Nq/exwPfxpKXJDPLsz4Ah7ceSx5UofmeHDH58FlkrOKB6fvyqmc5xv0rjF5aKK7 3+TEVUVVluAhqHAypSWHjjufEA+HOvqQFrwAOb7diQqfJ7FVshI8qDs0eGjzJREV/kPcR8DD/q6a HHcBmaIJydcPqsJRhqhIHcep5EktDjWzw6jQxuBBfuhSxLYHpwTtsAvPFVZahgdua4jm24qKC3/w y5o86GPsOqstF3keRIJYqdOE4bSNasfH6RDloePx0BQdWYpc4o7PUzyIAlLGA6senFGgVVRUwOqh QD5fuHMj/aNtmA4qtB/CCieWOjwM53h1IhI9xoM+dNT6IUi8Oh5cggdGm7awwvYiKHh2VJzJw7nR XogcafgPHipFtd88B1nPF644dYzmUtcKCR6CQ8+P/nzhziOFr4IH8xmDPWS4oGLN8uByPLjUoefV /ZOuYBd7vnDnpaljJmxQS6WzY4T2ghs3wp7kpUjZdrwgqSSM9+xZZ1bZk7GoKFMjak/2BSIomWGF 0/abGKkjE/bcrqWs7DAqtGPykC8Y42ig/kl9H2P6LwZMQ9c9FuABPAzPw6sL/s1XjQV4AA+Ch9VC dAweZphMzi9DRymbM0ynV7cfoUkJPEDgAQIPEHiAwAMEHiDwAIEHCDxA4AECD9BUeViIi2vRAg8Q eIDAAzQ4D7Q9hZIB0lqHL+ro/S6i3Rdqt+4P3W5tf3cW1R9ExedVhJdNqM2NUk0SDiAalYfmBvh/ uYtkxIjvp1TKUtebpezGYZO8CkmqSMLiq1H8wNfhgcLLZ3ggCQV4oLIcnAQPrIL34luQu2F2JnmQ NQa1jQj/sz5i9729NLUH7y972CtOZB/EYh6el7qG3uLDix4aRravjY/OeZWYySRsYkAsJ5ro85ul Jk7tTe2268zrz0PzL8zFQ1oYOHL7QZ5ghsSu4tUlD6mitvDLkowoeRWSrI/0eT56Db1F8CB3Gmml EqS5joxgNAnJuoiMcSKprEgOVT/wnBTlLVPZUVX90FZHh7toTdHmfkmmg8xxVjxJhBTjIWi57Kvy D30y6Uua1CtLgUqSMIwBb3PYdcg+zojdQPZDWKIpaPyot/1glTQjXVL5Gj2shodYbqR5YIVaMW7x YKYTZXkwYuyLeBjAflDxsWIy5PNFpLJNlFTrriN1eC0P0atGs6C0vbAunEhCFpJuL3TuUIaHvvVD a4QY9qRuOfY2DetO0P0P++dv2f+g7cmmcuNmmTSogrQjaW5Je441G16cHucheVXDLMnZk2TwYCVm kITKkBQ32Dbinhs3pCuO8Ho9eIAC0azuBjz0pGFeOIAHCDxA4AECD9BoPGTNKOq0j7IndTpX+QAO W9STr3g4LrxNP8wDRsKNWbyZDOdB4kQat36g+l2UdNRleSiMDoUdwVRw+dI4d6aD6o5NRzWeWBmv 6VJ4CLufwUNvHppuQmq9u0n3L+ujaw6N+a1NZyw/lnUSkvYotM5dy53diYc25oF/WcZPxFkcLM/0 zLXFwthfh1SPZ+q2YimlYsvcaWFaRvze1f4s1m8uPKmh+7dNC+WZqXHGWs4By/tAcV+u7a4k5fQU XkgvXVUxb4RXLnLh0iDTM0FRlxhZPjiKpoq5zXb1JD37ynLpxIMPPGfcIaw8HCTv1dc5YwMfdbjX B16L8F2CplYzXywwPLY+cnnt6ScrDRj9wasXlhO9zbjC24qkFBn+bnGTlPV7D8OD6f4NvChdnLEU d3p726tNURdwmgfL92iFGVQ+tofV9iTaTvQYD6nbiqSU8c5P+o0A6mM/FPBgvs+UikzaGRvjIfoi VJQH4+2RHA8qVynSXljpG3qm8+2FanrTt5VtjLLthe/fXkhryWwvNI7cH8t3keHht5yxjbfbsieF 0zd0OItvFg9BnU36xUphl4X2pIqzfomh8XHn7UmJbva2vGVbF9iTOb93h/ejOjw2vYIT8HX9joP3 xo11WwPzYLp/R/cJ9x7Q0/v6XbI0G+cxbgv+Cwg8QOABAg8QeIDG4gFarsADBB4g8ACBBwg8QEPz 8Baau1ZVPLyB5i1fycNSFmldiL7+s/x9Ax6WzcPqL7d3N/cP795dXFx+8WF1BR4WzsPtNx8/fPr2 29vHp7vny9VvwcPCebj7+NdPGxqe7l7WPPwOPCych5sPn24fHx9fbm5uni9WvwcPC+fhYdNWPJ7d PK91sfoJeFg6D7cbHM7Onu+f7y9WPwUPC+fh3ePt7dlG9/drHj4HDwvn4WJbO7xsgHi4BA+L5+Hy aY3C093N+u/D+9XPwMPCeXh/97TG4e754ezhO/AAHq5e7tZ6eb5/+O7dFXgAD88va93cr3m4+AI8 LJ6HLx/un583NLy7uPwK9uTiefh09f79+8v1/6urr25XfwAPy+bhS/Hzj/B3L5yHD3/6/Oe/+OVW v/r1bz6Ch4Xz8Le//+Of//rm3//57/ff/++HH374GjyAB/AAgQcIPEDgAQIPEHiAwAMEHiDwAIEH CDxA4AECDxB4gMADBB4g8ACBB/AAHsADeAAP4AE8gAfwAIEHCDxA4AECDxB4gMADBB4g8ACBBwg8 QOABAg8QeIDAAwQeIPAAgQckIXgAD+ABPCyDB6zXDHEesF4zJHjAes0Q5wHrNUOcB6zXDHEedus1 P2K9Zmi1X6/5bIvDGdZrhjbrNW+W53253yzQi/WawQPWa4Y4D5dPT0/79dyxXjN42KzXvAXi4QHr NUOH9ZrPsF4ztMJ6zZDmAes1Q5wHrNcMMR6wXjPEeei5XrOHZq4qHlCg5q8aHqDlCjxA4AECDxB4 gMADNCAPeDKfonSm/dhbDjzMiYfrnvoMPIAH8AAeevNAW2VjaBxReGYQBp1GniyVh6q8DDdR7hwC D+ABPJw4D7T/s2sByNP2u9+1Cvv97TeZ3c05+vTmJLKDgibIQ5tLLRoHGvYbxbe2uDP7oT3ey1NF qNGgoOm1F7us3WVxU4xFJirzkTgYTbEncU5bHSSDgibKg4QgLNTe4EGd40MeskFBk+OBjJzLtBc2 D1TIA5iYJg+7upvZkypvM/akaA3YIe2hbaiwJ6fPQ07IN/AAHsADBB7AA3gAD+ABPICHo/NArVOC WGd30/XYPGKGz5ZpG5XsQw4Pxm2AhwulQlURMFxq3N8mHpCJffrUfVAQR5+43kx5aDosIndO8Zwt CDnqTuWd4OpYSsW0lgevrkb2CfYGDx70nVMqa7Mhk8/zwMryvmx240F3rIKH7jz4DA9iS+sWJ+FR F07yw/62xVH1jMGDJ1G4STpbPW9crC7SSh5SDnweIt9FbWsyVx6E/eCl/WDz4IUvnGVas+OABa9c Wh50ix7hoQlYtycxF4rqnG+v4rX9oMkPQmttqX6+mlN9vqCa+sFHPGbCZ8L8n03iUnABxUNzni7t rGJJuNypqZTs+kHlaMKBz+lWZMy9fqi2H6I8iI+gnjd50HV7noeUyz3HQ2g/xEIjXUyWUz9UP1+U 8CDOCrgwQDO9qcaWtMtdxbUjDzTcu2Bz6H/Q3QPcDPDK+Iq1F4GX3Cd4sPsfIjwkXe4GD6IBIOPl QKJqe3L+9kN1hdLhGDrqFacp8LArwmXbSuuvk8UB/gsIPEDgAQIP0CnxsH/OKrL+495cvGW5RB4i G8DDvHgoncgBPCyAB1Y9kDWkhobvfYOG4MFtdUQeyO6aZ3sH8uZCg/CQ/DlI/eB9ZAhmiTcXmgkP zAXlo0Ny5Uc/by40JA/uetNquObPZkO/+oG4i5m/46HbC00BeHhNHvbmwxaEw7/th7sehAdhTzav r8GenHz90PCwI8ShfxI8XLcggAfwINoL8LBIHljz0FgODvXDUnmAfxM8gAfwMLY/q/N85uFjaGS0 YnQQIyXCz86GXBZhiu0j6clrRwCFg9apGbfFZ10jisWRMvGi7N29tr+7OHmNZI2Nb80OeucvvBNF k64q/4tG2rcufjVqKBx+Ifvx7SEhdTz42fLQFJ6OPKTrh+PyoAt4dHgWaR6sMUavwoNT31zKlTHe fOZsYLboryyZx5zM6r0Z5U10CFuH22vydFI5XcWDykiSVYyYCpxfmrwxQNXroUsdeUj+6GQ/+E7z mbNKlexh0z4dRJoHL4aAK0ulx+TpnAc14TaFg9ZFlRCO3CddUZjz/MZ48BEf0Gvy4GVbWT+fuUg4 NZAyPY+5KseHfKJocH6IydOD+iEyhJRnYaS9CGoS/YII4ya4L+OoSh52rs3tx86pGe2QGm8+c0rw kAuCvJmuKR4GmDw9GJ6pXvCgJA+e4jzExvfmeOhqPwjXpmOYDMBD/Xzm5hF5HmhIHqjD5Ok6k7Vl HEz/ED5kGDMEUVBTquineehYPygeog7OMeYzV69akvZ/Z4dBm2iQbm1D24t8v8nTKc+DrjDUA6nq t+D2RZMM6tJhSvW3JzUPboD6oew5blDRaCeNdksDa1k8vHomTh6Iah6u3VDtBXSiPMCfBR7AA3gA D9A0eQi6SugETHPwcEweMoBAr8pDM4Bz/+nAw5J5aBjg/3vzQEZnJCkPtveB4wmaDA8u4bjo4r+I jOqOujSgCfFwPTAPsVHdZEzVDR4mxcPBfhiWh+jU4uFU3eBhWjwctb0gtBcnxoO7Vv6L4ezJvX82 b08Ch+nxMOzzBVdq0EJ2FzQyD7L/waWmlDoWD8BhSjzAfwEewAN4AA/gATxAJ83DctfvLlrVifI3 OiseqtfXqwo5Onw4umpa/EIUCyTFg1dXo1KaM3exVB6oe6JQsgQa62/y2RLredD99cPx0P3h/FR5 8L5ifd4Zrt8txnQ3PbjE46Pvomj2lVO3H7y0H2wevBiOLQZv77ccsOCVi07JSazfLe9FOXqILx4a jDOba/3gS9oLiwefWI/1VNbvVvNdUGIgsb6LudYP1fZDyYDc01y/29wYuYt52w81zxdFA7RJhRxM 1hR5viAff/KI80B2XKt5iL1j1vk9gTn0Pyxm/W41Tj20J/XjT/1j9xL6J6njMXTUK451k3VxAQ+7 kla2rbT+GpuFuKVYGxf4LyDwAIEHCDxAJ8RDOxvjQJN74xXLufDgDyxE+mbCefesyb3Bw6nzMOzk 3uDhpHlQOT3E5N7QPHgYanJvaEb1wxCTe0OnzMPwk3tDJ10/DD+5NzRnHuon94ZOmQcIPIAH8AAe wAN4AA/gATyAh1nz8FlfgYc58eD6q5AHaOECDxB4gMADBB4g8ACBBwg8QOABAg/QmPo/2z1DGUfQ PhwAAAAASUVORK5CYIJ= ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0057_image008.jpg Content-Transfer-Encoding: base64 Content-Type: image/jpeg /9j/4AAQSkZJRgABAQEANQA1AAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACcAOQDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDo7bRv DVnpGnSzeGdElAsYpXEllFvmzGSzBiOACoyTn73JFTi28Gs0oHgnTcRgEsbKDacoX4OOnGM98+ld XoKRTeFtLSWFHVrKIEMMggoMitT5Of3Sc8GsblHncEXhCRGkfwXpQU/MiiygyVIyO3JPHHYZPSrE um+FIZoN/gzSBDKg/wCXOHcr72Uj7vONp6dc13nycfuk46e1GUP/ACzWlcDiLjw/4dSO2nXwtoEM c8PmpHLp8ZZjgHy8gfeORjGeh4NUhpGgtOsK+GPDzo5jRblNMjKh3b0x0HI69V969FyvH7teOR14 oBUDAjUD2ouB5zFpfh393BN4c8Po7RozXTaUixoxG5sjGOAUH3s5P0q7D4R0OS0u5J9A8PsiuUTy tLjjYcrjqDngn0ruCUIwYlI9KbKsc0bRvGCrdeSKLgcHqOj+HdN1K6MnhDR5bOI7VCabCCzbQ2Nx 7891AwCc8YqCS38JxypCPBukM7EszfYYRsTcR0xy3C+xzXoxKtnManPXNJlM58pM+tFwOCW08GsG b/hDNLCKMlvslvjPPGcegOfQ8dajSz8JI8cdx4O0gSNIUIFlAB6hhxycfw9a9B+TGPKTFIyROyM0 EbMh3KSOVOMZH50XA5i28K+E77SjdReFdGUsG2j7DCxBGR2XHUVz7eHraCFd3gfRXmdI41H9mxkB sNuc4XucHB7DtmvSCRtwFCj2pKLgcHZ+HNLmvP3vgzRBD5ZUgaYq4cbiDynOcD25HvVFfC+keVLI PDljKmFYNHpUR52kqAPL6FtoOCeP7p4r0qii4HE2Hhnw3PIIpPDOleYsMhmV9LjTawb5SCUGcgnp kcVWfR/Ddo8cDeENHkXbAfO/s+MgKwG8t8vUZGPXPtXfMAylT0IxREqQwpEqDaihRkntRcDgIbXw je2lxJa+DNH82KLzAr2kB5yAQQB78Hvg1PHpPhO7tZng8JaND5ezM0tlCyJubGTgc4AJPTHTPWu4 SOGNmZLeNWfG4qMZxwM075MY8pMHtRcDz9rXwfDvWTwbpT7I3fzUsYQkm044yMgEg9enGeuar+R4 YnVo7fwTpCTffVnsYWUpknoBnO0Z9Bn2r0g7D1iQ8Y59KMpnPlLnpmncDz25tfCNut4q+EtCkaJX eGQWsARxuIUnjgHj5uh6Ck8nwh9s8geCdLdBL5JdbKH7/HOCvTB+ueK9BEcAZmFvECwAY46gdAfp Tvk/55J1z+PrSuBzFp4L8LMbjd4a0Y4nYDNhFwOOPu1Z/wCEJ8Kf9Cxov/gBF/8AE1uRpHFv2Rgb 2Lnk9TT9w/uD8zQBgf8ACE+FP+hY0X/wAi/+Jo/4Qnwp/wBCxov/AIARf/E1v7h/cH5mjcP7g/M0 AeYeKvC3h631SJINB0uJTCCVSzjUZ3N6Citjxiw/teL5B/qB3P8AeaiqQHR+Hf8AkWdK/wCvOH/0 AVbF9CpHmKUBB+bk9CR/7KTVTw7/AMizpX/XnD/6AKne50xWYuI924ltyHqOCen/AOunBXb0uKTs TR3tpILcq5/0jPl5BGcdfpVYaoPLZ2t8bBlhv5GenUdf880/7XpSLE+5AIywjJVsqQMn36UxpNJV U3RxeVtaQMQcDGM/zH8q0UI/yshyfcmvLwWYUmHcCpY5Yj8On+e2elNa+Zbff5A37lXG5sfNz/dz +lND6U8QVESRURmVQpPHf/8AVUW/RiqF0UEjGCHyMf4Z60KMf5WDb7lk3UpkjCWyFHk2bjLg8Zyc Y9jSS6naQuyuJBt4zsOCckYH5Uw32nQXM6uoiaIhmdlOCcdj9D/Om3FxpkZbzIVZlO9RsPznG7j1 4oUFf4WHM+49NXsHXIaT0I8tjjpn+eKG1axCsUZ5CpIwqHkjrSRT6W0jxKsYYAttK9VABJ9vp7U5 5dMizlY8Z+b5CeTn29qOSN/hYcz7okN9arK8bFt6HBAUnvj0qKPVrCRAxdk5VSGUjaSM805ptMMc srCMohDO5Q45PXPfkfpUNxPp0BcPboXRwSoHpzu+mOaFCL0swcn3RK+pQR23nNHKCd+1Npydpxz6 ZqX7bbCSWNmIaIFmwpwAOvbr7Vnm+sNrLHZxvFAcKS+PvNgnGOlWLa7tbkzyG3RFVcuxOSdwB6Ad 8/jTdNJXswU/MedVsBgF3BO7gxtngZPGKd/adlt3bnx/1zbP5Y79qYtxprv8yxrJ8xAZTkjJBP6U PNpe48IZFRnAVDuwvUj8v0pckezDmfdEh1C0AjYudr52kKfx/Co11ayLsrs0ZGT8yn7vr7ZqMX2m C1jdl6bkVWQlsjqP61KDpUcvlhYg+SCNpPOeh/Gjkit4sOZ90SwXlrcvsiZicsvKkcjr/OoDqKQy ut1GIlXfh1YsMLjrwMdak8zToCjBVUkblIQnr3/T9KjlvtMaKSX5JgN27ahP17d/1pKCv8LsDk+4 6TUI0MTJGXjkTcrEkZznA6e3/wCupIruN4Z5JEKCA4fB3cjrj1pgl06SOOUiMgJtXIJwOMj9f1qN JdJiZtqopCYIVWOV7DGOvt1o5Y2+Fhd9yYajZspYO3HbYc9M9PwpranZxxq8hkQMSBlDzhttQyXO lC4eOaJF8tN29kOMFex+lPku9NVwkgjWParq5BAO48Yp8i/lYcz7ocuqWZiVz5i7v4dhJH5UPqdr HOI3DhPLEnmFTtwaZBNp0lwAtuqyOFOdnc5wM0TXenp5n7jzBEmCVjPA3AAfmaOSN7crDmdty9A8 VxCk0eSjjIJBFB4JqG0vLSUrBbuu4JuEeDkDp3qZvvGsZKzLTujiPGP/ACF4v+uA/wDQmoo8Y/8A IXi/64D/ANCaihDOk8O/8izpX/XnD/6AKupY2ihsw7ixLEsScknNUvDv/ItaT/15w/8AoAq5p2kW t3ZLPMbhpHZskXEg/iPYNinG99BO3Uc9laOwZoBuBJB56mg2ds0ao8W8KCAT15OT09TVj+wLD0uP /AqT/wCKo/sCw9Lj/wACpP8A4qq9/uKy7EEdpbx9IyTzyevPB/QAUgs7Rc4gHOc9e9WP7AsPS4/8 CpP/AIqj+wLD0uP/AAKk/wDiqPf7hZED2lrKWLwAlsZPPYYpJbK0nYNJAGIGAeRxjHb2qx/YFh6X H/gVJ/8AFUf2BYelx/4FSf8AxVHv9wsuxAlpaxtuSAA7dp68j39aRbKzTG23Ax06+pP9TVj+wLD0 uP8AwKk/+Ko/sCw9Lj/wKk/+Ko9/uFl2Ki6daBZlMbMkpG5STgY6AY6VM1vbvJ5jQqXxjdjnFS/2 BYelx/4FSf8AxVH9gWHpcf8AgVJ/8VT999QsiEW1uJjKIyHJ3E7jgnOc4zjOaRbS2USBYiBIMMNz YP4Z4+oqf+wLD0uP/AqT/wCKo/sCw9Lj/wACpP8A4qlafcNCq2nWLZ3WwORg8np+dSLa2yOWWEAk EHryD1qb+wLD0uP/AAKk/wDiqP7AsPS4/wDAqT/4qn7/AHCy7FY2NmSpNuMr06+mKDZWrEl4y7Ek lm6nP0qz/YFh6XH/AIFSf/FUf2BYelx/4FSf/FUe/wBwsuxWextJBGDEQIwAoBI4HQfTmg2NmRjy Bjn1/wA/4VZ/sCw9Lj/wKk/+Ko/sCw9Lj/wKk/8AiqPf7haPYr/YrUxxo0W4R5Kk9cnqeKZLp9pL C0QjMYbA3JwR9DVv+wLD0uP/AAKk/wDiqP7AsPS4/wDAqT/4qj3+4WXYga0tXB3Qg5ABJz0AwKHt LVypaEEqAAecgDpU/wDYFh6XH/gVJ/8AFUf2BYelx/4FSf8AxVK0+4WRXWztUkEiwAMCCCM9ulKL S1AceQMSfe681P8A2BYelx/4FSf/ABVH9gWHpcf+BUn/AMVRafcLLsRRwQRSGSOLa5GCRnmnHkmq k2m2Mc/lAXOfX7TJgf8Aj1WsBcAdAOKiV+pSOJ8Y/wDIXi/64D/0JqKPGP8AyF4v+uA/9CaihAdJ 4d/5FrSf+vOH/wBAFbWi/wDIKi/3n/8AQjWL4d/5FrSf+vOH/wBAFbWi/wDIKi/3n/8AQjVQ3Ey/ RRRWggooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAKbQebIxL4Gem KrPw5FXk++/1NUX++frWUxo4fxj/AMheL/rgP/Qmoo8Y/wDIXi/64D/0JqKSGdJ4d/5FrSf+vOH/ ANAFbWi/8gqL/ef/ANCNYvh3/kWtJ/684f8A0AVtaL/yCov95/8A0I1UNxMv0UUVoIKKKKACiiig AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCBPvv9TVF/vn61PJdJFMUyNxPQ1X Y5YmspjRxHjH/kLxf9cB/wChNRR4x/5C8X/XAf8AoTUUkM6Tw7/yLOk/9ecP/oArXsZFtLNICdxU k5A9ST/WsLSJWg8G2EqY3pYRMM9M+WKsnV0hRA6NKcqC67cNu9MZHHfB9PWrhCT1iS5Jbm79tT0N H21PQ1gnWsKoNoUd/uhnB/8A1/SrNnffa45T5JjaPI+Yj5iO+PSqcaiV2JSizV+2p6Gj7anoawIt TuIRDHdW5eWYbl27V446gEj1/r1p0WrtP5WyzZQ7KpLuOMtjt7An9KbhUDnibv21PQ0fbU9DXPHW 2EqRNbhXBAcbvUHge/A+tXdPvTeo+6Eo0eAScYY4zkDtSlCpFXYKUW7I1Ptqeho+2p6Gq+B6UYHp WfMyrFj7anoaPtqehqvgelGB6UczCxY+2p6Gj7anoar4HpRgelHMwsWPtqeho+2p6Gq+B6UYHpRz MLFj7anoaPtqehqvgelGB6UczCxY+2p6Gj7anoar4HpRgelHMwsWPtqeho+2p6Gq+B6UYHpRzMLF j7anoaPtqehqq4+WnW/VqUqjSuOxY+2x+ho+2x+hpMD0H5UYHoPyrP27CxVkKyS78r7ZHIprY3HH SrgAz0H5Vg6E7yaFZu7MzsmSzHJPJoVTmdgOa8Y/8heL/rgP/Qmoo8Y/8heL/rgP/QmorRAdL4b/ AORb0n/rzh/9AFa9Y3h8sPDGllApYWUWNx4+4Kda67HPbGaSLaCW2bGByobGecc1UYSkm0S5Jbms QCQSBkdD6Uy4kMVvJIuNyqSN3SqT61bIrkLI+zqFAz24xn3FR/2xsDSTRP5RYrGFjO44IHrz1qlT l2E5ruNg1WRpT5kkIRWRSSAvUgE53H1+nuafFqMsucSwKDI6gkcYBwBwxyT+HQ8U+1vFu7jylt4t qr87ED8gPy61fCIOiKOc8AdaqTS0aEk31M/+02t7eFrlRI8gZv3YC9D0AJ5oGsJkh4JABuy2RjI7 dfoK0CiFw5RSwBAOOQD1pcD0H5VPNDsOz7mUdb8yNDBayksVxuxgg4z0PbI/pUqaskryRpFISu4B 8fK2BnP0q+I0Vy6ooYgDIHYUeWgfeEXfjGcdqHKHYLS7mQupXqsvmRrtKjJMe0AkE84Y9P5dxUsW qSvOITEGzKqCRfulTwT+ox9fatTA9BQAAMAAChzi/shyvuZq6sJSEWCVGfhGIDDPHUA+4qL+2TD5 Ecqh5WVXcr8owc8DJ69PrWqY0LKxUFl+6cdKUqpOSqk/Sjmh2C0u5mxasZYJJPJYGHaZOOCD129+ Kgl1mdYndbfCkjYzAYAIPXJHPHsK2cAZ4HPXiggEYIBHoRQpwT+EOWXcxpdUuoy3+rKZVQ+wYydu f48H73TIHuamu9X+yM0bRhm2gowYYY7c5PoM8VpbE27di7fTHFKVU4yqnHTIp88esQ5X3Ml9aZt0 cUDGQkbDgMB09xk8nvjpTm1gRyGJonLJ99toAOM5A5PPFam1ePlHHTijaM5wM/Slzw/lDll3Ktre STiDNu2JELmRTlFPpmrdAAAwAAB2FFQ2m9CkNf7tOt+rU1/u0636tWU9hk9FUtQ1KPT2tldGdriX ykAdF5wT1Yj06DmoR4i0ZphENSt9xAwS/BySMA9M/KawsxmoOtc/4f8A+Rfsv+uf9TW7DLHNGksT h43AZWU8EHoRWF4f/wCRfsv+uf8AU1dPcDm/GP8AyF4v+uA/9Caijxj/AMheL/rgP/QmoroQjf0a Y2/hDTplXcUsYmA9fkFXH1C1jUJcxqJBtVlEXA3cjg84/wAKraEYx4U00yqGj+wxbgRnI2DPHerD XOmIqoYV2r8wAh4XBxnpxyMVpBJrYiXqNOp2LJu+zsSQTh4gOvc/XpVi2ure9icpESqEhg0fGR1x nr/9aqrXummZDLCFKMFTdHyCR6Y4xk1ZsrmGeWURQeXg5DbcFwe/8qqUbK9mJPXcr/2mkLMZII1d o1YMnOc5IUnqDipP7XjCs7RSeWG27hj+6Tn8xirot4AMCGMDOcbBSfZoNrr5Me1zlhsHzH1NTzQ7 DtLuUP7ctwu9kkCc4IXJIyACB7/pirktyIpkVxiNkLb+SQQQMYA96cLS2AIFvEAeo2Dn/OKkVFTG 1QNvA9qTcOiGlLqVG1OGGCOS5/dFyygD5hkHHWo7fWI52lBikQIu4HH3sZz/ACq+Yo2ABjQgHIBU cGmG2hZGUxJhhtbC4yMYp3hbYVpdyo2s2iEhvNyF3EbM465/EY/lQNYhYgRxTMSCeV29F3d/y/Gr a2tuuNsEQwu3hB09PpTlhiXG2JBjphRxReHYLS7me2tw5ISNzhWzkYAYY4/Xr7VajvoprOS6iDlE 3cMu0nFPFpbBtwt4g3POwZ5608RRiMxhFCNnKgYBz1obh0QJS6mRHrskssoW2UxROysysWyFxk8c DqevpS/25I43RQKynAH3j83GeQMHr0HNaqwxIu1Y1AxjGKHt4ZFZXhjZWOWDKDk+tVz0/wCUXLLu Z7anP5hhSGISq2DvYgEZUZHGep/Sli1Oedolit0ywYkNu4xj0HAOeCa0BDEoAWJAB0wo4/zgflTT bQM6OYYy6fdYqMr9KXNDsO0u5WfVYIYRJMHUMu9QFySvr9enHuKaNZtQq79+5nKgKpbvjP8AI1da GJ02PEjJjG0qCMelN+zW+c+RFnjnYO3NJOHVBaXcqT6xbxO8SHdMhwUI6UjaxDF/rkkXKoV2Luzu AOPwzV4wxMSWiQk8klRzTTbQMSTBGSQASUHQdB+FCcOwWl3Hv92nW/Vqa/3adb9WrnnsWUtZksYv skl9NLAFlJSWNyu07TwcdQemPeskr4XllkDlV+zuqFjIcEkBVAPfIxz61sa21tDZLc3Fv5/kyAoN +0KTxknsKyILbRLu5htf7NkQSkmJvNPzBd2ScHjlSPfjtWK2A6S0kSa0gkjUrG8asoPUAjjNYvh/ /kX7L/rn/U1uwxpDGkUY2oihVHoBwKwvD/8AyL9l/wBc/wCpqqe4zm/GP/IXi/64D/0JqKPGP/IX i/64D/0JqK6EI6Tw8qv4Z0pWAZTZRAg9xsFXn02zd9xt03YIyBjqMfyqh4eYr4Y0pgpYizh+UdT8 gqRNegdyBBKFGeWwCcEjhepGRVwU3flJk4rcvLZWqKqrbxgLjHHpSCGGyjllhhA+XcVTvjmqZ1yH eVWPd8wAPmKM59fT8ae+pJKDGtq8uWKOpYLjkjv1HFVyVOouaPQWDVBPLsEOACoJD55YgenTn6+1 Oj1BpSwjt9xDsoHmY4U4J5H04qmk2nylAloxjkjEm7zSCVB+9jOSRjr14q9b21tJEGFsyLv3KHYn Pv16Hriqkorp/X3iTb6iLqMawJJcr5JcEgAlwAPUgUq6paMxXzcMM5G1u3PXFSPZW8jRl4gfLBCr ngZ68UpsrYggwIQck/j1qL0/MfvFZ9aslQMkhkyVACg9+n9KlGpWpeSMSAyx5DIM9QMkZp8djbRM CkQAAwqnkD/OB+VCWNvG+5I8cEbc8c9aH7PzD3ilHrSu6qYMFlBG2TOc9Oqipk1WJpvJKMs3mLHt 68nqc+g/w9attbwuCGjUg46+wx/Kmra26Y2woCCCDjnjHf8AAUN0+wWl3IRqlq+RHJufoqkFdx9M kfT86YurQhYRMuySQBigJbapzySB7c+lWPsduJI3EYBQ5AHToB/QU1tPtHYM1upIAA5PQdKL0+zD 3iNNVtpImdW+4V8wf3N3TNQSa5boH2ozEEbecbhg85xx0NXltLdFdVhUK4ww7GkaztmjMZhXZxwO On/6zQnTvswtLuUX1oRuyGAbl29JD32/7PT5v/rVZfUoIpXjmJjKKGJ2kjpnripWsrZ4xG0WVByP mOc8c5znPAoeztpGDPCrEDAJz6YovT7BaXchGq2bZ2y5AJU4Ukgjrxj9aaNXtCzYY7Fj8xnIIAXp 06+n51JNplrMADGV+fedpxk+n09qkNlbFSpgTBxn8OlH7vzD3xn9pWhjVxLlWcICFPU9BVqo4YEg QqgOCcknqT/nFSVErdClfqNf7tOt+rU1/u0636tWU9hjrm2iu4TFMpKEg/KxUg+xBBFUzoWmmXzV tijggho5XTGAQMYIwOTwODk1o0VhcYo61z/h/wD5F+y/65/1NdAOtc/4f/5F+y/65/1NXT3A5vxj /wAheL/rgP8A0JqKPGP/ACF4v+uA/wDQmoroQjpPDuP+Ea0nPT7HD/6AKuxWVlDAYI7dFiOAUA4P OeR9TXh2m/FrXrTS7S2jtNNKRQpGpaN8kBQOfnqz/wALh8Qf8+emf9+pP/i6authWTPaPsVpsRFj KBCSuxmUqT1wQacLa1DbhEN3HPOTyT/Mn868V/4XD4g/589M/wC/Un/xdH/C4fEH/Pnpn/fqT/4u jml3CyPaRaWyvuVWUldpAdgCMY5GcGrAZVAA4AGBXh3/AAuHxB/z56Z/36k/+Lo/4XD4g/589M/7 9Sf/ABdDbe4WSPcd4o3ivDv+Fw+IP+fPTP8Av1J/8XR/wuHxB/z56Z/36k/+LpWYz3HeKN4rw7/h cPiD/nz0z/v1J/8AF0f8Lh8Qf8+emf8AfqT/AOLoswPcd4o3ivDv+Fw+IP8Anz0z/v1J/wDF0f8A C4fEH/Pnpn/fqT/4uizA9x3ijeK8O/4XD4g/589M/wC/Un/xdH/C4fEH/Pnpn/fqT/4uizA9x3ij eK8O/wCFw+IP+fPTP+/Un/xdH/C4fEH/AD56Z/36k/8Ai6LMD3HeKN4rw7/hcPiD/nz0z/v1J/8A F0f8Lh8Qf8+emf8AfqT/AOLoswPcd4o3ivDv+Fw+IP8Anz0z/v1J/wDF0f8AC4fEH/Pnpn/fqT/4 uizA9x3ijeK8O/4XD4g/589M/wC/Un/xdH/C4fEH/Pnpn/fqT/4uizA9wZgRxVW6vbmzRWttOlvW Y4Kxyom0evzEV4z/AMLh8Qf8+emf9+pP/i6P+Fw+IP8Anz0z/v1J/wDF0nG6sB65/bmq/wDQs3X/ AIFwf/FUf25qv/Qs3X/gXB/8VXkf/C4fEH/Pnpn/AH6k/wDi6P8AhcPiD/nz0z/v1J/8XWfsV3A9 c/t3Vf8AoWbr/wAC4P8A4qn6LBNa6LaQXEflzJHh03Btp9Mjg15B/wALh8Qf8+emf9+pP/i6P+Fw +IP+fPTP+/Un/wAXVRp2A7fxj/yF4v8ArgP/AEJqK8r1r4lazf3iSy21gGEYX5Y3xjJ/2veitEgP /9k= ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0057_image009.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhPgAiAHcAMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAAALAMABAA2 ABoAgAAAAP//AAJVhI+pG7EPo2TNzYtjrbn7vXmiBILjmZQliqoqK7ounMkyPdm2ovf+j/gJhy8A 8YhMKnvGpdOESyWjFCL1Yb1igVqIr0vagcPFMTlkvkDT6ga7Y4EVAAA7 ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0057_image010.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhIgAxAHcAMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAAALAQAAwAa ACoAgAAAAP//AAJahI+hiu2+2JstBoqNzXjz6X1QJD5heZwooKJt+YrxN3N1dlv6zve+rvkJg8Je osg7IltLZlMyaoKkFOq0aMPihrSfzOcywpIrcvhWRV+hK+KlnWLDWe+55lMAADs= ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0057_image011.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhIAFTAHcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G RklDRTkuMBMAAAAHdElNRQfYAxgJMRw9OVEwACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAG9vRwjwAsAAAAACABUwCDAAAAcW9krKiZ7OnY8e/i//// AQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDAQIDA/84tNz+MMpJq7046827/yA1jGRpnmiqrmzr vnAsz3Rt33iu73zv/8CgcEgsGo/IpHLJbDqf0Kh0Sq1ar9isdjsTeL/gsHhMLpvP6LR6zW673/C4 fH4eCAL4vH7P7/v/gIGCg4SFhoeIiYqLjI2AdgEFkpOUlZaXmJmam5ydnp+goaKjpKWmp5mQqKus ra6vsLGys6qztre4ubq7srW8v8DBwsOuvsTHyMnKwL4AzgCTz8+S0JXSzpTTBdfY1t3R39vW29zR ltrc0NXXl+Xl2eHV4+fh5PLi2fbS5t7r78uiat1b1+4cJnkDD/LDxzBevnkLE/KT+LAitYgLLV7c 2BD/nMV7HDlSBDhK4EOQIVOmRFgwH0iCLDOKi4lxIkSVL1dSe5nT5Tx1GXPSFEmylEmDSDWqlLm0 J9CQQpkG1anU6c+OPW/ie8qw60ypS4t2aqZN39CdZVFKVWt160ebCuHKZGf2LExzWTUSdDt1o9qw YjcZk1u1pWGlXvd+7cv3sGKqb6neTXy4MdeuMf96DTz2DtSmSfWuHdd2MdR9lD+nZlra78XHlEtf Hog6q2bOmI66Dh126F+awOFVlB15JE6IwYkir4mZInGwuHN7RouQrju6aLXC42ncOfJ6ErEX/uiQ d/btopmLBB/90+D28OPLt/V+vv37+EPVz8+/v//9//4FKCB8AA5o4IHLFIjgggz+oiBgl21lHXb/ VAXehd3plI6EZXmSkD+onRbiO0K5cxI7UYXmVIiwPLgZXlfxBltlyXWk3EQjhYdYJh9CluGL5alm o2hsCUfYbaa4OCRsM6aGJFcpwnjSVb5NuWNLJk5pF2hVHmnYjFDamFcrSibX2lyAvTaajJINiRlk 1GkWppZoAulmjztGSJqUjaVp1HScmEniiBSyqFyRbDq5m2pjetiQdTgSmtaizXHHHo9w7dXoKkp+ NSdhjN2WWWVtWmnam6vFielZhw73JaqUyqnJqGqmSiaggXpaJ6Kg9tNNlLWCqthspvpJT23tIFss Rv85qqfddr9KuSkqnd4Zo1ZNlrqkejWSU9yVs8KK5pmnRUbpsxoaadytkXzSZaTo/CSebRj2c2x6 jBrqrrjpnqgsY7HNi6lP/tZTDK4NJqywLtUu7PDD+iEM8cQUlyRxxRhnnMrFGnfcccMeh8wgyMYu gyeSu6AsciwkvxjXMCfvO4vKK7/SMs0upxynngPLgnPNrNwMDm3ZqUMbS78efazBfFZHtD0zKf2a P+gBHYzQMWoK5k5cWzbKp5n6tbW3ZA9rNTMc50pdX8DFe6ih4u253jc6zm222B2enQvW795Nq5il kHgj4Ive3afevPAdtteEN/5zsIxr2mrhcj2OeJKeaW/idHUEPxrtjXk76lxaeHpuuNOX79Jy6qwX tXrrsCfzeuy0CzN77birnnnuvCNze+/At7h78MTr3m7xyNs+fPLMC39889Df8nv01G/8fPXYB718 9tx3dn334Ef8ffjkczJ9+dCfjz7z6q+PfPvuEw9//MDPTz/v9t+Pe/76085//7D7HwBZJ8ABXq6A BtQbAhNotQUysGYOfKDIEgAAOw== ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0057_image012.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhHAFCAHcAMSH/C01TT0ZGSUNFOS4wFQAAAAlwSFlzAAAOxAAADsQBlSsOGwAh/wtNU09G RklDRTkuMBMAAAAHdElNRQfYAxgJMi1HygLJACH+CEF1dGhvcjogACH+DURlc2NyaXB0aW9uOiAA If4LQ29weXJpZ2h0OiAAIf4PQ3JlYXRpb24gdGltZTogACH+ClNvZnR3YXJlOiAAIf4MRGlzY2xh aW1lcjogACH+CVdhcm5pbmc6IAAh/ghTb3VyY2U6IAAh/gAh/gdUaXRsZTogACH/C01TT0ZGSUNF OS4wGAAAAAxtc09QTVNPRkZJQ0U5LjAFb/0hNQAsAAAAABwBQgCCAAAAcW9krKiZ7OnY////AQID AQIDAQIDA/84utz+MMpJq7046827/2AojmRpnmiqrmzrvvAqzHRt33iu73zv/8CgcEgsGo9I20IQ aDqf0Kh0Sq1ar9isdsvter/gsPi5DBDO6LR6zW673/C4fE6v2+/4vH7PR5cJAH2Cg4SFhoeIiYJ/ gYqOj5CRkpN9jJSXmJmam3uWnJ+goaKQlgCmjYCnpmeoaKqrrrCvsGmnaraut6mvubeys4CsqmzA wLW0wWutscu4rLqzqMu7wryjcoytjdPJtW3S3sS93dLa4efP6erJ5rru4+Dr4/D0wujTzfPc127Z 4dz4xJ0DCM1doHjyDs4j9++dvG7p8qXy5TCYRIXr8iFUt4//Hxt/ygSiWzjyIUR2DBdiPHkvYcWT 2wwylFgx5kaNJHN6/KiAiUVn1lgG7UgwZEOU+noRPapy2C6gMsHRHBkTaUalbjruTOMJq9GSLHMW 9WqxZcSsTF063IgU41SVHCG2s/p1a7+eZpBVfTk2bt2yTFfKdUqz3duAadvShcl45j3C77TaJQDy 7N+wKU1mRqht7sWkZIX+5VxPtN/ME0tbljv5TSmg1ooFpQa2mq+5V9XSBj2b5FRnYQEi2934NMfh ku12bc28ufNEy59Ln06dzp/q2LNr54p3u/fvz6+DH0/+mvjy6NNjOo/2W2Njxp4OfwicOPHP3qKx c0rH3LbZ/53xBx80xfzDC051XcRfJd3FsRR+NWlGVWmkqaWXWbg5mJ9uGe51jFmnIZZLXxeytkiD GvoF4YSYjQgXgqGhdFNiySl1YFRwBYeaYWDFE5BUMdYYB3vtpbRijpKt1BeSOOa2WkILFmQhaos9 M6OLtQkWEpBPtlgHke6pCJ+AQ0VppEgs4uchj7XBoWRsNpIJFV0B3obcGz5a9lYeYLqnEFseguZl npe9J5OVGNZkJpY6PslWXLitWaRIe7n1Eh59ivMnk6NJKJ9LMHZZqYmi2jGgMpAlBimIj+pUjSxY 7okpinJcGeOUYZJV4Y6qlegoHoKJiKiqg4FYpauhwuqqHcKZUpomnAYuWBhy1OLjq5P71dcfqS8a BK2gjMXXYqjZzqdHs+qlq+4g6K7r7rtf0grvvPTO0W69+NJ7b778rrtvvwCj92/ABH83cMEIY3dw wgyHJ2/DEG+3cMQUezRxxRiHcnHGHGuycccgT/JxyCQ7MnLJKBtycsosMziATy3HnMnKMtds3cM2 53wIzTr3vAbPPgdNGc5CF80s0UYnPSTSSjfN08tmOC01HEBPzXLVVqOMddYkb801yF5/zXHYYmOc AAA7 ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0057_image013.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhOQBXAHcAMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAAALAEAAQA3 AFUAgAAAAP8AAALihI+pFu2+opwSRkuzbpqFDipfyJAgZ3rpNK5H675xArv1DNykjvMbXkn5gDnT EHgUESlJ2ZLZaRKb0mWyOoU+o6wt9+I9gcM/JfmLwIZvam+tvU6fQzC4Wz4XF/N6e3zPV+Z3BxiY gWK4Mbi26Na4hZjI9PgUKVlBaZU5tYnU2fM5Y3m5MEpKExpjevqSauO6sspaBGtUOFtyiztSS5eL 66TL2tJb9ruLB/ymbDbLxtxMylM8Vno6RE2jlXh1ScWNxldVrFYLB3t+5he62PmYCd/4uZ6aPofB Iuuog+/9oN+hAAA7 ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0058.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Run Time

At run time

&= #8226;Source record comes in

= 226;Inaport will generate SQL, changing ‘#fieldName’ to ‘value of field’ =

&= #8226;SQL will be executed against target table <= /div>

•Primary keys returned will b= e sued as matches

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0059.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Benefits

&= #8226;No up front cost of building indexes

&= #8226;Run starts immediately

&= #8226;No memory cost of in memory indexes

•

&#= 8226;For large target tables, and/or small import runs, speed can be greatly improved

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0060.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Drawbacks<= span style=3D'mso-special-format:lastCR;display:none'>

•Can only be used with target= s that support SQL

&= #8226;Not ACT!

&= #8226;Expressions restricted to SQL

&= #8226;No normcomp(), regular expressions

&= #8226;Requires understanding of SQL

&= #8226;May require database tuning

&= #8226;SQL executed for each= incoming record

= 226;Search on non-indexed field can have significant SQL Server performance impact

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0061.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

Summary

SQL Matching is good fit:

&#= 8226;Target table is much larger than import table, or

&= #8226;Target table is very large

&#= 8226;Depends on system, but > 2-400,000 records

•

Remember

&#= 8226;You can mix and match – use different match techniques on different tables

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/slide0049.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1

THANK YOU

www.inapl= ex.com

www.inaplex.com/cs/forums

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/master04_stylesheet.css Content-Transfer-Encoding: base64 Content-Type: text/css Ym9keQ0KCXt3aWR0aDo1MzRweDsNCgloZWlnaHQ6NDAwcHg7fQ0KLlRCDQoJe21zby1zcGVjaWFs LWZvcm1hdDpub2J1bGxldFwyMDIyO30NCi5UDQoJe3RleHQtYWxpZ246bGVmdDsNCglmb250LWZh bWlseTpBcmlhbDsNCgljb2xvcjojRkZGRjk5Ow0KCWZvbnQtc2l6ZToyMDklOw0KCW1zby1jaGFy LXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5CQg0KCXttc28tc3BlY2lhbC1m b3JtYXQ6bm9idWxsZXRcMjAyMjt9DQouQg0KCXt0ZXh0LWFsaWduOmxlZnQ7DQoJZm9udC1mYW1p bHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNGRkZGOTk7DQoJZm9udC1zaXplOjE1 MiU7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLkIxQg0K CXttc28tc3BlY2lhbC1mb3JtYXQ6YnVsbGV0XDIwMjI7DQoJZm9udC1mYW1pbHk6QXJpYWw7fQ0K LkIxDQoJe3RleHQtYWxpZ246bGVmdDsNCglmb250LWZhbWlseToiTHVjaWRhIFNhbnMgVW5pY29k ZSI7DQoJY29sb3I6I0ZGRkY5OTsNCglmb250LXNpemU6MTMzJTsNCgltc28tY2hhci13cmFwOjE7 DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouQjJCDQoJe21zby1zcGVjaWFsLWZvcm1hdDpi dWxsZXRcMjAyMjt9DQouQjINCgl7dGV4dC1hbGlnbjpsZWZ0Ow0KCWZvbnQtZmFtaWx5OiJMdWNp ZGEgU2FucyBVbmljb2RlIjsNCgljb2xvcjojRkZGRjk5Ow0KCWZvbnQtc2l6ZToxMTQlOw0KCW1z by1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5CM0INCgl7bXNvLXNw ZWNpYWwtZm9ybWF0OmJ1bGxldFwyMDEzO30NCi5CMw0KCXt0ZXh0LWFsaWduOmxlZnQ7DQoJZm9u dC1mYW1pbHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNGRkZGOTk7DQoJZm9udC1z aXplOjk1JTsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQou QjRCDQoJe21zby1zcGVjaWFsLWZvcm1hdDpidWxsZXRcMDBCQjt9DQouQjQNCgl7dGV4dC1hbGln bjpsZWZ0Ow0KCWZvbnQtZmFtaWx5OiJMdWNpZGEgU2FucyBVbmljb2RlIjsNCgljb2xvcjojRkZG Rjk5Ow0KCWZvbnQtc2l6ZTo5NSU7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92 ZXJmbG93OjE7fQ0KLk4NCgl7bXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93 OjE7fQ0KLk4xDQoJe21zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30N Ci5OMg0KCXttc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouTjMN Cgl7bXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLk40DQoJe21z by1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5PQg0KCXttc28tc3Bl Y2lhbC1mb3JtYXQ6bm9idWxsZXRcMjAyMjt9DQouTw0KCXt0ZXh0LWFsaWduOmxlZnQ7DQoJZm9u dC1mYW1pbHk6QXJpYWw7DQoJY29sb3I6YmxhY2s7DQoJbXNvLWNvbG9yLWluZGV4OjE7DQoJZm9u dC1zaXplOjg1JTsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9 DQouTzENCgl7bXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLk8y DQoJe21zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5PMw0KCXtt c28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouTzQNCgl7bXNvLWNo YXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLkNCQg0KCXttc28tc3BlY2lh bC1mb3JtYXQ6bm9idWxsZXRcMjAyMjt9DQouQ0INCgl7dGV4dC1hbGlnbjpjZW50ZXI7DQoJZm9u dC1mYW1pbHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNGRkZGOTk7DQoJZm9udC1z aXplOjE1MiU7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0K LkNCMUINCgl7bXNvLXNwZWNpYWwtZm9ybWF0Om5vYnVsbGV0XDIwMjI7DQoJZm9udC1mYW1pbHk6 QXJpYWw7fQ0KLkNCMQ0KCXtmb250LWZhbWlseToiTHVjaWRhIFNhbnMgVW5pY29kZSI7DQoJY29s b3I6I0ZGRkY5OTsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9 DQouQ0IyDQoJe2ZvbnQtZmFtaWx5OiJMdWNpZGEgU2FucyBVbmljb2RlIjsNCgljb2xvcjojRkZG Rjk5Ow0KCW1zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5DQjMN Cgl7Zm9udC1mYW1pbHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNGRkZGOTk7DQoJ bXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLkNCNA0KCXtmb250 LWZhbWlseToiTHVjaWRhIFNhbnMgVW5pY29kZSI7DQoJY29sb3I6I0ZGRkY5OTsNCgltc28tY2hh ci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouQ1RCDQoJe21zby1zcGVjaWFs LWZvcm1hdDpub2J1bGxldFwyMDIyO30NCi5DVA0KCXt0ZXh0LWFsaWduOmNlbnRlcjsNCglmb250 LWZhbWlseTpBcmlhbDsNCgljb2xvcjojRkZGRjk5Ow0KCWZvbnQtc2l6ZToyMDklOw0KCW1zby1j aGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5IQkINCgl7bXNvLXNwZWNp YWwtZm9ybWF0Om5vYnVsbGV0XDIwMjI7fQ0KLkhCDQoJe2ZvbnQtZmFtaWx5OiJMdWNpZGEgU2Fu cyBVbmljb2RlIjsNCgljb2xvcjojRkZGRjk5Ow0KCW1zby1tYXJnaW4tbGVmdC1hbHQ6MDsNCglt c28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouSEIxQg0KCXttc28t c3BlY2lhbC1mb3JtYXQ6YnVsbGV0XDIwMjI7DQoJZm9udC1mYW1pbHk6QXJpYWw7fQ0KLkhCMQ0K CXtmb250LWZhbWlseToiTHVjaWRhIFNhbnMgVW5pY29kZSI7DQoJY29sb3I6I0ZGRkY5OTsNCglt c28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouSEIyDQoJe2ZvbnQt ZmFtaWx5OiJMdWNpZGEgU2FucyBVbmljb2RlIjsNCgljb2xvcjojRkZGRjk5Ow0KCW1zby1jaGFy LXdyYXA6MTsNCgltc28ta2luc29rdS1vdmVyZmxvdzoxO30NCi5IQjMNCgl7Zm9udC1mYW1pbHk6 Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNGRkZGOTk7DQoJbXNvLWNoYXItd3JhcDox Ow0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLkhCNA0KCXtmb250LWZhbWlseToiTHVjaWRh IFNhbnMgVW5pY29kZSI7DQoJY29sb3I6I0ZGRkY5OTsNCgltc28tY2hhci13cmFwOjE7DQoJbXNv LWtpbnNva3Utb3ZlcmZsb3c6MTt9DQouUUJCDQoJe21zby1zcGVjaWFsLWZvcm1hdDpub2J1bGxl dFwyMDIyO30NCi5RQg0KCXtmb250LWZhbWlseToiTHVjaWRhIFNhbnMgVW5pY29kZSI7DQoJY29s b3I6I0ZGRkY5OTsNCgltc28tbWFyZ2luLWxlZnQtYWx0OjA7DQoJbXNvLWNoYXItd3JhcDoxOw0K CW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLlFCMUINCgl7bXNvLXNwZWNpYWwtZm9ybWF0OmJ1 bGxldFwyMDIyOw0KCWZvbnQtZmFtaWx5OkFyaWFsO30NCi5RQjENCgl7Zm9udC1mYW1pbHk6Ikx1 Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNGRkZGOTk7DQoJbXNvLWNoYXItd3JhcDoxOw0K CW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLlFCMg0KCXtmb250LWZhbWlseToiTHVjaWRhIFNh bnMgVW5pY29kZSI7DQoJY29sb3I6I0ZGRkY5OTsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtp bnNva3Utb3ZlcmZsb3c6MTt9DQouUUIzDQoJe2ZvbnQtZmFtaWx5OiJMdWNpZGEgU2FucyBVbmlj b2RlIjsNCgljb2xvcjojRkZGRjk5Ow0KCW1zby1jaGFyLXdyYXA6MTsNCgltc28ta2luc29rdS1v dmVyZmxvdzoxO30NCi5RQjQNCgl7Zm9udC1mYW1pbHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0K CWNvbG9yOiNGRkZGOTk7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93 OjE7fQ0KLlRibA0KCXtmb250LWZhbWlseToiTHVjaWRhIFNhbnMgVW5pY29kZSI7DQoJY29sb3I6 I0ZGRkY5OTsNCgltc28tY2hhci13cmFwOjE7DQoJbXNvLWtpbnNva3Utb3ZlcmZsb3c6MTt9DQou VGJsMUINCgl7bXNvLXNwZWNpYWwtZm9ybWF0Om5vYnVsbGV0XDIwMjI7DQoJZm9udC1mYW1pbHk6 QXJpYWw7fQ0KLlRibDENCgl7Zm9udC1mYW1pbHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNv bG9yOiNGRkZGOTk7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7 fQ0KLlRibDINCgl7Zm9udC1mYW1pbHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNG RkZGOTk7DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLlRi bDMNCgl7Zm9udC1mYW1pbHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNGRkZGOTk7 DQoJbXNvLWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLlRibDQNCgl7 Zm9udC1mYW1pbHk6Ikx1Y2lkYSBTYW5zIFVuaWNvZGUiOw0KCWNvbG9yOiNGRkZGOTk7DQoJbXNv LWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7fQ0KLmRlZmF1bHRCDQoJe21z by1zcGVjaWFsLWZvcm1hdDpub2J1bGxldFwyMDIyO30NCi5kZWZhdWx0DQoJe3RleHQtYWxpZ246 bGVmdDsNCglmb250LWZhbWlseTpBcmlhbDsNCglmb250LXdlaWdodDpub3JtYWw7DQoJZm9udC1z dHlsZTpub3JtYWw7DQoJdGV4dC1kZWNvcmF0aW9uOm5vbmU7DQoJdGV4dC1zaGFkb3c6bm9uZTsN Cgl0ZXh0LWVmZmVjdDpub25lOw0KCW1zby1mYXJlYXN0LWhpbnQ6bm87DQoJbGF5b3V0LWZsb3c6 aG9yaXpvbnRhbDsNCgljb2xvcjpibGFjazsNCgltc28tY29sb3ItaW5kZXg6MTsNCglmb250LXNp emU6ODUlOw0KCW1zby10ZXh0LXJhaXNlOjAlOw0KCW1zby1saW5lLXNwYWNpbmc6IjEwMCAwIDAi Ow0KCW1zby1tYXJnaW4tbGVmdC1hbHQ6MDsNCgltc28tdGV4dC1pbmRlbnQtYWx0OjA7DQoJbXNv LWNoYXItd3JhcDoxOw0KCW1zby1raW5zb2t1LW92ZXJmbG93OjE7DQoJZGlyZWN0aW9uOmx0cjsN Cgltc28td29yZC13cmFwOjE7DQoJbXNvLXZlcnRpY2FsLWFsaWduLXNwZWNpYWw6YmFzZWxpbmU7 DQoJbXNvLWFuc2ktbGFuZ3VhZ2U6RU4tVVM7fQ0KYTpsaW5rDQoJe2NvbG9yOiMwMDk5OTkgIWlt cG9ydGFudDt9DQphOmFjdGl2ZQ0KCXtjb2xvcjojMzMzMzk5ICFpbXBvcnRhbnQ7fQ0KYTp2aXNp dGVkDQoJe2NvbG9yOiM5OUNDMDAgIWltcG9ydGFudDt9DQp= ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/script.js Content-Transfer-Encoding: quoted-printable Content-Type: application/javascript; charset="us-ascii" function LoadSld() { var sld=3DGetObj("SlideObj") if( !g_supportsPPTHTML ) { =09 sld.style.visibility=3D"visible" return } if( MakeNotesVis() ) return runAnimations =3D _InitAnimations(); =09 if( IsWin("PPTSld") ) parent.SldUpdated(GetSldId()) g_origSz=3DparseInt(SlideObj.style.fontSize) g_origH=3Dsld.style.posHeight g_origW=3Dsld.style.posWidth g_scaleHyperlinks=3D(document.all.tags("AREA").length>0) if( g_scaleHyperlinks ) InitHLinkArray() if( g_scaleInFrame||(IsWin("PPTSld") && parent.IsFullScrMode() ) ) document.body.scroll=3D"no" _RSW() if( IsWin("PPTSld") && parent.IsFullScrMode() ) FullScrInit(); =09 MakeSldVis(); ChkAutoAdv() if( runAnimations ) { if( document.all("NSPlay") ) document.all("NSPlay").autoStart =3D false; if( sld.filters && sld.filters.revealtrans ) setTimeout( "document.body.start()", sld.filters.revealtrans.duration * = 1000 ); else document.body.start(); } } function MakeSldVis()=20 { var fTrans=3Dg_showAnimation && SldHasTrans() if( fTrans )=09 { if( g_bgSound ) { idx=3Dg_bgSound.indexOf(","); pptSound.src=3Dg_bgSound.substr( 0, idx ); pptSound.loop=3D -(parseInt(g_bgSound.substr(idx+1))); } SlideObj.filters.revealtrans.Apply()=09 } SlideObj.style.visibility=3D"visible" if( fTrans ) SlideObj.filters.revealtrans.Play() } function MakeNotesVis()=20 { if( !IsNts() ) return false=20 SlideObj.style.display=3D"none" nObj =3D document.all.item("NotesObj") parent.SetHasNts(0) if( nObj ) {=20 nObj.style.display=3D"" parent.SetHasNts(1) } return 1 } function ChkAutoAdv() { if(SldHasTrans()) SlideObj.onfilterchange=3DAutoAdv else AutoAdv() } function AutoAdv() { if(!IsWin("PPTSld") || !gUseSldTimings )return var sld=3DGetCurSld() if( (sld.mAdvDelay>0) && !parent.IsFramesMode() ) setTimeout("parent.GoToNextSld()",sld.mAdvDelay) } function GetObj(id) { if(g_supportsPPTHTML) return document.all(id); else return document.getElementById(id); } function SldHasTrans() { return SlideObj.style.filter !=3D ""; } function GetSldId()=20 { var regExp =3D /file:\/\/\//i var pos =3D location.href.search(regExp) if (MHTMLPrefix !=3D "" && pos !=3D -1) sId =3D location.href.substring(pos) else { sId =3D RemoveFilePrefixFromHref(location.href); var regExp =3D /\// var fixedHref =3D sId var pos =3D -1 =09 pos =3D fixedHref.search(regExp) while (pos !=3D -1) { fixedHref =3D fixedHref.replace(regExp, "\\") pos =3D fixedHref.search(regExp) } =09 if (g_fBaseHyperlink =3D=3D true) sId =3D "file:///" + fixedHref; else sId =3D fixedHref.substring(fixedHref.lastIndexOf('\\') + 1) } =09 return sId } function HideMenu() { if( frames["PPTSld"] && PPTSld.document.all.item("ctx= tmenu") && PPTSld.ctxtmenu.style.display!=3D"none" ) { PPTSld.ctxtmenu.styl= e.display=3D'none'; return true } return false } function IsWin( name ) { return window.name =3D=3D name } function IsNts() { return IsWin("PPTNts") } function IsSldOrNts() { return( IsWin("PPTSld")||IsWin("PPTNts") ) } function SupportsPPTAnimation() { return( navigator.platform =3D=3D "Win32"= && navigator.appVersion.indexOf("Windows")>0 ) } function SupportsPPTHTML() { var appVer=3Dnavigator.appVersion, msie=3DappVer.indexOf("MSIE "), ver=3D0 if( msie >=3D 0 ) ver=3DparseFloat( appVer.substring( msie+5, appVer.indexOf(";",msie) ) ) else ver=3DparseInt(appVer) return( ver >=3D 4 && msie >=3D 0 ) } function _RSW() { if( !g_supportsPPTHTML || IsNts() || ( !g_scaleInFrame && (!IsWin("PPTSld") || !parent.IsFullScrMode()) ) ) return var padding=3D0; if( IsWin("PPTSld") && parent.IsFramesMode() ) padding=3D6 cltWidth=3Ddocument.body.clientWidth-padding cltHeight=3Ddocument.body.clientHeight-padding factor=3D(1.0*cltWidth)/g_origW if( cltHeight < g_origH*factor ) factor=3D(1.0*cltHeight)/g_origH newSize =3D g_origSz * factor if( newSize < 1 ) newSize=3D1 s=3DSlideObj.style s.fontSize=3DnewSize+"px" s.posWidth=3Dg_origW*factor s.posHeight=3Dg_origH*factor s.posLeft=3D(cltWidth-s.posWidth+padding)/2 s.posTop=3D(cltHeight-s.posHeight+padding)/2 if( g_scaleHyperlinks ) ScaleHyperlinks( factor ) } function _InitAnimations() { animRuntimeInstalled =3D ''+document.body.localTime !=3D 'undefined'; isFullScreen =3D (window.name =3D=3D "PPTSld") && !parent.IsFramesMode(); g_animUseRuntime =3D g_showAnimation && animRuntimeInstalled && !(isFullSc= reen && parent.IsSldVisited()); if( g_animUseRuntime ) { collSeq =3D document.all.tags("seq"); if( collSeq !=3D null ) { for(ii=3D0;ii numSlds ) gSldJumpIdx =3D numSlds; if ( gSldJumpIdx >=3D 0 ) { if ( gSldJumpIdx =3D=3D 0 ) gSldJumpIdx =3D 1; var jumpTo =3D parseInt(gSldJumpIdx); gSldJump =3D 0; gSldJumpIdx =3D ""; win.GoToSld( parent.GetSldList().mList[jumpTo-1].mSldHref ) } } } function _KDH() { if( event.keyCode =3D=3D 8 ) { event.returnValue =3D 0; parent.GoToPrevSld(); } } function DocumentOnClick() { if( IsNts() || parent.HideMenu() ) return; if( ( g_allowAdvOnClick && !parent.IsFramesMode() ) || (event && (event.keyCode=3D=3D32) ) ) parent.GoToNextSld(); } var g_supportsPPTHTML =3D SupportsPPTHTML(), g_scaleInFrame =3D 1, gId=3D""= , g_bgSound=3D"", g_scaleHyperlinks =3D false, g_allowAdvOnClick =3D 1, g_showInBrowser = =3D 0, gLoopCont =3D 0, gUseSldTimings =3D 1; var g_showAnimation =3D g_supportsPPTHTML && SupportsPPTAnimation() && ( (w= indow.name=3D=3D"PPTSld" && !parent.IsFramesMode()) || g_showInBrowser );va= r g_animManager =3D null; var g_animUseRuntime =3D false; var g_animItemsToHide, g_animInteractiveItems, g_animSlideTime; var g_animMainSequence =3D null; var ENDSHOW_MESG=3D"End of slide show, click to exit.", SCREEN_MODE=3D"Fram= es", gIsEndShow=3D0, NUM_VIS_SLDS=3D16, SCRIPT_HREF=3D"script.js", FULLSCR_= HREF=3D"fullscreen.htm"; var gCurSld =3D gPrevSld =3D 1, g_offset =3D 0, gNtsOpen =3D gHasNts =3D gO= tlTxtExp =3D 0, gHasNarration =3D 0, gOtlOpen =3D true window.gPPTHTML=3DSupportsPPTHTML() var g_fBaseHyperlink =3D false; var gMainDoc=3Dnew Array(new hrefList("slide0001.htm",1,-1,1),new hrefList(= "slide0007.htm",1,-1,1),new hrefList("slide0018.htm",1,-1,1),new hrefList("= slide0051.htm",1,-1,1),new hrefList("slide0012.htm",1,-1,1),new hrefList("s= lide0052.htm",1,-1,1),new hrefList("slide0053.htm",1,-1,1),new hrefList("sl= ide0054.htm",1,-1,1),new hrefList("slide0055.htm",1,-1,1),new hrefList("sli= de0056.htm",1,-1,1),new hrefList("slide0057.htm",1,-1,1),new hrefList("slid= e0058.htm",1,-1,1),new hrefList("slide0059.htm",1,-1,1),new hrefList("slide= 0060.htm",1,-1,1),new hrefList("slide0061.htm",1,-1,1),new hrefList("slide0= 049.htm",1,-1,1)); /********************************************* Frameset functions These functions control slide navigation and state of the frameset. **********************************************/ function RemoveFilePrefixFromHref(href) { var regExp =3D /^file:\/\/\//i; return href.replace(regExp, "") } function FullScrInit() { g_allowAdvOnClick =3D GetCurSld().mAdvOnClk document.body.style.backgroundColor=3D"black" document.oncontextmenu=3Dparent._CM; document.onkeydown =3D _KDH; document.ondragstart=3DCancel document.onselectstart=3DCancel self.focus() } function Redirect( frmId ) {=09 var str=3Ddocument.location.hash,idx=3Dstr.indexOf('#'), sId=3DGetSldId() if(idx>=3D0) str=3Dstr.substr(1); if( window.name !=3D frmId && ( sId !=3D str) ) { obj =3D GetObj("Main-File") window.location.href=3Dobj.href+"#"+sId return 1 } return 0 } var MHTMLPrefix =3D CalculateMHTMLPrefix();=20 function CalculateMHTMLPrefix() { if ( document.location.protocol =3D=3D 'mhtml:') {=20 href=3Dnew String(document.location.href)=20 Start=3Dhref.indexOf('!')+1=20 End=3Dhref.lastIndexOf('/')+1=20 if (End < Start)=20 return href.substring(0, Start)=20 else=20 return href.substring(0, End)=20 } return ''; } function GetTags(base,tag) { if(g_supportsPPTHTML) return base.all.tags(tag); else return base.getElementsByTagName(tag); } function UpdNtsPane(){ if(frames["PPTNts"]) PPTNts.location.replace( MHTMLP= refix+GetHrefObj( gCurSld ).mNtsHref ) } function UpdNavPane( sldIndex ){ if(gNavLoaded) PPTNav.UpdNav() } function UpdOtNavPane(){ if(gOtlNavLoaded) PPTOtlNav.UpdOtlNav() } function UpdOtlPane(){ if(gOtlLoaded) PPTOtl.UpdOtl() } function SetHasNts( fVal ) { if( gHasNts !=3D fVal ) { gHasNts=3DfVal UpdNavPane() } } function ToggleOtlText() { gOtlTxtExp=3D!gOtlTxtExp UpdOtlPane() } function ClearMedia() { // Clear any sounds playing before launching another browser window. Other= wise, // in fullscreen mode, you'll continue to hear the sound in the frames mod= e. if (PPTSld.pptSound) PPTSld.pptSound.loop =3D 0; } function FullScreen() {=20 if ( PPTSld.g_animUseRuntime ) PPTSld.document.body.pause(); ClearMedia(); var href =3D ( document.location.protocol =3D=3D 'mhtml:') ? FULLSCR_HREF = : FULLSCR_HREF+"#"+GetHrefObj(gCurSld).mSldHref; if (MHTMLPrefix !=3D "") href =3D RemoveFilePrefixFromHref(href) if(PPTNav.event.ctrlKey) { var w =3D (window.screen.availWidth * 1.0) / 2.0 var h =3D w * (PPTSld.g_origH * 1.0) / PPTSld.g_origW win =3D window.open( MHTMLPrefix+href,null,"toolbar=3D0,resizable=3D1,top= =3D0,left=3D0," + "width=3D"+ w + ",height=3D" + h ); if( win.document.body && PPTSld.g_animUseRuntime ) win.document.body.PPTSldFrameset=3Dwindow; } else { win =3D window.open( MHTMLPrefix+href,null,"fullscreen=3Dyes" ); if( win.document.body && PPTSld.g_animUseRuntime ) win.document.body.PPTSldFrameset=3Dwindow; } } function ToggleVNarration() { rObj=3DPPTSld.document.all("NSPlay") if( rObj && !PPTSld.g_animUseRuntime ) { if( (rObj.playState =3D=3D 1)||(rObj.playState =3D=3D 0) ) rObj.Play() else if( rObj.playState =3D=3D 2 ) rObj.Pause() else return; } else if( PPTSld.g_animUseRuntime ) { narObj =3D PPTSld.document.all("narrationID") if( narObj ) narObj.togglePause() } } function GetCurSldNum() { =20 obj=3DGetHrefObj(gCurSld) if( obj.mOrigVis =3D=3D 1 ) return obj.mSldIdx else =20 return gCurSld } function GetNumSlds() { =20 if( GetHrefObj(gCurSld).mOrigVis =3D=3D 1 ) return GetSldList().mNumVisSlds; else return GetSldList().mList.length } function GetSldNum( href ) { for(ii=3D0; ii 1 ) PopSldList(); else if( !IsFramesMode() ) { if( gLoopCont ) GoToFirst() else EndShow() } } function GoToPrevSld() { ii=3DgCurSld-1 if( ii > 0 ) { obj=3DGetHrefObj(ii) while ( obj && ( obj.mVis =3D=3D 0 ) && ( ii>0 ) ) obj=3DGetHrefObj(--ii) if( ii =3D=3D 0 ) ii=3D1 GoToSldNum(ii) } } function GoToFirst(){ GoToSld( GetHrefObj(1).mSldHref ) } function GoToLast() { ii=3DGetSldList().mList.length if( ii !=3D gCurSld ) GoToSld( GetHrefObj(ii).mSldHref ) } function GoToSldNum( num ) { if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue obj =3D GetHrefObj( num ) obj.mVis=3D1 gPrevSld=3DgCurSld gCurSld =3D num; =09 if (MHTMLPrefix !=3D "") PPTSld.location.replace(MHTMLPrefix+RemoveFilePrefixFromHref(obj.mSldHref= )) else PPTSld.location.replace(obj.mSldHref) =09 if( IsFramesMode() ) { UpdNavPane(); UpdOtlPane(); UpdNtsPane() } } function GoToSld( href ) { if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue GetHrefObj( GetSldNum(href) ).mVis=3D1 if (MHTMLPrefix !=3D "") PPTSld.location.replace(MHTMLPrefix+RemoveFilePrefixFromHref(href)) else PPTSld.location.replace(href) } function SldUpdated( id ) { if( id =3D=3D GetHrefObj(gCurSld).mSldHref ) return gPrevSld=3DgCurSld gCurSld=3DGetSldNum(id) if( IsFramesMode() ) { UpdNavPane(); UpdOtlPane(); UpdNtsPane() } } function PrevSldViewed(){ GoToSld( GetHrefObj(gPrevSld).mSldHref ) } function HasPrevSld() { return ( gIsEndShow || ( gCurSld !=3D 1 && GetHrefO= bj( gCurSld-1 ).mVis =3D=3D 1 )||( GetCurSldNum() > 1 ) ) } function HasNextSld() { return (GetCurSldNum() !=3D GetNumSlds()) } function CloseWindow() { if( HideMenu() ) return; =09 var event =3D PPTSld.event; if( !IsFramesMode() && event && (event.keyCode=3D=3D27 || event.keyCode=3D= =3D32 || event.type=3D=3D"click" ) ) window.close( self ); CatchNumKeys( self, event ); } function Unload() { gIsEndShow=3D0; } function SetupEndShow() { gIsEndShow=3D1; PPTSld.document.body.scroll=3D"no"; PPTSld.document.onkeypress=3DCloseWindow; PPTSld.document.onclick=3DCloseWindow; PPTSld.document.oncontextmenu=3D_CM; } function EndShow() { if( IsFramesMode() ) return if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue doc=3DPPTSld.document var dir =3D doc.body.dir if( dir !=3D "rtl" ) dir =3D "ltr"; doc.open() doc.writeln('

' + ENDSHOW_MESG + '

') doc.close() } function SetSldVisited(){ GetSldList().mList[gCurSld-1].mVisited=3Dtrue } function IsSldVisited(){ return GetSldList().mList[gCurSld-1].mVisited } function hrefList( sldHref, visible, advDelay, advClk ) { this.mSldHref=3D this.mNtsHref =3D sldHref this.mOrigVis=3D this.mVis =3D visible this.mVisited=3D false this.mAdvDelay=3D advDelay this.mAdvOnClk=3D advClk } function SldList(arr,curSld,fEnd) { this.mCurSld =3D curSld; this.mList =3D new Array(); var idx =3D 1; for(ii=3D0;ii 0) { PushSldList(sldList,fEnd); gCurSld =3D 1; } else if( PPTSld.event ) PPTSld.event.cancelBubble=3Dtrue } function PushSldList(arr,fEnd) { var ii =3D gSldStack.length; gSldStack[ii] =3D new SldList(arr,gCurSld,fEnd); GoToSld( gSldStack[ii].mList[0].mSldHref ); } function PopSldList() { if (gSldStack[gSldStack.length-1].fEndShow) EndShow() else { gCurSld =3D gSldStack[gSldStack.length-1].mCurSld; gSldStack[gSldStack.length-1] =3D null; gSldStack.length--; var sldList =3D gSldStack[gSldStack.length-1]; GoToSld( sldList.mList[gCurSld - 1].mSldHref ); } } var custShowList=3Dnew Array(); /********************************************* Navigation button implementation There are 2 types of buttons: ImgBtn, TxtBtn implemented as function objects. They share a similiar interface so the event handlers can call SetActive, for example, on a button=20 object without needing to know exactly=20 what type of button it is. **********************************************/ //---------------------------------- function ImgBtn( oId,bId,w,action ) //---------------------------------- { var t=3Dthis t.Perform =3D _IBP t.SetActive =3D _IBSetA t.SetInactive=3D _IBSetI t.SetPressed =3D _IBSetP t.SetDisabled=3D _IBSetD t.Enabled =3D _IBSetE t.ChangeIcon =3D null t.UserAction =3D action t.ChgState =3D _IBUI t.mObjId =3D oId t.mBorderId=3D bId t.mWidth =3D w t.mIsOn =3D t.mCurState =3D 0 } function _IBSetA() { if( this.mIsOn ) { obj=3Dthis.ChgState( gHiliteClr,gShadowClr,2 ) obj.style.posTop=3D0 } } function _IBSetI() { if( this.mIsOn ) { obj=3Dthis.ChgState( gFaceClr,gFaceClr,1 ) obj.style.posTop=3D0=20 } } function _IBSetP() { if( this.mIsOn ) { obj=3Dthis.ChgState( gShadowClr,gHiliteClr,2 ) obj.style.posLeft+=3D1; obj.style.posTop+=3D1 } } function _IBSetD() { =20 obj=3Dthis.ChgState( gFaceClr,gFaceClr,0 ) obj.style.posTop=3D0=20 } function _IBSetE( state ) { var t=3Dthis GetObj( t.mBorderId ).style.visibility=3D"visible" if( state !=3D t.mIsOn ) { t.mIsOn=3Dstate if( state ) t.SetInactive() else t.SetDisabled() } } function _IBP() { var t=3Dthis if( t.mIsOn ) { if( t.UserAction !=3D null ) t.UserAction() if( t.ChangeIcon ) { obj=3DGetObj(t.mObjId) if( t.ChangeIcon() ) obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-4)*t.mWidth else obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-0)*t.mWidth } t.SetActive() } =20 } function _IBUI( clr1,clr2,nextState ) { var t=3Dthis SetBorder( GetObj( t.mBorderId ),clr1,clr2 ) obj=3DGetObj( t.mObjId ) obj.style.posLeft=3Dobj.style.posLeft+(t.mCurState-nextState)*t.mWidth-obj= .style.posTop t.mCurState=3DnextState return obj } //----------------------------------------- function TxtBtn( oId,oeId,action,chkState ) //----------------------------------------- { var t=3Dthis t.Perform =3D _TBP t.SetActive =3D _TBSetA t.SetInactive=3D _TBSetI t.SetPressed =3D _TBSetP t.SetDisabled=3D _TBSetD t.SetEnabled =3D _TBSetE t.GetState =3D chkState t.UserAction =3D action t.ChgState =3D _TBUI t.mObjId =3D oId t.m_elementsId=3D oeId t.mIsOn =3D 1 } function _TBSetA() { var t=3Dthis if( t.mIsOn && !t.GetState() ) t.ChgState( gHiliteClr,gShadowClr,0,0 ) } function _TBSetI() { var t=3Dthis if( t.mIsOn && !t.GetState() ) t.ChgState( gFaceClr,gFaceClr,0,0 ) } function _TBSetP() { if( this.mIsOn ) this.ChgState( gShadowClr,gHiliteClr,1,1 ) } function _TBSetD() { =20 this.ChgState( gFaceClr,gFaceClr,0,0 ) this.mIsOn =3D 0 } function _TBSetE() { var t=3Dthis if( !t.GetState() ) t.ChgState( gFaceClr,gFaceClr,0,0 ) else t.ChgState( gShadowClr,gHiliteClr,1,1 ) t.mIsOn =3D 1 } function _TBP() { var t=3Dthis if( t.mIsOn ) {=20 if( t.UserAction !=3D null ) t.UserAction() if( !t.GetState ) return if( t.GetState() ) t.SetPressed() else t.SetActive() } =20 } function _TBUI( clr1,clr2,lOffset,tOffset ) { SetBorder( GetObj( this.mObjId ),clr1,clr2 ) Offset( GetObj( this.m_elementsId ),lOffset,tOffset ) } function Offset( obj, top, left ){ obj.style.top=3Dtop; obj.style.left=3Dle= ft } function SetBorder( obj, upperLeft, lowerRight ) { s=3Dobj.style; s.borderStyle =3D "solid" s.borderWidth =3D 1=20 s.borderLeftColor =3D s.borderTopColor =3D upperLeft s.borderBottomColor=3D s.borderRightColor =3D lowerRight } function GetBtnObj(){ return gBtnArr[window.event.srcElement.id] } function BtnOnOver(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetActive() } function BtnOnDown(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetPressed() } function BtnOnOut(){ b=3DGetBtnObj(); if( b !=3D null ) b.SetInactive() } function BtnOnUp() { b=3DGetBtnObj() if( b !=3D null ) b.Perform() else Upd() } function GetNtsState(){ return parent.gNtsOpen } function GetOtlState(){ return parent.gOtlOpen } function GetOtlTxtState(){ return parent.gOtlTxtExp } function NtsBtnSetFlag( fVal ) { s=3Ddocument.all.item( this.m_flagId ).style s.display=3D"none" if( fVal ) s.display=3D"" else s.display=3D"none" } function _BSetA_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S= etActive() } function _BSetI_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S= etInactive() } function _BSetP_Border(){ b =3D gBtnArr[this.mObjId]; if( b !=3D null ) b.S= etPressed() } function _BSetA_BorderImg() {=20 b =3D gBtnArr[this.mBorderId]=20 if( b !=3D null && this.mIsOn && !b.GetState() ) { obj=3Dthis.ChgState( gHiliteClr,gShadowClr,2 ) obj.style.posTop=3D0 } } function _BSetI_BorderImg() {=20 b =3D gBtnArr[this.mBorderId] if( b !=3D null && this.mIsOn && !b.GetState() ) { obj=3Dthis.ChgState( gFaceClr,gFaceClr,1 ) obj.style.posTop=3D0 } } var gHiliteClr=3D"THREEDHIGHLIGHT",gShadowClr=3D"THREEDSHADOW",gFaceClr=3D"= THREEDFACE" var gBtnArr =3D new Array() gBtnArr["nb_otl"] =3D new TxtBtn( "nb_otl","nb_otlElem",parent.ToggleOtlPan= e,GetOtlState ) gBtnArr["nb_otlElem"] =3D new TxtBtn( "nb_otl","nb_otlElem",parent.ToggleOt= lPane,GetOtlState ) gBtnArr["nb_nts"] =3D new ImgBtn( "nb_nts","nb_ntsBorder",10,parent.ToggleN= tsPane ) gBtnArr["nb_nts"].SetActive =3D _BSetA_BorderImg; gBtnArr["nb_nts"].SetInactive =3D _BSetI_BorderImg; gBtnArr["nb_ntsBorder"] =3D new TxtBtn( "nb_ntsBorder","nb_ntsElem",parent.= ToggleNtsPane,GetNtsState ) gBtnArr["nb_ntsElem"] =3D new TxtBtn( "nb_ntsBorder","nb_ntsElem",parent.To= ggleNtsPane,GetNtsState ) gBtnArr["nb_prevBorder"] =3D gBtnArr["nb_prev"]=3D new ImgBtn( "nb_prev","n= b_prevBorder",30,parent.GoToPrevSld ) gBtnArr["nb_nextBorder"] =3D gBtnArr["nb_next"]=3D new ImgBtn( "nb_next","n= b_nextBorder",30,parent.GoToNextSld ) gBtnArr["nb_sldshw"]=3D new ImgBtn( "nb_sldshw","nb_sldshwBorder",18,parent= .FullScreen ) gBtnArr["nb_sldshwBorder"] =3D new TxtBtn( "nb_sldshw","nb_sldshwBorder",pa= rent.FullScreen,null ) gBtnArr["nb_sldshwBorder"].SetActive =3D _BSetA_Border; gBtnArr["nb_sldshwBorder"].SetInactive =3D _BSetI_Border; gBtnArr["nb_sldshwText"] =3D new TxtBtn( "nb_sldshw","nb_sldshwText",parent= .FullScreen,null ) gBtnArr["nb_sldshwText"].SetActive =3D _BSetA_Border; gBtnArr["nb_sldshwText"].SetInactive =3D _BSetI_Border; gBtnArr["nb_voice"] =3D gBtnArr["nb_voiceBorder"] =3D new ImgBtn( "nb_voice= ","nb_voiceBorder",18,parent.ToggleVNarration ) gBtnArr["nb_otlTxtBorder"] =3D gBtnArr["nb_otlTxt"]=3D new ImgBtn( "nb_otlT= xt","nb_otlTxtBorder",23,parent.ToggleOtlText ) gBtnArr["nb_ntsBorder"].m_flagId=3D "nb_nts" gBtnArr["nb_ntsBorder"].SetFlag =3D NtsBtnSetFlag gBtnArr["nb_otlTxt"].ChangeIcon=3D GetOtlTxtState /********************************************* Context menu implementation _CM() is the function that's hooked up to the oncontextmenu event. Once we're asked to show the menu, we first build it by creating DIVs on-the-fly. Then we position it=20 within the screen area so it doesn't get clipped. Creating the DIVs using createElement() means we don't have to write out any extra HTML into the slide HTML files. **********************************************/ var sNext=3D"Next",sPrev=3D"Previous",sEnd=3D"End Show",sFont=3D"Arial",sAr= row=3D"Arrow",sFreeform=3D"Freeform",sRect=3D"Rectangle",sOval=3D"Oval" function ShowMenu() { BuildMenu(); var doc=3DPPTSld.document.body,x=3DPPTSld.event.clientX+doc.scrollLeft,y= =3DPPTSld.event.clientY+doc.scrollTop m =3D PPTSld.document.all.item("ctxtmenu") m.style.pixelLeft=3Dx if( (x+m.scrollWidth > doc.clientWidth)&&(x-m.scrollWidth > 0) ) m.style.pixelLeft=3Dx-m.scrollWidth m.style.pixelTop=3Dy if( (y+m.scrollHeight > doc.clientHeight)&&(y-m.scrollHeight > 0) ) m.style.pixelTop=3Dy-m.scrollHeight m.style.display=3D"" } function _CM() { if( !parent.IsFullScrMode() ) return; if(!PPTSld.event.ctrlKey) { ShowMenu() return false } else HideMenu() } function BuildMenu() { if( PPTSld.document.all.item("ctxtmenu") ) return var mObj=3DCreateItem( PPTSld.document.body ) mObj.id=3D"ctxtmenu" mObj.style.visibility=3D"hidden" var s=3DmObj.style s.position=3D"absolute" s.cursor=3D"default" s.width=3D"120px" SetCMBorder(mObj,"menu","black") var iObj=3DCreateItem( mObj ) SetCMBorder( iObj, "threedhighlight","threedshadow" ) iObj.style.padding=3D2 CreateMenuItem( iObj,sNext,M_GoNextSld,M_True ) CreateMenuItem( iObj,sPrev,M_GoPrevSld,M_HasPrevSld ) =09 CreateSeparator( iObj ) CreateMenuItem( iObj,sEnd,M_End,M_True ) mObj.style.visibility=3D"visible" } function Cancel() { window.event.cancelBubble=3Dtrue; window.event.returnVa= lue=3Dfalse } function Highlight() { ChangeClr("activecaption","threedhighlight") } function Deselect() { ChangeClr("threedface","menutext") } function Perform() { e=3DPPTSld.event.srcElement if( e.type=3D=3D"menuitem" && e.IsActive() ) e.Action() else PPTSld.event.cancelBubble=3Dtrue } function ChangeClr( bg,clr ) { e=3DPPTSld.event.srcElement if( e.type=3D=3D"menuitem" && e.IsActive() ) { e.style.backgroundColor=3Dbg e.style.color=3Dclr } } function M_HasPrevSld() { return( parent.HasPrevSld() ) } function M_GoNextSld() { if( gIsEndShow ) M_End(); else GoToNextSld() } function M_GoPrevSld() { if( gIsEndShow ) { gIsEndShow=3D0; history.back();= PPTSld.event.cancelBubble=3Dtrue; } else GoToPrevSld() } function M_True() { return true } function M_End() { window.close( self ) } function CreateMenuItem( node,text,action,eval ) { var e=3DCreateItem( node ) e.type=3D"menuitem" e.Action=3Daction e.IsActive=3Deval e.innerHTML=3Dtext if( !e.IsActive() ) e.style.color=3D"threedshadow" e.onclick=3DPerform e.onmouseover=3DHighlight e.onmouseout=3DDeselect s=3De.style; s.fontFamily=3DsFont s.fontSize=3D"9pt" s.paddingLeft=3D2 } function CreateSeparator( node ) { var sObj=3DCreateItem( node ) SetCMBorder(sObj,"menu","menu") var s=3DsObj.style s.borderTopColor=3D"threedshadow" s.borderBottomColor=3D"threedhighlight" s.height=3D1 s.fontSize=3D"0px" } function CreateItem( node ) { var elem=3DPPTSld.document.createElement("DIV") node.insertBefore( elem ) return elem } function SetCMBorder( o,ltClr,rbClr ) { var s=3Do.style s.backgroundColor=3D"menu" s.borderStyle=3D"solid" s.borderWidth=3D1 s.borderColor=3DltClr+" "+rbClr+" "+rbClr+" "+ltClr } ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/fullscreen.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/buttons.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhWAESAPf4AAAAAIAAAACAAICAAAAAgIAAgACAgICAgAQEBISEBASEBISEhAQEhMTExAQE /KTM9Pz8/ERERPz8BAT8/KSkpGRkhMTcxCRkxAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAMDAwP8AAAD/AP//AAAA//8A/wD//////yH5BAEAAPgALAAAAABYARIA QAj/APEJHEiwoMGDCBMqXMiwocOHECNKnEixosWLGCEiQKCRo8YDIEHig2DxAD4LKD1avDDhgUuV GUOGbHBR5QGYFBG4fHAB58EKECJEwCfUYAWPFGAygLCRKQIIUKM6WAohKUGgCikcFWh1INWoYKVS 7SrQ41GbIhGYLAuVQVOoC+IyXUuUAkG1HE3KFDhAwkgJc5/qDZmxsOHDiBMrXsy4sePDGyP7lChT 5MULmDPnlDw5YmW6FTNrfgi0aNGEZPEtbfo2bNTUpYeeRph69dPWrqvCNFuBIGG1A59CYPAVQtwF cw0OxWdTIOiBCQAjaAB17fOFII8voGmRc+eOkilm/z9OvTtnjN4hYk1YoT3H2rnBOphPAB9skgq3 2lcaX/5YnJVt9BloAar12UEIRGCZdQghMABI1Tn32IQUVthYexhmqGGGMBHAgIfEhSiiiATAtOGJ GnYI4ogsEldicAYOGNJGZaml3Y0L3NTZUBz1xlB0PUoUI0jlVWRSVN89xBKSGB1YU1TMoRfVBEle hR9HQs1GEHxQ3RZZbveZthxt/LEmXHyp5XWABSCpaRJwbM13gAACPHVccgJFgF+NEhqUAEkQSCfc ddhVhh5dVTaEAEsTUNlkZUWKN9BNGDE6QU8OrSdbllzpxyVTTrU21Uj3scfhp7nNpyoDaTIEJ3P9 If8J2kbLNYegg9JRBwGhFvbq66+ZUiDssMQWK2yHxiZLrInKNotss8l+B5yBrr5p2UIJvortANoC 6+234IbLla/elRtZjeamh5CC3Sb0YLvixivvYkDFGlZqBNh7r4n6goVvv6/ZlCicN+kL71ALTnpQ dCIZp7CihkLA3UQmoWRBogyxtBPGCTnZncVR1rSTo5nuydC/Eo8kUH+lOoTyyvjoCuZu+PjYIKLD rZybtrM1d10C0QXKEVz48GrQkEeWdFJKlbb0UmEeV0SzyC6RvNB646LWIVjUNeC1zAFb+RDKXksM 9r531bwmpQW9+hQDDsx5pqwDRWBXcFES2hc+gEn/wJGdEEWdE6LoWcoxQweaTNmkhydkKaYMYY2Q p1unbLl/pPKbn3v7EZRvrKvqlja2ONvrtoIw9tn2g32/tQBlhtYkU+MNikZ7QYlPDPuMldpOmuJX nVo5VF3HjI+q89mteX5IDd/fVFClma5kiE4f2XUJhlz09gj2NbTDRifkmu7zXjR++RVJ/lPznuvr QH2iD6S+UewP9Dnon6d2NLwN8n90BB6hC68cFMCHoe+ACASP9c4DowUyEF0OPFcDI0ij/VXPaAKC UfhS95AKGoQ7IBRICI1HwhGaUIQoLGEKT6jCFrLwhSuMoQtlCMMZ2rCGOKShDm+4wxzy8Ic+DGIP B4cIRCKGMCAAOy== ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/frame.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Slide 1 ------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/outline.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"

1	Inaport Training= SQL Matching
2	Matching Matching Process of deciding which record or set of records in the target table(s) should be updated Alternatively, decide if record already exists and take appropriate action
3	Matching Techniq= ues Inaport supports different ways to match Standard build expressions on source and target Fuzzy Refine Standard to allow for poor data SQL Use SQL SELECT instead of expressions External Use an external match file generated by another application such as Paribus
4	Matching Both Standard and Fuzzy matching Are flexible, powerful, easy to use Build an in memory index The in memory index has benefits and drawbacks Fast once it is built, BUT Up front cost of building (read data, build index) - and On-going memory cost For large (>2-400,000 records) these up front costs may be significant
5	SQL Matching= SQL matching is an alternative scheme Executes SQL SELECT against the target table for each incoming reco= rd Benefits No up front cost No memory cost Drawbacks Not as flexible – restricted to SQL SQL cost per incoming record
6	How it Works= You specify a SQL SELECT statement that will read the primary key of the target table, with a WHERE clause that implements your match criteria SELECT accountid FROM account WHERE account =3D ‘#CompanyName’
7	How it Works= SELECT accountid FROM account WHERE account =3D ‘#CompanyName’ At run time, Inaport will: Parse the SQL and replace any field names with the field value ‘#CompanyName’ becomes ‘InaPlex’ Run SQL against target Use primary keys found as matches
8	How it Works= When working with a child table, WHERE clause must include match on foreign key SELECT contactid FROM contact WHERE accountid= =3D ‘#PARENTKEY’ &nb= sp; AND lastname =3D ‘#LastName’ Inaport will replace ‘#PARENTKEY’ with the primary key of the matched parent record (e.g. accountid) SELECT contactid FROM contact WHERE accountid= =3D ‘A12345678’ &nb= sp; AND lastname =3D ‘Smith’
9	Example – Operations Tab Select SQL Match from the Match type
10	Example – Relationships Tab Set the primary and foreign keys on the Relationships Tab Normally accept the Inaport defaults
11	Example –= Match Tab On Match Tab, click “Enter Initial SQL” and Inaport will write SQL
12	Run Time At run time Source record comes in Inaport will generate SQL, changing ‘#fieldName’ to ‘value of field’ SQL will be executed against target table Primary keys returned will be sued as matches
13	Benefits No up front cost of building indexes Run starts immediately No memory cost of in memory indexes For large target tables, and/or small import runs, speed can be gre= atly improved
14	Drawbacks Can only be used with targets that support SQL Not ACT! Expressions restricted to SQL No normcomp(), regular expressions Requires understanding of SQL May require database tuning SQL executed for each incoming record Search on non-indexed field can have significant SQL Server performance impact
15	Summary SQL Matching is good fit: Target table is much larger than import table, or Target table is very large Depends on system, but > 2-400,000 records Remember You can mix and match – use different match techniques on different tables
16	"THANK YOU= " THANK YOU www.inaplex.com www.inaplex.com/cs/forums

------=_NextPart_01C8993F.FA2A88A0 Content-Location: file:///C:/CCB0D66C/Match_SQL_files/filelist.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C8993F.FA2A88A0--