DSXchange

Hi, We have installed and configured AVI in our system. I am running a sample job with some address data in a text fileincluding, Address, city, province and country. But the job always fail with the below error: AVI,0: The lqtcr library has not yet been successfully initialized. Check that you spec...

Thank you. I will check with the Sales person on options available.

Hi,
Is address verification interface always paid stage?
Can we get a trial version from IBM?
I tried to search this over the internet, could not find much details. Please advise.

Thank you, this is very helpful..

Hi,
Do we have any good documentation available for AVI other than IBM tutorials? The information available in IBM pages seems minimal.

Thanks, Ernie.
It helped. The value we had earlier was not actually NULL, which caused the issue.

Hi,
Any suggestions, please...

Thank you all!
We added an extra newline command (\n) at the end of the command line and resolved the issue.

Hi, I am using an Execute Command stage in my sequencer to get the total number of records which are present in a file so that I can give the value as a loop variable. I am using the command wc -l <path>/fieldlist.txt | cut -f 1 -d " " | tr -d '\r' I am getting the below output ..JobContro...

Thanks, Ray. But I could not get the val() function to work as expected. Say my column ins custID (custID is of type integer in database) and my Information analyzer rules states: len(trim(cusid)) <= 10 Here, cusid variable is of type string and hence I am not able to bind it to an integer data type...

Hi, Could you please help to see if the data type of variable we create in Information analyzer can be changed? For example if my rules is len(var1) = 10, then var1 will be by default of type String. Can I change it to "Any" or "Integer" type while we create the rule definition i...

This is related to Information analyzer and Datarules stage: Suppose we have a file which contains 10 columns, and we have 10 Information analyzer rules binded to them. . When we run the job after configuring the rules, we get to know that, 1 rules fails out of 10. Normally the record would go in th...

Hi Craig and Andy,
Yes, the number of rejected records are not needed at this point.
So, we will go with the aggregation. Thanks much.

Is there a way we can capture the rows written into target (file/DB) & write that information to an audit table. For example if we have a job like this Sequential File --> Transformer --> DB2 Say 1000 records are written to oracle DB. I want to insert the value 1000 into an audit table (which is...

Hi, Yes. This is a parallel job, I selected it incorrectly earlier. Validated the libphonenumber 7.2.8.jar and confirmed there are no spaces. It was a typo. We specified the required jar files in Classpath in Java integration stage, separated by semicolon and it is working fine now. Thank you, Craig...