Results 1 to 3 of 3

Thread: Truncate Table

  1. #1
    Join Date
    Dec 2002
    Posts
    12

    Thumbs down Unanswered: Truncate Table

    Does anyone know the equivelant to 'Truncate table' command in DB2?!

    Thanks.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Truncate Table

    Check this link

    http://www.tek-tips.com/faqs.cfm?spid=178&sfid=2955

    Cheers

    Sathyaram

    Originally posted by KenWhite
    Does anyone know the equivelant to 'Truncate table' command in DB2?!

    Thanks.

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605

    Lightbulb Re: Truncate Table

    On Windows:
    IMPORT FROM nul: of del REPLACE INTO schema.tablename

    On Unix:
    IMPORT FROM /dev/null of del REPLACE INTO schema.tablename

    Originally posted by KenWhite
    Does anyone know the equivelant to 'Truncate table' command in DB2?!

    Thanks.

Posting Permissions

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