DSXchange

Hi all,

Can anybody suggest me how schema file is used to import meta data.

okay thanks for your valuable suggestions.

I want to use DSSendMail as a post job routine. I am unable to figure out how to give the parameters for the DSSendMail job. Is there a syntax? I am copying the DsDirector report for a run: JenaTest..AfterJob (DSSendMail): Parameter 1 (''smtp.abcd.com','subrata.jena@abc.com','rana.sinharay@abc.com',...

okay

I think I have to build one routine n I have to place this in after job sub routine stage.
Can you explain in diferent steps what the routine will do in this scenario.

Please reply

okay

yes I have few records in the table.
My requirement is to develop the job using parallel extender nt server.
If I have to use dssend mail routine activity for this please be specific that what the routine will do in this case.

please suggest.....

okay. but there are several options avaliable in job properties like 1-general 2-parallel 3-compiler 4-operator specific 5-reporting so please be specific how I have to add the enviornment variable. I am using recent 7.5x ds version parallel job in unix platform. Another thing can reffer these varia...

okay I got the idea. yes I am using the recent 7.5 version. but my source is not flat file its a relational database. so please let me know start loop and end loop will work or not in this case. supplier email id I can get by joing with another table. I am representing my design idea and an issue re...

Hi,

Actually I want to assign some values to the enviornment variables from a particular job during run time and I want to refer these values in the sequence job.
please let me know whether it will work or not.

Hi , Actually I want to send two mails for each record(for each supplier). For example sname,flag1,flag2 -------------------- a,1,0 b,0,1 ============ for these two records I have to send 4 mails to 2 suppliers like to supplier a I have to send two mails,and to supplier b I have to send two mails me...

Hi All,

Can any body will suggest me ow to add enviornment variable in datastage parallel job.

Hi All, please give me solution regarding this. From the following data I have to send e mail supplier,flag1,flag2 a,1,0 b,0,1 my reqierment if flag1=1 then send email to supplier a that the flag1=1 if flag1=0 then send email to supplier a that flag1=0 same for flag2 for this definitely I have to pe...

Thanks for the Ray, much appreciated.

Cheers

Hi All, Managed to get around this by joining the datasets into a complex flat file, then loading the CFF to a sequential file, at which point it is readable in a Server job. Still perplexed by the original problem, but am happy with a work-around, so onwards and upwards.. Thanks again to anyone tha...

Hello again all, I have been through the job with a fine toothed comb and cannot for the life of me work out why there is "{prefix=2}" after the fields in the OSH. This to me seems likely to be the problem - or at least indicative of the problem. Can anyone advise me please as to where thi...

Thanks for that, I shall check it out.

Incidentally, out of the following columns, the first outputs ok, the second doesn't:

Int_18266_M9Q:string[max=35];
Int_05350_N0Q:string[max=35] {prefix=2};

This is from the OSH. Could you tell me where the prefix=2 is defined please?

Thanks