DSXchange

What is "ur help"?

Ur was a city in ancient Babylonia. The second person personal pronoun in English is spelled "you" or, in possessive case, "your".

Overkill. All you need to trim is the @FM character.

Your problem, it seems to me, is the CHAR() functions in your WRITESEQ statement. WRITESEQ itself adds a line terminator - that's why you're getting two lines. All you need is

Probably the best solution is for you to create a DataStage job to effect the transformation that you have partially specified. Even better would be to write out a complete set of mappings first.

Welcome aboard.

Have you configured Engine credentials?

First tell us what YOU have tried.

We're not in the business of handing out solutions on a silver platter.

We're happy to help with problems.

(Actually some of us ARE in the business of handing out solutions, but that's only in exchange for professional fees.)

samyamkrishna wrote:

ray.wurlod wrote:And the error message ID ? ...

There is no error message id in the warning.

or where will i find it?

Thanks,
Samyam

Double click to view the Detail of the log event.

Please clarify what you mean by "running 8 jobs parallely". To me it suggests no dependencies between the eight jobs, which means that I'd expect any that did not abort to run to completion (given that they only run for a short time - they finish before the Terminator can send stop signals).

That's fine, but it does not give you any rollback capabilities on the set of tables. You have to design another job to "undo" committed transactions on the other tables.

Is the InsertRec column explicitly mapped from input to output in the stage?

I don't believe that there's any stage that can handle the metadata mismatch between DATETIME and DATE. In addition to what SURA suggests you could, of course, use an extraction function in your SELECT statement to return just the date portion, cast as DATE if required. Or you could follow your idea...

Distributed Transaction Stage, once they enable it for use with Teradata.

Until then it has to be "roll your own" back!

Thanks, Stuart, I did find that (from the Information Center). As noted, I don't have a copy at the moment - will be installing it probably next week. Note, however, that the required role is Administrator - configuration of viewing permissions is not available to Author role. I was unable to find a...

I don't know the answer to that but would like to add a supplementary question (I don't have a copy of BG to play with at the moment): is it possible to make different Categories (folders) visible to some users and not to others? That is, does BG have an inherent security model other than Informatio...

You should be able to use that for the Windows server as well. Look at the dsjob command for the requirements for running a job on a remote server.