DSXchange

Thanks a lot for the reply. I was using DSLOGFATAL to abort the job in a assumption that it will aborts the job and control pass to exception handler. Now i removed the DSlogfatal and retuned 1 if validation fails.This pass the control to the exception handler and the sequence finished in restartabl...

Hello, I have a sequence designed as below: Job Activity -> Routing Activity -> Job Activity Exception handler -> notification activity. Option "Automatically handle activities that fails" is enabled. Routine calls "DSLogFatal" if any validation fails. This abort the sequence, bu...

Logic for Routine we wrote is:

1)Take the condtion(A<100 and A>1) and amnt as input parameter.
2)expr = Ereplace(condtion,field,amnt)
3)If expr then Ans=true else Ans=false

But the routine didn't return result as expected.

The 3rd stmt is not working.

Please advise me on this.

Thanks,
Shyju

what i understood is
take the amount and condtion as input parameter..
then do the validaion as return the boolean to the calling job.

How do we validate the amount with a condtion created at run time?


Thanks for you response.
Shyju

I apologise for that.

Hi All, we have a req to validate an input file with following format amount condtion 100 (amount>=0 and amount<=300) 200 (amount>=5 and amount<=800) 300 (amount>=0 and amount<=300) As the above as input source file, we need to validate the amount(field1) based on the condtion(field2). Please help m...

Hi All,

Can we call a SYBASE stored procedure from DataStage using ODBC stage.

Thanks in advance
Shyju

Thank you very much Craig

Thanks Craig

Hi All

Can we install two datastage clients(7.5.1 & 7.5.2) in the same machine or will it be upgraded with the latest version ?

Thanking you in advance
Shyju[/b]

Hi All,

Can anyone of you tell me the new features introduced in Datastage7.5.2?

And what are the new pluggins added in DS 7.5.2?

Thanking you in advance,
Shyju[/b]

Thanx Ray...

Hi All,
I would like to know what is the internal database used by DataStage Server.

Cheers,
Shyju

Hi All, I created a job where I have to call a stored procedure from Oracle 10g database using Oracle 8i stage. The result of the stored procedure is stored in two tables A and B. In the Oracle 8i stage, I call the stored procedure under sql -> before and then under Query, select few columns from ta...

Hi All,
Can we export a whole project from manager and at the same time export again whole project from the manager by opening another session? Will it currupt any job since the export is done twice on the same project and at the same time?

Cheers,
Shyju.