DSXchange

If you are comfortable with the transformer then you can preprocess the date in a stage variable to get two digit day. Something like the following: Specify a stage variable, say FixDay . Its derivation will be If Len(Field(in.Col, " ", 2)) = 1 then Field(in.Col, "...

Perhaps an interview

Avoid using unix kill . Kill -9 is a really killer. There might be zombie threads after that. There are so many clean methods of unlocking a job. Go to each and every pid and at the bottom, click, show by process . When you see your job, click on Release All . Remember the pid because then you have ...

O yea, forgot to mention that.
date_fmt is your source column name and
date_tst is your target column name. They can be same too, I think.

Use the following in Modify stage. date_fmt:timestamp = timestamp_from_string [%mmm %dd %yyyy %hh:%nn:%ss] (date_tst) But in order for this to work, you will have to pre process your date to have two digits for day. To get the scale of 3, in your target stage, set the default timestamp forma...

The job is locked. Either by someone else (which you say is not the case) or by yourself (this can happen if connection between the server and client is lost abruptly). You need to unlock the job. Search for it. There are numerous method advised.

You can find gazillions of awk scripts online. Even awk one liners. If you search on awk here, you will find quite a few examples.

What is the length and scale of the double field? It might be more than the target and hence the warning.

TEMP_FILE should be a file that is local to DB2 and not on your datastage server.

Use generated sql. Also, '11-MAY-2007' is a mere representation of the date format set for your sql tool. Also, trunc() will not elimiate the time part it will just set the time to '00:00:00' . Try the following if you insist for user defined sql. select TO_CHAR(batch_strt_tmstp, 'YYYY-MM-DD HH2...

Are you able to view data? Can you post the sql you are using? Also you are using tunc() function on the timestamp, but I do not see any time part, just the date part. Is it really a timestamp or just date, and if just date, then why are you using the trunc() function?

The error indicates that the engine requested a job run but the resouces were not available and hence the request timed out. This may happen if you are running one too many jobs at the same time and hence exhausting the resources.

Use the search facility to get code by others. There are quite a few examples here.
Another place where you can look is, in the source code of the sdk routine, DSRunJob(), under 'Utility'. Look at the section "* Retrieve more information about this job run."

Read the sequential file as a delimited file and then load it to a fixed width file. This will be much better than manually going in and removing the delimiters.

Welcome Aboard
You dont need multiple posts for the same question. Please delete the other post before anyone else replies to it.
As for your question, refer to Plug-In Documentation, specifically DataStage WebSphere MQ Stage guide in DataStage pdf guides.