DSXchange

Not sure... perhaps in all three, and you may need to bump the internal field size up as well. Play.

You just need to remove the double quotes? No need to escape anything, just use single quotes in the function call:

That error implies that your substringed CLOB value is greater than 4000 bytes so guessing an NLS issue. Perhaps you can use Long Varchar as the intermediate value?

Ah... forgot about that little nugget.

If it was working fine, they wouldn't have posted here. And there's more to the requirement than that. All you have out of the box is either 1) all stages always run or 2) it restarts from the point of failure. As kind of a 2b) you can also specify stages to 'do not checkpoint' so they always run re...

Show us the config file you used.

plink?

I don't know how to do that just from what is installed... can you check your 'manifest' or with your vendor?

4GB is a limitation of 32bit architecture. You've said your O/S is 64bit, what about your version of DataStage?

Pretty common to list out all jobs and then check to see if they are aborted. The dsjob executable can list all projects, or all jobs in a project and check the status of a job.

I'm still a little unclear on what your 'general question' is attempting to find out. CDC does not 'perform' deletes, it detects them just as it detects new records and changes. What you do with them is completely up to you and the nature of the associated target. For a none 'warehouse' type target,...

Make sure you understand that you'll need to either move the file to the DataStage server via a mechanism like ftp (which Pandeesh posted an example of) and then read it like 'normal' or you could source the file from the remote server using one of the FTP stages. Or you could make the remote file a...

A single command to reset all jobs? No. You could always write one, but it would need to continue to do it 'job wise' as you noted.

praguur86 wrote:ERROR: cannot locate the TAR utililty on your PATH.
Please make sure TAR is on your PATH before installing

Seems a pretty simple solution to me - make sure it can find the UNIX utility 'tar' in your PATH environment variable.

Just trying to clarify as "jobmonapp" plays no role in getting link counts from Server jobs, only Parallel ones.