Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Join query if no referential integrity bw two tables

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
kethepalli vagdevi

New User


Joined: 07 Sep 2006
Posts: 2

PostPosted: Thu Sep 07, 2006 12:41 pm    Post subject: Join query if no referential integrity bw two tables
Reply with quote

There are two tables .
Table 1 contains 3 fields say A (primary key), B, C
Table 2 contains 2 fields say X,Y - no primary key.

We need to join these two tables.
There is no referential integrity between these tables.
Tha values in field A(char 3) are same as values in first 3 characters of field X(char 8).
and we need to join , table 1 and table 2 based on field A (of size 3) with only first 3 characters of field X(of size 8) .

There are more than 1 record for field A in table 2(field X).

eg : Field A has value 'MNP'
Field X has value 'MNP00045'
Back to top
View user's profile Send private message

sarunkumaar

New User


Joined: 31 Aug 2006
Posts: 15
Location: Chennai, India

PostPosted: Thu Sep 07, 2006 1:37 pm    Post subject: Join Query
Reply with quote

Use substring to match the keys.

SELECT COLUMNS_NEEDED FROM TABLE01 T1, TABLE02 T2
WHERE SUBSTR(T2.X,1,3) = T1.A
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am
No new posts Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us