Topic
14 replies Latest Post - ‏2012-10-08T06:57:57Z by gas22
MVTS_Bill_Jacob
MVTS_Bill_Jacob
6 Posts
ACCEPTED ANSWER

Pinned topic Data->Extract: Can I apply a table data filter?

‏2012-09-14T15:04:17Z |
Using Data Studio Administrator Client 3.1. Trying to export table data in a format to easily Load this data at a later date.
If I right click on the table, Data/Extract, I do not get an option to filter my selection. If the table is 100 records, this export/import process is ok. When I'm dealing with 20+ million records this won't work.

I tried filtering the results via query. Right click "SQL Results" and Export/Current results. This exports results, but only in a format for CSV or text file. It won't "Load" back into the table because it doesn't format for "Character string delimiter" (doesn't retain column definition).

Is there a way to filter the "Extract Data" function in this tool.
Thanks,
Updated on 2012-10-08T06:57:57Z at 2012-10-08T06:57:57Z by gas22
  • lakshman
    lakshman
    67 Posts
    ACCEPTED ANSWER

    Re: Data->Extract: Can I apply a table data filter?

    ‏2012-09-14T16:36:39Z  in response to MVTS_Bill_Jacob
    Hi Bill,

    As per the options mentioned in your posting it looks like you are using Data Source Explorer to extract data. Please use the Administrative Explorer from "Administrative" perspective which gives more options and also supports to update the SELECT query or command for filtering or any other purpose.

    Here is our Data Studio documentation link which provides more details ...
    http://publib.boulder.ibm.com/infocenter/dstudio/v3r1/topic/com.ibm.datatools.data.ui.doc/topics/t_unloadingta.html

    Herewith I am attaching few screen shots which will help to navigate the functionality...
  • MVTS_Bill_Jacob
    MVTS_Bill_Jacob
    6 Posts
    ACCEPTED ANSWER

    Re: Data->Extract: Can I apply a table data filter?

    ‏2012-09-14T17:35:26Z  in response to MVTS_Bill_Jacob
    Hi Lakshman -

    What tool is that shown in queryFilter.jpg? Is it 'Optim High Performance Unload', or is it part of Data Studio?
    Thanks
    • lakshman
      lakshman
      67 Posts
      ACCEPTED ANSWER

      Re: Data->Extract: Can I apply a table data filter?

      ‏2012-09-14T19:07:30Z  in response to MVTS_Bill_Jacob
      It is part of Data Studio ...just change to the Administrative perspective as shown in the screen shot. This perspective look and feel like DB2 control center.

      Once you select the table to unload the data...you can see the options "unload-> With Export Utility..." . The documentation link which I provided you in the previous posting will give you more details
      • MVTS_Bill_Jacob
        MVTS_Bill_Jacob
        6 Posts
        ACCEPTED ANSWER

        Re: Data->Extract: Can I apply a table data filter?

        ‏2012-09-17T15:04:16Z  in response to lakshman
        I attached screen shots of "Unload" process. I don't have the "With Export Utility" option.
        • MVTS_Bill_Jacob
          MVTS_Bill_Jacob
          6 Posts
          ACCEPTED ANSWER

          Re: Data->Extract: Can I apply a table data filter?

          ‏2012-09-17T15:11:32Z  in response to MVTS_Bill_Jacob
          Trying to attach screen shots...
          • lakshman
            lakshman
            67 Posts
            ACCEPTED ANSWER

            Re: Data->Extract: Can I apply a table data filter?

            ‏2012-09-17T16:55:16Z  in response to MVTS_Bill_Jacob
            Hi Bill.

            Thanks for sending screen shot, which helped me to identify that you are trying for DB2 Z. Unfortunately we don't support "Export Utility" option for DB2 Z, currently it is supported only for DB2 LUW.
            Please try the "Table Data Filter" option in any way, I know its not perfect solution what you are looking for.
            I will open a feature request about your requirement to support on DB2 Z in future.
            • MVTS_Bill_Jacob
              MVTS_Bill_Jacob
              6 Posts
              ACCEPTED ANSWER

              Re: Data->Extract: Can I apply a table data filter?

              ‏2012-09-17T18:31:38Z  in response to lakshman
              Thanks for your help.
              • gas22
                gas22
                2 Posts
                ACCEPTED ANSWER

                Re: Data->Extract: Can I apply a table data filter?

                ‏2012-10-05T10:47:24Z  in response to MVTS_Bill_Jacob
                Could anybody attach a screen shot about filtering table data??. I think something is wrong with my data studio, it doesn't show me the filter button when i display data from a table.
                • MVTS_Bill_Jacob
                  MVTS_Bill_Jacob
                  6 Posts
                  ACCEPTED ANSWER

                  Re: Data->Extract: Can I apply a table data filter?

                  ‏2012-10-05T13:22:47Z  in response to gas22
                  Are you trying to Extract filtered data? If so, check out lakshman's post (a couple above) about the DB2 version.
                  • loicjulien
                    loicjulien
                    96 Posts
                    ACCEPTED ANSWER

                    Re: Data->Extract: Can I apply a table data filter?

                    ‏2012-10-05T16:30:00Z  in response to MVTS_Bill_Jacob
                    Hi,

                    I am attaching a screenshot. The rectangle in red (upper right), is how you bring the filtering dialog. The screenshot was taken from the Data > Edit Data Menu of the Administration Perspective.

                    Hope this helps,
                    ~Loic
                  • gas22
                    gas22
                    2 Posts
                    ACCEPTED ANSWER

                    Re: Data->Extract: Can I apply a table data filter?

                    ‏2012-10-08T06:57:57Z  in response to MVTS_Bill_Jacob
                    MVTS_Bill_JAcob: No, i'm just trying to filter data, it seems i have any kind of incompatibility (db2 8 on z/os) so it doesn't appear the tool bar where the filter button lies.

                    loicjulien: Thanks, i haven't the tool bar with the filter button, that's what i suspected.
      • prashanta.nc
        prashanta.nc
        1 Post
        ACCEPTED ANSWER

        Re: Data->Extract: Can I apply a table data filter?

        ‏2012-09-17T15:11:52Z  in response to lakshman
        Here is the attachment.