DSXchange

Check if the below link helps

viewtopic.php?t=98926

Thanks for the information.

Never know that we can do that in DataStage...

The issue is resolved now.

there is an extra orphan word sneaked into the email to list.
We have removed that word and the sequence is running fine now

Regards

I am getting the below error. This is working in dev region but is not working in another region. The SMTP server used here is working fine for other jobs. Please guide -------------------------------------- ##..JobControl (DSSendMail): Error when executing command: Project/sendmail_##.sh *** No out...

Probably , your peers might have used the Null field value property to populate "NULL" for null values.

palak08 wrote:So if I send email in case of failure then master sequence will never show as aborted. In that case I will not have restartability feature for this sequence.

Yes , I think restartability will work only if a sequnce aborts not in other cases

Or unhandle the child sequence abort by removing the failure email, thus your master sequence will get aborted whenever your child sequence aborts

As per your code the master sequence will not be aboeted since you are handling the abort of inner sequence in form of a email.
If you check the Log Warnings check box in master sequence , you will get a warining message whenever your inner sequence si finished with status other than ok.

A search with "Controller problem" will return lot of useful informtion to you .Try it.

Thanks
major

got it

Thanks Chulett and narasimha.

Hi, I have a .sql file say Query.sql file , it contains a series of sql queries which include cursors , looping etc. I need to run this Query.sql file from datastage. Currently i am storing it in Unix and using the below command in before job subroutine to invoke it from a dummy job. sqlplus USER_NA...

Thanks its working fine.

Just want to share we should not put ; at last statement

Hi all,

I just wanted to know whether we can write multiple sql statements in before/after sql in Oracle OCI stage.

when i try wiht multiple queries it shows an error 'sql statement not properly ended'

Thansk,

Thanks Guys,

Using STP stage as 'transform' solved my problem :D

Any suggestions please....