DSXchange

This conversion can be done automatically in DataStage if you have NLS installed, just declare your input as LATIN1 and the output as UTF8

This conversion can be done automatically in DataStage if you have NLS installed, just declare your input as LATIN1 and the output as UTF8

That's a pretty conclusive error message; it would seem that the Teradata API does not support reject links at V7. In that case I am certain that somewhere in the stage itself is an option to redirect rejects to some file. Have you checked the documentation for the options?

That is a good sign, it means you aren't adding a reject link, just an output link. You need to attach an input link first, then you can right-mouse-click-and-drag a reject output link.

No, that won't really work in DataStage but will work in Excel. Dates are stored as integers, not real numbers.

If the UNIX login is working but the DataStage one isn't I would look and check all of the IIS settings as that is the likely source of the problem.

Does that mean you get an error message when you draw a link coming out of the Teradata stage, or later when you compile? All of the other database stages support that type of reject, so I really would expect that Teradata does as well.

Do you have other users defined who you can check access to DataStage with? Also, have you gone into iis admin to see if the security settings and roles are unchanged from yesterday's settings?

No need to use it in the stage, just set the parameter value correctly at runtime.

can you login to your server with that userid/password combination using TELNET or whatever tool you prefer (i.e. putty)?

It is considered bad taste to post the same question twice in short order - please use your thread here

Go into the Parameters tab of your job in the designer and click on the "Add Environment Parameter" button to get the list. If it is not in the standard list, then you would need to add it for that project using the DataStage Administrator client.

My first thought is that you didn't run the jobs that you thought you had run. What happens if you start one of these jobs manually from the director - does the status change and the log entries show up?

Put a reject link coming out of the Teradata stage. I just tried it (at V8) but am fairly certain that functionality exists at V7.

The Server "@FM" is the equivalent of CHAR(254)