DSXchange

Did you read the log entries?

Clearly there's a permission/authorisation issue invoking the Logging Admin Service. Does your user have a (the?) Information Server Suite Administrator role?

Not really. Replace your Teradata stage with a Sequential File stage then examine the records that have these characters. Alternatively create a reject link from your Teradata Connector stage and examine the records sent along that link (into a sequential file).

Welcome aboard.

They're probably not white spaces but something else. Dump them into a text file then use a hex editor/viewer to determine what they actually are.

Try specifying as LongVarChar.

My guess is permissions on the RT_SCTEMP directory.

Why not tell us (in English) what you're trying to achieve? Some information about actual and expected results would also aid us to help you. What you have given does not.

Yes it's possible.

The server, if scaled for version 7, will not be adequate for version 8 (by a long way).

The version 7 installation will have to be switched to using a different itag, since version 8.1 mandates used of the default itag.

Press F1 while you're on that Administrator client screen. That will also tell you which manual the information is in.

As an example, you may have designed a database using ERwin, which is not a part of DataStage. A metabroker exists, however, that can read an ER1 (or XML) file produced by ERwin and import the table information into the repository.

Is the FTP password provided in the BAT file without redirection?

You can add it there. Its existence is sufficient cue for the engine.

And your problem is... ?

How have you tested this stored procedure?

(Craig thinks in URLs.)

"Terminated unexpectedly" can mean that someone or something has killed a process or a network connection.

No.

Not in DataStage, not in Oracle (for VARCHAR2 data type).