delete from KEU_PARTNER_CONFIG where TRADING_PARTNER = ‘sftp_PCL’
The above SQL command will remove the trading_partner values for ‘sftp_PCL’.
INSERT INTO KEU_PARTNER_CONFIG values (‘as2_DITECH’,’/gis/data/archive/as2/IT_DITECH/i’,’/gis/data/archive/as2/IT_DITECH/o’,’/int/prod/gis/data/keu/as2/IT_DITECH/o’,’/gis/data/gentran/i’) Continue reading
select distinct list_name from CODELIST_XREF_ITEM
This SQL command will allow you to select distinctly the whole table for code lists. Continue reading
UPDATE sap_xref
SET ROUTE = REPLACE(ROUTE, ‘EAH_IN’, ‘EAS_IN’)
WHERE ROUTE LIKE ‘SAP_EAH_IN_RFC_%’ Continue reading
This SQL command is useful for finding out which envelope_id’s use a particular Sterling Integrator map. Continue reading