LSTOWN-L Archives

LISTSERV List Owners' Forum

LSTOWN-L

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Topic: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Gregory Juster <[log in to unmask]>
Fri, 10 Mar 2000 15:15:30 -0500
text/plain (56 lines)
After rebooting the server, here's the new error

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

> DISTRIBUTE MAIL-MERGE DBMS=ODBC [log in to unmask]
Invalid RFC822 field found in mail header: "test". Mail not delivered.

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


I'm crazy or stupid or what? What's going on!!!
It was working 2-3 weeks ago and not error message always change!

Here's the job :


//CAMPAIGN-001 JOB ECHO=YES DISTRIBUTE MAIL-MERGE DBMS=ODBC
[log in to unmask] PW=1234567
//TO DD *
SELECT custem, itcust.custno as custno, tempfn, tempsn, itcuin.mailno,
itcust.context, itcust.ccdsid as 'country', itcust.sprtyp as 'sports',
itcuin.trdopt as 'trend', itcuin.emlopt as 'mailoption', itcuin.intlan as
'language', 'C' as client
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: test query
To: &*TO;
test query....

/*



-----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?

ATOM RSS1 RSS2