I am trying to append tableA to tableB. Both tables are identical (except tableB has 3 fields that have different character size). My problem is when I do an append from, I need the deleted records to come over along with other records. When I go to view tableB, there are no deleted records, only the non-deleted. Here is the code:
use tableB exclusive
zap
append from tableA
Does anyone know why this might be happening? Is there another way to bring deleted record over if append from doesn't do the job?
Thanks
Nick Patel