delete from KEU_PARTNER_CONFIG where TRADING_PARTNER = ‘sftp_PCL’
The above SQL command will remove the trading_partner values for ‘sftp_PCL’.
SQL Command To Delete Certain Values From Tables
Leave a Reply
Tag Archives: SQL
SQL Command To Insert Into Table
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
SQL Command To Select Distinct
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
Rule To Replace Values In SQL When Certain Value Is Found
UPDATE sap_xref
SET ROUTE = REPLACE(ROUTE, ‘EAH_IN’, ‘EAS_IN’)
WHERE ROUTE LIKE ‘SAP_EAH_IN_RFC_%’ Continue reading
SQL Command – Which Envelope ID Uses Which Map
This SQL command is useful for finding out which envelope_id’s use a particular Sterling Integrator map. Continue reading
SQL Mapping – A General Note
Purpose
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