DSXchange

syedmuhammedmehdi

Hi, I need to change a column length and type in all stages till Target from Source stage. There are many stages in between. Could anyone please advise is there any shortcut to propagate column attributes in next stages till target stage?

syedmuhammedmehdi

I build header and body email file in datastage and then used command

cat email.txt | /usr/bin/sendmail -t -oi

and it worked.

syedmuhammedmehdi

It is UNIX. Yes, it is allowed by recipient 's email system. In plain text actually the issue is one code which is in proper alignment for one text type ex:- Calibri will necessarily will not be in proper alignment for all other types i.e. Arial, Times etc so I want to create it using html table wit...

syedmuhammedmehdi

thanks, Ok, I'm using below command from execute command stage but it is not converting tags into proper html format and just getting it as plain text, could you please advise what may be the issue with the below command? echo "<html><b>Hello</b></html>"| mail -s "$(echo -e "This...

syedmuhammedmehdi

Hi, I want to send automatic email from datastage sequence through dssendmail routine but i want to send html mail having a html table in body of email. Could you please advise can we sent html email thru dssendmail?

syedmuhammedmehdi

I'm not loading into the same table.

syedmuhammedmehdi

qt_ky

yes, it is exactly the same thing

syedmuhammedmehdi

Paul, yes, same stage properties

syedmuhammedmehdi

I removed oracle target and kept dataset in new job after split, will that not give same transform duration? Actually and also in my old job by monitoring link stats at run time the job was just working at load for 2:15 hrs thru. By using these two ways I determined that transform time was just 45 m...

syedmuhammedmehdi

Hi, I'm loading one Oracle table with around 19 million records. I was checking speed of the process by making changes in the job. My job had a fetch query and some sort stages, remove duplicates, joins, a transformer, a funnel and ultimately loads to an Oracle table. This job was taking around 3 hr...

syedmuhammedmehdi

ok, thanks all

syedmuhammedmehdi

v11.3

syedmuhammedmehdi

Yes, it is missing. Both Change and Ereplace are missing, it is really strange here

syedmuhammedmehdi

Hi, In my previous company we used to use Datastage v9 and v8.1 and in both of them our parallel job used to have function Ereplace but that in my current company we don't have Ereplace function instead of it being v11. Could you please advise what may be the reason and what can be done?

syedmuhammedmehdi

Thanks Chulett for reply.Actually, after some debugging I came to know that there was no slowness caused by bulk load but before Oracle Connector I was using transformer in which I was calling Oracle Sequencer for surrogate key generator which was actually causing slowness. So, I removed surrogate k...

DSXchange

Search found 43 matches

Propagating Column Length in Next Stages

Re: Html Email by Dssendmail Routine

Html Email by Dssendmail Routine

Datastage Loading in Oracle table Speed

Ereplace function Missing in Parallel Jobs