29%irm_session_prepare();
30%
if(%sysevalf(%superq(portfolio_key)ne,
boolean)) %then %do ;
32 %irm_rgf_retrieve_analysis_data(key = &portfolio_key.
34 , outds = ST_STG.CREDIT_PORTFOLIO
35 , outds_partition_list = partition_list
37 , outds_dataInfo = portfolio_dataInfo
38 , outds_dataDef = portfolio_dataDef
39 , host = &rgf_protocol.:
40 , server = &rgf_service.
43 , tgt_ticket = &tgt_ticket.
44 , username = &irm_user_id.
45 , password = &irm_user_password.
46 , outVarTicket = ticket
47 , outSuccess = httpSuccess
48 , outResponseStatus = responseStatus
54%
if(%sysevalf(%superq(portfolio_key)ne,
boolean)) %then %do ;
56 data ST_STG.PORTFOLIO_DATAINFO;
58 portfolio_dataInfo(rename = (key = analysisDataKey name = analysisDataName))
59 portfolio_dataDef(rename = (key = dataDefinitionKey name = dataDefinitionName))
64data ST_STG.SYNC_CREDIT_PORTFOLIO;
70 table_name =
"ST_STG.CREDIT_PORTFOLIO";
77 data ST_STG.PORTFOLIO_DATAINFO;
79 sourceSystemCd length= $16. label=
'Source system code'
80 cyclesKey length= $16. label=
'Cycle key'
81 schemaName length= $16. label=
'Schema name'
82 schemaVersion length= $16. label=
'Schema version'
83 metaLibraryNm length= $16. label=
'Meta library name'
86 data ST_STG.SYNC_CREDIT_PORTFOLIO;