Started: ldomn1.awk ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 252855 - alumni@curtin.edu.au] CurrentCost=[0.33] Extension=[3113] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3113 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|ALUMNI|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1271~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3113 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1271~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3113 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[ALUMNI] Found: site_siteid=[101] dt_extgroupunique=[ALUMNI] ovhcode=[M20220331215847] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215847','DEBIT','MESSAGENET','Messagenet FEB 2022 252855 - alumni@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215847','DEBIT','MESSAGENET','Messagenet FEB 2022 252855 - alumni@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3554~INSERT into ovhdefn VALUES ('M','M20220331215847','DEBIT','MESSAGENET','Messagenet FEB 2022 252855 - alumni@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3554~INSERT into ovhdefn VALUES ('M','M20220331215847','DEBIT','MESSAGENET','Messagenet FEB 2022 252855 - alumni@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215847',0.33,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215847',0.33,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3558~INSERT into ovhcost VALUES ('M20220331215847',0.33,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3558~INSERT into ovhcost VALUES ('M20220331215847',0.33,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'ALUMNI',3113,'N','M20220331215847','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'ALUMNI',3113,'N','M20220331215847','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54856~0~2~0~21181~INSERT into ovhasso VALUES (0,101,'ALUMNI',3113,'N','M20220331215847','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54856~0~2~0~21181~INSERT into ovhasso VALUES (0,101,'ALUMNI',3113,'N','M20220331215847','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 255828 - dba@curtin.edu.au] CurrentCost=[142.34] Extension=[4455] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4455 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|NETWORK|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5137~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4455 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5137~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4455 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[NETWORK] Found: site_siteid=[101] dt_extgroupunique=[NETWORK] ovhcode=[M20220331215848] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215848','DEBIT','MESSAGENET','Messagenet FEB 2022 255828 - dba@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215848','DEBIT','MESSAGENET','Messagenet FEB 2022 255828 - dba@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3553~INSERT into ovhdefn VALUES ('M','M20220331215848','DEBIT','MESSAGENET','Messagenet FEB 2022 255828 - dba@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3553~INSERT into ovhdefn VALUES ('M','M20220331215848','DEBIT','MESSAGENET','Messagenet FEB 2022 255828 - dba@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215848',142.34,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215848',142.34,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3557~INSERT into ovhcost VALUES ('M20220331215848',142.34,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3557~INSERT into ovhcost VALUES ('M20220331215848',142.34,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'NETWORK',4455,'N','M20220331215848','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'NETWORK',4455,'N','M20220331215848','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54857~0~2~0~21180~INSERT into ovhasso VALUES (0,101,'NETWORK',4455,'N','M20220331215848','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54857~0~2~0~21180~INSERT into ovhasso VALUES (0,101,'NETWORK',4455,'N','M20220331215848','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 262693 - support@systems.curtin.edu.au] CurrentCost=[5.28] Extension=[4455] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4455 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|NETWORK|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5137~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4455 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5137~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4455 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[NETWORK] Found: site_siteid=[101] dt_extgroupunique=[NETWORK] ovhcode=[M20220331215849] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215849','DEBIT','MESSAGENET','Messagenet FEB 2022 262693 - support@systems.curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215849','DEBIT','MESSAGENET','Messagenet FEB 2022 262693 - support@systems.curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3549~INSERT into ovhdefn VALUES ('M','M20220331215849','DEBIT','MESSAGENET','Messagenet FEB 2022 262693 - support@systems.curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3549~INSERT into ovhdefn VALUES ('M','M20220331215849','DEBIT','MESSAGENET','Messagenet FEB 2022 262693 - support@systems.curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215849',5.28,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215849',5.28,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3553~INSERT into ovhcost VALUES ('M20220331215849',5.28,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3553~INSERT into ovhcost VALUES ('M20220331215849',5.28,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'NETWORK',4455,'N','M20220331215849','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'NETWORK',4455,'N','M20220331215849','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54858~0~2~0~21176~INSERT into ovhasso VALUES (0,101,'NETWORK',4455,'N','M20220331215849','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54858~0~2~0~21176~INSERT into ovhasso VALUES (0,101,'NETWORK',4455,'N','M20220331215849','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4021512 - cfadmin@webp1.curtin.edu.au] CurrentCost=[58.41] Extension=[2000] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|NETWORK|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4460~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4460~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[NETWORK] Found: site_siteid=[101] dt_extgroupunique=[NETWORK] ovhcode=[M20220331215850] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215850','DEBIT','MESSAGENET','Messagenet FEB 2022 4021512 - cfadmin@webp1.curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215850','DEBIT','MESSAGENET','Messagenet FEB 2022 4021512 - cfadmin@webp1.curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3542~INSERT into ovhdefn VALUES ('M','M20220331215850','DEBIT','MESSAGENET','Messagenet FEB 2022 4021512 - cfadmin@webp1.curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3542~INSERT into ovhdefn VALUES ('M','M20220331215850','DEBIT','MESSAGENET','Messagenet FEB 2022 4021512 - cfadmin@webp1.curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215850',58.41,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215850',58.41,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3546~INSERT into ovhcost VALUES ('M20220331215850',58.41,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3546~INSERT into ovhcost VALUES ('M20220331215850',58.41,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215850','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215850','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54859~0~2~0~21169~INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215850','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54859~0~2~0~21169~INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215850','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4021513 - cfadmin@webp2.curtin.edu.au] CurrentCost=[52.25] Extension=[2000] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|NETWORK|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4460~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4460~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[NETWORK] Found: site_siteid=[101] dt_extgroupunique=[NETWORK] ovhcode=[M20220331215851] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215851','DEBIT','MESSAGENET','Messagenet FEB 2022 4021513 - cfadmin@webp2.curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215851','DEBIT','MESSAGENET','Messagenet FEB 2022 4021513 - cfadmin@webp2.curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3540~INSERT into ovhdefn VALUES ('M','M20220331215851','DEBIT','MESSAGENET','Messagenet FEB 2022 4021513 - cfadmin@webp2.curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3540~INSERT into ovhdefn VALUES ('M','M20220331215851','DEBIT','MESSAGENET','Messagenet FEB 2022 4021513 - cfadmin@webp2.curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215851',52.25,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215851',52.25,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3544~INSERT into ovhcost VALUES ('M20220331215851',52.25,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3544~INSERT into ovhcost VALUES ('M20220331215851',52.25,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215851','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215851','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54860~0~2~0~21167~INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215851','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54860~0~2~0~21167~INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215851','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4021514 - cfadmin@webp3.curtin.edu.au] CurrentCost=[124.52] Extension=[2000] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|NETWORK|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4460~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4460~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[NETWORK] Found: site_siteid=[101] dt_extgroupunique=[NETWORK] ovhcode=[M20220331215852] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215852','DEBIT','MESSAGENET','Messagenet FEB 2022 4021514 - cfadmin@webp3.curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215852','DEBIT','MESSAGENET','Messagenet FEB 2022 4021514 - cfadmin@webp3.curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3537~INSERT into ovhdefn VALUES ('M','M20220331215852','DEBIT','MESSAGENET','Messagenet FEB 2022 4021514 - cfadmin@webp3.curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3537~INSERT into ovhdefn VALUES ('M','M20220331215852','DEBIT','MESSAGENET','Messagenet FEB 2022 4021514 - cfadmin@webp3.curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215852',124.52,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215852',124.52,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3541~INSERT into ovhcost VALUES ('M20220331215852',124.52,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3541~INSERT into ovhcost VALUES ('M20220331215852',124.52,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215852','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215852','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54861~0~2~0~21164~INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215852','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54861~0~2~0~21164~INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215852','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4021515 - cfadmin@webp4.curtin.edu.au] CurrentCost=[139.7] Extension=[2000] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|NETWORK|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4460~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4460~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2000 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[NETWORK] Found: site_siteid=[101] dt_extgroupunique=[NETWORK] ovhcode=[M20220331215853] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215853','DEBIT','MESSAGENET','Messagenet FEB 2022 4021515 - cfadmin@webp4.curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215853','DEBIT','MESSAGENET','Messagenet FEB 2022 4021515 - cfadmin@webp4.curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3550~INSERT into ovhdefn VALUES ('M','M20220331215853','DEBIT','MESSAGENET','Messagenet FEB 2022 4021515 - cfadmin@webp4.curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3550~INSERT into ovhdefn VALUES ('M','M20220331215853','DEBIT','MESSAGENET','Messagenet FEB 2022 4021515 - cfadmin@webp4.curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215853',139.70,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215853',139.70,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3554~INSERT into ovhcost VALUES ('M20220331215853',139.70,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3554~INSERT into ovhcost VALUES ('M20220331215853',139.70,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215853','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215853','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54862~0~2~0~21177~INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215853','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54862~0~2~0~21177~INSERT into ovhasso VALUES (0,101,'NETWORK',2000,'N','M20220331215853','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4029250 - s.murray@curtin.edu.au] CurrentCost=[3.96] Extension=[7850] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7850 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|COUNSELL|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5459~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7850 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5459~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7850 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[COUNSELL] Found: site_siteid=[101] dt_extgroupunique=[COUNSELL] ovhcode=[M20220331215854] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215854','DEBIT','MESSAGENET','Messagenet FEB 2022 4029250 - s.murray@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215854','DEBIT','MESSAGENET','Messagenet FEB 2022 4029250 - s.murray@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3548~INSERT into ovhdefn VALUES ('M','M20220331215854','DEBIT','MESSAGENET','Messagenet FEB 2022 4029250 - s.murray@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3548~INSERT into ovhdefn VALUES ('M','M20220331215854','DEBIT','MESSAGENET','Messagenet FEB 2022 4029250 - s.murray@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215854',3.96,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215854',3.96,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3552~INSERT into ovhcost VALUES ('M20220331215854',3.96,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3552~INSERT into ovhcost VALUES ('M20220331215854',3.96,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'COUNSELL',7850,'N','M20220331215854','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'COUNSELL',7850,'N','M20220331215854','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54863~0~2~0~21175~INSERT into ovhasso VALUES (0,101,'COUNSELL',7850,'N','M20220331215854','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54863~0~2~0~21175~INSERT into ovhasso VALUES (0,101,'COUNSELL',7850,'N','M20220331215854','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4035508 - n.gasson@curtin.edu.au] CurrentCost=[2.42] Extension=[4308] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4308 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|PSYCHOLA|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4564~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4308 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4564~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4308 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[PSYCHOLA] Found: site_siteid=[101] dt_extgroupunique=[PSYCHOLA] ovhcode=[M20220331215855] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215855','DEBIT','MESSAGENET','Messagenet FEB 2022 4035508 - n.gasson@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215855','DEBIT','MESSAGENET','Messagenet FEB 2022 4035508 - n.gasson@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3529~INSERT into ovhdefn VALUES ('M','M20220331215855','DEBIT','MESSAGENET','Messagenet FEB 2022 4035508 - n.gasson@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3529~INSERT into ovhdefn VALUES ('M','M20220331215855','DEBIT','MESSAGENET','Messagenet FEB 2022 4035508 - n.gasson@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215855',2.42,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215855',2.42,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3533~INSERT into ovhcost VALUES ('M20220331215855',2.42,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3533~INSERT into ovhcost VALUES ('M20220331215855',2.42,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'PSYCHOLA',4308,'N','M20220331215855','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'PSYCHOLA',4308,'N','M20220331215855','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54864~0~2~0~18930~INSERT into ovhasso VALUES (0,101,'PSYCHOLA',4308,'N','M20220331215855','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54864~0~2~0~18930~INSERT into ovhasso VALUES (0,101,'PSYCHOLA',4308,'N','M20220331215855','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4090294 - a.ridley@curtin.edu.au] CurrentCost=[0.66] Extension=[9802] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 9802 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|CELCADMN|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~6403~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 9802 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~6403~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 9802 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[CELCADMN] Found: site_siteid=[101] dt_extgroupunique=[CELCADMN] ovhcode=[M20220331215856] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215856','DEBIT','MESSAGENET','Messagenet FEB 2022 4090294 - a.ridley@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215856','DEBIT','MESSAGENET','Messagenet FEB 2022 4090294 - a.ridley@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3530~INSERT into ovhdefn VALUES ('M','M20220331215856','DEBIT','MESSAGENET','Messagenet FEB 2022 4090294 - a.ridley@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3530~INSERT into ovhdefn VALUES ('M','M20220331215856','DEBIT','MESSAGENET','Messagenet FEB 2022 4090294 - a.ridley@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215856',0.66,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215856',0.66,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3534~INSERT into ovhcost VALUES ('M20220331215856',0.66,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3534~INSERT into ovhcost VALUES ('M20220331215856',0.66,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'CELCADMN',9802,'N','M20220331215856','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'CELCADMN',9802,'N','M20220331215856','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54865~0~2~0~21157~INSERT into ovhasso VALUES (0,101,'CELCADMN',9802,'N','M20220331215856','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54865~0~2~0~21157~INSERT into ovhasso VALUES (0,101,'CELCADMN',9802,'N','M20220331215856','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4104273 - desmond.pegrum@cbs.curtin.edu.au] CurrentCost=[0.11] Extension=[4087] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4087 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|DIVOFFBC|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~2131~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4087 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~2131~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4087 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[DIVOFFBC] Found: site_siteid=[101] dt_extgroupunique=[DIVOFFBC] ovhcode=[M20220331215857] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215857','DEBIT','MESSAGENET','Messagenet FEB 2022 4104273 - desmond.pegrum@cbs.curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215857','DEBIT','MESSAGENET','Messagenet FEB 2022 4104273 - desmond.pegrum@cbs.curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3535~INSERT into ovhdefn VALUES ('M','M20220331215857','DEBIT','MESSAGENET','Messagenet FEB 2022 4104273 - desmond.pegrum@cbs.curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3535~INSERT into ovhdefn VALUES ('M','M20220331215857','DEBIT','MESSAGENET','Messagenet FEB 2022 4104273 - desmond.pegrum@cbs.curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215857',0.11,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215857',0.11,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3539~INSERT into ovhcost VALUES ('M20220331215857',0.11,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3539~INSERT into ovhcost VALUES ('M20220331215857',0.11,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'DIVOFFBC',4087,'N','M20220331215857','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'DIVOFFBC',4087,'N','M20220331215857','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54866~0~2~0~21162~INSERT into ovhasso VALUES (0,101,'DIVOFFBC',4087,'N','M20220331215857','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54866~0~2~0~21162~INSERT into ovhasso VALUES (0,101,'DIVOFFBC',4087,'N','M20220331215857','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4144555 - amanda.smith@curtin.edu.au] CurrentCost=[2.64] Extension=[9819] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 9819 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|SSAFPROJ|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~6418~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 9819 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~6418~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 9819 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[SSAFPROJ] Found: site_siteid=[101] dt_extgroupunique=[SSAFPROJ] ovhcode=[M20220331215858] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215858','DEBIT','MESSAGENET','Messagenet FEB 2022 4144555 - amanda.smith@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215858','DEBIT','MESSAGENET','Messagenet FEB 2022 4144555 - amanda.smith@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3534~INSERT into ovhdefn VALUES ('M','M20220331215858','DEBIT','MESSAGENET','Messagenet FEB 2022 4144555 - amanda.smith@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3534~INSERT into ovhdefn VALUES ('M','M20220331215858','DEBIT','MESSAGENET','Messagenet FEB 2022 4144555 - amanda.smith@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215858',2.64,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215858',2.64,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3538~INSERT into ovhcost VALUES ('M20220331215858',2.64,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3538~INSERT into ovhcost VALUES ('M20220331215858',2.64,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'SSAFPROJ',9819,'N','M20220331215858','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'SSAFPROJ',9819,'N','M20220331215858','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54867~0~2~0~21161~INSERT into ovhasso VALUES (0,101,'SSAFPROJ',9819,'N','M20220331215858','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54867~0~2~0~21161~INSERT into ovhasso VALUES (0,101,'SSAFPROJ',9819,'N','M20220331215858','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4213121 - stephanie.cook@curtin.edu.au] CurrentCost=[3.08] Extension=[5837] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 5837 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|EDUC 1|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~7246~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 5837 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~7246~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 5837 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[EDUC 1] Found: site_siteid=[101] dt_extgroupunique=[EDUC 1] ovhcode=[M20220331215859] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215859','DEBIT','MESSAGENET','Messagenet FEB 2022 4213121 - stephanie.cook@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215859','DEBIT','MESSAGENET','Messagenet FEB 2022 4213121 - stephanie.cook@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3533~INSERT into ovhdefn VALUES ('M','M20220331215859','DEBIT','MESSAGENET','Messagenet FEB 2022 4213121 - stephanie.cook@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3533~INSERT into ovhdefn VALUES ('M','M20220331215859','DEBIT','MESSAGENET','Messagenet FEB 2022 4213121 - stephanie.cook@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215859',3.08,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215859',3.08,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3537~INSERT into ovhcost VALUES ('M20220331215859',3.08,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3537~INSERT into ovhcost VALUES ('M20220331215859',3.08,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'EDUC 1',5837,'N','M20220331215859','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'EDUC 1',5837,'N','M20220331215859','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54868~0~2~0~21160~INSERT into ovhasso VALUES (0,101,'EDUC 1',5837,'N','M20220331215859','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54868~0~2~0~21160~INSERT into ovhasso VALUES (0,101,'EDUC 1',5837,'N','M20220331215859','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4227794 - uniready@curtin.edu.au] CurrentCost=[1.76] Extension=[7632] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|UNI-READ|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1497~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1497~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[UNI-READ] Found: site_siteid=[101] dt_extgroupunique=[UNI-READ] ovhcode=[M20220331215900] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215900','DEBIT','MESSAGENET','Messagenet FEB 2022 4227794 - uniready@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215900','DEBIT','MESSAGENET','Messagenet FEB 2022 4227794 - uniready@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3532~INSERT into ovhdefn VALUES ('M','M20220331215900','DEBIT','MESSAGENET','Messagenet FEB 2022 4227794 - uniready@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3532~INSERT into ovhdefn VALUES ('M','M20220331215900','DEBIT','MESSAGENET','Messagenet FEB 2022 4227794 - uniready@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215900',1.76,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215900',1.76,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3536~INSERT into ovhcost VALUES ('M20220331215900',1.76,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3536~INSERT into ovhcost VALUES ('M20220331215900',1.76,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215900','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215900','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54869~0~2~0~21159~INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215900','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54869~0~2~0~21159~INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215900','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4281632 - admissions] CurrentCost=[39.27] Extension=[7805] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7805 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|ARO-C|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1261~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7805 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1261~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7805 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[ARO-C] Found: site_siteid=[101] dt_extgroupunique=[ARO-C] ovhcode=[M20220331215901] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215901','DEBIT','MESSAGENET','Messagenet FEB 2022 4281632 - admissions',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215901','DEBIT','MESSAGENET','Messagenet FEB 2022 4281632 - admissions',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3555~INSERT into ovhdefn VALUES ('M','M20220331215901','DEBIT','MESSAGENET','Messagenet FEB 2022 4281632 - admissions',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3555~INSERT into ovhdefn VALUES ('M','M20220331215901','DEBIT','MESSAGENET','Messagenet FEB 2022 4281632 - admissions',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215901',39.27,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215901',39.27,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3559~INSERT into ovhcost VALUES ('M20220331215901',39.27,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3559~INSERT into ovhcost VALUES ('M20220331215901',39.27,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'ARO-C',7805,'N','M20220331215901','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'ARO-C',7805,'N','M20220331215901','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54870~0~2~0~21182~INSERT into ovhasso VALUES (0,101,'ARO-C',7805,'N','M20220331215901','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54870~0~2~0~21182~INSERT into ovhasso VALUES (0,101,'ARO-C',7805,'N','M20220331215901','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4284414 - counselling@curtin.edu.au] CurrentCost=[136.4] Extension=[7850] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7850 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|COUNSELL|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5459~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7850 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5459~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7850 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[COUNSELL] Found: site_siteid=[101] dt_extgroupunique=[COUNSELL] ovhcode=[M20220331215902] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215902','DEBIT','MESSAGENET','Messagenet FEB 2022 4284414 - counselling@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215902','DEBIT','MESSAGENET','Messagenet FEB 2022 4284414 - counselling@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3541~INSERT into ovhdefn VALUES ('M','M20220331215902','DEBIT','MESSAGENET','Messagenet FEB 2022 4284414 - counselling@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3541~INSERT into ovhdefn VALUES ('M','M20220331215902','DEBIT','MESSAGENET','Messagenet FEB 2022 4284414 - counselling@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215902',136.40,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215902',136.40,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3545~INSERT into ovhcost VALUES ('M20220331215902',136.40,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3545~INSERT into ovhcost VALUES ('M20220331215902',136.40,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'COUNSELL',7850,'N','M20220331215902','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'COUNSELL',7850,'N','M20220331215902','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54871~0~2~0~21168~INSERT into ovhasso VALUES (0,101,'COUNSELL',7850,'N','M20220331215902','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54871~0~2~0~21168~INSERT into ovhasso VALUES (0,101,'COUNSELL',7850,'N','M20220331215902','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4329803 - curtinenglish@curtin.edu.au] CurrentCost=[0.11] Extension=[2154] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2154 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|CELCADMN|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~3576~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2154 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~3576~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 2154 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[CELCADMN] Found: site_siteid=[101] dt_extgroupunique=[CELCADMN] ovhcode=[M20220331215903] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215903','DEBIT','MESSAGENET','Messagenet FEB 2022 4329803 - curtinenglish@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215903','DEBIT','MESSAGENET','Messagenet FEB 2022 4329803 - curtinenglish@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3552~INSERT into ovhdefn VALUES ('M','M20220331215903','DEBIT','MESSAGENET','Messagenet FEB 2022 4329803 - curtinenglish@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3552~INSERT into ovhdefn VALUES ('M','M20220331215903','DEBIT','MESSAGENET','Messagenet FEB 2022 4329803 - curtinenglish@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215903',0.11,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215903',0.11,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3556~INSERT into ovhcost VALUES ('M20220331215903',0.11,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3556~INSERT into ovhcost VALUES ('M20220331215903',0.11,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'CELCADMN',2154,'N','M20220331215903','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'CELCADMN',2154,'N','M20220331215903','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54872~0~2~0~21179~INSERT into ovhasso VALUES (0,101,'CELCADMN',2154,'N','M20220331215903','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54872~0~2~0~21179~INSERT into ovhasso VALUES (0,101,'CELCADMN',2154,'N','M20220331215903','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4332506 - cmscurrentstudents] CurrentCost=[7.92] Extension=[1919] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1919 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|BENT-VAC|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~6070~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1919 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~6070~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1919 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[BENT-VAC] Found: site_siteid=[101] dt_extgroupunique=[BENT-VAC] ovhcode=[M20220331215904] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215904','DEBIT','MESSAGENET','Messagenet FEB 2022 4332506 - cmscurrentstudents',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215904','DEBIT','MESSAGENET','Messagenet FEB 2022 4332506 - cmscurrentstudents',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3539~INSERT into ovhdefn VALUES ('M','M20220331215904','DEBIT','MESSAGENET','Messagenet FEB 2022 4332506 - cmscurrentstudents',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3539~INSERT into ovhdefn VALUES ('M','M20220331215904','DEBIT','MESSAGENET','Messagenet FEB 2022 4332506 - cmscurrentstudents',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215904',7.92,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215904',7.92,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3543~INSERT into ovhcost VALUES ('M20220331215904',7.92,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3543~INSERT into ovhcost VALUES ('M20220331215904',7.92,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'BENT-VAC',1919,'N','M20220331215904','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'BENT-VAC',1919,'N','M20220331215904','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54873~0~2~0~21166~INSERT into ovhasso VALUES (0,101,'BENT-VAC',1919,'N','M20220331215904','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54873~0~2~0~21166~INSERT into ovhasso VALUES (0,101,'BENT-VAC',1919,'N','M20220331215904','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4333397 - nexacurtconn@curtin.edu.au] CurrentCost=[787.6] Extension=[1000] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1000 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|DIVOFFBC|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~7105~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1000 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~7105~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1000 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[DIVOFFBC] Found: site_siteid=[101] dt_extgroupunique=[DIVOFFBC] ovhcode=[M20220331215905] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215905','DEBIT','MESSAGENET','Messagenet FEB 2022 4333397 - nexacurtconn@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215905','DEBIT','MESSAGENET','Messagenet FEB 2022 4333397 - nexacurtconn@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3551~INSERT into ovhdefn VALUES ('M','M20220331215905','DEBIT','MESSAGENET','Messagenet FEB 2022 4333397 - nexacurtconn@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3551~INSERT into ovhdefn VALUES ('M','M20220331215905','DEBIT','MESSAGENET','Messagenet FEB 2022 4333397 - nexacurtconn@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215905',787.60,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215905',787.60,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3555~INSERT into ovhcost VALUES ('M20220331215905',787.60,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3555~INSERT into ovhcost VALUES ('M20220331215905',787.60,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'DIVOFFBC',1000,'N','M20220331215905','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'DIVOFFBC',1000,'N','M20220331215905','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54874~0~2~0~21178~INSERT into ovhasso VALUES (0,101,'DIVOFFBC',1000,'N','M20220331215905','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54874~0~2~0~21178~INSERT into ovhasso VALUES (0,101,'DIVOFFBC',1000,'N','M20220331215905','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4360232 - a.monks@curtin.edu.au] CurrentCost=[47.08] Extension=[3604] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3604 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|OCC-THER|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5012~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3604 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5012~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3604 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[OCC-THER] Found: site_siteid=[101] dt_extgroupunique=[OCC-THER] ovhcode=[M20220331215906] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215906','DEBIT','MESSAGENET','Messagenet FEB 2022 4360232 - a.monks@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215906','DEBIT','MESSAGENET','Messagenet FEB 2022 4360232 - a.monks@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3547~INSERT into ovhdefn VALUES ('M','M20220331215906','DEBIT','MESSAGENET','Messagenet FEB 2022 4360232 - a.monks@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3547~INSERT into ovhdefn VALUES ('M','M20220331215906','DEBIT','MESSAGENET','Messagenet FEB 2022 4360232 - a.monks@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215906',47.08,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215906',47.08,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3551~INSERT into ovhcost VALUES ('M20220331215906',47.08,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3551~INSERT into ovhcost VALUES ('M20220331215906',47.08,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'OCC-THER',3604,'N','M20220331215906','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'OCC-THER',3604,'N','M20220331215906','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54875~0~2~0~21174~INSERT into ovhasso VALUES (0,101,'OCC-THER',3604,'N','M20220331215906','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54875~0~2~0~21174~INSERT into ovhasso VALUES (0,101,'OCC-THER',3604,'N','M20220331215906','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4361058 - ss.uniready@curtin.edu.au] CurrentCost=[0.88] Extension=[7632] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|UNI-READ|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1497~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1497~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[UNI-READ] Found: site_siteid=[101] dt_extgroupunique=[UNI-READ] ovhcode=[M20220331215907] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215907','DEBIT','MESSAGENET','Messagenet FEB 2022 4361058 - ss.uniready@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215907','DEBIT','MESSAGENET','Messagenet FEB 2022 4361058 - ss.uniready@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3544~INSERT into ovhdefn VALUES ('M','M20220331215907','DEBIT','MESSAGENET','Messagenet FEB 2022 4361058 - ss.uniready@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3544~INSERT into ovhdefn VALUES ('M','M20220331215907','DEBIT','MESSAGENET','Messagenet FEB 2022 4361058 - ss.uniready@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215907',0.88,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215907',0.88,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3548~INSERT into ovhcost VALUES ('M20220331215907',0.88,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3548~INSERT into ovhcost VALUES ('M20220331215907',0.88,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215907','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215907','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54876~0~2~0~21171~INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215907','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54876~0~2~0~21171~INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215907','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4374842 - physioclinicalprogram@curtin.edu.au] CurrentCost=[3.74] Extension=[4659] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4659 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|PHYSIO|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~570~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4659 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~570~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 4659 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[PHYSIO] Found: site_siteid=[101] dt_extgroupunique=[PHYSIO] ovhcode=[M20220331215908] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215908','DEBIT','MESSAGENET','Messagenet FEB 2022 4374842 - physioclinicalprogram@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215908','DEBIT','MESSAGENET','Messagenet FEB 2022 4374842 - physioclinicalprogram@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3536~INSERT into ovhdefn VALUES ('M','M20220331215908','DEBIT','MESSAGENET','Messagenet FEB 2022 4374842 - physioclinicalprogram@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3536~INSERT into ovhdefn VALUES ('M','M20220331215908','DEBIT','MESSAGENET','Messagenet FEB 2022 4374842 - physioclinicalprogram@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215908',3.74,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215908',3.74,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3540~INSERT into ovhcost VALUES ('M20220331215908',3.74,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3540~INSERT into ovhcost VALUES ('M20220331215908',3.74,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'PHYSIO',4659,'N','M20220331215908','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'PHYSIO',4659,'N','M20220331215908','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54877~0~2~0~21163~INSERT into ovhasso VALUES (0,101,'PHYSIO',4659,'N','M20220331215908','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54877~0~2~0~21163~INSERT into ovhasso VALUES (0,101,'PHYSIO',4659,'N','M20220331215908','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4375497 - studentservices] CurrentCost=[929.17] Extension=[1000] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1000 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|DIVOFFBC|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~7105~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1000 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~7105~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1000 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[DIVOFFBC] Found: site_siteid=[101] dt_extgroupunique=[DIVOFFBC] ovhcode=[M20220331215909] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215909','DEBIT','MESSAGENET','Messagenet FEB 2022 4375497 - studentservices',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215909','DEBIT','MESSAGENET','Messagenet FEB 2022 4375497 - studentservices',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3538~INSERT into ovhdefn VALUES ('M','M20220331215909','DEBIT','MESSAGENET','Messagenet FEB 2022 4375497 - studentservices',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3538~INSERT into ovhdefn VALUES ('M','M20220331215909','DEBIT','MESSAGENET','Messagenet FEB 2022 4375497 - studentservices',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215909',929.17,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215909',929.17,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3542~INSERT into ovhcost VALUES ('M20220331215909',929.17,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3542~INSERT into ovhcost VALUES ('M20220331215909',929.17,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'DIVOFFBC',1000,'N','M20220331215909','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'DIVOFFBC',1000,'N','M20220331215909','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54878~0~2~0~21165~INSERT into ovhasso VALUES (0,101,'DIVOFFBC',1000,'N','M20220331215909','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54878~0~2~0~21165~INSERT into ovhasso VALUES (0,101,'DIVOFFBC',1000,'N','M20220331215909','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4377147 - admin@perthvoicesclinic.com.au] CurrentCost=[2.86] Extension=[87702] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 87702 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|DOM-FAC|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4864~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 87702 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~4864~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 87702 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[DOM-FAC] Found: site_siteid=[101] dt_extgroupunique=[DOM-FAC] ovhcode=[M20220331215910] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215910','DEBIT','MESSAGENET','Messagenet FEB 2022 4377147 - admin@perthvoicesclinic.com.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215910','DEBIT','MESSAGENET','Messagenet FEB 2022 4377147 - admin@perthvoicesclinic.com.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3545~INSERT into ovhdefn VALUES ('M','M20220331215910','DEBIT','MESSAGENET','Messagenet FEB 2022 4377147 - admin@perthvoicesclinic.com.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3545~INSERT into ovhdefn VALUES ('M','M20220331215910','DEBIT','MESSAGENET','Messagenet FEB 2022 4377147 - admin@perthvoicesclinic.com.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215910',2.86,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215910',2.86,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3549~INSERT into ovhcost VALUES ('M20220331215910',2.86,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3549~INSERT into ovhcost VALUES ('M20220331215910',2.86,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'DOM-FAC',87702,'N','M20220331215910','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'DOM-FAC',87702,'N','M20220331215910','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54879~0~2~0~21172~INSERT into ovhasso VALUES (0,101,'DOM-FAC',87702,'N','M20220331215910','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54879~0~2~0~21172~INSERT into ovhasso VALUES (0,101,'DOM-FAC',87702,'N','M20220331215910','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4389677 - unireadyadmin@curtin.edu.au] CurrentCost=[1.1] Extension=[7632] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|UNI-READ|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1497~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1497~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[UNI-READ] Found: site_siteid=[101] dt_extgroupunique=[UNI-READ] ovhcode=[M20220331215911] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215911','DEBIT','MESSAGENET','Messagenet FEB 2022 4389677 - unireadyadmin@curtin.edu.au',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215911','DEBIT','MESSAGENET','Messagenet FEB 2022 4389677 - unireadyadmin@curtin.edu.au',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3556~INSERT into ovhdefn VALUES ('M','M20220331215911','DEBIT','MESSAGENET','Messagenet FEB 2022 4389677 - unireadyadmin@curtin.edu.au',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3556~INSERT into ovhdefn VALUES ('M','M20220331215911','DEBIT','MESSAGENET','Messagenet FEB 2022 4389677 - unireadyadmin@curtin.edu.au',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215911',1.10,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215911',1.10,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3560~INSERT into ovhcost VALUES ('M20220331215911',1.10,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3560~INSERT into ovhcost VALUES ('M20220331215911',1.10,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215911','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215911','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54880~0~2~0~21183~INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215911','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54880~0~2~0~21183~INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215911','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 4389680 - unireadyadmin] CurrentCost=[206.8] Extension=[7632] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|UNI-READ|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1497~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~1497~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 7632 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[UNI-READ] Found: site_siteid=[101] dt_extgroupunique=[UNI-READ] ovhcode=[M20220331215912] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215912','DEBIT','MESSAGENET','Messagenet FEB 2022 4389680 - unireadyadmin',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215912','DEBIT','MESSAGENET','Messagenet FEB 2022 4389680 - unireadyadmin',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3546~INSERT into ovhdefn VALUES ('M','M20220331215912','DEBIT','MESSAGENET','Messagenet FEB 2022 4389680 - unireadyadmin',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3546~INSERT into ovhdefn VALUES ('M','M20220331215912','DEBIT','MESSAGENET','Messagenet FEB 2022 4389680 - unireadyadmin',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215912',206.80,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215912',206.80,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3550~INSERT into ovhcost VALUES ('M20220331215912',206.80,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3550~INSERT into ovhcost VALUES ('M20220331215912',206.80,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215912','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215912','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54881~0~2~0~21173~INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215912','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54881~0~2~0~21173~INSERT into ovhasso VALUES (0,101,'UNI-READ',7632,'N','M20220331215912','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 PAC ] CurrentCost=[474.65] Extension=[1772] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1772 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|HR-EMP|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5681~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1772 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~5681~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1772 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[HR-EMP] Found: site_siteid=[101] dt_extgroupunique=[HR-EMP] ovhcode=[M20220331215913] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215913','DEBIT','MESSAGENET','Messagenet FEB 2022 PAC ',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215913','DEBIT','MESSAGENET','Messagenet FEB 2022 PAC ',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3543~INSERT into ovhdefn VALUES ('M','M20220331215913','DEBIT','MESSAGENET','Messagenet FEB 2022 PAC ',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3543~INSERT into ovhdefn VALUES ('M','M20220331215913','DEBIT','MESSAGENET','Messagenet FEB 2022 PAC ',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215913',474.65,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215913',474.65,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3547~INSERT into ovhcost VALUES ('M20220331215913',474.65,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3547~INSERT into ovhcost VALUES ('M20220331215913',474.65,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'HR-EMP',1772,'N','M20220331215913','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'HR-EMP',1772,'N','M20220331215913','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54882~0~2~0~21170~INSERT into ovhasso VALUES (0,101,'HR-EMP',1772,'N','M20220331215913','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54882~0~2~0~21170~INSERT into ovhasso VALUES (0,101,'HR-EMP',1772,'N','M20220331215913','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 cmscurrentstudents <>] CurrentCost=[7.92] Extension=[1919] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1919 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|BENT-VAC|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~6070~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1919 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~6070~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 1919 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[BENT-VAC] Found: site_siteid=[101] dt_extgroupunique=[BENT-VAC] ovhcode=[M20220331215914] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215914','DEBIT','MESSAGENET','Messagenet FEB 2022 cmscurrentstudents <>',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215914','DEBIT','MESSAGENET','Messagenet FEB 2022 cmscurrentstudents <>',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3531~INSERT into ovhdefn VALUES ('M','M20220331215914','DEBIT','MESSAGENET','Messagenet FEB 2022 cmscurrentstudents <>',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3531~INSERT into ovhdefn VALUES ('M','M20220331215914','DEBIT','MESSAGENET','Messagenet FEB 2022 cmscurrentstudents <>',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215914',7.92,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215914',7.92,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3535~INSERT into ovhcost VALUES ('M20220331215914',7.92,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3535~INSERT into ovhcost VALUES ('M20220331215914',7.92,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'BENT-VAC',1919,'N','M20220331215914','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'BENT-VAC',1919,'N','M20220331215914','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54883~0~2~0~21158~INSERT into ovhasso VALUES (0,101,'BENT-VAC',1919,'N','M20220331215914','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54883~0~2~0~21158~INSERT into ovhasso VALUES (0,101,'BENT-VAC',1919,'N','M20220331215914','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 digital student engagement ] CurrentCost=[6088.39] Extension=[5290] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 5290 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|ORIENT|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~7555~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 5290 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~7555~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 5290 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[ORIENT] Found: site_siteid=[101] dt_extgroupunique=[ORIENT] ovhcode=[M20220331215915] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215915','DEBIT','MESSAGENET','Messagenet FEB 2022 digital student engagement ',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215915','DEBIT','MESSAGENET','Messagenet FEB 2022 digital student engagement ',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3557~INSERT into ovhdefn VALUES ('M','M20220331215915','DEBIT','MESSAGENET','Messagenet FEB 2022 digital student engagement ',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3557~INSERT into ovhdefn VALUES ('M','M20220331215915','DEBIT','MESSAGENET','Messagenet FEB 2022 digital student engagement ',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215915',6088.39,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215915',6088.39,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3561~INSERT into ovhcost VALUES ('M20220331215915',6088.39,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3561~INSERT into ovhcost VALUES ('M20220331215915',6088.39,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'ORIENT',5290,'N','M20220331215915','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'ORIENT',5290,'N','M20220331215915','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54884~0~2~0~21184~INSERT into ovhasso VALUES (0,101,'ORIENT',5290,'N','M20220331215915','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54884~0~2~0~21184~INSERT into ovhasso VALUES (0,101,'ORIENT',5290,'N','M20220331215915','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= ----------------------------- ============================================================== Type=[M] Item=[DEBIT] Reference=[MESSAGENET] Description=[Messagenet FEB 2022 ot fieldwork ] CurrentCost=[3.08] Extension=[3628] dbid0 = 602 execute_sql: print Sending [SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3628 AND site.sitenm1[1,4] = directtemplate.site;] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [101|OCC-THER|] aline = [Status:|SQLCODE~0~OK~SQLERRD~2~0~1~9~0~3015~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3628 AND site.sitenm1[1,4] = directtemplate.site|1|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~2~0~1~9~0~3015~SELECT unique siteid, extgroupunique FROM directtemplate, site WHERE directtemplate.extension = 3628 AND site.sitenm1[1,4] = directtemplate.site] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[1] /tmp/dbcmdidf602 closed. sql0id=[0] sql0_nrows = [1] siteid=[101] extgroupunique=[OCC-THER] Found: site_siteid=[101] dt_extgroupunique=[OCC-THER] ovhcode=[M20220331215916] sql1=[INSERT into ovhdefn VALUES ('M','M20220331215916','DEBIT','MESSAGENET','Messagenet FEB 2022 ot fieldwork ',98)] dbid0 = 602 execute_sql: print Sending [INSERT into ovhdefn VALUES ('M','M20220331215916','DEBIT','MESSAGENET','Messagenet FEB 2022 ot fieldwork ',98);] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3558~INSERT into ovhdefn VALUES ('M','M20220331215916','DEBIT','MESSAGENET','Messagenet FEB 2022 ot fieldwork ',98)|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~3~0~3558~INSERT into ovhdefn VALUES ('M','M20220331215916','DEBIT','MESSAGENET','Messagenet FEB 2022 ot fieldwork ',98)] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql2=[INSERT into ovhcost VALUES ('M20220331215916',3.08,'31/03/2022')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhcost VALUES ('M20220331215916',3.08,'31/03/2022');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3562~INSERT into ovhcost VALUES ('M20220331215916',3.08,'31/03/2022')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~0~0~2~0~3562~INSERT into ovhcost VALUES ('M20220331215916',3.08,'31/03/2022')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= sql3=[INSERT into ovhasso VALUES (0,101,'OCC-THER',3628,'N','M20220331215916','31/03/2022','')] dbid0 = 602 execute_sql: print Sending [INSERT into ovhasso VALUES (0,101,'OCC-THER',3628,'N','M20220331215916','31/03/2022','');] to [txsql -s -d catcom 2>&1 1>>/tmp/dbcmdidf602] Reading result of SQL from [/tmp/dbcmdidf602] aline = [Status:|SQLCODE~0~OK~SQLERRD~10~54885~0~2~0~21185~INSERT into ovhasso VALUES (0,101,'OCC-THER',3628,'N','M20220331215916','31/03/2022','')|0|] result_arr[0|status]=[SQLCODE~0~OK~SQLERRD~10~54885~0~2~0~21185~INSERT into ovhasso VALUES (0,101,'OCC-THER',3628,'N','M20220331215916','31/03/2022','')] result_arr[0|sqlcode]=[0] result_arr[0|sqlerrmsg]=[OK] result_arr[0|nrows]=[0] /tmp/dbcmdidf602 closed. result of insert ovhasso nrows=0 sqlcode= -----------------------------