Search found 127 matches

by Sunshine2323
Fri Apr 14, 2006 5:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting One Record to Many
Replies: 10
Views: 5250

vijayrc wrote:Is this a Parallel job Stage ??
Yes
by Sunshine2323
Thu Apr 13, 2006 8:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting One Record to Many
Replies: 10
Views: 5250

As suggested PIVOT stage can get you your required output.
by Sunshine2323
Wed Apr 05, 2006 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting Datatype From Hashed File
Replies: 11
Views: 5825

Hi Anand,

Can you please explain the logic behind checking the datatype?
Can't you make a comparison for '-' or 0, why do you also need to check the datatype?
by Sunshine2323
Wed Apr 05, 2006 2:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to create sequence number per ID?
Replies: 4
Views: 2889

Hi bharathappriyan,

Declaring a stage variable

StgCounter=if RowProcCompareWithPreviousValue(Input.ID) then StgCounter+1 else 1
by Sunshine2323
Tue Apr 04, 2006 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vertical pivot
Replies: 15
Views: 7755

Hi, Sorry, there was an error in writing the stage variable names Here is the right way, StageVar=DSLink3.No StageVar2=StageVar<> StageVar1 StageVar1=StageVar StageVar5=DSLink3.Type:',':DSLink3.Name1:',': DSLink3.Name2 StageVar4=IF StageVar2=1 then DSLink3.No:',': StageVar5 else Trim(StageVar4):',':...
by Sunshine2323
Sun Apr 02, 2006 12:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Insert and update a table
Replies: 1
Views: 1794

Hi Archana,

Check This Post

Also what is your target?
by Sunshine2323
Tue Mar 28, 2006 3:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Searching a string in a set of strings
Replies: 5
Views: 3231

if (index(Arg1,'ELEC',1)+ index(Arg1,'GAS',1)+index(Arg1,'CONS',1))>0 then 1 else 0
by Sunshine2323
Sun Mar 19, 2006 11:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: add/minus months function
Replies: 11
Views: 5980

Can be done using OCONV, ICONV

Check this post
by Sunshine2323
Thu Mar 16, 2006 12:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vertical pivot
Replies: 28
Views: 15406

Hi Smita, Job Design: Input----->Transformer---->Remove Duplicate----->Output Declare stage variables as follows: StageVar =DSLink3.No StageVar2 =StageVar<> StageVar1 StageVar1 =StageVar StageVar5 =DSLink3.Type:',':DSLink3.Name1:',': DSLink3.Name2 StageVar4 =IF StageVar2=1 then DSLink3.No:',': Stage...
by Sunshine2323
Wed Mar 15, 2006 12:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: vertical pivot
Replies: 28
Views: 15406

Hi Smita,

Can be easily be done using stage variables.
You can search the forum and find how to implement this using stage variables.
In case you do not find it I will post it by tomorrow morning.
by Sunshine2323
Tue Mar 14, 2006 1:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Lookup in a comma delimited file
Replies: 6
Views: 3087

Hi narshimha, If I understand your requirement correctly then You want to look up these numbers against a database table column and if any of these numbers are present in the column then reject the row. As suggested, you can pivot the data in the sequential file to get it in this format 123 432 623 ...
by Sunshine2323
Tue Mar 14, 2006 12:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: intermediate result set required from a recordset
Replies: 19
Views: 8898

Hi Naren, Only change in the routine is Ans=Arg1 in the Else part of the 2nd IF statement DEFFUN ReadRec(X) Calling "DSU.ReadRec" COMMON /ReadRec/Initialized, HASH_RECURSIVE If Not(Initialized) Then Gosub OpenHashedFile ; Read Rec From Handle, Arg1 Then Col2 = Rec<1> Col3 = Rec<2> If Col2 ...
by Sunshine2323
Mon Mar 13, 2006 6:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: intermediate result set required from a recordset
Replies: 19
Views: 8898

My requirement is for my input record 'a' look for the value in reference data if it finds the key value , then it should check the col2 value=4 or not. If the col2 value = 4 then take the value from the col3 which is 'b'.Then need to check the remang records in the refrence data for the 'b'.Here, ...
by Sunshine2323
Mon Mar 13, 2006 1:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: intermediate result set required from a recordset
Replies: 19
Views: 8898

Hi, I have used Ray's code and got the expected output you require. First Load your input data in a Hash File say HASH_RECURSIVE Create a Transform Function ReadRec as follows: DEFFUN ReadRec(X) Calling "DSU.ReadRec" COMMON /ReadRec/Initialized, HASH_RECURSIVE.fvar If Not(Initialized) Then...