IBM Sterling B2B: SELECT a Code List: Difference between revisions
(Criou a página com " = SELECT a code List = SELECT * FROM CODE_LIST_XREF = SELECT Code List codes = SELECT * FROM CODELIST_XREF_ITEM WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>'...") |
|||
| Line 19: | Line 19: | ||
FROM CODELIST_XREF_VERS | FROM CODELIST_XREF_VERS | ||
WHERE CODELIST_XREF_VERS.LIST_NAME = '<LIST NAME>') | WHERE CODELIST_XREF_VERS.LIST_NAME = '<LIST NAME>') | ||
= SELECT Code List Samples= | |||
SELECT * | |||
FROM CODELIST_XREF_ITEM | |||
WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>' | |||
AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION | |||
FROM CODELIST_XREF_VERS | |||
WHERE CODELIST_XREF_VERS.LIST_NAME = '<LIST NAME>') | |||
AND CODELIST_XREF_VERS.SENDER_ITEM = 'XYX_AC'; | |||
SELECT * | |||
FROM CODELIST_XREF_ITEM | |||
WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>' | |||
AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION | |||
FROM CODELIST_XREF_VERS | |||
WHERE CODELIST_XREF_VERS.LIST_NAME = '<LIST NAME>') | |||
AND REGEXP_LIKE('XYX_AC_20210401_04.TXT', CODELIST_XREF_VERS.SENDER_ITEM); | |||
= Ver também = | = Ver também = | ||
Revision as of 18:08, 1 April 2021
SELECT a code List
SELECT * FROM CODE_LIST_XREF
SELECT Code List codes
SELECT * FROM CODELIST_XREF_ITEM WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>'
SELECT Code List Default Version
SELECT *
FROM CODELIST_XREF_ITEM
WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>'
AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION
FROM CODELIST_XREF_VERS
WHERE CODELIST_XREF_VERS.LIST_NAME = '<LIST NAME>')
SELECT Code List Samples
SELECT *
FROM CODELIST_XREF_ITEM
WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>'
AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION
FROM CODELIST_XREF_VERS
WHERE CODELIST_XREF_VERS.LIST_NAME = '<LIST NAME>')
AND CODELIST_XREF_VERS.SENDER_ITEM = 'XYX_AC';
SELECT *
FROM CODELIST_XREF_ITEM
WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>'
AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION
FROM CODELIST_XREF_VERS
WHERE CODELIST_XREF_VERS.LIST_NAME = '<LIST NAME>')
AND REGEXP_LIKE('XYX_AC_20210401_04.TXT', CODELIST_XREF_VERS.SENDER_ITEM);