調査方法
SQLServer(10.104.253.15)で以下のクエリを実行
select ProgramID
,STRING_AGG(CONVERT(VARCHAR(MAX), Include_File), ',') WITHIN GROUP (ORDER BY Include_File ASC) AS Include_FileList
from (
select ProgramID,Include_File
from T_BatchPG_VariableList
where Include_File IS NOT NULL
and Include_File IN (
--以下に該当するInclude記載
'BCH2SHUY'
,'BS4020O4'
,'BS4020O5'
,'BS8013O4'
,'BU40224L'
,'BU40234L'
,'BU4030O8'
,'BU4090O5'
,'BU80206L'
,'BU80207L'
,'BU8020AL'
,'BU8020BL'
,'BU80223L'
,'BVDTSFDT'
,'BY50023L'
,'BY80127L'
,'BY80174L'
,'BY80175L'
,'BY8030L5'
,'BY8080L3'
,'CEDPB25W'
,'CEDPB43U'
,'CEDPB52U'
,'CEDPB55U'
,'CEDPBV31'
,'CEDPBV35'
,'CEDPGJ06'
,'CEDPQ03U'
,'CHOHYO03'
,'CHOHYOGG'
,'DDPDXUK2'
,'DSHPHARA'
,'DT3MANBN'
,'DX3MSCO1'
,'DXCORPR2'
,'DXHGINZU'
,'DXHKAO10'
,'DXHKAO20'
,'DXHSDN20'
,'DXHSKT10'
,'DXHSUN10'
,'DXHTOS10'
,'DXHYOKKB'
,'DXMMMCO1'
,'DXR10DN6'
,'DXR10IBM'
,'DXR10MSI'
,'DXR10YKW'
,'DXR20MAT'
,'DXRFURUK'
,'DXRYWPR1'
,'DXRYWPR4'
,'DXS3MS10'
,'DXS3MS11'
,'DXSCOR02'
,'DXSJOIL3'
,'DXSMMM10'
,'DXSMMM11'
,'DXSMMMSK'
,'DXSMMS11'
,'DXSPJNW1'
,'DXSRYOW1'
,'DXSRYOW4'
,'DXSSNYS2'
,'DXSSYUH2'
,'DXSTONW1'
,'DXSTONW4'
,'DXUKOIL3'
,'JRDK06DT'
,'LDTMEXCL'
,'SEQKAISE'
,'SSALLSEN'
,'TDYRYODT'
,'TEKINENN'
,'TSOMEN'
)
group by ProgramID,Include_File
) AS T
group by ProgramID
order by ProgramID
Oracle(10.100.254.116) PROD_3DOSADMIN にて以下のクエリを実行
select *
from HO_T_MIGRATION_POLICY
where MIGRATION_ID IN (
--以下該当するプログラムID記載
'BS30070P'
,'BS40020P'
,'BS80130P'
,'BU40013P'
,'BU40090P'
,'BU40220P'
,'BU40230P'
,'BY40070P'
,'BY50020P'
,'BY80036P'
,'BY80037P'
,'BY80130P'
,'IN41000P'
,'IN41010P'
,'IP30010P'
,'IP30020P'
,'IP40120P'
,'IP40310P'
,'IP40320P'
,'JB55277P'
,'JB55279P'
,'JCSV019P'
)
order by MIGRATION_ID
