DSXchange

I also get the same error code. However, if I manually reset the failed job using Director, it runs fine after that.
So I believe it gives this error code if you try to run a failed job even if you specify "reset and run" option in dsjob...

I'm trying to import a 1GB sequential file using the Sequential File Stage in EE 7.5. The job aborts at the last record saying the data is bad. This is the error msg: StatementDetailFile,0: Short read encountered on import. This most likely indicates one of the following possibilities: 1) The import...

I have the same problem:

Table1 has Col1 as VARCHAR2(20) (Oracle). A Lookup on that column returns a 4096-byte long string, precisely 1 character + 4095 spaces. If I put a TRIM() in the lookup SQL I still get the maximum allowable varchar2.

So, I'll join Ray on this one...

Just to let you guys know that I spoke to Ascential support and they told me this is a bug that will (probably) be fixed in the next release (7.6). In summary, if you use the aggregator stage to do a MAX on a character column, the value gets converted to dfloat and back to string yielding an incorre...

I am using Parallel Extender. In my aggregator, I have a Column for Calculation. In the Maximum Value Output Column, I have 13 character values. I have defined this column as a character value throughout but it contains numbers only. I would like the aggregator to do maximum on it. So I have values...

It's a smart question and this is the right place to ask it. You need to identify the primary key of your parent record. You then de-duplicate your child records based on this key to create your parent records. Here is one design: Read in your child records and write them out to the target child da...

I'd like opinions/suggestions on the following problem: I want to load two tables in a target database, let's call them PARENT and CHILD. I have a flat file generated from the mainframe containing records at the CHILD level. I'd like to load both PARENT and CHILD from this file, having the PARENT da...