DSXchange

The transformation should do the trick of removing all numeric characters from the string, if that was your intent.

Note that in order to have DataStage process the microseconds, the "microseconds" extended attribute must be set for the timestamp data type.

In a situation like this it is often helpful to locate the "guilty" portion. Since hangs are most often in write stages, replace those in a copy of your job with simple "peek" stages and see if the job completes. If it does complete, narrow it down to the one offending stage and ...

Was the same user number shown after your restart (number 63978)? How one goes forward depends upon that, since it is highly unlikely that the same user/lock scenario will happen twice in a row.

Yes, that will work - the same job can run simultaneously on one machine from two different projects; assuming that they don't use some single-threaded type resource such as writing to the same sequential file.

Those "junk" characters are indeed non-displayable characters in your current language set / representation. Are you certain that you really wish to remove these characters from the text/comment fields; perhaps the data will later be read by someone who does have the correct NLS settings a...

There is no option within the dsjob.exe calls that will give you that information.
There is no simple way to do this, but perhaps doing an export into XML format and then parsing that file for the short and long descriptions is the easiest way.

In that case, the "Field(In.BIGColumn,Char(9),1)" will parse the string until the first tab character, skipping past any and all spaces in the string, until it gets to the first TAB character and will return what is to the left of it as the function return value. you can confirm this by wr...

I think that you would need to be much more specific in order to get assistance on this issue.

- By "power of the data warehouse" do you mean the speed that DataStage loads the data at?

- How does the speed affect the information written to the datawarehouse?

How did you define your sequential file - as one column or as multiple columns? The definition is where your problem lies.

My fault, I meant "Designer" not "Director" but my fingers disobeyed me. From what you state, that search result won't help, you need to write BASIC job to FOR {all jobs in project} open job SELECT all passive stages FOR {all stages} IF Hashed file stage type THEN SELECT all link...

How about just searching the repository from the director for jobs that use the hashed file stage, or do you only want to locate writes? In that case I would write a small BASIC program to traverse all jobs in a project looking for the specific stage - and I believe you can use the link information ...

They did try to run it, but it kept on asking for more DLLs - I don't have the details. Does one need to register DLLs somehow? I thought it sufficient on Windows to have them in the PATH. I don't have access to any PCs here at work, but have mailed the 3 files to my home PC and will test it there t...

I've got an odd situation here which I can't test directly: At this site we wish to use maestro for controlling datastage. In order to use this scheduler, the "dsjob.exe", "dsclnt32.dll", and "dsrpc32.dll" files were copied to the remote system but I've been told that i...