Search found 109 matches
- 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 ...
- 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
- 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
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
- 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
- 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
Is there any way to clear the job log for a particular job from Administrator Command prompt.
Thanks in Advance..,
Regards
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
- 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
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
- 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
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
- 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
What is the relevent function I can Use for KeyMgtGetNextValue in PX.
Thanks In Advance
Best Regards
Ravi KumarR Chennupalli
- 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
- 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
- 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
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
- 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
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
- 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
- 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