sponsored links

Collapse

Announcement

Collapse
No announcement yet.

Member Size increases?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Member Size increases?

    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:
    Code:
    Member List                                                                            
                                 Source Creation    Last Change                  Deleted   
     Member           Size        Type  Date       Date     Time      Records    Records   
     UIMWLS                49152        06/13/19 06/13/19 09:52:59          6          0   
       Text:  Wait List Master                                                             
     Total number of members  . . . . . . . . . :                 1                        
     Total number of members not available  . . :                 0                        
     Total records  . . . . . . . . . . . . . . :                 6                        
     Total deleted records  . . . . . . . . . . :                 0                        
    Total of member sizes  . . . . . . . . . . :             49152                       
    After SQL DELETE (No Records Found for DELETE):
    Code:
    Member List                                                                           
                                 Source Creation    Last Change                  Deleted  
     Member           Size        Type  Date       Date     Time      Records    Records  
     UIMWLS                53248        06/13/19 06/13/19 09:52:59          6          0  
       Text:  Wait List Master                                                            
     Total number of members  . . . . . . . . . :                 1                       
     Total number of members not available  . . :                 0                       
     Total records  . . . . . . . . . . . . . . :                 6                       
     Total deleted records  . . . . . . . . . . :                 0                       
    Total of member sizes  . . . . . . . . . . :             53248                       
    Please explain ?!
    Last edited by DougCMH; 4 weeks ago.

  • #2
    Is the job under commitment control? Do you need to commit?

    Comment


    • #3
      Never mind. I just reread. I thought your DELETE had no WHERE clause, but I guess it does.

      Comment


      • #4
        I suspect the access plan is automatically is updated and automatically included in the member.
        Birgitta

        Comment

        sponsored links

        Collapse

        Working...
        X