Bounces are not stored in the changelog table, AUTO-DELETES are stored in
the changelog table.  If you're runing an adhoc list distribution (based on
a non-Listserv table) as oppose to a distribution to a Listserv maintained
list (an actual Listserv list), you cannot re-direct bounces to a table.
You must (if you need to somehow capture the bounces from a given distribute
job) write the bounces to a file and/or send to an email account.  If the
list you're planing on distributing to is a Listserv maintained list, you
should be able to re-direct the bounces back to the list and let the
AUTO-DELETE list keyword handle the deletes.

example of how to redirect back to LISTSERV list:

//LISTNAME_MAILING JOB ECHO= YES
// DISTRIBUTE MAIL-MERGE DBMS=LIST(LISTNAME) PW=xxxxxx ,
[log in to unmask]
//TO DD "1=1"
//DATA DD *
Date: &*DATE;
Message-Id: <LISTSERV%2006215134943@yourdomain>
From: "Physics Today" <user@yourdomain>
Reply-to: user@yourdomain
Errors-to: user@yourdomain
Subject: Editorial Preview April 2006
To: &*TO;
MIME-Version: 1.0
Content-Type: multipart/Alternative;
 boundary="----_=_NextPart_000_01C26BAB.2FEB88E0"

This is a multi-part message in MIME format.

------_=_NextPart_000_01C26BAB.2FEB88E0
Content-Type: text/plain;
 charset="iso-8859-1"


example of how to configure AUTO-DELETE to delete on the first occurance of
a bounce:

Auto-Delete= Yes,Full-Auto,MAX(1),DELAY(0)



----- Original Message ----- 
From: "Francoise Becker" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Monday, March 20, 2006 4:53 PM
Subject: Re: Bounced Email


> On 20 Mar 2006 at 16:07, Bruno Robichaud wrote:
>
> > Well the way we use Listserv is with a mail-merge DBMS backend, so the
email
> > list come from a DB table and I want the bounced to be in a DB table
also so
> > I can clean my email list table from bounced Email.
>
> Please take a look at the CHANGELOG_DBMS site variable and associated
> variables.
>
> http://www.lsoft.com/manuals/1.8e/sitemgr/sitevars.html#cChangelogdbms
>
> You can have your cake and eat it too. You can let LISTSERV do the
> bounce processing AND have the bounce information go to your
> database.
>
>
> -- 
> Francoise Becker <[log in to unmask]>
>
> Knowledge is just a click away: http://www.lsoft.com/optin.html