DSXchange

It's under the File branch along with the CFF, Sequential and Hashed File stages.

I was surprised to know that there is no way we can transulate an SQL error (such as referential integrity, data integrity, unique constraints.. etc ) to a job to Abort. This is not at all true. You have a specific issue with DB2 and whatever stage you are using. Perhaps a setting in the database n...

If it's a 'one time load' and the rows are complete duplicates of each other - why not simply preprocess the file in UNIX using the 'sort -u' command?

Dang, way too many of us trying to answer the same question at the same time.

Define 'all similar rows'. Sounds like a job for an Aggregator or stage variables perhaps.

so is it impossible to write to the same seq file three differently transformed outputs one after other in the same job.? Impossible? No. Practical? Not really. You could as long as each 'output' opens and closes the sequential file before the next one starts. Sequential files support multiple read...

You really don't want to do this in a transformer. The Sequence using the Wait For File stage will only 'stall forever' if you tell it to. You need to set a timeout value, how long it waits before it gives up on the file and then branch accordingly in your jobstream. Also consider a Loop construct w...

If that's the case, it must be a DB2 stage/database thing as that's certainly not possible with Oracle and OCI.

ecclesr wrote:Now I am trying to use Query Type - Load SQL from a file at run time such that it runs with parameters. Now I want to look at if it is possible for the script to run with parameters.

Ok... what happened when you tried it?

As noted, there is a sleep command in UNIX (lower case) and you pass to it the number of seconds that you want it to sleep / wait / pause. The bigger question is - you want to use it where? You could write a custom routine and use that in a Sequence job to pause processing, say in a Looping construc...

Currently it is just dropping records that have referential integrity violation and job completes successfully. I'd be suprised if it is actually completing "successfully". It should be throwing warnings into the log and have a status of "Finished (see log)" when done. It would abort once the numbe...

Why custom sql? It should hardly ever be needed, especially on the target side of a job. All it's going to do is get you into trouble, more so when you are new at this and unsure of what you are doing. Let the stage generate the sql for you. For something simple like needing a constant of '99991231...

The stage handles the delete/insert automatically so only one link is needed.

That's mostly because it's not 'Ascential' doing that part, it's the email services in the operating system. For Windows I would recommend looking into installing Blat, a nice little bit of freeware.

In other words - Manual Mode.