DSXchange

Are you providing any sort of transformations? I have worked with DB2. If you dont insert the nano seconds part, only then the database will add .000000 to it. If you are passing it, then it gets inserted as it is. If nothing else worked, varchar should have worked. There is something else going on....

What if you insert something thats on the higher end in the nanoseconds category. Something like
'2006-10-23 17:15:58.835789'
Does that get rounded off too
'2006-10-23 17:15:59.000000'

What if you specify the sql type as varchar, do you still encounter the same problem?

O really. Darn, i didnt know that. Never worked on windows server thats why

make sure you run the dsenv file first.

You can also look for the files for a specific time period in a day. If all files are found then execute sequence 4 , else end the job. Schedule this to run daily. Or you can also go with Control-M. With control-M, the control wont be in datastage, it will be with the scheduler. As Craig suggested, ...

O yea. I did go through that post but it never hit me. Still too early for me.

When you give the final delimiter as "|". That means, its the final delimiter for the record. You need a carrige return after that.
After a pipe, stick in Char(013):Char(010). Thats the carrige return for a dos file.

Ok now thats a post worth putting in your favorites bucket for future reference. Great find Kumar

An IPC stage can be used in between two active stages. Row-buffering are of two types, in process and inter process. The following is directly out of ds developer's help In process. You can improve the performance of most DataStage jobs by turning in-process row buffering on and recompiling the job....

How exactly are you performing Insert, updates and deletes?
Are you seperating them and doing it in three different jobs or a single job?

If thats the case then i think the OP needs to contact support.
If i were you, i would have the table already in place. I dont like the idea of creating things on the fly, thats too "at the last moment" for me.

My initial guess would be the use of resources. As 7 jobs are running in parallel, all using the Shared Container, which inturn, if has complex transformations and use of many stages, can cause errors.
As Craig pointed out, error messages are needed.

I was 'gonna'. But Kim beat me to it.
OPEN and CLOSE for hashed files
OPESSEQ and CLOSESEQ for sequential files

Ofcourse you can. Search for OpenSeq , CloseSeq commands. Also you can look into your Basic.pdf file.

Nop. Sorry, wild cards are not allowed in a server job. You will have to pre-determine the values of all the parameters and pass it to this job.