DSXchange

Um... I thought that's what I said

rleishman wrote:When I change the readu and writeu to read and write , the job runs to completion.

Thanks anyway.

I have a routine that creates/opens/reads/writes a hash file. It is called from a Transformer (ie. once for each row). The hash file is created on the first row. For any call to the routine, it only writes to the file if the key does not already exist. The routine works perfectly for the first 600 r...

A "wee bit"!!!!! :shock: I s'pose Katrina did a "tad" of damage in New Orleans, and Bush is under a "smidgeon" of pressure over it!!! Very nice Craig, thanks. Routine compile times down to sub 1 second. Does anyone (who knows) actually leave these options turned on? I t...

Whats "too big". I'm not at work at the moment, but I think it's a few hundred lines inc comments.

Hmmm. I don't think I am going to be any help here. Didn't you say you were transferring the rows to another table and then deleting them from the source table? That would take a couple of SQLs but you have shown me only one :? OK - I'm making a big assumption that the Teradata plugin logs the same ...

Affan, Once again, I don't use Teradata, but even if the SQL is successful it should appear in the log. Look at EVERY Info message from the start of the job to where the Terdata Plugin starts reading rows. Could you paste the SQL into your reply and enclose it in the CODE tags. I'm packing up soon, ...

I started out with this thought but they told me they were also fighting for space and they could not add an extra column hence the idea of using the existing column. Actually, I wasn't thinking of creating a new column is DB2, just passing an extra data item (that does not exist in the table) to t...

Dude, where the hell are you - it's Saturday all over the world and I refuse to believe you have less social life than me. Ah it's coming back now. Not a Job Property (oops :oops: , did I say Parameter before) but a Job Sequence setting used to log each activity in the sequence. Forget it; it doesn'...

We are doing the exact same thing at our site. Incoming files have headers and trailers; if they are missing or contain incorrect numbers then we assume that the extract or transfer mechanism by which they arrived has failed and we do not process them. Whether you abort or skip depends on how import...

Listen Troy, I'm pretty new to this forum, so I'm not as tough on newbies as Ray. The problem is he's right (dammit). Just to show how compassionate I am though, I'm going to give you the tools to find the answer: The mapping is: oconv(iconv(MetricDate, ":( "), ":cry:" ) To find ...

I use Oracle, not Teradata, but to help I think even Teradata gurus will need to know more. Can you establish whether the before-SQL is actually being run? If you have a look at the job log in Director, there should be an Info entry for each successful statement in the Before-SQL, and a Warning entr...

Affan, I want to get rid of those files from the project directory too, so I'll be interested to see the posts you get. If there's no way to do it automatically, hopefully someone can tell us which ones are redundant so that they can be removed in a Post-Job routine. As to active and passive stages:...

Nice. Was the spare column you used already in the table? Or did you just pass an extra column with the same value to the DB2 plugin? If the column already existed, then it is no longer being maintined by your job and will quickly get out of date. If the latter; clever! I had not thought of passing ...

Emilio, I can't believe the most interesting topic of the week was posted when I was asleep. Well now you Yanks are going home to bed and it's Australia's turn... Here's my understanding of your requirement: given an input file with n columns, you want to produce an output file where no single value...

The transform you want to use almost certainly references an SDK routine of the same name. So rather than referencing the transform from your routine, what you really want is probably to reference the underlying routine. If I'm wrong and the transform you want is just a simple one-liner that doesnt ...