Derby SQL SELECT EDI ISA Control Partner Information

Derby SQL SELECT EDI ISA Control Partner Information

Scenario:

We are looking to query EXTOL's back-end database to determine if an outbound document was sent and determine the ISA/GS information.

For more information on how to connect to EXTOL's database, Click here >

Solution:

In the example below, we show provide a general SQL select statement to query the ountbound EDI data. In addition to the fields provided, we supply optional fields.

Derby SQL Select :: Statement

SELECT "EBI"."LOG_OF_MESSAGE"."RECEIVER_ID", "EBI"."LOG_OF_MESSAGE"."MESSAGE_ID", "EBI"."LOG_OF_GROUP"."GROUP_CONTROL_REFERENCE", "EBI"."LOG_OF_INTERCHANGE"."INTERCHANGE_CONTROL_REF"
FROM "EBI"."LOG_OF_MESSAGE"
JOIN "EBI"."RELATED_LOG" RL1 ON "EBI"."LOG_OF_MESSAGE"."ID" = RL1.RELATED_LOG_ID
JOIN "EBI"."LOG_OF_GROUP" ON RL1.LOG_ID = "EBI"."LOG_OF_GROUP"."ID"
JOIN "EBI"."RELATED_LOG" RL2 ON "EBI"."LOG_OF_GROUP"."ID" = RL2.RELATED_LOG_ID
JOIN "EBI"."LOG_OF_INTERCHANGE" ON RL2.LOG_ID = "EBI"."LOG_OF_INTERCHANGE"."ID"
WHERE "EBI"."LOG_OF_MESSAGE"."MESSAGE_DIRECTION" = 'S'
ORDER BY "EBI"."LOG_OF_MESSAGE"."RECEIVER_ID", "EBI"."LOG_OF_MESSAGE"."MESSAGE_ID" ASC;

Derby SQL Select :: Results

EXTOL Business Integrator EBI Derby Select Outbound Group Contol Number Interchange Control Number

Derby SQL Select :: Statement :: Additional Fields

ACK_STATUS, MESSAGE_CONTROL_REFERENCE, REFERENCE_DATE_1, REFERENCE_DATE_2, SENDER_ID, STATUS, USER_REFERENCE_1, USER_REFERENCE_2, USER_REFERENCE_3, USER_REFERENCE_4, USER_REFERENCE_5






By: on
A free web counter provided by GoStats.