1. Create a .Type30 file. This needs to be an empty file.
2. Create a "directory file" in DataStage.
This creates a directory that is a subdirectory in your project directory.
3. Using an operating system MOVE command move all the illegal files from the hashed file directory to your new TempDirX directory.
4. Verify that the hashed file directory now contains only DATA.30, OVER.30 and .Type30. You may also like to verify - using View Data perhaps - that you can see the hashed file successfully, even if it is empty.
5. If it's appropriate to do so, move the files from TempDirX into the hashed file using a "UniVerse" COPY command. First, if needed, create a pointer to your hashed file.
Code: Select all
SETFILE X:\path\hashedfile hashedfile
Then execute the copy.
Code: Select all
COPY FROM TempDirX TO hashedfile ALL
6. Verify that the records are correctly in the hashed file. Then you can delete the temporary "directory file".
And, if you wish, you can delete the VOC pointer to the hashed file.
Code: Select all
DELETE FROM VOC WHERE @ID = 'hashedfile';