16May 2022 by admin No Comments SQL Command To Delete Certain Values From Tables SQL Commands delete from KEU_PARTNER_CONFIG where TRADING_PARTNER = 'sftp_PCL' The above SQL command will remove the trading_partner values for 'sftp_PCL'. Read More
16May 2022 by admin No Comments SQL Command To Insert Into Table SQL Commands 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') (more…) Read More
16May 2022 by admin No Comments SQL Command To Select Distinct SQL Commands select distinct list_name from CODELIST_XREF_ITEM This SQL command will allow you to select distinctly the whole table for code lists. (more…) Read More
16May 2022 by admin No Comments Rule To Replace Values In SQL When Certain Value Is Found SQL Commands UPDATE sap_xref SET ROUTE = REPLACE(ROUTE, 'EAH_IN', 'EAS_IN') WHERE ROUTE LIKE 'SAP_EAH_IN_RFC_%' (more…) Read More
11May 2022 by admin No Comments SQL Command – Which Envelope ID Uses Which Map SQL Commands This SQL command is useful for finding out which envelope_id's use a particular Sterling Integrator map. (more…) Read More