DSXchange

.DBF files are the source for DataStage and i hvae seen a datasource type as dbase in ODBC connectore stage but i don't know how to read those .DBF file using ODBC connecter stage. I dont want to use any external converter to convert .DBF to .CSV format. DBASE is not a source, the .DBF fiels from DBASe is source.

How can we read .DBF files using DataStage? or
Can we convert .DBF files into .CSV file format using any script?

Anyone please help me on this.....

Akilasaminathan1 wrote:DBASE is not a source, the .DBF files from DBASE is source.

Same thing. The file is the database. Use the ODBC Connector stage after creating an ODBC data source name using the dBase drivers.

Do we have any other specific script to convert as .CSV file format?

A non-DataStage solution? Google for "convert dbf to csv" to find alternatives.

Thanks.
I can able to read .DBF files using ODBC connector stage.
But i am not able to create metadata for .DBf files.
How to create metadata(table definition) for .DBF files?

Anyone please help me on this

Let's start with what you've tried and what issue(s) you are having.

dBase metadata are usually only "documented", which ultimately means that you have to retrieve them manually either from a document or from program code that accesses the data.

I use the ODBC stage to read DBFs. Be sure though, sometimes I need to make sure that the CDX and FPT files of the databse are in the same directory of the DBF file that the ODBC connection is pointed to.