DSXchange

The Sequential File stage DOES have a First Line is Column Names property. It's on the Stage tab. Look again.

Posting this question on a Teradata forum might be more fruitful, or looking in your Teradata manuals/help files.

Please advise where to find the "Incomplete Column" property in a parallel job's Sequential File stage.

The warning messages about licence expiry start five days prior to the expiry date on your licence. On 10/10 your DataStage will stop working, unless you obtain a licence with a later date and update the licensing information prior to then.

Please describe the job design; in particular what stage type is upstream of your Oracle stage, and what is the data type of the column in question in that stage? I ask to find out whether the conversion mentioned in the message is occurring within your job design, which I suspect, or in Oracle itse...

Use file systems with more space available.

For less than $1/week you can buy the right to read premium posts.

When setting environment variable values, there is no space either side of the "=" operator. Therefore you needed

The Column Generator stage has the limitations that Arnd suggests. You need a different stage type downstream (probably a Transformer stage) to insert the current time value.

The Hawk version (except for TX) has not been released. How would anyone have any release notes, then?

Welcome aboard. :D

You seem to have answered a different question, namely whether the final character of a string (ignoring white space) is a hyphen.

That is not the question that was asked.

That's when you'd need intermediate files. Hopefully "they" have fixed that in the next ("Hawk") release.

You've still missed the point. The OP required detection of non-alphanumerics, not non-numerics.

The split command is incapable of changing the file's format if you split on lines. What - precisely - did you do?

Is the "First Line is Column Names" property set to True? This does need to be explicitly set - it does not import with the other format information, because it is a stage property whereas the other format information form link properties. I suspect that this is the problem because the error is repo...

This has already been answered in the forum, so sending private emails or private messages is simply an annoyance. Please read this post.