Search found 4 matches
- 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 ...
- 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...
- 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...
- 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
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