DSXchange

If you do use them, make sure you write back to the locked records in the same transformer. I once found one job that locked records in one tranny and then updated the hash in a downstream tranny. Running it with any volume blew out the lock table. As Ken notes, I also don't use this option. However...

Why not let us know what the 'issues' are that you are having?

Is this your first time trying to use any Oracle stage in DataStage?

RTI is 'Real Time Integration' and was renamed to the 'SOA Edition' some time back, but the stages still retain the RTI name. At least in 7.x, in 8.x it is now known as 'WISD'.

Don't necessarily read 'Service Oriented Architecture' into SOA as I think they really mean 'soa'... as in these in my /tmp directory: $ ls -ld soa* drwx------ 2 dsuser dstage 96 Oct 9 2006 soa01727 drwx------ 2 dsuser dstage 96 Oct 20 2004 soa02581 drwx------ 2 dsuser dstage 96 Nov 8 17:26 soa02584...

You'd need to write your own custom routine using DSExecute - an interlude to your mail client of choice - mailx, for example. Then you'd have full control over all of the components. Have you tried doing this for the email addresses yet? I ask because your attempt to affect the SMTP server may be '...

You should find that these are 'temporary' files generated by the Sort stage. They end up in the Project when 'Temporary Directory' property of the stage is left empty. I always redirect that to someplace else - like "/tmp" on UNIX - so they get cleaned up automagically.

No, it means you don't want any quote character used. Check the help or try to leave the field empty.

Well, then it's not a new line. If you get the actual decimal value, then you can do as I suggested. However, if it is always just the last character in the field, then your substring is perfectly valid as well.

Nothing is wrong. Quotes are normal for string data in sequential file data and should not be causing problems in your 'downstream' processing. The data viewer doesn't show them to you because they are delimiters, not part of the data. If for some reason you really don't want them in the file, chang...

Your 'Master Sequence' must abort to trigger the restartability. You need to make sure that happens, either using the 'Automatically handle' option or specific triggers and stages.

sree569 also wrote:Thanks for your reply,but i can see only DSJobStartTimestamp for start date but i didnot find any for endtimestamp

Check again. The online help for DSGetJobInfo lists the correct InfoType for this, the equivalent should exist from the command line as well.

Not sure how much more clear I can be. LF = 'Line Feed' = hex a = decimal 10 = 'new line'. If that's what your character is, then what was posted should work. If it isn't, then you'll need to post something more specific than it being 'some unusual character'. Read the online help for the CHAR() fun...

System Variables can be used anywhere, any time. Check the online help, they are good things to get to know.