Topic
1 reply Latest Post - ‏2013-04-18T06:07:05Z by Raviteja GV
SystemAdmin
SystemAdmin
6 Posts
ACCEPTED ANSWER

Pinned topic TDM select query in selection criteria

‏2013-03-08T12:27:23Z |
IBM Optim test data management During extract process. How to extract distinct for many column from table. how can i write sql statment in table specification in access definition selection criteria.

Is there any other way to do it???
  • Raviteja GV
    Raviteja GV
    2 Posts
    ACCEPTED ANSWER

    Re: TDM select query in selection criteria

    ‏2013-04-18T06:07:05Z  in response to SystemAdmin

    Hi,

    To extract distinct column data from table, you have to write a subquery in table specifications of access definition

    For example:  Select * from table_name where row_id IN ( SELECT row_id FROM
    (SELECT
    TBL.*
    ,row_number() over (partition by column1||'~'||column2||'~'||column3 ) rowcnt1
    FROM table_name TBL)A
    WHERE rowcnt1 = 1)

    whatever i have highlighted that is default statement in SQL area, we have to write the remaining SQL statement to achieve our expected result.

    Regards

    Raviteja GV