Re: Backup of SQL tables and multi-member files

But if you do stick with members, with a name like DYYYYMMDD where the
first D is just a character required instead of all numbers for a member
name. Then a stored procedure to read the members from SysPartitionStat
(aka syspstat)

Select sys_dname as library, sys_tname as table, sys_mname as member
from sysPartitionStat
where sys_tname='HISTTABLE' and sys_mname<'D20171231'

And if you build your own QCMDEXC function...
Select sys_dname as library, sys_tname as table, sys_mname as member,
'RMVM FILE(' concat %trim(library) concat '/' concat %trim(table) concat
') MBR(' concat sys_mname concat ')' as myCmd,
myQcmdExc('RMVM FILE(' concat %trim(library) concat '/' concat
%trim(table) concat ') MBR(' concat sys_mname concat ')' )
from sysPartitionStat
where sys_tname='HISTTABLE' and sys_mname<'D20171231'



Rob Berendt