zOs/SQL/BMCBLIPR

select *
    from bmcacma1.CM_SCOPE
    where scName = 'DB2REO'
;
delete from bmcacma1.CM_SCOPE where scOwner = 'TST01'
;
insert into bmcacma1.CM_SCOPE
          (SCOWNER, SCName, Type, ACTION,OBJECT,NAME_PART1,NAME_PART2
          ,MIGDT, MIGTS, MIGTB, MIGCK, MIGFK, MIGIX, MIGVW, MIGAU
          ,MIGSY, MIGAL, MIGRO, MIGTR, MIGUC, MIGAX
          )
    values('TST01', 'DB2REO', 'B', 'I' , 'DB', 'DB2REO', ''
          ,'N'  , 'Y',   'Y',  'Y',    'Y',   'Y',   'Y',  'N'
          ,'Y'  , 'Y',   '',   'Y',    'Y',   'Y'
          )
;
insert into bmcacma1.CM_SCOPE
          (SCOWNER, SCName, Type, ACTION,OBJECT,NAME_PART1,NAME_PART2
          ,MIGDT, MIGTS, MIGTB, MIGCK, MIGFK, MIGIX, MIGVW, MIGAU
          ,MIGSY, MIGAL, MIGRO, MIGTR, MIGUC, MIGAX
          )
    values('TST01', 'DB2REO', 'B', 'E' , 'IX', 'S100447', '*'
          ,'N'  , 'Y',   'Y',  'Y',    'Y',   'Y',   'Y',  'N'
          ,'Y'  , 'Y',   '',   'Y',    'Y',   'Y'
          )
;
select *
    from bmcacma1.CM_SCOPE
    where scName = 'DB2REO'
;
delete from bmcacma1.CM_BLPROFILE where blpOwner = 'TST01'
;
select *
    from bmcacma1.CM_BLPROFILE
    where blpName = 'DB2REO'
;
insert into bmcacma1.CM_BLPROFILE
          (BLPOWNER, blpName, type, template)
    values('TST01', 'DB2REO', 'C', 'DB2REO_####')
;
select *
    from bmcacma1.CM_BLPROFILE
    where blpName = 'DB2REO'
;
commit