DSXchange

You will also need to use an internal command to locate the RT_BPnnn file, but from the project you can always use "find" to locate the file. If you only have a few derivations it might be faster just to look into your TRANS2 transformer stage.

Try

It depends on what format your start_time and end_time are. The typical formats are String and TimeStamp. In either case you can convert this to seconds and can compute the mathematical delta in seconds. Or you can do this directly between two TimeStamps and get a delta in TimeStamp format.

How did you declare the columns in your DataStage sequential file stage? It looks like the first 2 characters are missing.

I fairly certain that the bulk loader always defaulted to create & run the loader script. I think that somewhere in the stage you could change the settings so that it would only create the files but not perform loading - but it had to be explicitly set to stop loading.

I've seen that error message before; most people here have probably seen it before as well. Try running your job with APT_DISABLE_COMBINATION and find out what the real cause of the problem is.

Look at your transform stage. Perhaps you are performing some mathematical operation on a column containing non-numeric data. Does the transform have many derivations that are not 1:1?

S. Basu, it seems that you didn't look into the sticky readme which suggests using the search facility and the general recommendation that this forum is staffed by volunteers - if you need urgent and qualified instant help you will need to go to your support provider - provided you have purchased su...

There is no simple and correct answer. The answer depends upon the computer configurations when separate vs. when on the same box and also on your connectivity between the systems - how fast is the network and does anyone else use it? Normally the database engine is on a different system from the ET...

The limitation on DB2 VarChar is 32767. What is the DDL for your table in DB2?

Sahrl wrote:...when i loaded the table is loaded with warnings...

Could you please post the warnings?

Mandyli - I have a red light on my bike panel that blinks, what is the problem? The common theme to both your question and mine is that there is insufficient information to make an educated analysis. Do you always get this error? On all jobs or just one? What does this job do? Is the error in the se...

Process the files inidividually and write the data into a DataSet using "append", then process the DataSet in a final job.

There should also be a file at .../InformationServer/Version.xml

Can you not read all the files together and merge/sort them in your job?