DSXchange

I tried without MQ.. I mean.., i took a file zipped it(GZip), passed through the transformer with the data type binary and wrote to a file with extension .gz. it does not recognise it as gzip format.. Any clues!!!! Thanks Kalpna. What is the stage you use to read and write? You can try using Comple...

ray.wurlod wrote:With disjoint sets of keys Replace ought not to be a problem.

Load - Replace option replace table totaly with the input data, irrespective of the presence/absence of the key in the input.

What is the record Delimieter.
Many unix command have restriction to read 2048 characters per line.
If you Record Delimiter is 'none' specify as 'end'

Do you really need the Link Collector? DB2 will be quite happy with three inputs, so long as the sets of keys in each set are disjoint (so that there is no contention for locks). You may see substantial throughput gain as well. If you opt the option suggested by Ray, Replace may not be a wise idea.

Connection broken can be of many reason. Have you tried again to connect to the server and reimport?
Is that every time you get the same error?

Yes existing file will be dropped and a new file will be created. But I noticed one thing funny, when I was running a job, first time it happended to get aborted due to wrong Key column. The next time when I run, there is a file with a extension of 'about-to-be-deleted'. This lasted for 2 consicutiv...

Recreating lookup fileset with same name, will overwrite the existing file.

Hi Kumar, thanks for reply. Instead of Delete, why cant you just replace the whole content. What does it mean? I am giving the query in Before SQL. like this DELETE FROM SCHEMA.TABLENAME thanks in advance. As mentioned in other post, Delete uses the transaction log. Where as if you use replace it b...

You can parameterize the script and pre populate the sequential file with necesary SQL.

Instead of Delete, why cant you just replace the whole content.

There is a command SLEEP 10.
Is this you want or you need to wait for a file for 10 sec?

HI,
You can use Ereplace to supress '/' or
Oconv(10740, "DYMD[2,2,2]" : @VM : "MCN")

It is always better not to abort the flows. But you can do this by adding a transformer in reject link and you can provide the constraint as abort after 1 row. But need to make sure that all the rejects are due this reason. Or you can do a post checking with the job log, for the specific SQL error c...

Since you are new to the forum, you can search the forum the information you want to get. Most of them might have already discussed.
Like this.

Hi,
Pls dont hijack the thread. Post in a new thread. With more information. What is that you want to do and what is the desired result?
What are the input sources?