ibmi-brunch-learn

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:
    [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]
    After SQL DELETE (No Records Found for DELETE):
    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]
    Please explain ?!
    Last edited by DougCMH; June 13, 2019, 08:55 AM.

  • #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

        Working...
        X