Reading DBF file in UNix and convert to CSV

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

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

Reading DBF file in UNix and convert to CSV

Post by Naren12345babu »

Hi,

How to read a DBF file and convert it to CSV file in Unix shell script.
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 »

You could use a DataStage job with ODBC Connector stage to read the DBF file, assuming you setup the proper ODBC driver, and write to a CSV file. The only purpose a shell script could serve in this case would be to call the DataStage job.
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yeah, oddly enough when you post a question like that in a DataStage forum you're going to get a DataStage answer.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply