DSXchange

ray.wurlod

Not quite. It's driven not by the data, but by the design. If there's nothing on the input link (a Sort stage or a link sort) indicating that the data are sorted, then a tsort operator will be added when the score is composed. All three of these methods end up using a tsort operator. Therefore "...

ray.wurlod

Bear in mind that VarChar(4000) might be specified in characters. With NLS enabled this may require 8000 bytes or even 12000 or 16000 bytes, depending on the encoding used.

ray.wurlod

The modification history is not stored in DS_JOBS, it is stored in DS_JOBOBJECTS. You can join these, using the criterion DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO. Selecting for distinct category will, however, invalidate this join. So you need to think a bit more clearly about your requirement, probab...

ray.wurlod

That's really poor management. I wouldn't task a beginner thus. Did you pretend to be more experienced than you really are? I'd be interested in learning what the task actually is. There's almost nothing you can do with these stage types alone. Can you please explain the task and, if you know, why &...

ray.wurlod

You can do that, by using background processes and clever control of timing within the sequence.

ray.wurlod

I prefer an explicit Sort stage, partly because of the law of least astonishment (don't try to astonish the next programmer) and partly because it gives me control of more things, such as memory used for sorting and generation of key change flags.

ray.wurlod

Do you have version 8.5, which has looping in the Transformer stage? Even so, you don't really need it. Use stage variables to compare the current row with the previous row and, where the key value is the same and the other value is missing, use the other value from the previous row. Make sure that ...

ray.wurlod

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%.sh%');

ray.wurlod

Read the manual about what wildcard character is supported. Tip: it's not the percent sign.

ray.wurlod

Code: Select all

EVAL "FIELD(CATEGORY,'\',COUNT(CATEGORY,'\'),1)"

ray.wurlod

Well there IS a filter to search only for resolved topics.

ray.wurlod

Search!
This question has been answered in detail before.

ray.wurlod

Don't start with those. Start with simpler stage types.

ray.wurlod

Welcome aboard. Estimated row length is calculated by summing the sizes of the data types of all of the columns defining the row structure. See Chapter 2 of Parallel Job Developer's Guide to learn how large each data type is. But you've either got a very large number of columns, or some very large c...

ray.wurlod

You can run the comparison tool from the command line.

Search found 53125 matches