Search found 18 matches
- Thu Aug 30, 2018 8:42 am
- Forum: IBM QualityStage
- Topic: Quality Stage - Information Analyzer - Importing Projects
- Replies: 4
- Views: 13428
- Wed Aug 29, 2018 8:52 am
- Forum: IBM QualityStage
- Topic: Quality Stage - Information Analyzer - Importing Projects
- Replies: 4
- Views: 13428
Quality Stage - Information Analyzer - Importing Projects
Hello, We have upgraded Quality Stage to 11.7 from 9.1 version and currently in the process of migrating all the jobs and projects in Information Analyzer. I could migrate all datastage jobs but I am stuck with IA projects migration with the below error message. "no item was imported based on t...
- Wed Jan 24, 2018 12:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read comma delimited files with missing column values
- Replies: 8
- Views: 5080
- Mon Jan 22, 2018 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read comma delimited files with missing column values
- Replies: 8
- Views: 5080
- Mon Jan 22, 2018 9:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to read comma delimited files with missing column values
- Replies: 8
- Views: 5080
How to read comma delimited files with missing column values
Hello, I have a new requirement to work with comma delimited files with no quotes for blank values but I have never come across with this kind of files to work with. For example: D,0,SB,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 D,1,IN,,0,0,0,0,90000000,0,0,0,0,0,0,0,0,0,0 D,4,FEDOUT,,0,0,0,0,90000000,0...
- Tue Apr 25, 2017 5:51 am
- Forum: General
- Topic: Change Capture stage is inactive
- Replies: 2
- Views: 2839
Change Capture stage is inactive
Hello, I have never used "Change Capture stage" after I joined this company but for the first time I need it and I do not see it in the Palette so I tried to add from the Project/Stage Types/Parallel/Processing but it is inactive. Can you please help me on this. Please let me know how can ...
- Mon Apr 17, 2017 1:21 pm
- Forum: General
- Topic: Command stage output
- Replies: 7
- Views: 4664
- Thu Apr 13, 2017 9:02 am
- Forum: General
- Topic: Command stage output
- Replies: 7
- Views: 4664
- Wed Apr 12, 2017 8:10 am
- Forum: General
- Topic: Command stage output
- Replies: 7
- Views: 4664
- Tue Apr 11, 2017 1:43 pm
- Forum: General
- Topic: Command stage output
- Replies: 7
- Views: 4664
Command stage output
Hello, I have the below command in the execute command stage: c:\windows\system32\find /c "," D:\IBM\Data\Files\WorkingData\Proj\File.txt When I have tried the same command in the server's command prompt it was returning the correct output value but when I run the datastage job,it is not r...
- Wed Jan 18, 2017 3:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Quality - Index function issue in the data rule logic
- Replies: 9
- Views: 8622
- Wed Jan 18, 2017 12:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Quality - Index function issue in the data rule logic
- Replies: 9
- Views: 8622
- Tue Jan 17, 2017 3:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Quality - Index function issue in the data rule logic
- Replies: 9
- Views: 8622
- Tue Jan 17, 2017 2:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Quality - Index function issue in the data rule logic
- Replies: 9
- Views: 8622
Re: Data Quality - Index function issue in the data rule log
Adding oe more question to this.
If I have two words as a substring then it won't work. Example is given below.
If index(name1,'Walmart RCLR') >0 then cash = 0
when the name1 is 'SP Walmart RCLR 2313 OLCL'
If I have two words as a substring then it won't work. Example is given below.
If index(name1,'Walmart RCLR') >0 then cash = 0
when the name1 is 'SP Walmart RCLR 2313 OLCL'
- Tue Jan 17, 2017 2:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data Quality - Index function issue in the data rule logic
- Replies: 9
- Views: 8622
Data Quality - Index function issue in the data rule logic
Hello, I am using index function to get the substring from a string as shown below in a data rule logic but this is working in some cases and not working in some other cases. If index(name1,'RCLR') >0 then cash = 0 it's working when the name1 is 'SP Walmart RCLR 2313 OLCL' and the same logic is not ...