DSXchange

Use null handing. Thanks.

I think solution is in your warning:

"insert a copy operator between the modify and the upstream operator"

Thanks.

Following will give next Sunday. If you deduct 7 days, you will get previous Sunday.

Next_Day(to_date(date,'dd-mon-yy'), 'Sunday')


Thanks.

If your table is partitioned and local indexed, you may use tablename PARTITION (partitionname). So query will use only one partition.

2nd option: Add some to your where clause, so that it could reduce the number of records.

Thanks.

Until running the compute statistics on the table stat is not updated. So, you need to add HINTS on your update statement.

Thanks.

Chulett is right. 1st create index on ROW_ID column of the table. After that if still it is slow, then add Index HINTS.

Thanks.

Here is a link for that. Installation guide also has the details about the compatibility list.

http://www-01.ibm.com/support/docview.w ... wg27011265

Thanks.

You may use awk command 'length ==200' to separate all records with length 200.

Thanks

Since you have only one record for lookup, you can remove lookup and use stage variable in trasformer. Thanks.

Removing the transformer stage may increase the rate. Thanks.

Use copy stage and pass all columns but serial number. Thanks. I have a job that transforms data and assigns a serial number to it. At the end I want all the data to be sorted based on the serial number, but I dont want the see the serial number. DAtaStage works well if the serial number is pulled f...

Use Shared Container. Thanks.

anbu wrote:Can you tell us what you tried and what didn't work?

Just after the following warning: Input buffer overrun at field "XXX", at offset: 209 there could be the "Import warning at record ---". Check the source file and check that record. Certainly the length of that record is not in correct size. Thanks. Hi All, I have this error read...

If the table is indexed, you may use hint to specify the index. Thanks. Job is taking very long time while doing a select from db2 tables/views. Its a simple job selects from db2 api stage and loads to flat file. There are two tables and two views used in this job. This job was taking only few minut...

If the table is indexed, you may use hint to specify the index. Thanks. Job is taking very long time while doing a select from db2 tables/views. Its a simple job selects from db2 api stage and loads to flat file. There are two tables and two views used in this job. This job was taking only few minut...