DB2 and IFX

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
berettae
Participant
Posts: 5
Joined: Tue Jan 21, 2003 11:57 am
Location: Italy

DB2 and IFX

Post by berettae »

Any one know about loading procedure of IFX file (extracted from DataBase DB2) to a DataBase SQL Server ?
Any Data Stage plug-in ?
Top
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Re: DB2 and IFX

Post by ogmios »

Don't use IXF, export to DEL. Then if you want to do the loads via DataStage use a "sequential file stage". I'm not familiar with SQL server but there should also be 1 or 2 tools to load tables from ASCII files.

Ogmios
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”