PeopleBooks > PeopleTools 8.52: Data Management > Using PeopleSoft Data Mover > Using PeopleSoft Data Mover Command Modifiers > WHERE
The following operators are supported in an import WHERE clause: =, [ ], <, >,< =, > =, and simple uses of AND and OR. (replace[ with < and change > with ])
SET LOG C:\PSUSER_HRM.log;
SET input F:\psoprdefn.dat;
IMPORT psoprdefn WHERE OPRID  :1;CHAR,PS;
It may or may not be an error depending what you are trying to do. It's rather safe that the system avoid duplicates entries in that tables.
Want to replace data ? Delete the row prior the import.
Otherwise, you may set IGNORE_DUPS, it will ignore the duplicate rows to be loaded.
Datamover tries to insert data in PSOPRDEFN and rows exist with these keys.
To avoid this you can add the following statement in your script:
This will update the values other than the keys if a row already exists in the database with the keys in the dat file.
I can advice you to buy the new book of Jim Marion, PeopleSoft PeopleTools Data Management and Upgrade Handbook