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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOWTO: Daily Upload from DB2/AS400 to Oracle/Sun

Status
Not open for further replies.
mtscomasp

mtscomasp

Programmer
Oct 23, 2001
4
US
I need to upload DB2/AS400 data daily. This would be a piece of cake in SQL Server using DTS. But I don't know where to start in the Oracle world.

I DONT want to export files daily from DB2 side & then FTP them to the Oracle/Sun box; it's been tried & there are too many failure points. Also, that would require tracking dozens of files (one for each query).

I've seen some threads about database links using ODBC, but I'm on a Sun box. Is it still possible? Are there other connectivity options?

All suggestions are welcome!

Thanks much in advance
 
Status
Not open for further replies.

Similar threads

KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
184
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
149
TheLazyPig
TheLazyPig
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
345
SkipVought
S
Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
448
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
337
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top