--On March 7, 2006 1:43:17 PM -0400 Bruno Robichaud <[log in to unmask]> wrote: > I think the * in my select was causing a issues but right now I want to > know what wrong with my format because when I changed the * for the email > field o get error on /* Ect. , I just want to have the right format so I > can based myself for other is it possible to change my syntaxe for the > real thing plz thx. everything is one line or a continued line up to the //DATA, and that neeeds to be //DATA DD * ,EOF on one line (you missed the EOF) -- due to line wrapping going on I'm not totally sure your client isn't line wrapping the // TO DD * SELECT ... line. > > //XYZNEWS-215 JOB ECHO=NO > // DISTribute MAIL-MERGE PW=**** , > DBMS=YES(EMAIL=strEmail) > // TO DD * > SELECT strEmail FROM EmailTable_63 > /* > //DATA DD * , > To: <&*TO;> > From: XYZnews editor <*****@gmail.com> > Date: &*date; > Subject: test; > MIME-Version: 1.0 > Content-Type: multipart/alternative; Boundary="123456789123456789abcd" > > --123456789123456789abcd > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > jj > > --123456789123456789abcd > Content-Type: text/html; charset=us-ascii > Content-Transfer-Encoding: 7bit > > <html> > <head>I'm a Head</head> > <body> > <h2>Im relly the real shit</h2> > </body> > </html> > > --123456789123456789abcd-- > > -- "Genius might be described as a supreme capacity for getting its possessors into trouble of all kinds." -- Samuel Butler