DSXchange

It's certainly possible to move hashed files (note it's hashed file, not hash file) but, if they have VOC entries on the old system, you will need to create those on the new system. Also, if you try to move a hashed file while it is in use, you are pretty much guaranteed to end up with a corrupted h...

... and when you specify a Filter Command, the stage reads that stdout file unit rather than whatever is mentioned in the File property.

Your approach leaves may orphan records in DS_JOBOBJECTS (note, too, that it's a letter "O", not a zero, in the name). You are missing deleting every stage, every link and every annotation. What you really need is DELETE FROM DS_JOBOBJECTS WHERE OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE N...

For small volumes such as you propose a server job may well be faster than the equivalent parallel job.

Server jobs have far less startup overhead.

Click Next ?

There's no single command, but you can write a shell script or DataStage sequence to loop through the file a line at a time reading the line and effecting the mv command.

Meh. PXPivot stage can do that.

Don't forget the Platform SDK.

Welcome aboard.

I'm sure I've answered exactly this question quite recently. Perhaps it was posted by one of your colleagues.

Why not get in the habit of a Search of DSXchange to see if you can find your answer immediately?

There is no generic "magic wand". The only available solution is to complete the deletion of the hashed files that were partially deleted. And you need to prevent future "accidental" deletions (probably by educating somebody). If they have a VOC entry, use DELETE.FILE DICT hashed...

Do you have your NLS TIME locale set exactly the same way in both environments?

vamsi.4a6 wrote:I do not have access to Metadatarepositary tables like DS_JObs etc from command line and Administrator

Yes you do.

Is this an undocumented option? E:\IBM\InformationServer\Clients\istools\cli>istool -help istool Command [ Command_Options ] [ Options ] Possible values for: Command glossary export : Export business glossary content glossary import : Import business glossary content glossary bi2bg : Building a glos...

Do you want to read the files' content or names?

Do you have any preferred mechanism for identifying these "dynamic" directory names?