DSXchange

Hi,

My DS job is loading to Netezza and it may or may not create a .nzbad file.
I wanted to attach this .nzbad file to email as attachment. Also there is no specific name for this file as it creates name dynamically.

NZCC_2012051411124910_25696_0.CDW_ETLPOC.nzbad

So In attachment option I have given below string:

/tmp/DS_Log_Bad_Files/*.CDW_ETLPOC.nzbad

But even if file is present, DS job says that :

Seq_Load_CBActives_Test_1..JobControl (DSSendMail): Cannot open attachment file '/tmp/DS_Log_Bad_Files/*.CDW_ETLPOC.nzbad'

File permissions:
-rw-r--r-- 1 dsadm dstage 14 May 14 12:41 NZCC_2012051411124910_25696_0.CDW_ETLPOC.nzbad

Please advice.
Thnaks,
Rashmi

Doesn't support wildcards. You'll either need to 'look it up' and then pass it as a parameter each run or write your own email routine that can handle wildcards for the attachment.

Thank you for your reply.

Can you please elaborate on writing email routine?

Thanks,
Rashmi