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 table
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