Data Mover Script - Example

I do these so rarely I forget the syntax:

set output c:\temp\temp.dat;
set log c:\temp\temp.log;
export table_name where key_field = '123';

________________________________________________________

set input c:\temp\temp.dat;
set log c:\temp\tmp.log;
delete from ps_table_name where key_field = '123';

import *;

0 comments: