Not working.
I tried with only the email field, email, firstname, lastname. Result : not
working.

I also tried with a hardcoded list only with my email like so :
//TO DD *
[log in to unmask] Gregory Juster
/*
This should work, no? It doesn't!

I tried again putting the distribute keyword on a different line and I'm
still having the error :

Job "CAMPAIGN-001" started on 10 Mar 2000 12:41:13

> DISTRIBUTE MAIL-MERGE DBMS=ODBC [log in to unmask]
Error X'0100003B' loading recipient data from DBMS.

Serious error occurred - traceback follows
------------------------------------------
>>> Error X'0100003B' loading DISTRIBUTE recipients <<<
 -> Severity: Error
 -> Facility: DBMS interface
 -> Abstract: SQL error

Job "CAMPAIGN-001" ended   on 10 Mar 2000 12:41:13



Anyway, here's the symplified job revised and still not working. The query
should return 2 records. :

//CAMPAIGN-001 JOB ECHO=YES DISTRIBUTE MAIL-MERGE DBMS=ODBC
[log in to unmask] PW=342542
//TO DD *
SELECT custem, tempfn, tempsn
FROM itcust
WHERE itcust.custno = itcuin.custno AND custem in
([log in to unmask],[log in to unmask])
/*
//DATA DD *
Date: &*DATE;
From: Intertops Campaign ([log in to unmask])
Subject: My Subject
To: &*TO;
My Message

/*



-----Original Message-----
From: LISTSERV list owners' forum
[mailto:[log in to unmask]]On Behalf Of Ben Parker
Sent: Thursday, March 09, 2000 6:44 PM
To: [log in to unmask]
Subject: Re: Implicit DD (TO or DATA) not found in job stream. ???


On Thu, 2 Mar 2000 11:11:39 -0500, Grégory Juster <[log in to unmask]> wrote:

>//TO DD *
>SELECT CUSTEM, TEMPSN, TEMPFN, CURTYP FROM itcust WHERE custem in
>([log in to unmask],[log in to unmask])
>/*

Does this SELECT statement work when submitted manually from a command line
directly to the database?