DSXchange

Can these settings be switched on when you are looking up the same file and writing as well in the same stage?? Sure, as long as you realize that the read cache "pages" a large section of the file into memory, essentially a snapshot of the whole hashed file when it's small. The write cache means th...

If you've confirmed that the job number for the RT_LOGnnn file in question is no longer being used, go ahead and manually remove the log files. There's no job left, so the log is probably meaningless to you. The only way to view it now is manually thru the command line and then it's probably hard to...

Just streaming a hashed file out is wicked fast. The mechanics behind parsing it are pretty irrelevant, because the file just dumps out from some starting point. Data can be sorted going into the hashed file, but the randomizing effect of the storage algorithm means that the data comes out in an obs...

Any specific reason for sequencer ? In a development environment, how do you run a complex series of interdependent jobs without using a scheduler? A "jobstream" allows you to build and test the jobstream. A sophisticated or dynamic stream of jobs won't work within the confines of an enterprise sch...

Doesn't hurt to ask Don't let me hijack Ray's original post. I think the motivation comes from learning what makes answering questions a little difficult. I know when I see 500 unread messages after a 2 day lapse I feel daunted.

If you do find processes executing, look at before/after job/transformer routine calls. If the transformer is executing an after routine, the links may be green but the call could still be open. Also, look at any large log file purging that could be happening. Your &PH& directory could be fu...

That would be helpful How about a Search button, something like show me all posts I haven't read since a certain date? Also, how about a Search button, something like show me all posts that haven't had a response since a certain date? Sometimes a post falls thru the cracks, there's no easy way to fi...

It's faster to use command line ftp and move the file local to the Windoze server. Then, you can inspect the file using many easy to use tools. The FTP stage is hyper-sensitive to file structure, consider junking it in favor of command line ftp transfer and then the good old trust Sequential file st...

Are you all sure that your solutions will serve for a reference lookup?

DS can only point to one version of Oracle sqlnet. Your OCI9 stage works because it's probably point to Oracle 9 client (look at the ORACLE_HOME variable in the dsenv file). Oracle 9 client works with 8, 9, and 10, so you have no worries unless you also need to point to 7, which is no longer support...

So, you want an OCI/ODBC based reference lookup that will collapse an indeterminate number of values into a comma separated list? Best answer: stored procedure Second best answer: pre-collapse the reference rows via a job into a hashed file containing the required results Reasons: 1. SQL cannot prod...

Check the free space on the file system for the project, plus make sure your /tmp isn't full.

Welcome aboard! Is this a new installation, a new project, etc? Have you looked at the permissions of the userid used logging into the Director client? Do they have permissions to the project directory?

Arnd, what release is that? Did you set the auto-purge on the base job?

Wait until you see what happens to job instances. Since each instance has it's own log messages, it appears each instance has its own job log file. But they don't, the base job has the single log. Go to a base job and look at its log, you'll see all log messages from all instances. Unless they've fi...