DSXchange

Thanks shamshad and OddJob for your suggestions. We tried setting APT_DISABLE_COMBINATION=True. But still we got the same error. Actually, one out of the two SQL is just a one time delete SQL. So, we removed this DB2 stage having the delete SQL and tried giving this delete SQL in the Before SQL tab ...

Hi, In one of our job we have two DB2 stages as target. Both these DB2 stages have SQL statement on the same table. On certain occasion when we run the job, the job gets aborted giving a deadlock error. And on most occasions when we re-run it, it completes successfully. The error message that we get...

Thanks all. At last we figured out that the extra unwanted character was coming right from the source file. We tried changing the Line Termination property in the source Sequential File stage to be as DOS style from Unix style. This solved the issue. The extra null character no more shows up in the ...

shamshad - In the Sequential File stage of a server job, hope we cannot explicitly define a Final Delimiter for Record level as you had mentioned...

The delimiter between the columns is "~".

But, there is no transfer involved inbetween. The file is created in Unix server and also the read takes place from the same Unix server.

When we give fixed length and say view data, we get error message and it does not show up any data. The error message that we get is - "column unexpectedly ended by EOR" Yes, we are seeing it using view data only. At the last column value, after the actual string value, it shows a thick li...

ArndW - All columns are Char(). When we try doing a view data, the last column shows this binary null at the end.

shamshad - The DatStage version is 7.5.2

ArndW - All columns are Char(). When we try doing a view data, the last column shows this binary null at the end.

shamshad - The DatStage version is 7.5.2

We are not giving any termination character. When we write to the file, we give the Delimiter and Quote character as 000. When we read that file, we only change the Delimiter to be as "~", because this is how the columns are separated in the incoming data.

Hi, We are trying to write to a Sequential file stage and then read from the same file in the same job. When we write to the file, its has a single column which contains the complete row. And when we read that file, we read with 50 columns by providing a delimiter character. But when we read the fil...

Thanks all for your suggestions.

I did it by using a Row Generator and then a full outer Join.

Hi, We have a requirement where we aggregate a few records and write the record count out to a sequential file. When zero records are passed through the Aggregator, the output of the Aggregator does not write any record on the output file. But we have a need where we have to write the record count v...

Hi shivakumar,

Can you please let us know if you were able to achive this logic. We have a similar situation.

Thanks.

dspxlearn,

With write method of Load. it takes us approx. 5 mins. for loading 1.5 million rows.

Each row has around 100 columns in them.

Yes, there are no constraints on the table. It originally had some indexes on it and even that was removed to do the Load process.

And also the Disable Contraints is set to False.