Db2 Tools for zOS

 View Only
Expand all | Collapse all

How can I copy a row in data studio

  • 1.  How can I copy a row in data studio

    Posted Fri July 01, 2022 02:04 PM
    image.png
    how do I copy a row
    Hi, how can you easily copy a row of data and paste it in using the data studio integrated into IDz?E.g. I want to copy row 5 and paste it as a new row


    ------------------------------
    Joe Taffe-Atkins
    ------------------------------

    #Db2Toolsforz/OS


  • 2.  RE: How can I copy a row in data studio

    Posted Mon July 18, 2022 12:11 PM
    Hi Joe,

    Sorry about the delay in response. As far as i have tried, there is not a good visual way to do so. One option could be to do it using a SQL statement like insert into table1 (select * from table1 where id=5) .. Alternately, DS provides a Load/Unload capability which will allow bulk data actions. 
    Hope this helps

    ------------------------------
    Sowmya Kameswaran
    Technical Architect
    Transformation - Db2 for zOS platform and ecosystem
    IBM
    San Jose
    ------------------------------

    Original Message