a:1:{i:0;a:7:{s:7:"cod_prj";s:7:"Veratex";s:6:"versao";s:1:"1";s:7:"cod_apl";s:16:"fv2_dye_setnulls";s:4:"nome";s:9:"onExecute";s:4:"tipo";s:1:"E";s:5:"parms";s:0:"";s:6:"codigo";s:1120:"// this doesn't work so I did it in the cron job on ls4 fv2import.sh 
$setnuls = '
ALTER TABLE dyeorder
  ALTER COLUMN price_lb_d SET DEFAULT 0,
  ALTER COLUMN cost_lb_d SET DEFAULT 0,
  ALTER COLUMN dye_cost SET DEFAULT 0,
  ALTER COLUMN gr_lbs_o SET DEFAULT 0,
  ALTER COLUMN gr_lbs_d SET DEFAULT 0,
  ALTER COLUMN gr_lbs_op SET DEFAULT 0,
  ALTER COLUMN fin_lbs SET DEFAULT 0,
  ALTER COLUMN work_loss SET DEFAULT 0,
  ALTER COLUMN cost_lb_g SET DEFAULT 0,
  ALTER COLUMN est_yards SET DEFAULT 0,
  ALTER COLUMN yards_recd SET DEFAULT 0,
  ALTER COLUMN cost_lb_t SET DEFAULT 0,
  ALTER COLUMN gr_yield SET DEFAULT 0,
  ALTER COLUMN cost_yd_t SET DEFAULT 0,
  ALTER COLUMN gr_value SET DEFAULT 0,
  ALTER COLUMN lbs_alloc SET DEFAULT 0,
  ALTER COLUMN yds_alloc SET DEFAULT 0,
  ALTER COLUMN lbs_ualloc SET DEFAULT 0,
  ALTER COLUMN yds_ualloc SET DEFAULT 0,
  ALTER COLUMN flbs_alloc SET DEFAULT 0,
  ALTER COLUMN fyds_alloc SET DEFAULT 0,
  ALTER COLUMN flbs_uallo SET DEFAULT 0,
  ALTER COLUMN fyds_uallo SET DEFAULT 0,
  ALTER COLUMN csyds SET DEFAULT 0
'
sc_exec_sql($setnuls);



";}}