DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 43 matches
Author Message
 Topic: Propagating Column Length in Next Stages
syedmuhammedmehdi

Replies: 3
Views: 435

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Mar 20, 2018 10:15 am   Subject: Propagating Column Length in Next Stages
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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 attrib ...
Resolved
 Topic: Html Email by Dssendmail Routine
syedmuhammedmehdi

Replies: 7
Views: 820

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: 820

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: 820

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: 820

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: 1255

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: 1255

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: 1255

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: 1255

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: 1255

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: 1453

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: 1453

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: 1453

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: 1453

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: 942

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 ...
 

 Jump to:   



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