DSXchange

Are you having any luck access that Oracle source? I don't believe the "express" edition is supported at all, specifically the client.

"echo"? Perhaps Ernie will stumble across this and help explain his method. How about trying "find" instead?


This, however, may have issues if there are sub-directories with files that match that pattern in play.

You do understand why this happens with null values, yes? Why not post your entire derivation so we can see how you are doing the null handling during the concatenation?

I said "locks" and I meant row level locks, not table locks. Again, what db & stage? What array size? What transaction size? Remote or co-located database server? Many, many factors.

So... you put /dev/null in the Filename prompt and this in the Filter with the full path for the filename (times two): grep -v -e "`head -1 FILENAME`" FILENAME And it told you it was empty? If so, then you may be a victim of the filter's bad handling of quotes in the command. I've seen it strip them...

Do an exact search for "project already exists", there are several conversations on the subject here. It won't find them all but it will find enough to get you started and you can pull new keywords to search for from them.

ushasribandaru wrote:I am not aware of this QualityStage, can u help me to explain me in detail

U probably could but you really should ask Ray. And because you aren't aware of it, you probably don't have it so it will be somewhat... academic.

What's not working? Post your job design, where it seems that just a Sort stage would be needed with no stage variable shenenigans that you seem to be using.

You'll need to get the job number from the repository and then issue: CLEAR.FILE RT_LOGnnnn where 'nnn' is the job number. You'll also need to re-establish any auto purge settings for the job as they will be gone as well. You should be able to Search for the proper syntax to get a job number, off th...

Try your full expression again in the Filter and put /dev/null in the Filename prompt (rather than the filename again) and see if that helps.

I have no idea what you are asking for. Can you provide examples - both of the source data and what the transformed output should be?

Wouldn't you just... sort... them?

Impossible to say - locks perhaps, server load, delete volume per key, who knows? Might help to say what database and stage are in use here, but investigation of issues like this typically are a DBA task.

No, not that I am aware of, other than the need to write to standard out. Did you test your expression from the command line? It just hangs for me.

Thanks... please let us know if they come back with an update.