DSXchange

I have the below job sequence : Execution action - Reset if required, then run JobA | rtn1 |(returnvalue=0) JobB | rtn2(returnvalue=0) --- Terminator |(returnvalue!=0) JobC When the sequence fails (after I forcefully abort), I would want it to re-start from JobB. I have checkpoints ON. But since Job...

Thanks a lot Rich & Gateleys.
I tried the second one & it worked perfect...

Hi All, I have a requirement where based on tgt table rowcount in a job, I have to branch my sequencer flow. Please let me know if there is a way to acheive this from Sequencers. JobA -> JobB (if tgtrows of JobA=0) -> JobD (if tgtrows of JobB=1) -> JobE, etc... -> Jobc (if tgtrows of JobA=1) After J...

It didnt work either. I did go through other threads on this discussion & tried Varchar(20000+) with To_Char. This works in a very random fashion. It succeeds during few runs & fails during the rest. I have no clue on what basis this is happening. Finally I have decided to go for a SQL scrip...

Hi Two fields in my source Oracle table are of CLOB datatype. When I import this table into Datastage it gets converted to Longvarchar. This job is a direct load into target table. When I run the same it gives me the following error: -- ORA-24801: illegal parameter value in OCI lob function. I tried...

I did give a valid SMTP Server address.
CTSINTCOSXUB.cts.com

x.y.com was just an example.

Thanks
Preethi

When I try sending a mail from a sequencer job , I get the follwoing error: ---------------------------------------------------------------------------------- Email_Notification..JobControl (DSSendMail): Error when executing command: D:\Ascential\DataStage\Projects\UFL_Test\sendmail_Email_Notificati...

Hi Tom
I do have read/write/select access to the repository.

Preethi

Hi All I am new to Metastage and I am facing few problems while attaching to the directory. I created a new directory (PF880ETL) through Directory Administrator, but when I try to connect to it through Metastage Explorer,it gives the following error. -------------------------------------------------...