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