Search found 65 matches

by panchusrao2656
Sun Sep 25, 2005 1:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: spilt the record into three records
Replies: 13
Views: 19111

i put three out put streams from the copy stage and changed the column names in the output and then i used a funnel at the end as each stream has the same columns.

Once agin thank you for your views.

Rao
by panchusrao2656
Sun Sep 25, 2005 12:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reg. trim function in modify and type conversion
Replies: 1
Views: 1097

reg. trim function in modify and type conversion

can i use trim function in modify stage? 1.I need to trim a string(Varchar) of length 50 to string(Varchar) of ength 12. i am using modify stage for other conversions. So I cannot use another stage for that.Is there any way i can trim it and escape from the warnings. And the other one is: 2.I am get...
by panchusrao2656
Mon Sep 19, 2005 11:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: spilt the record into three records
Replies: 13
Views: 19111

thank you for your ideas.i solved that with a copy stage ,3 output links and one funnel stage.
by panchusrao2656
Sat Sep 17, 2005 4:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: spilt the record into three records
Replies: 13
Views: 19111

spilt the record into three records

i have a record with 4 columns key,A,B,C.I want to split the record into three records with the columns as key,type. SOURCE: key A B C 01 2 3 4 Target: key TYPE VAL 01 A 2 01 B 3 01 C 4 IS THERE ANY SHORT CUT WITH OUT USING ONE COPY STAGE, THREE MODIFY STAGES AND ONE FUNNEL. THANKS IN ADVANCE RAO