DSXchange

Operator.

Welcome aboard. How do you define "performance"? What's wrong with 0.012 seconds? How many rows were selected?

"Some long error message" is singularly unhelpful. Please post the actual error message.

IBM offers a class called "DataStage Administration". It is geared entirely to parallel jobs, and does not cover administering the engine very much at all.

My class - while designed for the server environment - does have good coverage of administering the engine.

Each is chargeable.

If the delimiter is "|" then you need to specify the Field Delimiter as "|". You possibly also need to specify the Final Delimiter as "End".

Do you have the Final Delimiter property set to "End"?

There is no such thing as int(2). You have an int32 with a display width of 2. The largest possible int32 has 11 characters. This will not fit in a string[6] and therefore DataStage generates this alert. You may have knowledge about your data that might allow you to use int16, where six characters i...

Yes, the control daemon referred to is a Teradata process.

There's a great tool called DataStage Manager that can do precisely what you require.

When you import table definitions through the ODBC driver for Excel, check the box captioned "System Tables". For reasons best known unto Microsoft, worksheet names are presented as system tables. There are also rules regarding the layout of the worksheet to enable it to be able to be accessed via O...

Your output file is the same as your input file - a bad thing, because it destroys (or would destroy) your input file. Use a different output file name.

And get some training!

Do you have any ODBC data source names defined?

No.

If something is missing, and you have specified the correct directory, then only a new copy that has the required component can solve your problem.

Just make sure you have the correct directory. Try the parent of I386.

Learn to post in the correct forum and learn to spell.

All components in the Repository are re-usable. You can use them as many times as you need to. You can also create new objects, such as shared containers, table definitions, to use over and over again. Reprocessing logic has to be designed with site-specific requirements in mind. Under what circumst...