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>'...") |
(No difference)
|
Revision as of 00:01, 3 March 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>')