DSXchange

Nope.

OK, didn't look close enough at the SQL. Oracle won't automagically import that file data into your query for the subselect. You'll need to pass the entire "in list" in as a parameter.

Looks to me like you've set the Job Activity stage to validate the job rather than run it. Occurred: 10:11:50 AM On date: 8/3/2012 Type: Control Event: Validating Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2. (...) Occurred: 10:11:52 AM On date: 8/3/2012 Type: Control Event: Job xfmDSPHFRestriction_...

bobbysridhar wrote:I am not using parameter in file.

Yes, you are - hence my answer.
#Dir# is the parameter.

Simple answer... you cannot use parameters in a SQL file.

That question has been asked and answered here many times - yes.

Don't forget there are two repositories in play now. Best to get support involved. IMHO.

Can you post the log entries from the "no processing" run?

Yah, that too.

And stop using the Reply with quote link for no reason, use the Reply to topic link instead. Please.

Why not simply check the documentation rather than ask here? Connectivity Guide for Teradata Databases pdf, Chapter 2: Teradata connector, "Teradata connector properties" section.

The "never dimensioned" error means you spelled the routine name wrong or it has no idea what it is because you haven't included the appropriate header file that defines it. Case it important so change its name to DSGetParamInfo and make sure the appropriate INCLUDE statement is in your co...

OK. Thanks?

As noted, it doesn't matter what the job does - all the Reset does is allow it to be run again after it has aborted. A Restartable Sequence job has slightly different rules, you can restart it after an abort and it will pick up where it left off whereas you Reset it to force it to clear the checkpoi...

A Server job is a Server job, even if it runs in the Enterprise Edition or 8.anything... so don't worry about your "parallel environment" question. As to why it is aborting, first suggestion would be to do an exact search here for "Fault type is 11. Layer type is BASIC run machine.&qu...