a:1:{i:0;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:19:"fv2_greige_initiate";s:4:"nome";s:9:"onExecute";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:964:"$clear_table = 'Truncate table grpcs';
$import_table = 'Insert into grpcs (p_o_number,old_po,style,invoice,piece,lbs_recd,racks,lbs_used,lbs_open,dye_order,cost_lb_g,total_cost,adate,edate,ddate,shipto,sdate,ac,defects,TSET,BSET,L3SET,L4SET,TPER,BPER,L3PER,L4PER,DESC1,DESC2,DESC3,DESC4,DESC5,DESC6,DESC7,DESC8) select p_o_number,old_po,style,invoice,piece,lbs_recd,racks,lbs_used,lbs_open,dye_order,cost_lb_g,total_cost,adate,edate,ddate,shipto,sdate,ac,defect,TSET,BSET,L3SET,L4SET,TPER,BPER,L3PER,L4PER,DESC1,DESC2,DESC3,DESC4,DESC5,DESC6,DESC7,DESC8 from fairlanevrtx.mpiece';

sc_exec_sql($clear_table);
sc_exec_sql($import_table);

$clear_table = 'Truncate table greigepo';
$import_table = 'Insert into greigepo (status,ac,p_o_number,date,mill,ship_to,new_style,lbs_ordere,lbs,roll_size)  select status,bcode,knitorder,date,knitter,scode,kstyle,klbsorder,blbs,ksize from fairlanevrtx.kopo';
sc_exec_sql($clear_table);
sc_exec_sql($import_table);

";}}