DSXchange

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

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.

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.

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

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

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

Post the VB code.

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.