I'm hoping someone has seen this. I'm moving our dev db (8.1 FP5 for
both) to a windows machine from AIX using db2move, and all goes well
except with a few tables like PAYPERIOD
IMPORT: -Rows read: 1505; -Rows committed: 1505; Table
"SCHMA"."PAYMENTOPTION"
IMPORT: -Rows read: 0; -Rows committed: 0; Table
"SCHMA"."PAYMENTREVERSAL"
IMPORT: -Rows read: 4514; -Rows committed: 4514; Table
"SCHMA"."PAYPERIOD"
IMPORT: -Rows read: 0; -Rows committed: 0; Table
"SCHMA"."PAYPERIODMESSAGE"
Looks good, but when I try and put on the RI I get an error, so I
select on PAYPERIOD and get
select * from insyncad.payperiod
PAYPERIOD_ID PAYPERIODNUM PAYYEAR PAYROLLRUNTYPE_CD
PERIODENDINGDATE_DT
-------------------- ------------ ------- -----------------
--------------------------
0 record(s) selected.
Where did all the rows that were commited go?