I have an externally described file created with DDS.
Record format is 112 long.
It has 1 member.
It has 6 records.
It has no deleted records.
I do an SQL DELETE FROM on that file (from STRSQL).
SQL reports "No Records found for DELETE" (as I expected) - so, nothing happened to the data in the file.
It still has 1 member with the same 6 records and no deleted records.
And yet, the member size has increased ???
Before SQL DELETE:
After SQL DELETE (No Records Found for DELETE):
Please explain ?!
Record format is 112 long.
It has 1 member.
It has 6 records.
It has no deleted records.
I do an SQL DELETE FROM on that file (from STRSQL).
SQL reports "No Records found for DELETE" (as I expected) - so, nothing happened to the data in the file.
It still has 1 member with the same 6 records and no deleted records.
And yet, the member size has increased ???
Before SQL DELETE:
Code:
[FONT=courier new]Member List Source Creation Last Change Deleted Member Size Type Date Date Time Records Records UIMWLS [COLOR=#FF0000] 49152[/COLOR] 06/13/19 06/13/19 09:52:59 [COLOR=#FF0000] 6 0[/COLOR] Text: Wait List Master Total number of members . . . . . . . . . : 1 Total number of members not available . . : 0 Total records . . . . . . . . . . . . . . : 6 Total deleted records . . . . . . . . . . : 0 [COLOR=#FF0000]Total of member sizes . . . . . . . . . . : 49152 [/COLOR] [/FONT]
Code:
[FONT=courier new]Member List Source Creation Last Change Deleted Member Size Type Date Date Time Records Records UIMWLS [COLOR=#FF0000]53248[/COLOR] 06/13/19 06/13/19 09:52:59 [COLOR=#FF0000] 6 0[/COLOR] Text: Wait List Master Total number of members . . . . . . . . . : 1 Total number of members not available . . : 0 Total records . . . . . . . . . . . . . . : 6 Total deleted records . . . . . . . . . . : 0 [COLOR=#FF0000]Total of member sizes . . . . . . . . . . : 53248 [/COLOR] [/FONT]
Comment