DSXchange

Thanks Chulett for your reply.

Job is in multiinstance which is called multiple times in nonmultiinstance
sequence job.

The same job is working fine in DEV and QA but failing in preprod.

Is this has anything to do with complier options.Thanks.

Hi, I have one datastage job which is called multiple times in same sequence to load different datasets to the same table. The sequence is getting aborted in the any of the jobactivity with the following status EDMInsDSErrorLog.REJ_LKP_PACE_BOS_ERRMSG has finished, status = 99 (Not running) This is ...

Thanks for your Great Advice but not an Efficient one!

We figured out a solution in PX..
using Trim(Convert('XX','',ARG),',','R')

Thanks,
NV

Yes I know..
But this is a PX job as reflected in the Job Type in the Post header

Hi, I am trying to replace all the characters 'XX,' to '' (Empty) using the Convert function..As I underatand it replaces each character seperately and hence my output is not as expected. I want to change "XX,XX,XX,6,XX,7" to "6,7" Any other way to replace this entire set in one ...

I want to capture from Primary dataset(INPUT).

Hi chulett, I could resolve this issue after changing dssendmail_template.txt Removed -i option in sendmail #! /bin/sh /usr/sbin/sendmail -t -i<<//// changed to #! /bin/sh /usr/sbin/sendmail -t <<//// i have got one more question regarding multiple file attachments.I can send email with single attac...

Thanks for you help chulett.I will test this and post the results.

Hi chulett, Thanks for you reply. I went to sysadmins,but they couldn't figure it out. I tried sendmail outside datastage. sendmail -t sherin.mathew@pioneerinvestments.com sherin.mathew@pioneerinvestments.com "HI" testing EOT I am getting below message. /export/home/smathew/dead.letter... ...

Thanks chulett for your reply Please find the output generated. *** Output from command was: *** #! /bin/sh cat sendmail_*.sh /usr/sbin/sendmail -t -i<<//// From: sherin.mathew@pioneerinvestments.com To: sherin.mathew@pioneerinvestments.com Subject: Reject files from FX Rate Interfaces. Server: bosw...

Thanks chulet for your reply.

I couldn't find the .sh file in the mentioned path.I think it gets deleted after the excecution.

Could you please let me know any ways to capture this file contents.

Thanks
snt_ds

Hi, Thanks for the reply chulett I am hardcoding servername,from and to address.Getting the message like below and mail is not sending Executed command: /ETL_PROJECTS/SMM/sendmail_S_EDMFxInterface_151423_27682.sh *** Output from command was: *** No recipient addresses found in header If anyone faced...

Hi Dsxians, I am trying to send email using notification activity stage where i am getting a message as below and email not being sent *** Output from command was: *** No recipient addresses found in header I had given all the parameters of this stage.smtpservername,fromaddress,toaddress,subject etc...

Thanks chulett for the reply. Yes. A string with value of "NULL".If source file column is empty or NULL value then i am replacing with "NULL" string.Datatype is varchar. IF IsNull(ACTION_SRC_1_PositionDataFromPAM.BOOK_VALUE) Then 'NULL' Else if Trim(ACTION_SRC_1_PositionDataFromP...

Hi Dsxians, I am experiencing a strange problem in transformer stage for some columns and for some datastage jobs alone ,when i am trying to replace a 'NULL' string from source with setnull() function for a target decimal column 28,12.Derivation is below. If Trim(ACTION_SRC_3_PAMPositionAfterExchang...