DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 42 matches
Author Message
Resolved
 Topic: Html Email by Dssendmail Routine
syedmuhammedmehdi

Replies: 7
Views: 323

PostForum: General   Posted: Wed Nov 08, 2017 9:59 am   Subject: Re: Html Email by Dssendmail Routine
I build header and body email file in datastage and then used command

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

and it worked.
Resolved
 Topic: Html Email by Dssendmail Routine
syedmuhammedmehdi

Replies: 7
Views: 323

PostForum: General   Posted: Sun Nov 05, 2017 6:44 pm   Subject: Html Email by Dssendmail Routine
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 pr ...
Resolved
 Topic: Html Email by Dssendmail Routine
syedmuhammedmehdi

Replies: 7
Views: 323

PostForum: General   Posted: Sun Nov 05, 2017 12:20 am   Subject: Html Email by Dssendmail Routine
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 wi ...
Resolved
 Topic: Html Email by Dssendmail Routine
syedmuhammedmehdi

Replies: 7
Views: 323

PostForum: General   Posted: Fri Nov 03, 2017 11:00 am   Subject: Html Email by Dssendmail Routine
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 476

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 20, 2017 7:06 pm   Subject: Datastage Loading in Oracle table Speed
I'm not loading into the same table.
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 476

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 6:59 pm   Subject: Datastage Loading in Oracle table Speed
qt_ky

yes, it is exactly the same thing
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 476

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 6:50 pm   Subject: Datastage Loading in Oracle table Speed
Paul, yes, same stage properties
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 476

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 11:33 am   Subject: Datastage Loading in Oracle table Speed
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 worki ...
 Topic: Datastage Loading in Oracle table Speed
syedmuhammedmehdi

Replies: 8
Views: 476

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 9:52 am   Subject: Datastage Loading in Oracle table Speed
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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, ...
 Topic: Ereplace function Missing in Parallel Jobs
syedmuhammedmehdi

Replies: 9
Views: 540

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 9:33 am   Subject: Ereplace function Missing in Parallel Jobs
ok, thanks all
 Topic: Ereplace function Missing in Parallel Jobs
syedmuhammedmehdi

Replies: 9
Views: 540

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 10:18 am   Subject: Ereplace function Missing in Parallel Jobs
v11.3
 Topic: Ereplace function Missing in Parallel Jobs
syedmuhammedmehdi

Replies: 9
Views: 540

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 6:25 am   Subject: Ereplace function Missing in Parallel Jobs
Yes, it is missing. Both Change and Ereplace are missing, it is really strange here Sad
 Topic: Ereplace function Missing in Parallel Jobs
syedmuhammedmehdi

Replies: 9
Views: 540

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Oct 13, 2017 8:59 am   Subject: Ereplace function Missing in Parallel Jobs
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 inste ...
Resolved
 Topic: Oracle Connector - Oracle Bulk Load vs Insert
syedmuhammedmehdi

Replies: 2
Views: 465

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 09, 2017 9:33 am   Subject: Oracle Connector - Oracle Bulk Load vs Insert
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 ...
Resolved
 Topic: Oracle Connector - Oracle Bulk Load vs Insert
syedmuhammedmehdi

Replies: 2
Views: 465

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 25, 2017 9:00 am   Subject: Oracle Connector - Oracle Bulk Load vs Insert
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi, I'm loading 21 million records in a Oracle table and it is taking around 1 hr 30 Minutes to load using Oracle Connector. I used Bulk Load as well as Insert Mode in Oracle. Surprisingly, in both mo ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours