Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Joining across Databases in AIX 1

Status
Not open for further replies.
dja1

dja1

Programmer
Joined
Apr 24, 2002
Messages
65
Location
GB
I have two separate databases contained in the same Instance, (DB2 running under AIX).

I use SQL emdedded in COBOL programs.

Can I use SQL statements that join tables in both databases. If so, how do I "connect" them?
 
Sort by date Sort by votes
Hi,

Acording to my knowleage it is only posible with federated database aproach.

Hope this helps.
Grofaty
 
Upvote 0 Downvote
Grofaty

Thanks very much for you reply
 
Upvote 0 Downvote
Dave,

look up 3 part names.

location.creator.name

Try the following


db2/os390/techdocs/os23.pdf

Never done it on AIX but it works fine on mainframe. I'll try and dig out an example.

Cheers
Greg
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

gdg1976
  • Locked
  • Question Question
extract rows with characters in char field
Replies
6
Views
949
gdg1976
gdg1976
gdg1976
  • Locked
  • Question Question
hi all, input TAB1 COL1
Replies
0
Views
432
gdg1976
gdg1976
ANGELDANY
  • Locked
  • Question Question
WEEK ISO with Dates in string format YYYYMMDD
Replies
4
Views
1K
ANGELDANY
ANGELDANY
gdg1976
  • Locked
  • Question Question
db2 sql extract double rows (different in case sensitive)
Replies
6
Views
753
mikrom
mikrom
MohanV
  • Locked
  • Question Question
Using table functions in Query
Replies
5
Views
652
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top