DSXchange

ray.wurlod wrote:This is what's known as a Lazarus post. The original question was put in 2004. Both sites mentioned now exist - the Newsletters appear on one of them.

Humm... Still Collecting Poll for the both.

You will need to find all jobs with a status of "Running". They will need either recompilation or a RESET before Running again.

Any scripts available for this?
ie., Reset Before Running (I know this can be done from Jobsequence)

You mean Write method as 'Upsert' in DB2 stage?

If you dont see any of the job, then how you manage to open the recent jobs? If objects in the project folder has been wiped out, then there is not way you can get the objects back. If the unix system has be move to a new place and and now if you dont see any job under Jobs category, then Reindex wi...

By default it is roundrobin. But it varies depends upon the stages you use. If you use the same auto partion in DB2 stage, it used DB2 partiton. If you use in sort or join, it automatically inserts hash. Since it is not predictable, it is alway advisable to use delibrate partition mehton.

Or as mentioned Sort the data based on the keys, use aggregator and retain 'first' of the values.

At what stage the sequence is getting failed. And what is the trigger you use in the stage. One of the reason the Unhandled failure arised, when the failure trigger not been handled.

If record delimiter is blank, the next row of data will be concatinated with the previous row. Hence for the whole file. So if you use head or cat it would search for record delimeter for finish a single line. Hence assume it as an single line.

yes all the rows all entirely similar, i want the transformer output to be only one row or any one row only thx More you be clear, more you get the answer quickly. Similar is it ment for Duplicates. If so search the forum, you would get lot of ways to remove it. Use two stage variable to compare pr...

What stops you to use Append type in the target file to consolidate the three output.

sendmk wrote:hello,

can you tell me how to clear the context of a file in unix.

thx

Simply remove the file (rm) and 'touch' the file with the same name.

sendmk wrote:i want a output, which is getting written in between, to be written at the end of the file

Can you be bit more elaborate on your requirement.

If you use WaitForFile activity, you should make it to wait for a file which should be produced by another job and not by the same job. Hence the job2 should wait for a file which is produced by job1.

I'd be suprised if it is actually completing "successfully". It should be throwing warnings into the log Craig, this is possible. I have had this issue earlier and honestly speaking if you see the logs, you see all GREENS . haimurali What you can do is that have this job abort in sequence itself. Y...

A lively DataStagexchange would serve the purpose of ToolXchange.