I'm using lsmtp as the mail server and MS SQL 7 for the DBMS.
CR & LF might be my problem.
The query is not fixed. A web interface allow people to select customers
based on few criterias which build the query. Then I send a mail to listserv
by the web interface ... so I might need to check my carriage return.

Here's a simplified generated query and the result :

SELECT itcust.custno as custno, custem, tempfn, tempsn
FROM itcust, itcuin
WHERE itcust.custno = itcuin.custno
AND itcuin.userst = -1
AND itcust.custem like [log in to unmask] AND itcust.custem not like '% %'
AND itcust.custem not like '%.'
AND itcust.custem not like [log in to unmask]
AND itcuin.emlopt = -1
AND (itcust.dupind <> -1 OR itcust.dupind is null)
AND (itcust.prtind <> -1 OR itcust.prtind is null)
AND (itcust.chtind <> -1 OR itcust.chtind is null)
AND (itcust.context = 'fs')
AND itcuin.intlan in ('English')
AND itcust.ccdsid in (SELECT ccdsid from camp_country WHERE camp_id = 4)
ORDER BY custem

custno      custem                                             tempfn
tempsn
----------- -------------------------------------------------- -------------
-- ------------------------------
868383      [log in to unmask]                            AUGUST
AKINS
880300      [log in to unmask]                       MIKE
GOLDSTEIN
875524      [log in to unmask]                                  STEVE
HAMALIUK
883678      [log in to unmask]                                 LEIGHANN
CAMPBELL
880922      [log in to unmask]                            PETE
AGUILAR
911189      [log in to unmask]                        SVEN
DANELSING
860647      [log in to unmask]                                 HAYDEN
THOMPSON
860232      [log in to unmask]                          HARTLEY
GOLDENTHAL

Here's the DB related info in site.cfg

DBMS_DEFAULT_EMAIL=custem
DBMS_DEFAULT_NAME=tempsn
DBMS_DEFAULT_TABLE=itcust
ODBC_DSN=bulk
DBMS_DEFAULT_UEMAIL=uemail
ODBC_UID=bulk
DBMS_NO_HOSTNAME_ALIASING=0
DIST_OWNER_MAIL_MERGE=1
USE_LSMTP_MAIL_MERGE=1


-----Original Message-----
From: LISTSERV list owners' forum
[mailto:[log in to unmask]]On Behalf Of Francoise Becker
Sent: Thursday, March 09, 2000 4:02 PM
To: [log in to unmask]
Subject: Re: What I'm I doing wrong?


On 9 Mar 00, at 15:31, Gregory Juster wrote:

> DISTRIBUTE was on the next line and it was causing problems.
> I was receiving the following error :
> Job "CAMPAIGN" started on 3 Mar 2000 01:10:07
>
> > DISTRIBUTE MAIL-MERGE DBMS=ODBC [log in to unmask]
> Implicit DD (TO or DATA) not found in job stream.
>
> Job "CAMPAIGN" ended   on 3 Mar 2000 01:10:07

Sounds like either the //TO DD line was malformed, or the SELECT
statement did not return anything. Here is a sample job that works
(assuming the database is set up and MYTABLE exists, and there
is an email address starting with "FRANCOISE" in it):

------------------------------cut
here----------------------------------------
//TEST JOB ACK=MAIL
DISTRIBUTE MAIL DBMS=yes [log in to unmask] PW=xxxxx
//TO DD *
SELECT EMAIL FROM MYTABLE
WHERE UEMAIL LIKE 'FRANCOISE%'
/*
//DATA DD *,EOF
Date: &*date;
From: [log in to unmask]
To: &*to;
Subject: Hi

Hello,

This is a test message.

Francoise
------------------------------cut
here----------------------------------------

Make sure that lines are separated by carriage-return-line-feed and
not wrapping. Perhaps the mail program you are using is only
using one or the other but not both. What mail program are you
using to send the distribute job?

What database software are you using?
What is a sample output if you send the query you are using
directly to the database?
How is the database configured in your site.cfg file?

Francoise