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

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

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

    ‏2012-09-14T16:36:39Z  
    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...
  • lakshman
    lakshman
    67 Posts

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

    ‏2012-09-14T16:38:53Z  
    • lakshman
    • ‏2012-09-14T16:36:39Z
    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...
    One more screen shot to show how to open the Administrative perspective ...
  • lakshman
    lakshman
    67 Posts

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

    ‏2012-09-14T16:45:56Z  
    • lakshman
    • ‏2012-09-14T16:38:53Z
    One more screen shot to show how to open the Administrative perspective ...
    This screen cap show the querying editing edit box
  • MVTS_Bill_Jacob
    MVTS_Bill_Jacob
    6 Posts

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

    ‏2012-09-14T17:35:26Z  
    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

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

    ‏2012-09-14T19:07:30Z  
    Hi Lakshman -

    What tool is that shown in queryFilter.jpg? Is it 'Optim High Performance Unload', or is it part of Data Studio?
    Thanks
    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

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

    ‏2012-09-17T15:04:16Z  
    • lakshman
    • ‏2012-09-14T19:07:30Z
    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
    I attached screen shots of "Unload" process. I don't have the "With Export Utility" option.
  • MVTS_Bill_Jacob
    MVTS_Bill_Jacob
    6 Posts

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

    ‏2012-09-17T15:11:32Z  
    I attached screen shots of "Unload" process. I don't have the "With Export Utility" option.
    Trying to attach screen shots...
  • prashanta.nc
    prashanta.nc
    1 Post

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

    ‏2012-09-17T15:11:52Z  
    • lakshman
    • ‏2012-09-14T19:07:30Z
    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
    Here is the attachment.
  • lakshman
    lakshman
    67 Posts

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

    ‏2012-09-17T16:55:16Z  
    Trying to attach screen shots...
    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

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

    ‏2012-09-17T18:31:38Z  
    • lakshman
    • ‏2012-09-17T16:55:16Z
    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.
    Thanks for your help.
  • gas22
    gas22
    2 Posts

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

    ‏2012-10-05T10:47:24Z  
    Thanks for your help.
    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

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

    ‏2012-10-05T13:22:47Z  
    • gas22
    • ‏2012-10-05T10:47:24Z
    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.
    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

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

    ‏2012-10-05T16:30:00Z  
    Are you trying to Extract filtered data? If so, check out lakshman's post (a couple above) about the DB2 version.
    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

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

    ‏2012-10-08T06:57:57Z  
    Are you trying to Extract filtered data? If so, check out lakshman's post (a couple above) about the DB2 version.
    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.