Topic
1 reply Latest Post - ‏2012-09-12T12:13:17Z by RobertDickson
siksha
siksha
2 Posts
ACCEPTED ANSWER

Pinned topic information analyser command IAADMIN

‏2012-09-12T11:44:17Z |
IAAdmin -user <username> -password <password> -host<host name> -port<port number>
-csv ( specify the format in which output is needed )
[output <output file name>
( specify the filename where the output is to be written)
-getColumnAnalysisResult -projectName <project name> -columnName <column name>(datastore.schema.columnname)

For two or more columns in a table,how to generate the column analysis result.pl let me know
Updated on 2012-09-12T12:13:17Z at 2012-09-12T12:13:17Z by RobertDickson
  • RobertDickson
    RobertDickson
    43 Posts
    ACCEPTED ANSWER

    Re: information analyser command IAADMIN

    ‏2012-09-12T12:13:17Z  in response to siksha
    Hi,

    Short answer: Use an asterisk (an *).

    Take a look at http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r7/index.jsp?topic=%2Fcom.ibm.swg.im.iis.ia.restapi.doc%2Ftopics%2Fr_restapi_freq_dist.html where they say

    "For example, DATASOURCE.SCHEMA.TABLE.* retrieves the results for all columns of the table TABLE, in the schema SCHEMA of the database DATASOURCE. DATASOURCE.SCHEMA.. retrieves all results for all columns of all tables of the schema SCHEMA in the database DATASOURCE."

    I hope this helps.

    Regards,
    Robert