[/quote][/quote] > '-CLIENT--' +-pipename-+ > '-device---' > .... blah blah ... >[quote] > >-----+--------------------------------+---+-INSERT----+-------->[/quote] > '-TEMPFILES PATH--temp-pathname--' +-REPLACE---+ > +-RESTART---+ > '-TERMINATE-' > ... blah blah ... > > Where is the DELETE option?? Am I missing something?? Maybe I can > use REPLACE > to replace an existing record, but if I want to totally remove the > record with a certain key from existence this won't do. TIA[/quote] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <3F0070BC.84BD53AC@us.ibm.com> [ref] => <6a8ba9f8.0306300729.508e813a@posting.google.com> [htmlstate] => on_nl2br [postusername] => Larry [ip] => lsedels@us.ibm. [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) -->[/quote][/quote] > '-CLIENT--' +-pipename-+ > '-device---' > .... blah blah ... >[quote] > >-----+--------------------------------+---+-INSERT----+-------->[/quote] > '-TEMPFILES PATH--temp-pathname--' +-REPLACE---+ > +-RESTART---+ > '-TERMINATE-' > ... blah blah ... > > Where is the DELETE option?? Am I missing something?? Maybe I can > use REPLACE > to replace an existing record, but if I want to totally remove the > record with a certain key from existence this won't do. TIA[/quote] The usual way is to export the rows you want to keep (ignoring the ones you want to delete) and do a load replace of the exported rows. [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => <6a8ba9f8.0306300729.508e813a@posting.google.com> [htmlstate] => on_nl2br [postusername] => Mark A [ip] => ma@switchboard. [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 2 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> LOAD utility for batch deleting of records? - IBM DB2

LOAD utility for batch deleting of records? - IBM DB2

You can Load/Replace a null file and it will leave an empty table there. Larry Edelstein Kenjis Kaan wrote: > Is is possible to use db2's LOAD utility to batch delete a set of > records? > I know normally it is used to insert a batch of records from an asci > file for example ala DB2 LOAD FROM file1 of del .... INSERT INTO > MYTABLE (col1,col2) > > But what about if you need to use LOAD to erase a set of record from > MYTABLE first before calling LOAD to insert a new and updated set ...

  1. #1

    Default Re: LOAD utility for batch deleting of records?

    You can Load/Replace a null file and it will leave an empty table there.

    Larry Edelstein

    Kenjis Kaan wrote:
    > Is is possible to use db2's LOAD utility to batch delete a set of
    > records?
    > I know normally it is used to insert a batch of records from an asci
    > file for example ala DB2 LOAD FROM file1 of del .... INSERT INTO
    > MYTABLE (col1,col2)
    >
    > But what about if you need to use LOAD to erase a set of record from
    > MYTABLE first before calling LOAD to insert a new and updated set of
    > records? db2 LOAD doesn't seem to accommodate this? From the manuals
    > I can see the four operations are:
    >
    > LOAD Command
    > Command Syntax
    > .-,-------------.
    > V |
    > >>-LOAD----+---------+--FROM------+-filename-+--+--------------->
    > '-CLIENT--' +-pipename-+
    > '-device---'
    > .... blah blah ...
    >
    > >-----+--------------------------------+---+-INSERT----+-------->
    > '-TEMPFILES PATH--temp-pathname--' +-REPLACE---+
    > +-RESTART---+
    > '-TERMINATE-'
    > ... blah blah ...
    >
    > Where is the DELETE option?? Am I missing something?? Maybe I can
    > use REPLACE
    > to replace an existing record, but if I want to totally remove the
    > record with a certain key from existence this won't do. TIA
    Larry Guest

  2. #2

    Default Re: LOAD utility for batch deleting of records?

    "Kenjis Kaan" <tivolinewbiecanada.com> wrote in message
    news:6a8ba9f8.0306300729.508e813aposting.google.c om...
    > Is is possible to use db2's LOAD utility to batch delete a set of
    > records?
    > I know normally it is used to insert a batch of records from an asci
    > file for example ala DB2 LOAD FROM file1 of del .... INSERT INTO
    > MYTABLE (col1,col2)
    >
    > But what about if you need to use LOAD to erase a set of record from
    > MYTABLE first before calling LOAD to insert a new and updated set of
    > records? db2 LOAD doesn't seem to accommodate this? From the manuals
    > I can see the four operations are:
    >
    > LOAD Command
    > Command Syntax
    > .-,-------------.
    > V |
    > >>-LOAD----+---------+--FROM------+-filename-+--+--------------->
    > '-CLIENT--' +-pipename-+
    > '-device---'
    > .... blah blah ...
    >
    > >-----+--------------------------------+---+-INSERT----+-------->
    > '-TEMPFILES PATH--temp-pathname--' +-REPLACE---+
    > +-RESTART---+
    > '-TERMINATE-'
    > ... blah blah ...
    >
    > Where is the DELETE option?? Am I missing something?? Maybe I can
    > use REPLACE
    > to replace an existing record, but if I want to totally remove the
    > record with a certain key from existence this won't do. TIA
    The usual way is to export the rows you want to keep (ignoring the ones you
    want to delete) and do a load replace of the exported rows.


    Mark A Guest

Similar Threads

  1. Deleting multiple records
    By Looch in forum Coldfusion Database Access
    Replies: 14
    Last Post: April 19th, 01:37 PM
  2. Deleting records against a list
    By Rick Altman in forum FileMaker
    Replies: 2
    Last Post: July 18th, 03:38 AM
  3. deleting records and keeping them
    By kabir in forum Microsoft Access
    Replies: 1
    Last Post: July 13th, 05:33 PM
  4. deleting selection of records
    By George Mizzell in forum Macromedia Dreamweaver
    Replies: 0
    Last Post: July 13th, 01:30 PM
  5. Disk utility for partitioning drives and deleting partitions?
    By John Robson in forum Mac Applications & Software
    Replies: 1
    Last Post: July 9th, 08:15 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139