Search found 4 matches

by vellanki
Tue May 22, 2007 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: commands to delete and create DBF,MDX files
Replies: 5
Views: 4232

Hey, I thank you once again for your quick response. I have an abc.DBF, abc.MDX file. what i did was, i've given a DROP INDEX abc.MDX in the open command and CREATE INDEX abc on abc (... some key fields upon which the MDX is built) in the close command. Please observe that both are of the same file ...
by vellanki
Mon May 21, 2007 12:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: commands to delete and create DBF,MDX files
Replies: 5
Views: 4232

Re: commands to delete and create DBF,MDX files

Hi, I've already tried those in the close and open commands. In the log it shoots something like a fatal error and says invalid open command. I have tried the DROP INDEX.... What i need to do is to get an empty MDX, DBF file and recreate them with the new data coming from a flat file each time. The...
by vellanki
Sun May 20, 2007 9:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: commands to delete and create DBF,MDX files
Replies: 5
Views: 4232

commands to delete and create DBF,MDX files

Hi, Can someone please tell me how to delete a DBF,MDX file in datastage 7.5.2 Parallel edition and also create new ones. Which stage in database stages is more flexible to do this. My job is to transform data from a flat file(source with DBF,MDX) delete the old existing data and create the a new fi...
by vellanki
Thu May 10, 2007 8:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: what is an mdx file
Replies: 3
Views: 2854

what is an mdx file

Hi,
How do i create an mdx file in datastage. Can any one please tell me what an mdx file is ? How its been generated in DataStage px 7.5. What is its importance.

Thanks