How to Read DBF File in datastage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Naren12345babu
Premium Member
Premium Member
Posts: 76
Joined: Wed Jan 06, 2016 9:40 am
Location: Bangalore

How to Read DBF File in datastage

Post by Naren12345babu »

Hi, How to read DBF files in data stage which is installed on Unix.

I already have a ODBC Configured in ODBC.ini file. But not sure of the steps to read DBF file using ODBC Connector or any other stage.
Need help with steps to read the file.
Thanks
Naren Babu Ch
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Put the ODBC data source name into the ODBC Connector stage's database name.

Leave the user name and password empty.

Put the name of the file in as the table name. It's been a while, but I believe those are case-sensitive and you would leave off the extension, because you've defined that in your .odbc.ini file.
Choose a job you love, and you will never have to work a day in your life. - Confucius
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

And make sure that the ODBC DSN appears in the active uvodbc.config file.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply