DSXchange

Can you put a derivation of OCONV(In.Key,'MCP') for your key as a test, this will replace unprintable chars with a period ".". This would show that your key perhaps does contain a field mark or value mark (which is not allowed) or a null.

If you do a COUNT DS_JOBS or COUNT DS_JOBOBJECTS do you get 0 records for either or both? If so, then you have a problem that will probably necessitate restoring a backup.

You are, of course, correct. I'm just so used to European (or military) time that the AM/PM text completed zipped by me . I think the FIELD function is a better way to go in any case, since it is more robust than using straightforward positional values.

What would ROUND(44,2) result in? I though that rounding took a real number and turned it into an integer or rounded a real number to a given number of significant digits.

Killing a process from UNIX should only be done as a last resort; and killing a process using "kill -9" should only be done when you know exactly what you are doing. The best thing you can do is to enable the deadlock daemon so that if any spurious locks are left around they are cleanly removed on a...

Parallel Job Developer's Guide 3-37, 3-38, 5-21 to name just 3. Exactly what data type are you looking to round off and in which stage do you want to do this? For a Modify stage look at pages 28-8 onwards.

Each process loads into local virtual memory, not into shared global memory so they will each have their "own" copy in memory.

Craig - good thought, the function to use is

Field(In.ColumnName," ",2,1)

(although yours will work in this instance because there are no trailing spaces)

Also, use -file instead of -filepath (even when specifying a fully qualified path)

dwblore, please start a new thread as your question is unrelated to the current one.

Just use the substring function, use RIGHT(In.ColumnName,11) since your string looks like it has a variable length date portion.

You shouldn't fix the DATA.30 file, but the higher level type 30 directory of RT_STATUS119. And don't run it with "fix" until you know what is going to happen (i.e. how many and what type of errors) and after you take a copy.

Parallel job sequential file stages can handle fixed width files in much the same was as server jobs do. They are much more sensitive to data types and column defaults than server jobs but once you have a sequential file input set up correctly it does run very quickly. What, specifically, is/are you...

The internal corruption is not a good thing, you will need to run the $DSHOME/bin/fixtool program on the files before anything can be done with them. Are there just a few that you can do this step manually, or are there very many?

ppalka - I thought I asked twice to check permissions.
As a developer you should be in the group which has RW permissions to all the files in the project directory.