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!

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

Updating a External Source (AS400)

Status
Not open for further replies.

NotSQL

Technical User
May 17, 2005
205
GB
Hi,

I need to know if i can update a external source (AS400)using SQL Servers DTS.. I well aware you can do a straight update but what i need to do is update a field in the AS400 based on filter criteria in my Data warehouse..

Can this be done? if so how?
 
Is the AS400 running a different database platform? I hear them mentioned once in a while but I must admit I have never worked with one, or any type of mainframe system.

If all else fails, you could export your table, put it in SQL, do your update, then export again and load to the AS400. I would imagine it's possible to set up a connection though.

Good Luck,

Alex

A wise man once said
"The only thing normal about database guys is their tables".
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top