DSXchange

Ray, that is why I asked the OP to post the query - so that we can then point out the file name and show that it isn't accessible.

How many parallel nodes are running when you execute this job and what partitioning algorithm have you chosen between your files and the remove duplicates stage. This might be your root problem.

I did answer the question, with my code the input "William Jefferson 'Bill' Clinton"

Would get separated into First name "Wiliam", last name "Clinton", middle name "Jefferson 'Bill'".

Are you in clustered environment and the other fastnames in your config file are "ping"able systems with the requisite directories? If not, then replace the fastnames with "dwapp2w129m3" in order to make the config file acceptable.

Siva, that is an important piece of information, but would be more useful if you could cut-and-paste the query from DataStage into this thread.

Hashed files don't use external SQL.
Can you post your SQL statement in stage "TMP_SQE_RUN_RATE" please?

So I could envision a UNIX script which is called and modifies the contents of an odbc.ini file entry "dynamicODBC" (called from a job sequence). The ODBC entry in the job is hard-coded as "dynamicODBC" and would then access whatever path is in the file. At least I think that thi...

I can't test it from where I am, but you could code the reject link when the setting is "normal" and change it to "sparse" and re-compile; I know it will compile but don't know if the links will go down the reject link as they would with a normal lookup.

NO, YOU CANNOT COMPRESS THE FILES and keep the dataset usable. By renaming them the original dataset becomes corrupt.

can you ping the server from the client machine?
Could you have firewalls/proxy in place between the two machine?
can you do a "telnet server:8080"? (or is it 9080, I forget the port number and don't have access to datastage now)

I'm not sure that using "*.ds" is a good idea unless the OP wishes to delete all of the datasets.

Wouldn't a left outer join mean that for each row coming in on the LEFT it would find a match on the RIGHT and output a row with the matching data or nulls; i.e. the number of ouput rows will be identical to the number of input rows from the LEFT link?

Dataset descriptor files (the ones you name in jobs to access the datasets) contain no data and cannot be that large. You are probably talking about the actual data files and you should not manipulate them singly at all. If on Windows you can specify that the directory and its contents are to be com...

You would execute your ls command in a command activity, then parse and interpret the output of the ls command in a user activity stage.

Can you post your APT config file plus what your new system name is ("hostname" from the command line)?