Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    12

    Lightbulb Unanswered: is there any solution for this

    wat is its equivalent in db2.this is in oracle.
    i think there is no CREATE TABLE AS SELECT in db2.


    CREATE TABLE IPCS_LICENSE NOLOGGING AS SELECT 'Zigma' Company, 'ANY'
    IP, 'ANY' Hostname, CAST(TO_DATE('1/22/2007', 'mm/dd/yyyy') AS
    DATE) Expire, '10.1' Version, 'y' IsLicensed, SYSDATE LastUpdated
    FROM DUAL

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    I suggest that you put this in the DB2 forum

    http://www.dbforums.com/forumdisplay.php?f=8
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Sep 2006
    Posts
    12
    thank you bill

Posting Permissions

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