Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008

    Unanswered: IDS 9 - Copy data from one table to another

    I want to make a copy of an existing table using IDS 9. This is how I would do it in Oracle. I would create a new table and select all data from the original table into my newly created table.

    CREATE TABLE new_table AS SELECT * FROM old_table

    Any ideas how I can do the same with IDS 9?

  2. #2
    Join Date
    Feb 2009
    1. create table table_new
    2. insert into table_new select * from table_old

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts