DBPATH=[/u/catcom/database:/u/catcom/forms Doing fname = BulkImportForDirectoryCTDTramDepots.csv ++++++++++++++++++++++++++++ ===================================================== aline=[OldExtn,OldExtnGgroup,OldDepartment,OldDivision,OldParent,OldPABX,NewVACExtnGroup,NewExtn,NewExtnGroup,NewDepartment,NewDivision,NewParent,NewPABX,NewLocation,NewTelephone,NewComment,NewTEC,NewNode] Skip header ===================================================== aline=[,165CTD,,,VRT,,,,510UC2,,510,VRT,UCP,,,,,] OldExtn=[] OldExtnGroup=[165CTD] OldDepartment=[] OldDivision=[] OldParent=[VRT] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[510UC2] 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 = "510UC2"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "165CTD" " nrows=0 ERROR: No rows found for Oldextn= OldPABX= OldExtnGroup=165CTD ===================================================== aline=[,CTDVACA,,,VAC,,,,VACUC2,,VAC,VAC,UCP,,,,,] OldExtn=[] OldExtnGroup=[CTDVACA] OldDepartment=[] OldDivision=[] OldParent=[VAC] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[VACUC2] 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 = "VACUC2"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "CTDVACA" " nrows=85 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 = "CTDVACA" " handleOld() recordno=47434 surname=.UNPROGRAMMED firstname= extension=13622 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 47434] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 47434" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 47434] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 47434" handleOld() recordno=51564 surname=.UNPROGRAMMED firstname= extension=13614 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 51564] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 51564" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 51564] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 51564" handleOld() recordno=38974 surname=.UNPROGRAMMED firstname= extension=13691 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38974] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38974" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38974] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38974" handleOld() recordno=38975 surname=.UNPROGRAMMED firstname= extension=13692 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38975] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38975" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38975] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38975" handleOld() recordno=38976 surname=.UNPROGRAMMED firstname= extension=13693 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38976] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38976" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38976] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38976" handleOld() recordno=38977 surname=.UNPROGRAMMED firstname= extension=13694 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38977] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38977" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38977] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38977" handleOld() recordno=38978 surname=.UNPROGRAMMED firstname= extension=13695 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38978] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38978" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38978] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38978" handleOld() recordno=38967 surname=.UNPROGRAMMED firstname= extension=13684 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38967] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38967" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38967] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38967" handleOld() recordno=38968 surname=.UNPROGRAMMED firstname= extension=13685 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38968] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38968" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38968] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38968" handleOld() recordno=38969 surname=.UNPROGRAMMED firstname= extension=13686 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38969] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38969" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38969] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38969" handleOld() recordno=38970 surname=.UNPROGRAMMED firstname= extension=13687 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38970] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38970" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38970] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38970" handleOld() recordno=38971 surname=.UNPROGRAMMED firstname= extension=13688 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38971] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38971" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38971] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38971" handleOld() recordno=38972 surname=.UNPROGRAMMED firstname= extension=13689 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38972" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38972" handleOld() recordno=38973 surname=.UNPROGRAMMED firstname= extension=13690 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38973] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38973" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38973] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38973" handleOld() recordno=38965 surname=.UNPROGRAMMED firstname= extension=13682 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38965] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38965" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38965] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38965" handleOld() recordno=38966 surname=.UNPROGRAMMED firstname= extension=13683 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38966] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38966" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38966] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38966" handleOld() recordno=38963 surname=.UNPROGRAMMED firstname= extension=13680 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38963] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38963" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38963] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38963" handleOld() recordno=38964 surname=.UNPROGRAMMED firstname= extension=13681 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38964] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38964" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38964] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38964" handleOld() recordno=33411 surname=.UNPROGRAMMED firstname= extension=13604 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 33411] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 33411" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 33411] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 33411" handleOld() recordno=38954 surname=.UNPROGRAMMED firstname= extension=13671 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38954] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38954" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38954] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38954" handleOld() recordno=38955 surname=.UNPROGRAMMED firstname= extension=13672 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38955] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38955" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38955] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38955" handleOld() recordno=38956 surname=.UNPROGRAMMED firstname= extension=13673 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38956] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38956" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38956] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38956" handleOld() recordno=38957 surname=.UNPROGRAMMED firstname= extension=13674 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38957] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38957" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38957] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38957" handleOld() recordno=38945 surname=.UNPROGRAMMED firstname= extension=13662 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38945] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38945" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38945] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38945" handleOld() recordno=38958 surname=.UNPROGRAMMED firstname= extension=13675 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38958] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38958" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38958] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38958" handleOld() recordno=38959 surname=.UNPROGRAMMED firstname= extension=13676 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38959" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38959" handleOld() recordno=38960 surname=.UNPROGRAMMED firstname= extension=13677 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38960] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38960" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38960] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38960" handleOld() recordno=38961 surname=.UNPROGRAMMED firstname= extension=13678 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38961] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38961" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38961] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38961" handleOld() recordno=38979 surname=.UNPROGRAMMED firstname= extension=13696 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38979] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38979" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38979] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38979" handleOld() recordno=38962 surname=.UNPROGRAMMED firstname= extension=13679 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38962] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38962" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38962] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38962" handleOld() recordno=38946 surname=.UNPROGRAMMED firstname= extension=13663 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38946] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38946" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38946] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38946" handleOld() recordno=38947 surname=.UNPROGRAMMED firstname= extension=13664 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38947] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38947" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38947] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38947" handleOld() recordno=38948 surname=.UNPROGRAMMED firstname= extension=13665 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38948] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38948" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38948] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38948" handleOld() recordno=38951 surname=.UNPROGRAMMED firstname= extension=13668 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38951] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38951" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38951] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38951" handleOld() recordno=38952 surname=.UNPROGRAMMED firstname= extension=13669 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38952" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38952] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38952" handleOld() recordno=38953 surname=.UNPROGRAMMED firstname= extension=13670 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38953] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38953" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38953] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38953" handleOld() recordno=38935 surname=.UNPROGRAMMED firstname= extension=13652 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38935] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38935" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38935] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38935" handleOld() recordno=38936 surname=.UNPROGRAMMED firstname= extension=13653 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38936" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38936] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38936" handleOld() recordno=38937 surname=.UNPROGRAMMED firstname= extension=13654 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38937] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38937" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38937] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38937" handleOld() recordno=38938 surname=.UNPROGRAMMED firstname= extension=13655 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38938] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38938" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38938] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38938" handleOld() recordno=38939 surname=.UNPROGRAMMED firstname= extension=13656 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38939] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38939" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38939] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38939" handleOld() recordno=38940 surname=.UNPROGRAMMED firstname= extension=13657 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38940] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38940" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38940] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38940" handleOld() recordno=38941 surname=.UNPROGRAMMED firstname= extension=13658 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38941] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38941" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38941] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38941" handleOld() recordno=38942 surname=.UNPROGRAMMED firstname= extension=13659 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38942] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38942" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38942] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38942" handleOld() recordno=38944 surname=.UNPROGRAMMED firstname= extension=13661 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38944] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38944" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38944] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38944" handleOld() recordno=38925 surname=.UNPROGRAMMED firstname= extension=13642 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38925] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38925" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38925] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38925" handleOld() recordno=38926 surname=.UNPROGRAMMED firstname= extension=13643 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38926] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38926" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38926] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38926" handleOld() recordno=38927 surname=.UNPROGRAMMED firstname= extension=13644 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38927" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38927] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38927" handleOld() recordno=38928 surname=.UNPROGRAMMED firstname= extension=13645 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38928" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38928" handleOld() recordno=38929 surname=.UNPROGRAMMED firstname= extension=13646 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38929] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38929" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38929] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38929" handleOld() recordno=38930 surname=.UNPROGRAMMED firstname= extension=13647 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38930] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38930" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38930] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38930" handleOld() recordno=38912 surname=.UNPROGRAMMED firstname= extension=13629 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38912] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38912" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38912] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38912" handleOld() recordno=38931 surname=.UNPROGRAMMED firstname= extension=13648 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38931] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38931" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38931] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38931" handleOld() recordno=38932 surname=.UNPROGRAMMED firstname= extension=13649 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38932] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38932" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38932] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38932" handleOld() recordno=49187 surname=.UNPROGRAMMED firstname= extension=13606 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 49187] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 49187" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 49187] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 49187" handleOld() recordno=38933 surname=.UNPROGRAMMED firstname= extension=13650 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38933] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38933" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38933] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38933" handleOld() recordno=38934 surname=.UNPROGRAMMED firstname= extension=13651 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38934] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38934" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38934] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38934" handleOld() recordno=38916 surname=.UNPROGRAMMED firstname= extension=13633 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38916" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38916] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38916" handleOld() recordno=38917 surname=.UNPROGRAMMED firstname= extension=13634 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38917] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38917" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38917] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38917" handleOld() recordno=38918 surname=.UNPROGRAMMED firstname= extension=13635 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38918" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38918] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38918" handleOld() recordno=38919 surname=.UNPROGRAMMED firstname= extension=13636 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38919] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38919" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38919] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38919" handleOld() recordno=38920 surname=.UNPROGRAMMED firstname= extension=13637 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38920" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38920] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38920" handleOld() recordno=38921 surname=.UNPROGRAMMED firstname= extension=13638 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38921] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38921" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38921] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38921" handleOld() recordno=38922 surname=.UNPROGRAMMED firstname= extension=13639 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38922] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38922" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38922] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38922" handleOld() recordno=38923 surname=.UNPROGRAMMED firstname= extension=13640 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38923] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38923" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38923] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38923" handleOld() recordno=38924 surname=.UNPROGRAMMED firstname= extension=13641 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38924] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38924" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38924] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38924" handleOld() recordno=38907 surname=.UNPROGRAMMED firstname= extension=13624 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38907" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38907] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38907" handleOld() recordno=38908 surname=.UNPROGRAMMED firstname= extension=13625 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38908" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38908] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38908" handleOld() recordno=38909 surname=.UNPROGRAMMED firstname= extension=13626 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38909] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38909" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38909] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38909" handleOld() recordno=38910 surname=.UNPROGRAMMED firstname= extension=13627 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38910" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38910] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38910" handleOld() recordno=38911 surname=.UNPROGRAMMED firstname= extension=13628 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38911" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38911" handleOld() recordno=38913 surname=.UNPROGRAMMED firstname= extension=13630 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38913] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38913" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38913] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38913" handleOld() recordno=38914 surname=.UNPROGRAMMED firstname= extension=13631 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38914] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38914" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38914] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38914" handleOld() recordno=38915 surname=.UNPROGRAMMED firstname= extension=13632 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38915] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38915" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38915] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38915" handleOld() recordno=38900 surname=.UNPROGRAMMED firstname= extension=13616 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38900] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38900" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38900] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38900" handleOld() recordno=38901 surname=.UNPROGRAMMED firstname= extension=13617 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38901] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38901" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38901] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38901" handleOld() recordno=38902 surname=.UNPROGRAMMED firstname= extension=13618 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38902" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38902" handleOld() recordno=38980 surname=.UNPROGRAMMED firstname= extension=13697 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38980] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38980" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38980] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38980" handleOld() recordno=38903 surname=.UNPROGRAMMED firstname= extension=13619 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38903" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38903] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38903" handleOld() recordno=38904 surname=.UNPROGRAMMED firstname= extension=13620 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38904" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38904] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38904" handleOld() recordno=38905 surname=.UNPROGRAMMED firstname= extension=13621 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38905] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38905" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38905] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38905" handleOld() recordno=38906 surname=.UNPROGRAMMED firstname= extension=13623 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38906] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38906" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38906] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38906" handleOld() recordno=38897 surname=.UNPROGRAMMED firstname= extension=13612 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38897] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 38897" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38897] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 38897" handleOld() recordno=32965 surname=.UNPROGRAMMED firstname= extension=13615 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 32965] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 32965" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 32965] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 32965" handleOld() recordno=163606 surname=.UNPROGRAMMED firstname= extension=13609 site=CTD extgroupunique=CTDVACA handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 163606] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="VACUC2" where recordno = 163606" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 163606] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="VAC" where recordno = 163606" nrows=85 ===================================================== aline=[,0323CTD8,,,YTD,,,,0323UC10,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0323CTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0323UC10] 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 = "0323UC10"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0323CTD8" " 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 = "0323CTD8" " handleOld() recordno=38896 surname=SPRUCH firstname=PETER extension=13610 site=CTD extgroupunique=0323CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0323UC10" where recordno = 38896] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0323UC10" where recordno = 38896" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38896] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38896" nrows=1 ===================================================== aline=[,0457CTD8,,,YTD,,,,0457UC1,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[0457CTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[0457UC1] 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 = "0457UC1"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "0457CTD8" " nrows=2 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 = "0457CTD8" " handleOld() recordno=162573 surname=KIRKOVSKI firstname=STEVAN extension=13607 site=CTD extgroupunique=0457CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0457UC1" where recordno = 162573] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0457UC1" where recordno = 162573" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162573] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162573" handleOld() recordno=47471 surname=SUHR firstname=ASHLEY extension=13611 site=CTD extgroupunique=0457CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0457UC1" where recordno = 47471] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="0457UC1" where recordno = 47471" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 47471] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 47471" nrows=2 ===================================================== aline=[,5804CTD8,,,YTD,,,,5804UC9,,YTF,YTF,UCP,,,,,] OldExtn=[] OldExtnGroup=[5804CTD8] OldDepartment=[] OldDivision=[] OldParent=[YTD] OldPABX=[] ---> NewVACExtnGroup=[] NewExtn=[] NewExtnGroup=[5804UC9] 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 = "5804UC9"" nrows=1 Counting Dir entry for Oldextn dothesql=[1] myprocsql: procsql ":" "select recordno from directtemplate where extgroupunique = "5804CTD8" " nrows=136 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 = "5804CTD8" " handleOld() recordno=161031 surname=RENTOULIS firstname=PETER extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161031] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161031" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161031] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161031" handleOld() recordno=163560 surname=MCKENNA firstname=RONALD extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163560] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163560" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163560] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163560" handleOld() recordno=158890 surname=MOREHEAD firstname=RICHARD A extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158890] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158890" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158890] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158890" handleOld() recordno=163564 surname=SIMMONS firstname=LAWRENCE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163564] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163564" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163564] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163564" handleOld() recordno=28025 surname=SUBRAMANIAM firstname=CHANDRA M extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 28025] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 28025" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 28025] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 28025" handleOld() recordno=1176 surname=ACTON firstname=AUBREY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 1176] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 1176" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 1176] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 1176" handleOld() recordno=1253 surname=AKERO firstname=GEOFFREY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 1253] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 1253" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 1253] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 1253" handleOld() recordno=2035 surname=ANDRES firstname=ISAGANI extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 2035] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 2035" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 2035] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 2035" handleOld() recordno=56957 surname=ANSELMO firstname=DOMINIC extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56957] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56957" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56957] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56957" handleOld() recordno=56678 surname=LUDLOW firstname=JOHN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56678] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56678" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56678] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56678" handleOld() recordno=2244 surname=ARULANANDAM firstname=EMMANUEL R extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 2244] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 2244" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 2244] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 2244" handleOld() recordno=28012 surname=OOI firstname=THOMAS extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 28012] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 28012" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 28012] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 28012" handleOld() recordno=162547 surname=DE ROZARIO firstname=CEDRIC extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162547] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162547" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162547] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162547" handleOld() recordno=2388 surname=AZEMOTHE firstname=MAUDLINE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 2388] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 2388" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 2388] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 2388" handleOld() recordno=172344 surname=CAMPBELL firstname=JOHN extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 172344] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 172344" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 172344] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 172344" handleOld() recordno=46035 surname=ARULANANDAM firstname=CHRISTOPHE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 46035] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 46035" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 46035] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 46035" handleOld() recordno=158924 surname=FAALELE firstname=DANNY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158924] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158924" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158924] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158924" handleOld() recordno=3951 surname=CAKAREVIC firstname=ZIVKO extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 3951] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 3951" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 3951] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 3951" handleOld() recordno=45642 surname=MIKHAIL firstname=SALWA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 45642] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 45642" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 45642] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 45642" handleOld() recordno=4376 surname=CHANLAITIM firstname=MICHAEL extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 4376] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 4376" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 4376] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 4376" handleOld() recordno=4393 surname=CHANG firstname=CHUN SEA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 4393] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 4393" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 4393] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 4393" handleOld() recordno=4440 surname=CHAU firstname=NGOC extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 4440] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 4440" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 4440] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 4440" handleOld() recordno=4446 surname=CHEA firstname=VACHIRITH extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 4446] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 4446" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 4446] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 4446" handleOld() recordno=162551 surname=SAUNOA firstname=SYMON extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162551] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162551" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162551] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162551" handleOld() recordno=33417 surname=MIKHAIL firstname=AMGAD extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 33417] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 33417" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 33417] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 33417" handleOld() recordno=163557 surname=GIBLETT firstname=IAN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163557] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163557" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163557] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163557" handleOld() recordno=161020 surname=DONOVAN firstname=MICHAEL extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161020] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161020" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161020] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161020" handleOld() recordno=52640 surname=EVERARD firstname=KATINA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52640] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52640" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52640] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52640" handleOld() recordno=158893 surname=D VAS firstname=DON extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158893] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158893" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158893] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158893" handleOld() recordno=162322 surname=THOMOPOULOS firstname=NICK extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162322] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162322" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162322] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162322" handleOld() recordno=56958 surname=BEGGS firstname=MICHAEL extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56958] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56958" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56958] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56958" handleOld() recordno=160523 surname=NGO firstname=TAN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160523] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160523" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160523] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160523" handleOld() recordno=29498 surname=RANDI firstname=ERMES extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 29498] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 29498" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 29498] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 29498" handleOld() recordno=5972 surname=DESAI firstname=SHAILEISH extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 5972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 5972" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 5972] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 5972" handleOld() recordno=52613 surname=FINNIGAN firstname=TIM extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52613] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52613" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52613] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52613" handleOld() recordno=160522 surname=DANG firstname=VAN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160522] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160522" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160522] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160522" handleOld() recordno=56962 surname=HARRIS firstname=MUNRO extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56962] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56962" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56962] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56962" handleOld() recordno=6121 surname=DIEP firstname=CHIEU extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 6121] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 6121" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 6121] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 6121" handleOld() recordno=38943 surname=.ASSIGNED firstname= extension=13660 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 38943] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 38943" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38943] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38943" handleOld() recordno=7023 surname=FEDDEN firstname=RAYMOND extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 7023] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 7023" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 7023] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 7023" handleOld() recordno=162507 surname=KARUNANAYAKE firstname=SENAKE B extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162507] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162507" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162507] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162507" handleOld() recordno=55795 surname=FUNDER firstname=MICHAEL extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 55795] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 55795" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 55795] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 55795" handleOld() recordno=7853 surname=GHARGHORI firstname=YOLANDE A extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 7853] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 7853" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 7853] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 7853" handleOld() recordno=163614 surname=YACOUB firstname=FAWZIA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163614] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163614" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163614] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163614" handleOld() recordno=53991 surname=HA firstname=RAY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 53991] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 53991" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 53991] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 53991" handleOld() recordno=8566 surname=HALL firstname=LESLIE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 8566] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 8566" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 8566] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 8566" handleOld() recordno=8602 surname=HAMAWI firstname=SAMIA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 8602] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 8602" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 8602] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 8602" handleOld() recordno=160521 surname=CONIGLIO firstname=DON extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160521] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160521" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160521] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160521" handleOld() recordno=56966 surname=SMITH firstname=CRAIG extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56966] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56966" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56966] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56966" handleOld() recordno=38894 surname=.ASSIGNED firstname= extension=13600 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 38894] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 38894" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38894] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38894" handleOld() recordno=160520 surname=CAMPANARO firstname=ELIZABETH extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160520] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160520" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160520] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160520" handleOld() recordno=163565 surname=SMALL firstname=ANTHONY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163565] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163565" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163565] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163565" handleOld() recordno=9522 surname=YEE firstname=DEAN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 9522] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 9522" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 9522] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 9522" handleOld() recordno=9523 surname=HUYNH firstname=THANH extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 9523] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 9523" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 9523] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 9523" handleOld() recordno=158894 surname=JAMES firstname=CLIFFORD extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158894] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158894" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158894] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158894" handleOld() recordno=9787 surname=JAMETT firstname=JORGE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 9787] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 9787" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 9787] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 9787" handleOld() recordno=166799 surname=ROBERTS firstname=SID extension=13605 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 166799] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 166799" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 166799] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 166799" handleOld() recordno=52155 surname=LIPSETT firstname=PETER extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52155] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52155" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52155] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52155" handleOld() recordno=158925 surname=LABEN firstname=DONNY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158925] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158925" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158925] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158925" handleOld() recordno=31746 surname=SANAD firstname=GEORGE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 31746] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 31746" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 31746] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 31746" handleOld() recordno=49521 surname=METE firstname=RENE extension=13605 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 49521] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 49521" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 49521] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 49521" handleOld() recordno=10601 surname=KINGSAVANH firstname=FEVAKHAM extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 10601] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 10601" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 10601] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 10601" handleOld() recordno=10679 surname=KNEZEVICH firstname=LETICIA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 10679] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 10679" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 10679] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 10679" handleOld() recordno=162785 surname=ANDERSON firstname=CANE extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162785] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162785" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162785] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162785" handleOld() recordno=11013 surname=LALL firstname=JAVED extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 11013] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 11013" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 11013] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 11013" handleOld() recordno=158891 surname=DUNKLEY firstname=JEFFERY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158891] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158891" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158891] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158891" handleOld() recordno=49474 surname=MALVASO firstname=DOMENICO extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 49474] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 49474" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 49474] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 49474" handleOld() recordno=11210 surname=LAY firstname=KUONG extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 11210] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 11210" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 11210] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 11210" handleOld() recordno=27371 surname=ALI firstname=SHAHID extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 27371] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 27371" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 27371] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 27371" handleOld() recordno=46046 surname=.ASSIGNED firstname= extension=13603 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 46046] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 46046" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 46046] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 46046" handleOld() recordno=27613 surname=COLLINS firstname=LANCELOT B extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 27613] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 27613" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 27613] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 27613" handleOld() recordno=12028 surname=AKERO firstname=MERCILITA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 12028] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 12028" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 12028] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 12028" handleOld() recordno=12302 surname=MATHER firstname=ANDREW extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 12302] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 12302" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 12302] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 12302" handleOld() recordno=163562 surname=MICHEL firstname=JUDE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163562] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163562" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163562] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163562" handleOld() recordno=52637 surname=AULD firstname=DENNIS extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52637] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52637" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52637] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52637" handleOld() recordno=13911 surname=NGUYEN firstname=DUY K extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 13911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 13911" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 13911] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 13911" handleOld() recordno=13943 surname=NGUYEN firstname=TRIEU extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 13943] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 13943" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 13943] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 13943" handleOld() recordno=13949 surname=NGUYEN firstname=VAN CAO extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 13949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 13949" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 13949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 13949" handleOld() recordno=164707 surname=SMITH firstname=KIM extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 164707] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 164707" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 164707] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 164707" handleOld() recordno=14866 surname=PEREIRA firstname=ADOLPH extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 14866] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 14866" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 14866] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 14866" handleOld() recordno=14872 surname=PEREIRA firstname=GEORGE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 14872] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 14872" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 14872] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 14872" handleOld() recordno=14902 surname=PERISTERIS firstname=CHRISTOS extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 14902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 14902" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 14902] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 14902" handleOld() recordno=163556 surname=BROWN firstname=ANTHONY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163556" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163556] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163556" handleOld() recordno=56961 surname=DOHERTY firstname=SHANE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56961] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56961" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56961] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56961" handleOld() recordno=15714 surname=RASIAH firstname=RAJENDRA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 15714] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 15714" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 15714] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 15714" handleOld() recordno=162550 surname=RIPPER firstname=ALAN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162550" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162550] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162550" handleOld() recordno=16152 surname=PRONOBIS firstname=INGRID extension=13601 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 16152] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 16152" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 16152] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 16152" handleOld() recordno=162549 surname=ROWINSKA firstname=ELIZABETH extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162549] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162549" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162549] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162549" handleOld() recordno=54023 surname=ALLOM firstname=NIGEL extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 54023] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 54023" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 54023] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 54023" handleOld() recordno=162436 surname=MARSHALL firstname=GLENN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162436] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162436" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162436] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162436" handleOld() recordno=16537 surname=SALMANZADEH firstname=MUHEBAT extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 16537] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 16537" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 16537] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 16537" handleOld() recordno=52639 surname=MEYER firstname=PAUL extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52639] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 52639" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52639] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 52639" handleOld() recordno=16627 surname=SANYOTO firstname=SENTOT extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 16627] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 16627" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 16627] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 16627" handleOld() recordno=55264 surname=.ASSIGNED firstname= extension=13608 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 55264] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 55264" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 55264] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 55264" handleOld() recordno=160519 surname=BUI firstname=THOM extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160519] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160519" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160519] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160519" handleOld() recordno=158889 surname=BAILLIEU firstname=KATHLEEN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158889] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158889" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158889] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158889" handleOld() recordno=17456 surname=SMALL firstname=NORMAN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 17456] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 17456" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 17456] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 17456" handleOld() recordno=17688 surname=SON firstname=TEAN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 17688] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 17688" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 17688] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 17688" handleOld() recordno=160518 surname=BARTLEY firstname=STEPHEN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160518] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 160518" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160518] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 160518" handleOld() recordno=158896 surname=FEILLAFE firstname=JOSE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158896] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 158896" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158896] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 158896" handleOld() recordno=28033 surname=NGUYEN firstname=THANH MINH extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 28033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 28033" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 28033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 28033" handleOld() recordno=18296 surname=TAGLE firstname=ALEXANDER extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 18296] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 18296" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 18296] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 18296" handleOld() recordno=162548 surname=JAMIESON firstname=PETER extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162548] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162548" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162548] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162548" handleOld() recordno=18593 surname=THEOHARIS firstname=EVANGELOS extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 18593] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 18593" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 18593] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 18593" handleOld() recordno=163567 surname=GLADSTONE firstname=DARREN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163567] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163567" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163567] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163567" handleOld() recordno=38950 surname=.ASSIGNED firstname= extension=13667 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 38950] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 38950" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38950] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38950" handleOld() recordno=28029 surname=NGUYEN firstname=KIEM CHI extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 28029] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 28029" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 28029] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 28029" handleOld() recordno=163563 surname=NORMAN firstname=GEOFFREY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163563] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163563" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163563] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163563" handleOld() recordno=19096 surname=TSOI firstname=FOO K extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 19096] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 19096" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 19096] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 19096" handleOld() recordno=56960 surname=CAMERON firstname=CASEY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56960] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56960" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56960] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56960" handleOld() recordno=56959 surname=BRYANT firstname=IAN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56959" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56959] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56959" handleOld() recordno=163566 surname=WARREN firstname=MARK extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163566] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163566" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163566] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163566" handleOld() recordno=161018 surname=BROWNE firstname=STEPHEN extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161018] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161018" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161018] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161018" handleOld() recordno=163559 surname=KARAKOSTAS firstname=THOMAS extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163559] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163559" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163559] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163559" handleOld() recordno=56968 surname=VYAS firstname=RAJENDRA extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56968] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56968" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56968] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56968" handleOld() recordno=162538 surname=BROWN firstname=NOEL extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162538] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 162538" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162538] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 162538" handleOld() recordno=20274 surname=WILLIAMS firstname=IBRAHIM extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 20274] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 20274" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 20274] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 20274" handleOld() recordno=163558 surname=JOLLY firstname=ANDREW extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163558] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163558" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163558] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163558" handleOld() recordno=20359 surname=WILSON firstname=COLIN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 20359] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 20359" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 20359] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 20359" handleOld() recordno=20427 surname=WIMALASURIYA firstname=JINENDRASE extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 20427] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 20427" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 20427] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 20427" handleOld() recordno=38949 surname=.ASSIGNED firstname= extension=13666 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 38949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 38949" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 38949" handleOld() recordno=50809 surname=REID firstname=JOHN extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 50809] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 50809" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 50809] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 50809" handleOld() recordno=56949 surname=NOYAUX firstname=LOUIS extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 56949" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56949] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 56949" handleOld() recordno=164705 surname=LOUEY firstname=MARK extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 164705] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 164705" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 164705] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 164705" handleOld() recordno=161017 surname=BRISTOW firstname=GRAEME extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161017] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161017" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161017] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161017" handleOld() recordno=161025 surname=KRAWCZYK firstname=DONNA extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161025] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161025" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161025] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161025" handleOld() recordno=163561 surname=METRY firstname=SAMY extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163561] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 163561" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163561] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 163561" handleOld() recordno=181403 surname=KESSOUAR firstname=LILIA extension=13660 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 181403] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 181403" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 181403] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 181403" handleOld() recordno=161019 surname=DAHAN firstname=ZINA extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161019] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161019" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161019] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161019" handleOld() recordno=161076 surname=WILLISON firstname=WILLIAM extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161076] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161076" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161076] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161076" handleOld() recordno=161026 surname=LINCOLN firstname=BRENDON extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161026] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161026" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161026] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161026" handleOld() recordno=161030 surname=PITAMA firstname=KEVIN extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161030] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161030" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161030] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161030" handleOld() recordno=161033 surname=STA-MARIA firstname=SHERMAN extension=13613 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 161033" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161033] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 161033" handleOld() recordno=172928 surname=.ASSIGNED firstname= extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 172928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 172928" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 172928] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 172928" handleOld() recordno=172342 surname=.ASSIGNED firstname= extension=13602 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 172342] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 172342" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 172342] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 172342" handleOld() recordno=172343 surname=RASSIAS firstname=LOUIS extension=13605 site=CTD extgroupunique=5804CTD8 handleOld(): updating... sqlcmd=[update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 172343] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directtemplate set secure_code = secure_code, fgroup = "V" ,site="UCP" ,extgroupunique="5804UC9" where recordno = 172343" sqlcmd=[update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 172343] sub_dothesql=[1] mysubprocsql: sub_procsql ":" "update directcustom set date_updated="31/05/2018" ,jobno="RS310518CTDTRAMDEPOT" ,division="YTF" where recordno = 172343" nrows=136