SQL Commands | Appleyard Solutions

26Jun 2022 by admin No Comments

SQL Command To Retrieve Code List Based on Certain Criteria

SQL Commands

Below is an SQL command to return the code list entry based on certain criteria SELECT DISTINCT codelist_xref_item.sender_item, codelist_xref_item.receiver_item, codelist_xref_item.text1 FROM codelist_xref_item, codelist_xref_vers WHERE codelist_xref_item.list_name = 'KEU_SNDPRN_XREF' AND codelist_xref_item.list_name = codelist_xref_vers.list_name AND codelist_xref_item.list_version = codelist_xref_vers.default_version AND codelist_xref_item.sender_item = '9001910000006'

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'.

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…)

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…)

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…)

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…)