DSXchange

Loric, you have just asked the car-equivalent question of "My car always stops running after I start it. Why?". How can we answer you question without knowing more about your problem. a) there is always a reason. b) Does it always "hang" c) Does it process a number of rows or stop at the first row? ...

Poorna, The type in your case is probably going to be best set at 2 and the separation should be 1. The static hashed file types are: 1/19 - Directory. Type 1 is limited to 14 character names, uses sub-dirs as delimiters (i.e. "testprogramname" will be "testprogramnam/e") 2 - numeric, 8 rightmost di...

Yes, it would be 2 completely distinct streams. Since DS doesn't know that the 2 sequential files are the same, it starts both of them at the same time as separate processes and that is why it works. I can't recall the details of what my problem was with using just one canvas object for the sequenti...

The job log is in a DataStage table and is not a sequential file. You can use the UNIX command "dsjob -log <project> <job>" to get this information listed to standard output and could redirect that to a text file. Addendum - I should have read the whole post before replying, after seeing Rays's resp...

Craig, I don't know if that is necessary much of the time; it adds one more possible failure point to the process - forgetting to start one of the two, for example. I have often used named pipe stages in jobs when I do some implicit or explicit reformatting. One case is where I use it to read in a w...

Jasper, no, DataStage doesn't. There is no such thing as CHAR in DataStage, if a job reads CHAR columns they are padded with blanks. I think that in this case the TRIM() function isn't doing what is expected because the padding is not the normal space (char(32)) but nulls (char(000)) and that is why...

The TRIM function will remove spaces, but it might not remove characters that are not spaces but display as such. In your job add an extra test output column that displays the ASCII value of the last character in your test string - use SEQ(In.YourColumnName[LEN(In.YourColumnName),1])...

Every pound of weight has 3000 calories or 420 answers to DS questions. I don't know if we can afford to lose any weight and keep up our professionalism!

Ray - did you lose all your money at the craps tables and have to hire on as crew on a steamship to get back?

I think that (2) means instances of the server engine. Multiple projects in one instance of the engine is common and typical. You can have multiple instances of the server engine using the same or different versions on the same machine, these are completely independant from each other and each insta...

You have all the software you need on your machine - since the compiler is already a pre-requisite of installing PX. What I would ask you to think about is the requirement for using PX for this. If you write a DataStage Server job to read from a sequential file, convert using the EREPLACE() function...

The server function for what you are trying to do is ereplace and there is no PX equivalent function. If you only have a couple of conversions then a IF-THEN-ELSE construct in a transform stage would work, if there are many then you would best be served writing your own function to do this.

Craig, I lost this thread in the crush, sorry. I'm not at an Oracle site, but I thin the environment settings for ORA_NLS and NLS_LANG are the ones that influence a conversion. Also, what ASCII value does that upside-down-question-mark get converted to in the sequential file (the view data will alwa...

shyju,

yes, use two different sequential file stages, one to read from the file and the other to write to the file (the "file" being the named piped object in both cases). I remember having had a problem doing that with just one stage at 7.5

None are publicly available at present. I've sent 4 missives off to the e-mail address given and haven't even gotten a reply. I gather that they are still "working on it" but it is does seem to have gotten a low priority.