DSXchange

FYI. Bold doesn't work inside code tags so I changed them to quote tags.

So... are you saying it works now? If so, what kind of advise are you looking for - why that change would have fixed it?

So... Oracle, yes? Best way to see the why of this is via the Explain Plan to see the path the optimizer has decided to take through the tables / data in each case.

Ah... just saw the 'O' word in the additional info line.

There are a very large number of discussions here on the topic of pulling information out of job logs, did you try searching at all? Most of them end up mentioning 'ETLStats' so an exact search for that term should help quite a bit. And you've got a couple of choices on the How of this, depending on...

You'd have to do some investigation and then perhaps someone could help. Any idea where they get 'stuck', what they are doing? Does each one hang at the same step / place or does it differ? The logs should help answer those or perhaps a DBA but that's just a guess as we have no idea what your job de...

We don't know why either.

Many items use 'default' formats for displaying the data, that includes View Data and Peek which can confuse people. If you follow Rays advice for the Teradata push it should use the requested format, I would think. I was hoping for a more detailed target answer - what is the data type of the target...

You answered Ray's question but not mine which is about the viewing of the transferred data rather than the transfer itself.

Found this. Not a DataStage error but implies you may need to escape your single quotes.

Welcome.

I for one would be curious why you want to take this route. The syntax is not exactly straight-forward from what I recall, seems like doing it in a job would be 'better'. However, wondering what exactly it is you need to do in this routine in order to determine the best path.

Not familiar with the tool used but they did say this:

naveed.zuber wrote:Tried with both Binay and ASCII mode of transfer from SSH Tectia File transfer.

Ack! No idea why I decided you needed to separate out the truncate like that. As Ray notes, just the check is all you need. [sigh]

Really? Interesting... my apologies. I can see it being used for 'animated reports' but the requirement for the stages Stuart lists surprises me. Ah well. Perhaps Ernie can enlighten us.

No, that happens after the target connection is made before any rows are read from the source. If you need it to be conditional, you would need to check the input size - if zero, don't do anything as in no need to even run the job. Rows to load? Truncate the table as a separate step and then launch ...

Is this actually causing a problem? Those zeroes are not significant, hence me wondering. Since you've yet to mention it, what is your actual target?

splayer, there seems to be a bit of 'overthink' going on here with the explanations posted being a bit overly complicated in my mind. I would imagine you already have the delimiter and quote properties set properly so the only task seemingly left to do is (as noted) strip out the unwanted comma. Yes...