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
This paper will discuss SQL (ODBC) maps and outline general information necessary to complete a SQL map. The paper will also cover the flow of the translator for outbound SQL (ODBC) Maps and how to use the components available with the SQL File Format to design a map to process the result set returned via the SQL statement defined in the map. Continue reading