Search found 7 matches

by satyaatibm
Fri Apr 11, 2014 10:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenate multirow data into one line
Replies: 8
Views: 3052

Yes, I am keeping the last row in the Remove Duplicates stage...

But the o/p i am getting is:
1, HariRaj (Here Ram is missing)
2,JohnterrySmithPeter
by satyaatibm
Fri Apr 11, 2014 9:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenate multirow data into one line
Replies: 8
Views: 3052

I tried the below method in 9.1.. SRC-->SORT-->TFM-->Remove Duplicate--> TGT Sort by class and in TFM, I am taking 3 stage variables as below order KeyNext=class concatText= If keyNext <> keyPre Then STUDENTS else concatText: STUDENTS keyPre=KeyNext Here I am getting partial o/p as the first row dat...
by satyaatibm
Fri Apr 11, 2014 4:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenate multirow data into one line
Replies: 8
Views: 3052

Concatenate multirow data into one line

Hi, input file: CLASS, STUDENTS -------------------------- 1,Ram 1,Hari 1,Raj 2,John 2,terry 2,Smith 2,Peter O/p should be: CLASS, STUDENTS -------------------------- 1,RamHariRaj 2,JohnterrySmithPeter I wanted to concatenate all the rows based on the group column which is class here. Please suggest...
by satyaatibm
Tue Mar 11, 2014 4:23 am
Forum: General
Topic: Failed to authenticate the current user against the selected
Replies: 5
Views: 4482

Failed to authenticate the current user against the selected

Hi, While I am trying to connect to Designer Client its showing me the error message " Failed to authenticate the current user against the selected Services Tier " but at the same time I am able to connect to Director Client. Trying to connect to DS through Windows 7 64-bit machine. Thanks...
by satyaatibm
Thu Jun 06, 2013 3:32 am
Forum: General
Topic: Command to get list of uncompiled jobs
Replies: 1
Views: 2307

Command to get list of uncompiled jobs

Hi,

I wanted to fetch all the job names which are in non compiled state using UNIX command from particular category.

Can someone tell me the UNIX command to get all uncompiled jobs category-wise?

Regards,
Satya
by satyaatibm
Thu Feb 07, 2013 1:56 am
Forum: General
Topic: Installing DataStage client 7.1, 7.5.1 and 8.7 in Windows 7
Replies: 3
Views: 2995

Hi I understand that.. But Our client still using the older versions in PROD and slowly migrating to new versions. So, I need to have all 3 versions in stalled in my Windows 7 laptop so that anytime I can work with any version till everything will be migrated to 8.7.
by satyaatibm
Wed Feb 06, 2013 1:43 pm
Forum: General
Topic: Installing DataStage client 7.1, 7.5.1 and 8.7 in Windows 7
Replies: 3
Views: 2995

Installing DataStage client 7.1, 7.5.1 and 8.7 in Windows 7

Hi,

Is it possible to install DS 7.1, 7.5.1 and 8.7 clients in one Windows 7 64-bit machine. If yes, then is there anything special needs to be done to make everything (7.1, 7.5.1 and 8.7) work fine without any issue using multi-client manager??