DSXchange

Don't trust what View Data shows you in regard to "un-American" characters. Use a viewer that can display the Euro symbol, accented characters, etc. properly.

Ask yourself this question - is there any way that a Copy stage can change data? (Dropping columns and renaming columns are not changing data.)

None of which is available in version 7.

Have you tried invoking help with the stage open?

Every If needs a Then (as well as an Else) in DataStage expressions.

kamtammystuff wrote: U can use the same logic ...

... but do you think U (one of our posters) would actually need to?

The second person personal pronoun in English is spelled "you", not "u".

This information is available in the DS_AUDIT table.

Open its properties in the Repository (Stage Types branch) for a definitive answer.

Use stage variables (and maybe a Sort stage generating key change column sorting on id and division). Increment counter if no change, reset counter if there is a change.

... experienced eyeballs, maybe.

The fact that it's an "import" error means that the file is being read.

What is the actual command output? From the error message, it would appear that the line "29-1" appears in it.

If all the standard values are single character, you can use a Convert() function on the final character. For example:

Even though NLS is installed, you can disable it by setting NLSMODE to 0 in the uvconfig file (and running uvregen, etc.)

Welcome aboard. We do not do "as soon as possible" or "urgent". Typically you pay an official support provider for that. We prefer to receive specific questions, such as the one in your subject. DSXchange is an all-volunteer site, whose members post as and when they can. The shor...