DSXchange

ray.wurlod wrote:Administrator client Command window or within a dssh shell in the project directory on the DataStage server machine.

Either that or "LOGTO" the project in question after you connect.

That command line utility is "dsjob". Search here or read the Command Line Interface section of either Designer Guide pdf for usage. Also search here for "ETLStats" for another approach.

You can see everything I posted.

No. What exactly would I mail you?

Get a local copy of the file, make sure you can read it and then adding the FTP part should be fairly easy.

You need to know what the character is before you can remove or otherwise handle it properly. And do not use private email to ask for help when people here are obviously trying to do exactly that.

What you require should be handled automatically by the stage as long as the data types are defined correctly for each field.

Create your metadata like normal as if you were going to be reading it from a Sequential File stage and then load that metadata into the FTP stage. That or script a solution using command line FTP to get the file local to your DataStage server.

First step would be to determine exactly what this "box character" is, typically by checking with a hex editor to get the hex/octal value, many of which are free downloads.

A LongVarchar field would imply a LOB field of some time in the source and, if that's the case, there really isn't a good way to "load data very fastly".

For the database logs question, that one should go to your DBA as each can have multiple log types that need to be cleared / archived periodically and which can wreak havoc when full / stalled / out of space or just generally messed up.

Runtime Column Propagation. A Parallel job feature where columns not mentioned in the job would automatically 'propagate' at runtime and flow through the stages.

Next time, try to do a better job of picking meaningful subjects.

viewtopic.php?t=88639

If you need that "automatically handle" functionality for other parts of the Sequence, let us know. There are ways to work around the issue you are having with it and that one particular job.

Well, the "turn off RCP" advice would only apply to PX jobs.

While you can't change one status to another, you can let the Sequence know it's ok by using the right triggers for the situation. What are you using now and do you have the "Automatically handle activities that fail" option enabled?