Results 1 to 2 of 2

Thread: insert into

  1. #1
    Join Date
    Dec 2003
    Posts
    7

    Unanswered: insert into

    Does INSERT INTO command create a new table if there doesnt exist one already?

    Thks,
    Pradeep.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    No. You can use a separate SQL statement to create the table:

    create table table_new like table_old
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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