---Update the titles
Begin TRansaction
		SET ansi_warnings Off;
		UPDATE mt.customiz
		SET mt.customiz.title = mt.me2_customiz.title
		FROM mt.me2_customiz
			INNER JOIN mt.customiz
			ON (mt.me2_customiz.fldnum = mt.customiz.fldnum) where mt.me2_customiz.desktop = 'METEX1'; 

commit transaction;

--- update the suppressed fields
Begin TRansaction
		SET ansi_warnings Off;
		UPDATE mt.customiz
		SET mt.customiz.suppressed = mt.me2_customiz.suppressed
		FROM mt.me2_customiz
			INNER JOIN mt.customiz
			ON (mt.me2_customiz.fldnum = mt.customiz.fldnum) where mt.me2_customiz.desktop = 'METEX1'; 

commit transaction;

---- update the len fields
Begin TRansaction
		SET ansi_warnings Off;
		UPDATE mt.customiz
		SET mt.customiz."len" = mt.me2_customiz."len"
		FROM mt.me2_customiz
			INNER JOIN mt.customiz
			ON (mt.me2_customiz.fldnum = mt.customiz.fldnum) where mt.me2_customiz.desktop = 'METEX1'; 

commit transaction;

update the maxlen fields
Begin TRansaction
		SET ansi_warnings Off;
		UPDATE mt.customiz
		SET mt.customiz."maxlen" = mt.me2_customiz."maxlen"
		FROM mt.me2_customiz
			INNER JOIN mt.customiz
			ON (mt.me2_customiz.fldnum = mt.customiz.fldnum) where mt.me2_customiz.desktop = 'METEX1'; 

commit transaction;

----- Insert the new 4263 fld from the ME2_customiz

Begin TRansaction

insert into mt.customiz (fldnum, title, suppressed, ilevels, ireq, idefault, slevels, sreq, sdefault, scopy, "validation", "merge", 
row, col,len,datalen, nextfld, tooltip, datacol, ftype, fform, postitle, maxlen, dcopy, chkfunc, title2, title3, title4,
title5, qrow, qcol, qsupp)

select fldnum, title, suppressed, ilevels, ireq, idefault, slevels, sreq, sdefault, scopy, "validation", "merge", 
row, col,len,datalen, nextfld, tooltip, datacol, ftype, fform, postitle, maxlen, dcopy, chkfunc, title2, title3, title4,
title5, qrow, qcol, qsupp from mt.me2_customiz where desktop = 'METEX1' and fldnum = '4263' and fform = '2';

Commit transaction;