DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
neena
Participant



Joined: 31 Mar 2003
Posts: 90

Points: 752

Post Posted: Wed Aug 22, 2012 2:25 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi all, I am trying to extract data from a Cluster table in SAP and the requirement is that I join this table with two other tables and get the data.
Since it is a cluster table I choose the option "Build SQL query" while generating the ABAP code.

Issue: I was not able to join the Cluster table with more than One table. I would like to know if there is any limitation on Joining the No.of tables while using Cluster tables.

Example: Lets say A - Cluster table and B & C are Transparent tables I am trying to join B & C first and the the result I am trying to join it to the A.

When I Choose Build SQL query Option it is letting me to join A with B and A with C always but I was not able to join B & C.

I have read through the PDF's and searched the forum but couldn't able to find any information. Please let me know if I am missing anything.

Thanks so much.
bashbal



Group memberships:
Premium Members

Joined: 01 Mar 2004
Posts: 23
Location: Milwaukee, WI
Points: 277

Post Posted: Wed Jul 10, 2013 8:40 am Reply with quote    Back to top    

I know this message is a year old, but it is still relevant and I didn't find any similar solutions posted here.

I'm running DataStage Enterprise 8.5 FP2 with SAP R/3 pack 6.5.0.1 on HP-UX IA64.

You can't join cluster tables in SAP using direct SQL "WHERE" clauses, so "Build SQL Query" generation method won't work. Instead, use "Build Extraction Object" generation method to join a transparent table to cluster table.

When you "Build", first select the transparent table(s) as parent, then select the cluster table. Select the cluster table in the EO tree and click SQL Condition. From there you can either "Add Relationship" using the tool by selecting the Join Table and columns and other buttons, or you can manually enter the join clause in the "ABAP SQL Condition" box. If you need to filter using other columns from transparent table(s), you should apply separate SQL conditions from the EO tree.

Using this method, I have successfully implemented a job that joins VBRK (transparent) to KONV (cluster) table.

_________________
Lyle
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
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



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours