DBPATH=[/u/catcom/database:/u/catcom/forms Doing fname = BulkImportForDirectoryMTDTramDepots.csv ++++++++++++++++++++++++++++ ===================================================== aline=[OldExtn,OldExtnGgroup,OldDepartment,OldDivision,OldParent,OldPABX,NewVACExtnGroup,NewExtn,NewExtnGroup,NewDepartment,NewDivision,NewParent,NewPABX,NewLocation,NewTelephone,NewComment,NewTEC,NewNode] Skip header ===================================================== aline=[,165MTD,,,VRT,,,,510UC3,,510,VRT,UCP,,,,,] OldExtn=[] OldExtnGroup=[165MTD] OldDepartment=[] OldDivision=[] OldParent=[VRT] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[510UC3] NewDepartment=[] NewDivision=[510] NewParent=[VRT] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "510UC3"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "165MTD" " nrows=0 ERROR: No rows found for Oldextn= OldPABX= OldExtnGroup=165MTD ===================================================== aline=[,407MTD,,,VRT,,,,407UC1,,407,VRT,UCP,,,,,] OldExtn=[] OldExtnGroup=[407MTD] OldDepartment=[] OldDivision=[] OldParent=[VRT] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[407UC1] NewDepartment=[] NewDivision=[407] NewParent=[VRT] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "407UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "407MTD" " nrows=1 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "407MTD" " handleOld() recordno=22568 surname=.ASSIGNED firstname= extension=13935 site=MTD extgroupunique=407MTD handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="407UC1" where recordno = 22568] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="407UC1" where recordno = 22568" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="407" where recordno = 22568] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="407" where recordno = 22568" nrows=1 ===================================================== aline=[,MTDVACA,,,VAC,,,,VACUC3,,VAC,VAC,UCP,,,,,] OldExtn=[] OldExtnGroup=[MTDVACA] OldDepartment=[] OldDivision=[] OldParent=[VAC] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[VACUC3] NewDepartment=[] NewDivision=[VAC] NewParent=[VAC] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "VACUC3"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "MTDVACA" " nrows=71 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "MTDVACA" " handleOld() recordno=42120 surname=.UNPROGRAMMED firstname= extension=13964 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 42120] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 42120" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 42120] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 42120" handleOld() recordno=32923 surname=.UNPROGRAMMED firstname= extension=13927 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 32923] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 32923" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 32923] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 32923" handleOld() recordno=22001 surname=.UNPROGRAMMED firstname= extension=13926 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 22001] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 22001" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 22001] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 22001" handleOld() recordno=21206 surname=.UNPROGRAMMED firstname= extension=13936 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 21206] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 21206" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 21206] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 21206" handleOld() recordno=13846 surname=.UNPROGRAMMED firstname= extension=13934 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 13846] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 13846" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 13846] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 13846" handleOld() recordno=49450 surname=.UNPROGRAMMED firstname= extension=13937 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 49450] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 49450" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 49450] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 49450" handleOld() recordno=41900 surname=.UNPROGRAMMED firstname= extension=13903 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41900] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41900" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41900] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41900" handleOld() recordno=41904 surname=.UNPROGRAMMED firstname= extension=13904 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41904" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41904" handleOld() recordno=41907 surname=.UNPROGRAMMED firstname= extension=13905 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41907" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41907" handleOld() recordno=41908 surname=.UNPROGRAMMED firstname= extension=13906 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41908" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41908" handleOld() recordno=41910 surname=.UNPROGRAMMED firstname= extension=13907 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41910" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41910" handleOld() recordno=41911 surname=.UNPROGRAMMED firstname= extension=13908 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41911" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41911" handleOld() recordno=41912 surname=.UNPROGRAMMED firstname= extension=13909 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41912] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41912" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41912] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41912" handleOld() recordno=41914 surname=.UNPROGRAMMED firstname= extension=13910 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41914] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41914" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41914] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41914" handleOld() recordno=41916 surname=.UNPROGRAMMED firstname= extension=13911 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41916" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41916" handleOld() recordno=41918 surname=.UNPROGRAMMED firstname= extension=13912 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41918" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41918" handleOld() recordno=41925 surname=.UNPROGRAMMED firstname= extension=13915 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41925] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41925" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41925] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41925" handleOld() recordno=41927 surname=.UNPROGRAMMED firstname= extension=13916 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41927" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41927" handleOld() recordno=41928 surname=.UNPROGRAMMED firstname= extension=13917 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41928" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41928" handleOld() recordno=41932 surname=.UNPROGRAMMED firstname= extension=13919 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41932] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41932" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41932] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41932" handleOld() recordno=41933 surname=.UNPROGRAMMED firstname= extension=13920 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41933] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41933" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41933] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41933" handleOld() recordno=41935 surname=.UNPROGRAMMED firstname= extension=13928 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41935] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41935" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41935] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41935" handleOld() recordno=41936 surname=.UNPROGRAMMED firstname= extension=13932 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41936" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41936" handleOld() recordno=41937 surname=.UNPROGRAMMED firstname= extension=13938 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41937] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41937" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41937] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41937" handleOld() recordno=41942 surname=.UNPROGRAMMED firstname= extension=13943 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41942] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41942" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41942] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41942" handleOld() recordno=41945 surname=.UNPROGRAMMED firstname= extension=13946 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41945] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41945" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41945] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41945" handleOld() recordno=41946 surname=.UNPROGRAMMED firstname= extension=13947 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41946] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41946" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41946] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41946" handleOld() recordno=41950 surname=.UNPROGRAMMED firstname= extension=13951 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41950] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41950" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41950] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41950" handleOld() recordno=41951 surname=.UNPROGRAMMED firstname= extension=13952 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41951] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41951" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41951] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41951" handleOld() recordno=41952 surname=.UNPROGRAMMED firstname= extension=13953 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41952" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41952" handleOld() recordno=41953 surname=.UNPROGRAMMED firstname= extension=13954 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41953] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41953" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41953] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41953" handleOld() recordno=41954 surname=.UNPROGRAMMED firstname= extension=13955 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41954] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41954" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41954] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41954" handleOld() recordno=41955 surname=.UNPROGRAMMED firstname= extension=13956 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41955] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41955" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41955] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41955" handleOld() recordno=41956 surname=.UNPROGRAMMED firstname= extension=13957 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41956] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41956" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41956] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41956" handleOld() recordno=41957 surname=.UNPROGRAMMED firstname= extension=13958 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41957] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41957" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41957] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41957" handleOld() recordno=41960 surname=.UNPROGRAMMED firstname= extension=13961 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41960] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41960" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41960] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41960" handleOld() recordno=41961 surname=.UNPROGRAMMED firstname= extension=13962 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41961] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41961" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41961] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41961" handleOld() recordno=41962 surname=.UNPROGRAMMED firstname= extension=13963 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41962] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41962" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41962] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41962" handleOld() recordno=41963 surname=.UNPROGRAMMED firstname= extension=13969 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41963] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41963" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41963] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41963" handleOld() recordno=41964 surname=.UNPROGRAMMED firstname= extension=13965 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41964] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41964" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41964] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41964" handleOld() recordno=41965 surname=.UNPROGRAMMED firstname= extension=13966 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41965] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41965" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41965] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41965" handleOld() recordno=41966 surname=.UNPROGRAMMED firstname= extension=13967 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41966] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41966" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41966] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41966" handleOld() recordno=41967 surname=.UNPROGRAMMED firstname= extension=13968 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41967] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41967" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41967] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41967" handleOld() recordno=41968 surname=.UNPROGRAMMED firstname= extension=13970 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41968] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41968" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41968] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41968" handleOld() recordno=41969 surname=.UNPROGRAMMED firstname= extension=13971 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41969] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41969" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41969] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41969" handleOld() recordno=41970 surname=.UNPROGRAMMED firstname= extension=13972 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41970] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41970" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41970] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41970" handleOld() recordno=41971 surname=.UNPROGRAMMED firstname= extension=13973 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41971] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41971" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41971] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41971" handleOld() recordno=41972 surname=.UNPROGRAMMED firstname= extension=13974 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41972" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41972" handleOld() recordno=41973 surname=.UNPROGRAMMED firstname= extension=13975 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41973] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41973" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41973] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41973" handleOld() recordno=41974 surname=.VACANT firstname= extension=13976 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41974] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41974" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41974] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41974" handleOld() recordno=41975 surname=.UNPROGRAMMED firstname= extension=13977 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41975] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41975" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41975] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41975" handleOld() recordno=41976 surname=.UNPROGRAMMED firstname= extension=13978 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41976] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41976" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41976] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41976" handleOld() recordno=41977 surname=.UNPROGRAMMED firstname= extension=13979 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41977] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41977" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41977] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41977" handleOld() recordno=41978 surname=.UNPROGRAMMED firstname= extension=13980 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41978] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41978" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41978] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41978" handleOld() recordno=41979 surname=.UNPROGRAMMED firstname= extension=13981 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41979] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41979" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41979] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41979" handleOld() recordno=41980 surname=.UNPROGRAMMED firstname= extension=13982 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41980] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41980" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41980] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41980" handleOld() recordno=41981 surname=.UNPROGRAMMED firstname= extension=13983 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41981" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41981] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41981" handleOld() recordno=41982 surname=.UNPROGRAMMED firstname= extension=13984 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41982" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41982] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41982" handleOld() recordno=41983 surname=.UNPROGRAMMED firstname= extension=13985 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41983" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41983] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41983" handleOld() recordno=41984 surname=.UNPROGRAMMED firstname= extension=13986 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41984] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41984" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41984] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41984" handleOld() recordno=41985 surname=.UNPROGRAMMED firstname= extension=13987 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41985] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41985" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41985] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41985" handleOld() recordno=41986 surname=.UNPROGRAMMED firstname= extension=13988 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41986] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41986" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41986] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41986" handleOld() recordno=41987 surname=.UNPROGRAMMED firstname= extension=13989 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41987] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41987" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41987] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41987" handleOld() recordno=41990 surname=.UNPROGRAMMED firstname= extension=13992 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41990" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41990] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41990" handleOld() recordno=41991 surname=.UNPROGRAMMED firstname= extension=13993 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41991] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41991" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41991] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41991" handleOld() recordno=41992 surname=.UNPROGRAMMED firstname= extension=13994 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41992] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41992" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41992] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41992" handleOld() recordno=41993 surname=.UNPROGRAMMED firstname= extension=13995 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41993] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41993" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41993] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41993" handleOld() recordno=41994 surname=.UNPROGRAMMED firstname= extension=13996 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41994] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41994" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41994] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41994" handleOld() recordno=41995 surname=.UNPROGRAMMED firstname= extension=13997 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41995] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 41995" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41995] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 41995" handleOld() recordno=160250 surname=.UNPROGRAMMED firstname= extension=13925 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 160250] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 160250" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 160250] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 160250" handleOld() recordno=57316 surname=.UNPROGRAMMED firstname= extension=13990 site=MTD extgroupunique=MTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 57316] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC3" where recordno = 57316" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 57316] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="VAC" where recordno = 57316" nrows=71 ===================================================== aline=[,0412MTD8,,,YTD,,,,0412UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0412MTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0412UC9] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "0412UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0412MTD8" " nrows=1 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "0412MTD8" " handleOld() recordno=41949 surname=BRAY firstname=ANTHONY extension=13950 site=MTD extgroupunique=0412MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0412UC9" where recordno = 41949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0412UC9" where recordno = 41949" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41949" nrows=1 ===================================================== aline=[,0454MTD8,,,YTD,,,,0454UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0454MTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0454UC1] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "0454UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0454MTD8" " nrows=11 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "0454MTD8" " handleOld() recordno=162903 surname=BELVEDERE firstname=LEANNE extension=13945 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 162903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 162903" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162903" handleOld() recordno=162566 surname=.ASSIGNED firstname= extension=13931 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 162566] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 162566" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162566] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162566" handleOld() recordno=50840 surname=CAI firstname=JUN extension=13924 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 50840] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 50840" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50840] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50840" handleOld() recordno=159835 surname=MACRIS firstname=JOHN extension=13902 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 159835] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 159835" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 159835] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 159835" handleOld() recordno=41938 surname=.ASSIGNED firstname= extension=13939 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41938] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41938" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41938] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41938" handleOld() recordno=41939 surname=.ASSIGNED firstname= extension=13940 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41939] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41939" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41939] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41939" handleOld() recordno=41940 surname=.ASSIGNED firstname= extension=13941 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41940] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41940" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41940] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41940" handleOld() recordno=41941 surname=ARMSTRONG firstname=JIM extension=13942 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41941] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41941" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41941] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41941" handleOld() recordno=41947 surname=TOBLER firstname=SHANE extension=13948 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41947] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41947" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41947] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41947" handleOld() recordno=41948 surname=.ASSIGNED firstname=SIEMENS extension=13949 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41948] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 41948" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41948] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41948" handleOld() recordno=167090 surname=AH CHOW firstname=NEIL extension=13942 site=MTD extgroupunique=0454MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 167090] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0454UC1" where recordno = 167090" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 167090] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 167090" nrows=11 ===================================================== aline=[,5740MTD8,,,YTD,,,,5740UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5740MTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5740UC9] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "5740UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5740MTD8" " nrows=1 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "5740MTD8" " handleOld() recordno=162300 surname=.ASSIGNED firstname= extension=13901 site=MTD extgroupunique=5740MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5740UC9" where recordno = 162300] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5740UC9" where recordno = 162300" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162300] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162300" nrows=1 ===================================================== aline=[,5803MTD8,,,YTD,,,,5803UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5803MTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5803UC9] NewDepartment=[] NewDivision=[YTF] NewParent=[YTF] NewPABX=[UCP] NewLocation=[] NewTelephone=[] NewComment=[] (msg5) NewTEC=[] NewNode=[] keepold=[] OldExtn=[] checking NewExtnGroup exists dothesql=[1] myprocsql: procsql ":" "select grid from groupname where grid = "5803UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5803MTD8" " nrows=233 Moving Dir entry for Oldextn dothesql=[1] myprocsql: procsql "handleOld" "select dt.site, dt.extension, dt.extgroupunique, dt.fgroup, dt.recordno, dt.secure_code, dt.equip_type, dt.firstinit, dc.surname, dc.firstname, dc.title, dc.telephone, dc.empid, dc.section, dc.division, dc.location, dc.faxno, dc.mobile, dc.pager, dc.voicemail, dc.jobno, dc.email, dc.userid, dc.instrument, dc.macaddress, dc.subscriptiondesc, dc.devicetype, dc.phonetype from directtemplate dt, directcustom dc where dt.recordno = dc.recordno and extgroupunique = "5803MTD8" " handleOld() recordno=56877 surname=CRAIG firstname=TIM extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 56877] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 56877" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 56877] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 56877" handleOld() recordno=1129 surname=HANNA firstname=REDA extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 1129] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 1129" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 1129] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 1129" handleOld() recordno=28024 surname=YEE firstname=SHUNG YANG extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28024] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28024" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28024] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28024" handleOld() recordno=1235 surname=AHMAD firstname=RUM extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 1235] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 1235" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 1235] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 1235" handleOld() recordno=160610 surname=SALIB firstname=WAGDY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160610] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160610" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160610] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160610" handleOld() recordno=2246 surname=ARULANANTHAM firstname=ABEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2246] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2246" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2246] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2246" handleOld() recordno=2256 surname=ASHKAR firstname=MUSTAFA extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2256] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2256" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2256] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2256" handleOld() recordno=2347 surname=AUGUSTUS firstname=RICHARD A extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2347] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2347" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2347] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2347" handleOld() recordno=49479 surname=CHRISTIE firstname=JEFFREY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49479] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49479" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49479] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49479" handleOld() recordno=160608 surname=RICHARDSON firstname=DESMOND extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160608] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160608" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160608] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160608" handleOld() recordno=163522 surname=MILLS firstname=WARREN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163522] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163522" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163522] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163522" handleOld() recordno=2589 surname=BARDHO firstname=PETER extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2589] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2589" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2589] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2589" handleOld() recordno=160606 surname=PANG firstname=MADALENA extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160606] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160606" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160606] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160606" handleOld() recordno=45649 surname=BOWMAN firstname=DOUGLAS extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 45649] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 45649" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 45649] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 45649" handleOld() recordno=2724 surname=BATZAKIDIS firstname=EMMANUEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2724] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 2724" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2724] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 2724" handleOld() recordno=3056 surname=BIGNOUX firstname=CLOVIS extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 3056] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 3056" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 3056] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 3056" handleOld() recordno=33335 surname=SILVA firstname=MOHAN D extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 33335] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 33335" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 33335] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 33335" handleOld() recordno=36166 surname=HAVELOS firstname=NICK extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 36166] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 36166" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 36166] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 36166" handleOld() recordno=31772 surname=BADAYOS firstname=ARLOU G extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 31772] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 31772" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 31772] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 31772" handleOld() recordno=160621 surname=SEREN firstname=KATHLEEN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160621] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160621" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160621] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160621" handleOld() recordno=3362 surname=BOWERS firstname=LEON extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 3362] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 3362" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 3362] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 3362" handleOld() recordno=160605 surname=OSADCHIY firstname=LEON extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160605] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160605" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160605] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160605" handleOld() recordno=3617 surname=BROWN firstname=MARTIN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 3617] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 3617" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 3617] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 3617" handleOld() recordno=27805 surname=GREIG firstname=TIMOTHY P extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27805] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27805" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27805] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27805" handleOld() recordno=160604 surname=NARCIS firstname=LLOYD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160604] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160604" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160604] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160604" handleOld() recordno=3998 surname=CAMERON firstname=BRUCE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 3998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 3998" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 3998] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 3998" handleOld() recordno=49478 surname=SERAGO firstname=MICHAEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49478] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49478" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49478] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49478" handleOld() recordno=160603 surname=MILKERATIS firstname=CHRISTINE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160603] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160603" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160603] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160603" handleOld() recordno=27290 surname=ABDULLA firstname=DIAA extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27290] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27290" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27290] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27290" handleOld() recordno=163524 surname=PEDRO firstname=RODNEY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163524] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163524" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163524] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163524" handleOld() recordno=4379 surname=CHAN firstname=STEVEN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4379] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4379" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4379] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4379" handleOld() recordno=4430 surname=CHARUSHENKO firstname=JUDI A extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4430] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4430" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4430] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4430" handleOld() recordno=160602 surname=MCNAMARA firstname=SEAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160602] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160602" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160602] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160602" handleOld() recordno=4444 surname=CHAUHAN firstname=SHASHI extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4444] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4444" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4444] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4444" handleOld() recordno=33334 surname=GAMAGE firstname=NIHAL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 33334] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 33334" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 33334] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 33334" handleOld() recordno=160601 surname=MATHIOS firstname=PANAGIOTIS extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160601] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160601" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160601] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160601" handleOld() recordno=4628 surname=CLARK firstname=EILEEN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4628" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4628" handleOld() recordno=4629 surname=CLARK firstname=GAETAN I extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4629" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4629" handleOld() recordno=27629 surname=CORNELIUS firstname=WILLIAM A extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27629" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27629" handleOld() recordno=4818 surname=COLAKIDIS firstname=GEORGE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4818] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 4818" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4818] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 4818" handleOld() recordno=28660 surname=WALSH firstname=DAVID extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28660] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28660" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28660] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28660" handleOld() recordno=160600 surname=MATHIOS firstname=BILL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160600] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160600" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160600] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160600" handleOld() recordno=160599 surname=MAITRAK firstname=SIDDHARTH extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160599] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160599" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160599] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160599" handleOld() recordno=5103 surname=COSTANDI firstname=MICHEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5103] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5103" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5103] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5103" handleOld() recordno=49477 surname=RUSSELL firstname=DAVID J extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49477] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49477" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49477] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49477" handleOld() recordno=5477 surname=D CRUZ firstname=IVAN P extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5477] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5477" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5477] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5477" handleOld() recordno=160619 surname=SOK firstname=SOVANN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160619] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160619" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160619] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160619" handleOld() recordno=5689 surname=DAVIS firstname=WIWIEK extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5689] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5689" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5689] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5689" handleOld() recordno=5703 surname=DAWSON firstname=ANTON extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5703] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5703" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5703] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5703" handleOld() recordno=5803 surname=DE-PRAZER firstname=WINSTON L extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5803] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 5803" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5803] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 5803" handleOld() recordno=160598 surname=LEITCH firstname=JOHN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160598] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160598" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160598] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160598" handleOld() recordno=6076 surname=DIAS firstname=MARIO extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6076] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6076" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6076] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6076" handleOld() recordno=6196 surname=DISANAYAKE firstname=JULIAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6196] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6196" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6196] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6196" handleOld() recordno=6197 surname=DISANAYAKE firstname=SWINEETHA extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6197] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6197" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6197] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6197" handleOld() recordno=49485 surname=FERNANDEZ firstname=DESMOND P extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49485] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49485" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49485] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49485" handleOld() recordno=6276 surname=DOLE firstname=TUAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6276] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6276" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6276] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6276" handleOld() recordno=50908 surname=RANJAN firstname=CHELLIAH extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50908" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50908" handleOld() recordno=6433 surname=D ROZA firstname=MICHAEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6433] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6433" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6433] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6433" handleOld() recordno=6434 surname=DROZARIO firstname=BAZIL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6434] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 6434" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6434] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 6434" handleOld() recordno=160597 surname=LEE firstname=DANNY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160597" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160597] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160597" handleOld() recordno=160596 surname=LECOUTEUR firstname=TIM extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160596] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160596" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160596] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160596" handleOld() recordno=163521 surname=HUSSAIN firstname=SYED extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163521] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163521" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163521] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163521" handleOld() recordno=160595 surname=LARKINS firstname=ALAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160595] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160595" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160595] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160595" handleOld() recordno=164783 surname=.ASSIGNED firstname= extension=13944 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 164783] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 164783" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 164783] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 164783" handleOld() recordno=7067 surname=FEREIRA firstname=DESMOND extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 7067] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 7067" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 7067] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 7067" handleOld() recordno=160594 surname=KENNEDY firstname=SURESH extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160594] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160594" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160594] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160594" handleOld() recordno=161046 surname=SAINSBURY firstname=MICHAEL extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161046] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161046" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161046] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161046" handleOld() recordno=160618 surname=SNOWDEN firstname=MARK extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160618] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160618" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160618] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160618" handleOld() recordno=8767 surname=HARRIS firstname=KEITH P extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 8767] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 8767" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 8767] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 8767" handleOld() recordno=50918 surname=CREATON firstname=GARY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50918" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50918" handleOld() recordno=160591 surname=HARRIDEN firstname=CHRIS extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160591] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160591" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160591] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160591" handleOld() recordno=9016 surname=HENG firstname=LIM extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 9016] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 9016" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 9016] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 9016" handleOld() recordno=9057 surname=HERMES firstname=GABRIEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 9057] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 9057" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 9057] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 9057" handleOld() recordno=160249 surname=NADDA firstname=JIM extension=13921 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160249] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160249" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160249] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160249" handleOld() recordno=160590 surname=GULAVITA firstname=SRIYAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160590] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160590" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160590] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160590" handleOld() recordno=173008 surname=.ASSIGNED firstname= extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 173008] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 173008" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 173008] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 173008" handleOld() recordno=34947 surname=BIGNOUX firstname=JENNIFER extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 34947] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 34947" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 34947] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 34947" handleOld() recordno=32320 surname=HUA firstname=HAO NHIEN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 32320] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 32320" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 32320] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 32320" handleOld() recordno=160589 surname=GOULDING firstname=MURRAY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160589] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160589" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160589] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160589" handleOld() recordno=160611 surname=SAYNOR firstname=JACK extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160611] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160611" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160611] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160611" handleOld() recordno=9829 surname=JAYASURIYA firstname=DENNIS extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 9829] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 9829" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 9829] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 9829" handleOld() recordno=162514 surname=BROWNE firstname=ANDY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162514] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162514" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162514] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162514" handleOld() recordno=162517 surname=MATHEWS firstname=DAVID extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162517] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162517" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162517] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162517" handleOld() recordno=10138 surname=KAITHAVELIL firstname=SAJEEVAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10138] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10138" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10138] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10138" handleOld() recordno=10140 surname=KAIWAI firstname=DARREN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10140] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10140" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10140] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10140" handleOld() recordno=49486 surname=SWARIS firstname=BERNARD A extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49486] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49486" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49486] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49486" handleOld() recordno=10185 surname=KANG firstname=BOON HONG extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10185] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10185" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10185] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10185" handleOld() recordno=162438 surname=KENNEDY firstname=DONALD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162438] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162438" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162438] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162438" handleOld() recordno=163520 surname=EVERARD firstname=DONALD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163520] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163520" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163520] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163520" handleOld() recordno=10510 surname=KHAIRY firstname=MAMDOUH extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10510] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10510" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10510] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10510" handleOld() recordno=50919 surname=D SILVA firstname=MARSHALL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50919] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50919" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50919] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50919" handleOld() recordno=50920 surname=D SILVA firstname=PETER S extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50920" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50920" handleOld() recordno=10888 surname=KURUPASUTACHAI firstname=BUNDIT extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10888] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 10888" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10888] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 10888" handleOld() recordno=49476 surname=OHLSEN firstname=STEVEN R extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49476] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49476" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49476] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49476" handleOld() recordno=11021 surname=LAM firstname=DAVID extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11021] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11021" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11021] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11021" handleOld() recordno=160588 surname=GOONAWARDENA firstname=LAL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160588] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160588" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160588] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160588" handleOld() recordno=50928 surname=MERRIGAN firstname=VICTOR extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50928" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50928" handleOld() recordno=11209 surname=LAY firstname=KIEUN S extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11209] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11209" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11209] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11209" handleOld() recordno=163527 surname=YOUNG firstname=STEVEN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163527] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163527" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163527] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163527" handleOld() recordno=11341 surname=LEMASSON firstname=JOSEPH extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11341] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11341" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11341] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11341" handleOld() recordno=11342 surname=LEMASSON firstname=RHODA extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11342] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11342" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11342] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11342" handleOld() recordno=11540 surname=LOBO firstname=JAIME extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11540] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11540" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11540] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11540" handleOld() recordno=163526 surname=SHERSON firstname=RONALD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163526] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163526" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163526] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163526" handleOld() recordno=29786 surname=PIKARI firstname=HOWARD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 29786] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 29786" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 29786] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 29786" handleOld() recordno=11725 surname=LUK-TUNG firstname=MICHEL P extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11725] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 11725" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11725] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 11725" handleOld() recordno=160587 surname=GONSALVEZ firstname=BOSCO extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160587] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160587" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160587] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160587" handleOld() recordno=160585 surname=GIBSON firstname=CHESTER extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160585] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160585" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160585] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160585" handleOld() recordno=50841 surname=SWITALA firstname=DAVID extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50841] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50841" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50841] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50841" handleOld() recordno=160584 surname=FROST firstname=KYM extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160584] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160584" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160584] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160584" handleOld() recordno=12868 surname=MEAGHER firstname=CHRISTOPHE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 12868] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 12868" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 12868] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 12868" handleOld() recordno=50921 surname=DEAN firstname=GEOFFREY D extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50921] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50921" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50921] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50921" handleOld() recordno=12870 surname=MEAN firstname=RITHY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 12870] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 12870" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 12870] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 12870" handleOld() recordno=160583 surname=FERREIRA firstname=BEN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160583] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160583" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160583] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160583" handleOld() recordno=160582 surname=EWEN firstname=DORIS extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160582] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160582" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160582] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160582" handleOld() recordno=13200 surname=MINETTI firstname=KAREL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13200] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13200" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13200] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13200" handleOld() recordno=28122 surname=MOUJTAHID firstname=THERESA extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28122] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28122" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28122] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28122" handleOld() recordno=160581 surname=EVERARD firstname=DAVID extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160581] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160581" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160581] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160581" handleOld() recordno=162531 surname=WILLIAMS firstname=PETER extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162531] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162531" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162531] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162531" handleOld() recordno=13496 surname=MORTIMER firstname=GEOFFREY L extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13496] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13496" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13496] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13496" handleOld() recordno=160580 surname=EDMUNDS firstname=JOHN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160580] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160580" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160580] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160580" handleOld() recordno=13749 surname=NANETTE firstname=LYSIANNE D extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13749] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13749" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13749] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13749" handleOld() recordno=13891 surname=NG firstname=MICHAEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13891] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13891" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13891] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13891" handleOld() recordno=13919 surname=NGUYEN firstname=KHAC extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13919] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 13919" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13919] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 13919" handleOld() recordno=163525 surname=ROBERTS firstname=JOSEPH extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163525] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163525" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163525] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163525" handleOld() recordno=27384 surname=ANNAMNEEDI firstname=RAVIKUMAR extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27384] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27384" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27384] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27384" handleOld() recordno=14338 surname=OORLOFF firstname=ERROL F extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14338] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14338" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14338] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14338" handleOld() recordno=49483 surname=POPE firstname=WARREN V extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49483] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49483" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49483] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49483" handleOld() recordno=161034 surname=ARMITAGE firstname=PATRICK extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161034] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161034" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161034] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161034" handleOld() recordno=160616 surname=SINNEMA firstname=MARK extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160616] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160616" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160616] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160616" handleOld() recordno=33330 surname=CARRADY firstname=JEREMY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 33330] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 33330" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 33330] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 33330" handleOld() recordno=160579 surname=DOYLE firstname=GLEN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160579] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160579" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160579] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160579" handleOld() recordno=14731 surname=PAUL firstname=DAVID extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14731] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14731" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14731] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14731" handleOld() recordno=160578 surname=D CRUZ firstname=GREGORY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160578] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160578" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160578] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160578" handleOld() recordno=27854 surname=HOGG firstname=ALBERT F extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27854] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27854" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27854] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27854" handleOld() recordno=14833 surname=PELAWI firstname=LIGAT extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14833] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14833" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14833] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14833" handleOld() recordno=14874 surname=PEREIRA firstname=GLENVILLE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14874] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14874" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14874] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14874" handleOld() recordno=27855 surname=HONEYFORD firstname=JOSEPH A extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27855] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27855" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27855] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27855" handleOld() recordno=14923 surname=PERRY firstname=BRIAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14923] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 14923" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14923] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 14923" handleOld() recordno=27856 surname=WOOLLEY firstname=FRANCOISE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27856] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27856" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27856] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27856" handleOld() recordno=160577 surname=DAVITT firstname=RAY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160577] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160577" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160577] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160577" handleOld() recordno=27849 surname=HELDT firstname=THEODORE E extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27849] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27849" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27849] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27849" handleOld() recordno=32158 surname=AYENI firstname=HEI T extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 32158] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 32158" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 32158] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 32158" handleOld() recordno=49488 surname=ONG firstname=PAUL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49488] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49488" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49488] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49488" handleOld() recordno=15812 surname=REEVES firstname=LAURETTE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 15812] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 15812" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 15812] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 15812" handleOld() recordno=15855 surname=REITH firstname=DAVID extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 15855] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 15855" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 15855] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 15855" handleOld() recordno=15885 surname=REYNOLDS firstname=ALFRED extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 15885] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 15885" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 15885] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 15885" handleOld() recordno=160576 surname=CORRALES firstname=BOLIVAR extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160576] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160576" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160576] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160576" handleOld() recordno=27443 surname=BALARATNAM firstname=BENJAMIN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27443] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27443" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27443] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27443" handleOld() recordno=16142 surname=ROCHERY firstname=ANDRE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 16142] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 16142" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 16142] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 16142" handleOld() recordno=160615 surname=SINDEL firstname=KERRY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160615] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160615" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160615] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160615" handleOld() recordno=160614 surname=SIMONSZ firstname=GEORGE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160614] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160614" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160614] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160614" handleOld() recordno=16521 surname=SALDANHA firstname=BRIAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 16521] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 16521" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 16521] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 16521" handleOld() recordno=28106 surname=TUATAGA firstname=FILO extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28106] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28106" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28106] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28106" handleOld() recordno=16767 surname=SCHOLTEN firstname=RONALD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 16767] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 16767" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 16767] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 16767" handleOld() recordno=28098 surname=WESLEY firstname=VICTOR extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28098] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28098" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28098] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28098" handleOld() recordno=56752 surname=SINNEMA firstname=ANDREW extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 56752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 56752" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 56752] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 56752" handleOld() recordno=16934 surname=SENG firstname=BUNG extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 16934] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 16934" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 16934] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 16934" handleOld() recordno=17133 surname=SIDHOM firstname=ERYAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 17133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 17133" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 17133] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 17133" handleOld() recordno=161513 surname=CATO firstname=DAVID extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161513] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161513" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161513] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161513" handleOld() recordno=17295 surname=SIM firstname=KHINGSEING extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 17295] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 17295" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 17295] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 17295" handleOld() recordno=160575 surname=CORNEHLS firstname=GREGORY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160575] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160575" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160575] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160575" handleOld() recordno=160574 surname=CLEUR firstname=ROMELLE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160574] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160574" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160574] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160574" handleOld() recordno=49475 surname=BOIN firstname=PIERGIORGI extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49475] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 49475" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49475] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 49475" handleOld() recordno=162310 surname=SOK firstname=POUV extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162310] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162310" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162310] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162310" handleOld() recordno=162511 surname=BERRY firstname=TIM extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162511] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162511" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162511] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162511" handleOld() recordno=17675 surname=SOLOMONS firstname=CHRISTOPHE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 17675] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 17675" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 17675] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 17675" handleOld() recordno=27920 surname=JOSEPH firstname=PHILIP A extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27920" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27920" handleOld() recordno=36168 surname=KITULGODA firstname=MELISA A extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 36168] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 36168" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 36168] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 36168" handleOld() recordno=161043 surname=PAIN firstname=CHRISTOPHE extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161043] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161043" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161043] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161043" handleOld() recordno=18414 surname=TAUFIK firstname=ACHMAD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18414] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18414" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18414] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18414" handleOld() recordno=160572 surname=CHISHOLM firstname=DOUGLAS extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160572] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160572" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160572] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160572" handleOld() recordno=18601 surname=THEVANAYAGAM firstname=SAMUEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18601] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18601" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18601] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18601" handleOld() recordno=164675 surname=CATO firstname=CHARMAINE extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 164675] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 164675" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 164675] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 164675" handleOld() recordno=50916 surname=BURROWS firstname=MARIO extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50916" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50916" handleOld() recordno=18649 surname=THOMPSON firstname=FREDERICK extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18649] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18649" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18649] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18649" handleOld() recordno=18756 surname=TIMBULENG firstname=FERRY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18756] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18756" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18756] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18756" handleOld() recordno=160571 surname=CAPEWELL firstname=DONALD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160571] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160571" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160571] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160571" handleOld() recordno=161047 surname=THOMSON firstname=GAIL extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161047] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161047" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161047] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161047" handleOld() recordno=28130 surname=ROGERS firstname=DEXTER extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28130] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 28130" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28130] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 28130" handleOld() recordno=18948 surname=TRAN firstname=THAO extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18948] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 18948" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18948] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 18948" handleOld() recordno=19058 surname=TRUONG firstname=VI extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 19058] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 19058" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 19058] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 19058" handleOld() recordno=160570 surname=BURNS firstname=ADRIAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160570] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160570" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160570] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160570" handleOld() recordno=19244 surname=UNG firstname=MENG extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 19244] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 19244" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 19244] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 19244" handleOld() recordno=162530 surname=SAULTRY firstname=PETER extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162530] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162530" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162530] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162530" handleOld() recordno=163523 surname=NIGLI firstname=LESLIE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163523] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163523" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163523] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163523" handleOld() recordno=19477 surname=VANCUYLENBERG firstname=ANTHONY B extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 19477] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 19477" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 19477] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 19477" handleOld() recordno=162528 surname=PERERA firstname=PRABODH extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162528] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162528" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162528] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162528" handleOld() recordno=19786 surname=WALKER firstname=RICHARD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 19786] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 19786" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 19786] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 19786" handleOld() recordno=35668 surname=GIBSON firstname=CHRISTINE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 35668] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 35668" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 35668] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 35668" handleOld() recordno=160565 surname=ALEXANDROU firstname=GEORGE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160565] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160565" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160565] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160565" handleOld() recordno=161039 surname=JIMENEZ firstname=TRUDY extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161039] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161039" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161039] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161039" handleOld() recordno=50917 surname=CHANDRASEKARA firstname=CHANDRA extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50917] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50917" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50917] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50917" handleOld() recordno=160613 surname=SIMON firstname=MARIO extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160613] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160613" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160613] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160613" handleOld() recordno=27525 surname=BUI firstname=VAN HAO extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27525] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27525" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27525] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27525" handleOld() recordno=160612 surname=SILVY firstname=GERARD extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160612] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160612" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160612] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160612" handleOld() recordno=50911 surname=SIVAPALAN firstname=KANAPATHIP extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 50911" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 50911" handleOld() recordno=20112 surname=WHATMAN firstname=NEIL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20112] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20112" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20112] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20112" handleOld() recordno=22089 surname=GOMEZ firstname=RYAN extension=13933 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 22089] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 22089" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 22089] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 22089" handleOld() recordno=20237 surname=WILLEMS firstname=SHAYNE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20237] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20237" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20237] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20237" handleOld() recordno=45952 surname=JOHNSON firstname=TERESA M extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 45952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 45952" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 45952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 45952" handleOld() recordno=20283 surname=WILLIAMS firstname=LIONEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20283] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20283" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20283] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20283" handleOld() recordno=162510 surname=ANDERSON firstname=CAMPBELL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162510] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162510" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162510] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162510" handleOld() recordno=20319 surname=WILLIAMSON firstname=IAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20319] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20319" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20319] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20319" handleOld() recordno=20338 surname=WILLIS firstname=RODNEY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20338] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20338" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20338] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20338" handleOld() recordno=27501 surname=BREWTY firstname=DUNCAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27501] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 27501" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27501] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 27501" handleOld() recordno=20501 surname=WONG firstname=PETER S extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20501] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20501" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20501] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20501" handleOld() recordno=20505 surname=WONG firstname=TONG extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20505] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 20505" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20505] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 20505" handleOld() recordno=34416 surname=WOOLLEY firstname=PAUL F extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 34416] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 34416" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 34416] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 34416" handleOld() recordno=160567 surname=AYAD firstname=SAMUEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160567] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160567" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160567] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160567" handleOld() recordno=41896 surname=.ASSIGNED firstname= extension=13900 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41896] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41896" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41896] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41896" handleOld() recordno=41920 surname=O DEA firstname=DAVID extension=13913 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41920" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41920" handleOld() recordno=41922 surname=REDDY firstname=ELIZABETH extension=13914 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41922] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41922" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41922] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41922" handleOld() recordno=41930 surname=FOX firstname=EMMA extension=13918 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41930] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41930" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41930] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41930" handleOld() recordno=41934 surname=.ASSIGNED firstname= extension=13923 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41934] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41934" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41934] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41934" handleOld() recordno=41959 surname=.ASSIGNED firstname= extension=13960 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41959" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41959" handleOld() recordno=41989 surname=.ASSIGNED firstname= extension=13991 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41989] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 41989" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41989] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 41989" handleOld() recordno=160566 surname=ARMANIOS firstname=KHALIL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160566] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160566" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160566] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160566" handleOld() recordno=44008 surname=TEMPLETON firstname=KATHERINE extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 44008] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 44008" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 44008] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 44008" handleOld() recordno=164701 surname=TOOHEY firstname=TROY extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 164701] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 164701" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 164701] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 164701" handleOld() recordno=163659 surname=CHAU firstname=TRONG extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163659] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163659" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163659] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163659" handleOld() recordno=160622 surname=SUMWAI firstname=MICHAEL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160622] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160622" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160622] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160622" handleOld() recordno=160624 surname=TAWFIK firstname=RAYMOND extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160624] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160624" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160624] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160624" handleOld() recordno=160625 surname=TRAN firstname=VAN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160625] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160625" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160625] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160625" handleOld() recordno=160626 surname=VAZ firstname=KEVIN extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160626] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160626" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160626] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160626" handleOld() recordno=160627 surname=WILSON firstname=NEIL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160627] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160627" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160627] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160627" handleOld() recordno=160628 surname=XAVIER firstname=HENRY extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160628" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160628] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160628" handleOld() recordno=160629 surname=XAVIER firstname=MARINO extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 160629" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160629] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 160629" handleOld() recordno=162522 surname=LAWLOR firstname=TERRIL extension=13922 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162522] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 162522" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162522] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 162522" handleOld() recordno=161042 surname=MCPHERSON firstname=RICHARD extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161042] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161042" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161042] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161042" handleOld() recordno=161044 surname=PAYNE firstname=GWEN extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161044] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161044" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161044] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161044" handleOld() recordno=161045 surname=PETERS firstname=JUDITH extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161045] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 161045" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161045] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 161045" handleOld() recordno=163583 surname=NEW firstname=MARK extension=13929 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163583] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 163583" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163583] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 163583" handleOld() recordno=172107 surname=VANDERPUTT firstname=RICARDO extension=13930 site=MTD extgroupunique=5803MTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 172107] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5803UC9" where recordno = 172107" sqlcmd=[update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 172107] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="13/06/2018" ,jobno="RS130618MTDTRAMDEPOT" ,division="YTF" where recordno = 172107" nrows=233