Subject: | |
From: | |
Reply To: | |
Date: | Fri, 10 Mar 2000 14:03:22 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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?
|
|
|