DSXchange

Wave is new feature in 8.00 and hence all jobs need to be wave aware :? You do realize how singularly unhelpful posting something like this without any explanation is, yes? The only way posted this would help would be if you also included a description of what a "wave" is and some clue ho...

True... it looks like some flavor of an assertion error but didn't explicitly say so.

Right, any defined there are only instantiated when a job runs. Log into your server and issue the SET command to get a list of all of the variables you can 'Test' for.

True... but this actually is one where they mentioned the fact that they installed the compiler, hence my comment.

OK... any chance you searched the forums before posting? The messages you've bolded have been seen here many times.

You don't use @INROWNUM as the actual sequence number but rather the offset from a starting point. That starting point is passed in as a job parameter and is the maximum value currently in use in your target that you look up before the job starts. Then simply add @INROWNUM to that job parameter.

Is that a question or a statement?

Yup, that's practically always the case with these kind of posts.

That is why you have a DBA supporting you, ask them. Or wait for someone here who may know Teradata to stumble across this post. I, for one, do not.

anu123 wrote:ERROR: Cannot find any process numbers for stages in job 'Job Name'

You got this when in Cleanup Resources? If it was right when it started, it can be ignored - continue on, switch it to all processes and find your culprit.

Did you try searching for "Some users will not have access to this schema"? I got several matches, including resolved ones.

Probably, but you've have to give us a clue what 'environment variable' you are testing for first.

Not strange at all.

Any routine that is reference by a transform is trumped by that transform's definition and thus only shows up in that list. You'll need to check under the 'DS Transforms' link instead when trying to use it in a job.

So... planning on backing up from now on?

Probably best to post it plus ~10 lines on either side, wrapped in code tags.