DSXchange

Thanks Teej for the excellent lines that you wrote!!! """""""""""""""""""""""""""""""""""""""""...

Thanks DSGuru2B, somehow i was sure that i can use it in Server Edition.
I'll use ICONV/OCONV

Job configuration: SeqFile->Transf->SeqFile DSLink6.stdate is "Varchar(6)" in input-tab and "Date" in output-tab of Transformer In Transformer i defined variable "v_stdate" as StringToDate(Trim(DSLink6.stdate),"%yy-%mm-%dd") to be mapped to output "Date&q...

Just to make it more clear. Use the following job architecture: job1-(trgOK)>job2-(trgOK)>job3-(trgOK)>job4-(trgOK)>job5 |(trgFail) |F |F |F |F ------------------------------------------------------------------ sequencer | terminator As for resuming reprocess from the 3rd job, just make it //Add che...

Thank you Ray!

I tried to use this answer to get going on: DS 7.5.1 Parallel Job Unix Solaris I need to find out the status of my JobMonApp. If i do : ps -ef | grep `cat $APT_ORCHHOME/java/.jobmonpid` | grep -v 'grep' I'm getting the error: "cat: cannot open /java/.jobmonpid" I know it happens, b. $APT_O...

Thank you guys for very professional and informative discussion of
this topic.
I've learned lots new stuff.

Create one more Seq that will call your existing Seq and
in this new Seq do what you want: call jobs, another
Seqs, scripts, check Seqs Status, etc.

Would IT help?

we can do the following:
- create OS script to call your main sequence;
- in this OS script we need to read 'Job status' from
DS log-file after your main sequence finishes.
- from those OS script we send message about
status that we have just read to TIVOLI

Tell me if it helps?

I believe you are doing the right thing in a right place,
but try to play with different Code Pages.
Anything else, sorry i don't know.

More details,
does it make any sense, that this type of error
could come up because the Oracle installation was done
from user=OracleUser(NOT from Administrator), but
DS Server was installed from Windows Administrator???

Any ideas?

This is a message after the reset: From previous run DataStage Job 98 Phantom 5020 Program "JOB.1427108223.DT.1437338697.TRANS1": Line 43, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7 Program &quo...

We added a [Transformer] and the error changed to : "Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7" According to my observation, i think the problem with [Oracle]-stage, but don't know what is wrong with it? We used [Oracle OCI] stage everytime, and i...

Go to DS Administrator -> Projects ("select your project1") -> NLS
and change a mapping only for "your project1".
It won't affect the others.

This is from DS manual: "DataStage uses special maps for client server communication, with names ending in "-CS" (for "client server")". One of those "-CS" mapping should be used for client/server communication. Mapping should be changed on a server, NOT a cli...