DSXchange

Don't know if I'm out on left field here, but I think you will need to export out the analysis results to a flat file. The other team may have done this, based on what you said that they got the definition from flat files. There is no way for you get the definitions straight out of IADB, short of go...

Yes, Ray, that's what I ended up doing. IBM should get their act together! And the list of functions is short. I hope they can add more. I can use add_months right now.

Thanks, all.

I coded
and got the error "Mod is not a known scalar function."

I am coding this in a rule logic:
In the list of functions, the modulo operator is listed as "%". But with code similar to the above, I am getting this error:

The variable "%" contains an invalid character.

Does anyone know how to code modulus?

Thanks, guys.

The DBA had checked and confirmed we have SELECT permission on the views. But IA still could not see them.

RESOLVED: In Set Pre-filter, I had to Include Views, which is off by default.

We created views of tables but when I try to import metadata, the views are not available. Is IA only able to work on physical tables only?

I agree with this diagnosis:

wernerg_at wrote:Hi,

I think a closing quote is missing after 10:00 p.m.

Try changing

or PrinterException like 'Sun.-Sat. 9:00 a.m.. - 10:00 p.m. or

To

or PrinterException like 'Sun.-Sat. 9:00 a.m.. - 10:00 p.m.' or

BR

Werner

Have you looked into it?

Thanks, Ray.

As far as I know, the Run/Submit interface allows for scheduling a job. Is that not sufficient for your needs?

I have only used IA to profile, i.e., conduct column analysis, etc. on tables. Is IA also capable of profiling a flat file? If so, how?

Thanks, Ray.

Argh! I'm not a premium member yet and I don't see your full reply, Ray.

How's everyone at Zenith though? Please say hi to Tony, Amar, Tim and Brad for me.

Hi, everyone. From the 8.1.2 User Guide: Managed - Each data rule has a defined state, such as draft or accepted, so you can identify the status of each rule. A data rule or rule definition can have a Status of: - Draft - Candidate - Accepted - Deprecated - Rejected A rule or rule definition starts ...

It's now 10 months since the last post on this. Does anyone know of any developments?

Our project is now at this same stage, where we are doing a POC on deploying an IA project from one server to another.

It is the exception records that I would like to be in a user-defined table, immediately available for consumption outside of IA. Yes, we are looking at using DS to move them, but that is the extra step we can avoid if IA had the ability to output directly to a user-defined table. The table and colu...