ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Table Join

Post new topic  Reply to topic
 Table Join « View previous topic :: View next topic » 
Author Message
bobbee
PostPosted: Wed Jul 20, 2016 9:16 am    Post subject: Table Join Reply with quote

Knight

Joined: 20 Sep 2001
Posts: 541
Location: Tampa

I originally did a search on SELECT ESQL Database Joins. After reading this is what I wrote. One of the conditions broke and I showed it to the customer to see if this condition can happen. His first remark is "I don't see you doing any JOINs'. I look at this and understand it, well I wrote it. The other queries work where I am doing the same. I there a better way?

Code:

SET OutputRoot.XMLNSC.ns:sourceTransactions.ns1:sourceTransaction.ns1:SourceTransaction[ODMCallIndex].ns1:TSCode =
              THE (Select one.VALUE
                      FROM Database.CFFACT.T_Account_Property       AS one,
                           Database.CFFACT.Account_Property_Type    AS two,
                           Database.CFFACT.T_Account                AS three,
                           Database.CFFACT.T_TXN_ACCOUNT_REFERENCE  AS four
                     WHERE four.TRANSACTION_ID              = TRANID                        and 23494901
                           three.ACCOUNT_ID                 = four.ACCOUNT_ID               and 23204958
                           three.ACCOUNT_ID               = one.ACCOUNT_ID                and
                           one.ACCOUNT_PROPERTY_TYPE_ID    = two.ACCOUNT_PROPERTY_TYPE_ID  and   
                           two.NAME                   = 'SOURCE_APPL_CODE');
Back to top
View user's profile Send private message Send e-mail AIM Address
bobbee
PostPosted: Wed Jul 20, 2016 9:18 am    Post subject: Reply with quote

Knight

Joined: 20 Sep 2001
Posts: 541
Location: Tampa

excuse the numbers after the 'and' these were the values used in that line. I was debugging by hand.
Back to top
View user's profile Send private message Send e-mail AIM Address
fjb_saper
PostPosted: Wed Jul 20, 2016 10:13 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20696
Location: LI,NY

I hear you. Looks like a join.
http://www.ibm.com/support/knowledgecenter/en/SSMKHH_10.0.0/com.ibm.etools.mft.doc/ak05830_.htm

Try and switch it around a little:
Code:
SET OutputRoot.XMLNSC.ns:sourceTransactions.ns1:sourceTransaction.ns1:SourceTransaction[ODMCallIndex].ns1:TSCode =
              THE (Select one.VALUE
                      FROM Database.CFFACT.T_Account_Property       AS one,
                           Database.CFFACT.Account_Property_Type    AS two,
                           Database.CFFACT.T_Account                AS three,
                           Database.CFFACT.T_TXN_ACCOUNT_REFERENCE  AS four
                     WHERE four.TRANSACTION_ID              = TRANID                        and 23494901
                           three.ACCOUNT_ID                 = four.ACCOUNT_ID               and 23204958
                           two.NAME                   = 'SOURCE_APPL_CODE'   and
                           one.ACCOUNT_ID               = three.ACCOUNT_ID                and
                           one.ACCOUNT_PROPERTY_TYPE_ID    = two.ACCOUNT_PROPERTY_TYPE_ID  );


Hope it helps some
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
bobbee
PostPosted: Wed Jul 20, 2016 10:26 am    Post subject: Reply with quote

Knight

Joined: 20 Sep 2001
Posts: 541
Location: Tampa

That is the link i was looking at. thanks for the adjustment.
Back to top
View user's profile Send private message Send e-mail AIM Address
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Table Join
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.