Creating DBF and MDX files

ray.wurlod · Post by **ray.wurlod** » Tue May 15, 2007 5:03 pm

What kind of database product is this? Do you have an ODBC driver? If so, you should be able to use an ODBC stage.

kuppleca · Post by **kuppleca** » Wed May 16, 2007 9:18 am

We are using the OBDC stage. We are able to create the DBF files; however, we do not know how you set it up to create the MDX files.

The DBF and MDX files are dBase IV products. The MDX file is a special file that contains multiple index files.

Currently, these files are created by a VB6 application; however, they want to move the creation of the files over to DataStage, if possible.

ray.wurlod · Post by **ray.wurlod** » Wed May 16, 2007 3:58 pm

Unless there's a call available in the ODBC API for creating an MDX file there's no mechanism apparent in DataStage for doing so.

Ultimately it appears that you want to effect CREATE INDEX commands from DataStage. Would that be the case? Does dBaseIV support the notion of stored procedures?

There is a DataStage solution using BCI functions, but that would entail you obtaining an ODBC driver licensed for general purpose use; the one that ships with DataStage is licensed for use only from DataStage stages.

kuppleca · Post by **kuppleca** » Wed May 16, 2007 4:18 pm

Thanks for the information, and I'll see what we can do with it. I appreciate your help.

ray.wurlod · Post by **ray.wurlod** » Wed May 16, 2007 4:26 pm

If you can use a dBase IV stored procedure, you can use Stored Procedure stage to invoke it.

kduke · Post by **kduke** » Wed May 16, 2007 7:43 pm

Why not ExecDOS? I think all these commands can be done at the command line.

kduke · Post by **kduke** » Wed May 16, 2007 7:43 pm

Post the VB code.

kuppleca · Post by **kuppleca** » Tue May 22, 2007 10:19 am

I would like to Thank all of you for your answers and suggestions; however, my Project Manager has decided that too much time and money has been spent on this issue. We will stick with using the VB6 application for the time being. Maybe in the future we can convince the users to change the format of the files.

Thanks again.