I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields. That physical file field may or may not be a key in related logical files. While updating I am getting 'duplicate key on access path' error message. But UPDDTA works without any issue. Any guidance from anyone why this happens and how to correct this issue.Thanks in advance.
October 4, 2013 6:51 PM
October 9, 2013 9:19 PM