DSXchange

No replies then?
I have a workaround for this but I'd still like my doubts clarified especially if my assumption for the duplicate rows returned is correct.

I was under the impression that both DataStage and UNIX are super case-sensitive - at leats that's what Ascential had taught us in 2005...:-O

Hi folks I have a strange problem. Here goes. We all know DataStage is strictly case-sensitive. I thus have 2 environment variables, both pointing to the path where my .ds (dataset descriptor) files are stored - one if PathDS and the other is PathDs. this is because at some point we were using DS an...

Actually I think there were so many datasets, i panicked something was going wrong when the screen scrolled indefinitely - I thus stopped the command prematurely thinking I was deleting everything...:-o However with the echo command I managed to list out (in a file) the individual orchadmin commands...

I think I can safely assume that all datasets end with a .ds and filesets with a .fs.
that said I tried the following:
find . -name \*.ds -type f -exec orchadmin rm -f {} \;

This however didn't seem to work since it went on forever and i thus had to stop it.

Hi all By now I've understood why the orchadmin command should be used to delete datasets and why we shouldn't go for the kill with an rm command. However I have a few follow up questions which I hope someone here can help me out with: 1) Is the orchadmin rm command only for datasets or filesets as ...

however if what I understand is correct, this is not refreshed at job runtime? You are correct - Lookup File Stages use static lookup tables that must be refreshed manually. Which means this is useful only if my lookup data doesn't change too often. In my case my reference (lookup data) changes eve...

Thanks Ray. I'll try and find out what kind of environement we're in (SMP/MPP) but i'll go by the assumption that and 'Entire' Partition is not going to affect the runtime too adversely. I admit I'm not too familiar with the Lookup File Set stage - however if what I understand is correct, this is no...

Hi Thomas Thanks very much for that. I thus understand that it's not the total number of records in the reference link that decides whether a join should be used in place of a lookup. Rather it is the ratio between the number of lines in the reference and stream that plays the decisive role? In this...

Hello world This is a question that involves the use of lookups and joins - so basic DataStage fundamentals. This is what my current knowledge on the subject stands at, i.e. when to use what. Considering that I want a left outer join, if the number of lines in my lookup dataset (right hand side data...

Ha ha @ Craig But before you and the Ray discipline me for the misdemeanor, in my defense I found 4 hits when I searched for the error message - No default type conversion from type "date" to type "dfloat". Thought I'd thus update all 4 since in neither of them was the "pres...

Old topic (I know) but I had to go through this (and other similar ones) since I was looking for a solution. On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine...:-) No more warnings / aborts. Basically what happens I guess is on choosing to preserve the d...

Old topic (I know) but I had to go through this (and other similar ones) since I was looking for a solution. On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine...:-) No more warnings / aborts. Basically what happens I guess is on choosing to preserve the d...

Old topic (I know) but I had to go through this (and other similar ones) since I was looking for a solution. On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine...:-) No more warnings / aborts. Basically what happens I guess is on choosing to preserve the d...

Old topic (I know) but I had to go through this (and other similar ones) since I was looking for a solution. On a hunch I tried the option Preserve type = True within the Aggregator itself....worked fine...:-) No more warnings / aborts. Basically what happens I guess is on choosing to preserve the d...