Search found 109 matches

by cherry
Fri Aug 28, 2009 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: serach for a particular word
Replies: 3
Views: 1302

serach for a particular word

Hi All, I have a field that contains value AAAAAAA BANK OF SA I will come to know that the particular value is a BANK Name if it has BANK word in that value. How can I search the value to know that it is a BANK. Is thera any function to like FIND to search for a particular word in the value. Please ...
by cherry
Thu Aug 13, 2009 5:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatenation
Replies: 3
Views: 2205

Concatenation

Hi All, I have two fields to concatenate A=(011)7171361 B=(o) C=A:B When I do Concatenation of A:B iam getting the value as C=A(B value is not concatenated) But when I do C=B:A this is working fine. Do some one has clue why this is not working for C=A+B Iam writing the data to a DataSet Regards Cherry
by cherry
Thu Aug 13, 2009 3:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Specific Value
Replies: 1
Views: 836

Need Specific Value

Hi all,

I Have a field that holds the value A=(890)

I need to extract only 890 without braces.

Could some one please help me how to achieve this.

Best Regards
Cherry
by cherry
Wed Aug 05, 2009 8:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Clear Job Log from DSAdministrator
Replies: 5
Views: 2628

Heelo everyone,

Thanks for the quick response. That was really a very useful information for me. I got my problem solved by your responses.

Thanks for evryone..

Regards
Cherry
by cherry
Wed Aug 05, 2009 5:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Clear Job Log from DSAdministrator
Replies: 5
Views: 2628

Clear Job Log from DSAdministrator

Hi All,

Is there any way to clear the job log for a particular job from Administrator Command prompt.

Thanks in Advance..,

Regards
Cherry
by cherry
Tue Jul 28, 2009 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IIS Instalation
Replies: 3
Views: 1476

This is a fresh system, where the system I was installing doesn't have previous versions of IIS installed.

Could some one please help me on this

Regards
Cherry
by cherry
Tue Jul 28, 2009 6:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IIS Instalation
Replies: 3
Views: 1476

IIS Instalation

Hi All,

Iam trying to install IIS on my system. During Installation iam getting the following error.

An error occured installing the MKS Toolkit

Could some one please help me what does this related to and solution for this.

Thanks in Advance

Best Regards
Cherry
by cherry
Thu Jul 23, 2009 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fill the remaining spaces
Replies: 5
Views: 2297

Fill the remaining spaces

Hi All,

I have a field that has its length as Char(10), for this field if it has the data length that is coming in is 7 characters and the remaing space it has to get filled with the values AAA

Could you please tell me how can we achieve this.

Thanks in advance

Best Regards
Cherry
by cherry
Thu Dec 11, 2008 10:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate Key
Replies: 1
Views: 1017

Surrogate Key

Hi All,

What is the relevent function I can Use for KeyMgtGetNextValue in PX.


Thanks In Advance


Best Regards
Ravi KumarR Chennupalli
by cherry
Tue Dec 09, 2008 6:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract Data
Replies: 5
Views: 1919

Hi Chullet,

Its working fine, Thank a lot


Regards
Cherry
by cherry
Tue Dec 09, 2008 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract Data
Replies: 5
Views: 1919

I even get the data like 'XXX YYY ZZZ AAA'

Best Regards
Cherry
by cherry
Tue Dec 09, 2008 4:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract Data
Replies: 5
Views: 1919

Extract Data

Hi All,

I have a value coming from source as 'XXX YYY ZZZ', I need to extract as 'YYY ZZZ' into target.Is there any function in DS to achieve this. If yes Please let me know.


Thanks In Advance

Best Regards
Cherry
by cherry
Tue Dec 09, 2008 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Check first letter is Number or Character
Replies: 1
Views: 977

Check first letter is Number or Character

Hi All,

How can I check the first letter is a number or character for a value.
Is there any function in DS to achieve this, if yes please let me know.

Thanks in Advance


Best Regards
Cherry
by cherry
Wed Dec 03, 2008 3:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Session Id
Replies: 4
Views: 2225

There are enough session limits.I guess when I run the 3 jobs in a parallel mode, 3 session should get created. But in my case the first job is taking the second job's session id. Please correct me if iam wrong. Is there any way where I can change my job design to run in parallel mode. Regards Cherry
by cherry
Wed Dec 03, 2008 11:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data type
Replies: 8
Views: 2560

I got it, I have converted the field to to_char and changed the data type to char.The value is matching now.

Thanks for your support


Regards
Cherry