Search found 6 matches

by santhooosh.c
Thu May 07, 2009 7:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Preserve Partitioning option when using multiple stages
Replies: 6
Views: 4033

It's a good question, naive or not. The answer is no. Therefore you are going to wear the warning, and might choose to incorporate a message handler to demote it. ... You could choose to use copy stage in between Transformer and other stages Change your partition type in copy stage between Transfor...
by santhooosh.c
Sat Mar 21, 2009 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Incrementing values in datastage going wrong
Replies: 13
Views: 12211

Re: Incrementing values in datastage going wrong

Pls, Try 1: change the Execution Mode to "Sequential" in Transformer Try 2: change the Execution Mode to "Sequential" in Transformer change the prev stage Execution Mode to "Sequential" Try 3: If above is not working, have a sort stage before your Transformer stage. Set...
by santhooosh.c
Tue Aug 12, 2008 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORACLE ENTERPRISE UPDATE-POOR PERFORMANCE
Replies: 3
Views: 1833

Thanks for the Prompt Reply Ray :o

Yes, Key column has been indexed.
by santhooosh.c
Tue Aug 12, 2008 1:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORACLE ENTERPRISE UPDATE-POOR PERFORMANCE
Replies: 3
Views: 1833

ORACLE ENTERPRISE UPDATE-POOR PERFORMANCE

Could Someone assist me on this issue. My system Details: DataStage server 7.5.3 OS:Solaris Oracle 10g My Issue: I have four primary keys, datatype of one is varchar2 others are numeric in my table, Table has been indexed When i go for insert using the Oracle enterprise stage. i am able to get perfo...
by santhooosh.c
Wed Jun 18, 2008 3:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implicit conversion from source type "int32" to re
Replies: 2
Views: 4179

Implicit conversion from source type "int32" to re

Hi Buddies,

help me to get out the warning

Implicit conversion from source type "int32" to result type "string[max=6]": Converting number to string.

trying to convert int (2) to varchar(6), in modify stage, not able to find suitable function name
by santhooosh.c
Thu Mar 13, 2008 4:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how to "YYYY-MM-DD HH:MM:SS" add ########## second
Replies: 2
Views: 1826

This one should be helping you

Input 1: '1435668237'
Input 2: '1970-01-01 09:00:00'

Oconv(Iconv(Input2(1,10),'D-YMD[4,2,2]') + MeasureTimeSecondsToDays(Input1)),'D/YMD[4,2,2]')