DSXchange

Pierre There is a global catalog space under the UV account in Universe. I think it is called catdir. It was created in such a way as the user you connected with cannot read this directory or files in it. There should be a file name "$DS.SETCOL" in this directory. This user is probably in the wrong ...

Ray, Duke, thanks for all those valuable informations. I know now how to delete my files, and Ive learned some extra stuff on how datastage works. Thanks Kasia From"Ray Wurlod" Todatastage-users@oliver.com Cc DateThu, 05 Jun 2003 08:44:59 +1000 SubjectRE: Delete hash files > Check out the archives a...

Hi Dear all, I would like to expose you the following problem. A job which had never caused problems stopped showing the following messages : ----------------- DataStage Job 9 Phantom 689 Program "DSD.UVOpen": Line 469, "$DS.SETCOL" is not in the CATALOG space. [EACCES] Permission denied Program "DS...

This is a topic for an orphaned message.

Hi Katarzyna, You can completely delete hash files both created inside and outside of the project directory. There is a set of instructions to follow and I recommend you also verify this with DataStage Tech Support. I just deleted a hash file last night June 4, 2003. I am running on a Hp Unix platfo...

Check out the archives at www.tools4datastage.com. Search for DELETE.FILE and clearfile, perhaps limiting the search to my articles. Some time ago I posted an item describing the four ways to remove a hashed file, depending on how it was created. Also search for SETFILE because, using this command, ...

Katarzyna DELETE.FILE uses VOC entries to remove an operating system file. You can create a VOC record for a file and then use DELETE.FILE on it. You can also use other Universe commands like LIST, SORT, and SELECT once you have a VOC record. To create a VOC record then ED VOC HashFileName I F /path...

hi Katarzyna, if you want to delete them pysically totaly you cant: you have to go into the subdirectory and delete the and D_. If you only want to get rid of rows in the Hash-file, then use the "CLEAR.FILE"-command. Wolfgang > -----Original Message----- > From: Katarzyna Lewicka [mailto:katarzyna.l...

Hi,

How can I use the DELETE.FILE command in the DSAdministrator to delete hash files located in a directory distinct from the project directory.

(any other suggestion also appreciated)

Thanks

MONTHLY POSTING - DataStage Users List As of 2003-06-03 the DataStage Users discussion list had 758 subscriber addresses. A few of the addresses are to organizations who then redistribute the postings to more than one reader. ================== Posting Guidelines ================== 1) Non-moderated ...

For my enlightenment, could you give an example of a MATCHES statement performing as a case statement? Just curious..... At 09:39 PM 06/02/2003, you wrote: >You can however, use the MATCHES statement to perform as a case statement. > >Glenn Herbert wrote: > >>No. The CASE statement cannot be used di...

If you need the ability to restart at step N, then I suggest that you use a database of some description to keep track of which steps worked and which ones didnt. On a restart, you would then query this information to decide which steps still need to complete. You would have to write all this as you...

Hi, The job sequencer as the name suggests is great for sequencing a series of jobs that may or may not have interdependencies. Also because it is graphical development is pretty rapid and you have the advantage of the process being described graphically. This is great for describing the process flo...

Hello, Im looking for a solution for ordonnancing jobs. Any comparison for Job Seq vs Batch would be greatly appreciated. More precisely, Im looking for a solution for relaunching a sequence of jobs which failed at step N. Does the Job Sequencer manage it or should I go to Batch processes ? (relaunc...

Kathy, Multiple imbricated IF Then Else work well for me. Example from one of our Jobs: if Substrings(L1.F1,1,8)="00000000" then L1.F2 else if Iconv(substrings(L1.F2,7,2) : " " : substrings(L1.F2,5,2) : " " : substrings(L1.F2,1,4),"D DMY") >= Iconv(substrings(L1.F1,7,2) : " " : substrings(L1.F1,5,2)...