Search found 25 matches

by Nic
Wed Mar 22, 2006 11:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to delete hashed file - job aborts
Replies: 5
Views: 3471

Looks like it is permissions

Thanks for all your help, it pointed me to the right direction. looks like that is what was causing the problem as the person who scheduled the job can run them with the same userid whereas some other people can't. I will now investigate the groups and permissions and if they are not the same I will...
by Nic
Wed Mar 22, 2006 6:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to delete hashed file - job aborts
Replies: 5
Views: 3471

Unable to delete hashed file - job aborts

Error message - every job aborts which has a hashed file in it FSSValidationJob..HshFSS.LnkToHshFSS: DSD.UVOpen rm: Unable to remove directory HshFSS: File exists Unable to DELETE file "HshFSS". "HshFSS" is already in your VOC file as a file definition record. File name = File no...
by Nic
Wed Mar 22, 2006 6:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to delete hashed file - job aborts
Replies: 0
Views: 548

Unable to delete hashed file - job aborts

Error message - every job aborts which has a hashed file in it FSSValidationJob..HshFSS.LnkToHshFSS: DSD.UVOpen rm: Unable to remove directory HshFSS: File exists Unable to DELETE file "HshFSS". "HshFSS" is already in your VOC file as a file definition record. File name = File no...
by Nic
Tue Dec 13, 2005 3:29 am
Forum: DSXchange Testimonials
Topic: There are some very helpful people out there - THANKS!
Replies: 0
Views: 18981

There are some very helpful people out there - THANKS!

I wish I found out about you sooner!
by Nic
Tue Oct 04, 2005 8:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating folders dynamically on Unix via DataStage
Replies: 10
Views: 6610

Figured it out

Finally figured it out (didn't take this long - I took a break from it 8) )! No, I did not put in /usr/bin - it was DataStage that put that into the error message it gave. Anyway, I created a flat file with all the folder names in Stage 1 where the field (which is to be the folder names) has to be c...
by Nic
Thu Sep 29, 2005 1:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating folders dynamically on Unix via DataStage
Replies: 10
Views: 6610

Unfortunately it didn't work. I tried it with a pipe too, tried it as a Before/After Job subroutine too. I am not giving up though so I'll keep trying until I resolve this. This is the error I got just FYI: CPHLookupCensusforParts..CPHOnly.LnkToCPHOnly: ds_seqopen() - Error in filter command "/...
by Nic
Wed Sep 28, 2005 11:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to delete a hash file ?
Replies: 5
Views: 1974

Use Administrator

I always use Administrator. On the Projects tab click on your project and use Command. On the command line use:

Code: Select all

delete.file hashfilename
This should be the safest option.
by Nic
Wed Sep 28, 2005 11:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating folders dynamically on Unix via DataStage
Replies: 10
Views: 6610

xargs

I will add the notes and description now, however I am still struggling with it as I have found it works perfectly but creates the directories in the default folder but they should be created somewhere else and I don't seem to be able to direct them elsewhere. Any suggestions with this please? Thank...
by Nic
Tue Sep 27, 2005 1:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating folders dynamically on Unix via DataStage
Replies: 10
Views: 6610

It works!

Thank you so much for this, I have been struggling with it for some time, but your solution is simple and very effective! Thanks very much again! Nic 4. Write a job that transforms the directory names one per row to a dummy Sequential File stage (the file name is not important - you won't even use i...
by Nic
Mon Sep 26, 2005 1:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating folders dynamically on Unix via DataStage
Replies: 10
Views: 6610

Creating folders dynamically on Unix via DataStage

I need to create directories on a Solaris box dynamically based on the values of a field. The number of values and the values themselves change every run (they are 9 digit codes). Once these are created I need to place the relevant XML files into the relevant folders. I have managed to achieve this ...