Using Data Mover to "merge" users?

[southcarolina]

I've modified a copy of the userexport data mover script as below. What do I use in the userimport.dms to import the records in myuserexport.dat to merge the users into these tables; the "replace_data" will zap the table then load, I just want to add or append these users.

SET OUTPUT MYUSEREXPORT.DAT;
SET LOG AGFUSEREXPORT.LOG;

-- AGF USERS
EXPORT PSOPRDEFN WHERE OPRID LIKE 'AG%';
EXPORT PSOPRALIAS WHERE OPRID LIKE 'AG%';
EXPORT PSROLEUSER WHERE ROLEUSER LIKE 'AG%';
EXPORT PSUSERATTR WHERE OPRID LIKE 'AG%';
EXPORT PSUSEREMAIL WHERE OPRID LIKE 'AG%';
EXPORT PSUSERPRSNLOPTN WHERE OPRID LIKE 'AG%';
EXPORT PS_ROLEXLATOPR WHERE ROLEUSER LIKE 'AG%';
EXPORT PS_RTE_CNTL_RUSER WHERE ROLEUSER LIKE 'AG%';

 

[notadba]

If you want to add these employees where they do not exist already in the table, you can use the 'set ignore duplicates' command - rusty on the syntax but think it is set ignore_dups.

 

[jmiscione]

Hello,

I am trying to do the same thing you are. Have you found an answer about the userid import? If so, can you please send it along to joemiscione@hotmail.com? I would appreciate it.

Thanks,
Joe

 

[southcarolina]

Since the users starting w/ "AGF%" did not exist, the IMPORT keyword is fine. Also, I noted that the exportuser importuser scripts are now replaced in 8.4 w/ securityexport.dms and securityimport.dms which include much more attention. The "set ignore dups" is a great help too! THANKS!