IBM Sterling B2B: SELECT a Code List

= SELECT a code List =

SELECT * FROM CODE_LIST_XREF

= SELECT Code List codes =

SELECT * FROM CODELIST_XREF_ITEM WHERE CODELIST_XREF_ITEM.LIST_NAME = ''

= SELECT Code List Default Version=

SELECT * FROM CODELIST_XREF_ITEM WHERE CODELIST_XREF_ITEM.LIST_NAME = '' AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION                                        FROM CODELIST_XREF_VERS                                         WHERE CODELIST_XREF_VERS.LIST_NAME = '')

= SELECT Code List Samples=

Search for a mailbox using the filename in a code list

SELECT * FROM CODELIST_XREF_ITEM WHERE CODELIST_XREF_ITEM.LIST_NAME = '' AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION                                        FROM CODELIST_XREF_VERS                                         WHERE CODELIST_XREF_VERS.LIST_NAME = '') AND CODELIST_XREF_ITEM.SENDER_ITEM = 'XYX_AC';

Search for a mailbox using the filename and a regular expression in a code list

SELECT * FROM CODELIST_XREF_ITEM WHERE CODELIST_XREF_ITEM.LIST_NAME = '' AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION                                        FROM CODELIST_XREF_VERS                                         WHERE CODELIST_XREF_VERS.LIST_NAME = '') AND REGEXP_LIKE('ZYZ_AA_20210401_04.TXT', CODELIST_XREF_ITEM.SENDER_ITEM);

= Ver também =


 * IBM Sterling B2B: Criando um Connect:Direct Server Adapter
 * IBM Sterling Connect:Direct: Configurando a conexão para um Node C:D ou C:D Server Adapter
 * IBM Sterling B2B: Configurando a conexão do B2Bi-SFG para um Node C:D


 * Artigos sobre IBM Sterling
 * Mais Artigos sobre Cloud / WebDev / Tecnologias