Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Unanswered: replacing data in the table.(emptying)

    Hi,
    I am using the following statement for replacing the data in the table instead of deleting the records. If I do the delete the records which are in thousands, the transaction log will get filled up unnecessarily which I don't want to do. I use the following command to replace the data of the table.
    load from C:\test.sql of ixf replace into alert_history;
    where test.sql is a empty file and alert_history is the name of the table.
    But the table records are not getting emptied.
    May I know is there anything I need to do apart from this.
    The alert_history table here has around 200,000 records and I am OK even if I loose the data of the table after replacement.
    Please respond.
    Thx
    Shrini

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

    Re: replacing data in the table.(emptying)

    The empty file cannot be ixf ...

    It has to be del (not sure asc)

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2004
    Posts
    7

    Re: replacing data in the table.(emptying)

    Originally posted by sathyaram_s
    The empty file cannot be ixf ...

    It has to be del (not sure asc)

    Cheers
    Sathyaram
    Hi Sathyaram,
    Even del does not work.

    Thx
    Shrini

  4. #4
    Join Date
    Jul 2002
    Posts
    48

    Re: replacing data in the table.(emptying)

    After execution of load command, what is the message which you are getting. Whether you are getting the message saying load is completed.

    Another question i have is whether you any referential integrity on this table?

    Check whether table is in pending state or not?

    Nagesh

  5. #5
    Join Date
    Sep 2002
    Posts
    456

    Re: replacing data in the table.(emptying)

    I have used ixf file to empty the table on AIX DB2 V7 FP9

    dollar


    Originally posted by sathyaram_s
    The empty file cannot be ixf ...

    It has to be del (not sure asc)

    Cheers
    Sathyaram

Posting Permissions

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