Hello all,
I need to export some old records and delete them, but want to import them later when a user wants to access those records.
so I am testing my scripts and run into an issue that I can not understand.
The SQL query or ABL query returns the total records, let's say 1000. I export 100 records to a data file and then delete them. Total record number becomes 900.
I import those 100 records to a table and can see those records in the table. But the total records number is still 900. I rebuild the index, but it is same 900.
I am using Progress Openedge 11.4 and here are my queries.
SELECT COUNT(*) FROM PUB."com"
1000
SELECT COUNT (*) FROM PUB."com" WHERE cono = 999
100
AFTER deleting cono=999
SELECT COUNT(*) FROM PUB."com"
900
SELECT COUNT (*) FROM PUB."com" WHERE cono = 999
0
AFTER importing cono=999
SELECT COUNT(*) FROM PUB."com"
900
SELECT COUNT (*) FROM PUB."com" WHERE cono = 999
100
The table, "com" has a primary key and "cono" is one of the key columns.
Again, The ABL table count returns same number and reindexing after the import does not make any difference.
Any idea of why the total records number does not go back to 1000?
Thank you for reading,
Young
I need to export some old records and delete them, but want to import them later when a user wants to access those records.
so I am testing my scripts and run into an issue that I can not understand.
The SQL query or ABL query returns the total records, let's say 1000. I export 100 records to a data file and then delete them. Total record number becomes 900.
I import those 100 records to a table and can see those records in the table. But the total records number is still 900. I rebuild the index, but it is same 900.
I am using Progress Openedge 11.4 and here are my queries.
SELECT COUNT(*) FROM PUB."com"
1000
SELECT COUNT (*) FROM PUB."com" WHERE cono = 999
100
AFTER deleting cono=999
SELECT COUNT(*) FROM PUB."com"
900
SELECT COUNT (*) FROM PUB."com" WHERE cono = 999
0
AFTER importing cono=999
SELECT COUNT(*) FROM PUB."com"
900
SELECT COUNT (*) FROM PUB."com" WHERE cono = 999
100
The table, "com" has a primary key and "cono" is one of the key columns.
Again, The ABL table count returns same number and reindexing after the import does not make any difference.
Any idea of why the total records number does not go back to 1000?
Thank you for reading,
Young