DSXchange

If I were the programmer I would not be at all happy with a specification like "extract some information". What I'm trying to get you to do is to create a proper technical specification against which cogent advice as to coding may be given.

You can set the quote character in the Format properties of a Sequential File stage. (Technically it's in the link properties.)

Welcome aboard.

Search is your friend.

There are several solutions. Most common seems to be the External Source stage.

Write out IN ENGLISH what you want to do.

It is not clear from your code (a) because it is not indented (use Code tags) and (b) because you don't appear to have any clear idea of precisely what you want to accomplish.

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

Use a redirection operator to generate the report to wherever you require. Don't forget to redirect stderr to the same file.

RCP is not the same as row buffering.

With parallel jobs you ALWAYS get row buffering, and lots of environment variables to let you tune that mechanism.

Here we're in the server jobs forum.

Separate instances are not shown by default - you must expand the tree view.

Try detaching hJob1 when you're done with that job, so that you don't get a job locked situation.

Why are you executing the same job 18 times?

You could make a copy of UtilityRunJob and modify it so that it does not wait for the job to finish. Of course, you then relinquish control, and can not readily throttle demand on the server. Multiple, simultaneous execution of multi-instance parallel jobs, eh?? Of course, everyone knows that a Data...

DataStage SQL requires the terminating semi-colon.
Also you must be working in the project directory.

Is it always the same stage that generates the timeout?

Welcome aboard. Do try to come up with meaningful subject lines; it aids future searchers.

Please advise how the data are encoded in the remote file and what your DataStage NLS setting in the FTP stage is.

Convert works one character at a time.

That it worked for you was pure luck - all you got was each "X" converted to "A". Therefore "XX" would have been converted to "AA".