DSXchange

Is there a command line command to perform workload management (specifically to move a job up in its queue or to move a job to a different queue)? I've searched, but cannot find one. We're having a problem with the Operations Console (it complains that AppWatcher is not running when we can demonstra...

If we want to determine whether there's a relationship between ColumnA and ColumnB in TableX, does InformationAnalyzer allow TableX to be joined to itself for a cross-table analysis or do we have to create a virtual table? (We can't try it at the moment due to a connectivity issue.) Thank you for yo...

Can someone please outline the process for connecting Information Analyzer to a Neteeza data source? There does not appear to be an ODBC driver for Netezza installed with the Information Server suite.

Thank you for your time.

Does Information Analyzer have equivalents of the DataStage functions StripWhiteSpace, CompactWhiteSpace, character-by-character conversion (DataStage's Convert() function), and Trim(string,stripchar,options) ? They're certainly not documented for IA or available from the drop-down list, but may be ...

We have a requirement to compare the format of one field with the value in another field. Ideally there would be a function called format() that could return the kinds of format that is generated within column analysis but it appears that there is not. Can anyone suggest an approach for solving this...

Is it possible to use an IA virtual table (a three-way join of source data tables) to provide the reference column for an IN_REFERENCE_COLUMN check? Would the performance of such an approach be better than, or worse than, doing the same join in a view in the source database (which happens to be Nete...

Two part question. We have data such as "57 092 448 518" and want a scalar function to remove the white space characters so that we can test it with a MATCHES_FORMAT check. Is there such a function? The TRIM() function only removes leading and trailing white space. It may be that there are...

Has anyone used Java or Javascript in conjunction with the REST API for Information Analyzer? We have a BPMN workflow tool which allows us to insert pieces of Javascript to perform actions within a piece of software. We'd like to perform some GET operations to extract reports into another reporting ...

That works well, thank you.

Can something similar be done with other token types (principally &)?

We are seeking to standardize phone numbers, which sometimes have an international direct dialling prefix (001 or 011) as part of a contiguous string. Is there some way in PAL that we can extract these digits and keep only the remainder? For example, assuming a wholly numeric token, 00161299556022, ...

In our implementation of Information Analyzer there have been a whole lot of Data Stores and Data Schemas found, which are just sitting there containing no table definitions. Does anyone know how these might be deleted? Ideally this should be via the user interface rather than by hacking into the me...

Thank you for the answer, disappointing though it is.

We're about to begin investigating the IAAdmin command for a number of tasks. The manuals and Knowledge Center are silent on whether the -password option will accept a password encrypted using the encrypt utility in the ASBServer/ASBNode bin directory. Does anyone happen to know? (We're not quite in...

We have Business Glossary in version 8.7, and want to upgrade to 11.3, which we have installed. In both cases Workflow is enabled.

We can export and import the published glossary.

Is there any mechanism for transferring the development glossary?

Thank you for your time.

Thank you for your ideas. We will give them consideration.