DSXchange

Any ideas to fix this issue ?

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...

BillB,

That would work but we don't have server job as we have Data Quality license only. Any other ideas on this?

Hi Paul,

No. It did not work. Any other ideas?

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...

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 ...

Any other ideas on this issue?

Paul, All the above were verified and looks good, not sure why this command stage is not returning output.

Yes! Executed by the same user both times.

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...

Issue has been resolved. The weird thing is Index function worked after logging out of IA and relogin. My guess is changes I made were not applied before. It was vey confusing and frustrating though.

Hi Rodriguez,

Can you please let me know how to use this matches_regex in IA. I started first using matches_regex wih this rule logic and ended up trying Index function as I did not get the correct result with matchs_regex. Thank you!

I just tried >= instead of > but it dinot work. Please let me know if you have any other ideas on this.

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'

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 ...