DSXchange

Change all the files to OS your sitting on. If it is UNIX then make sure all the files are UNIX format. You can find a bunch of commands to do this. tr, dos2unix, sed etc to name a few. You can search for exact syntax on google.

Same thing

I think thats an excellent point. Have been dealing with server types in parallel forum and vice versa a lot. Also creates a confusion for folks who are replying. Thats a good point.

Well, DB2 accepts date in internal format, I am sure about that. Not too sure about timestamp though.
Try

If you want restartablility then its better to modularize the way you have done. It will be easier and in fact, the overall performance will be better. Consider the scenario in which your job breaks at the 4th aggregator. Now when you restart the job, all the previous aggregations need to be done al...

In DS administrator, highlight your project and hit the Command botton. You can run this query there.
OR
You can go to dshome directory, type uv or dssh. Then

And then paste the query there.

Use the query in this link. This will give you the job name which will create and read this file. If you just want the job name that will create the file then remove 'CSeqOutput' from the query.

Now that makes it so much easier. Two things 1) You are directly linking an integer field to a character field which is a big no no. You need to explicitly convert. 2) You have a nullable field without any null handling. Now if you search on the error messages, you will see that this has been covere...

Look into the Column Auto-Match property inside the transformer. Its the third icon from the right at the very top.

Then fixing those warning message will elimate the fatal message. And therefore require knowledge of the warning messages. Do you mind sharing it with us?

Please search on keywords 'Converting number to string'.

Are there any other error messages? Any warning message?

I recommend getting back to support for that. If your getting the millisecond part for the target table then I advise you to talk to your dba to set up the Current_Tp column in your table with a function that gets the current timestamp. This way every time a record is inserted, you will see current ...

Write a shell that invokes the db2 connect and runs the query via DSExecute() command. Ofcourse you can make it much easier and use a simple datastage job to do this.

A box character huh. See if the following works for you

Test it out with the above command. If it works then make sure you dont have any dots in your data before accepting it as a solution.