Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 14:45:09 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello again:

I am using BTEQ on the MVS mainframe batch mode.

I am trying to pass a from and to date for an SQL query where statement.

If I do the following:

     .LOGON xxx
     .IMPORT DATA   DDNAME=INFILE  ;
     .EXPORT DATA   DDNAME=OUTFILE ;
        USING FDATE (CHAR(10)),
              TDATE (CHAR(10)),
             filler (CHAR(60))

FOR the query Where statement:

     WHERE CONTACT_DATE (date) > :FDATE
     and CONTACT_DATE (date) < :TDATE

I get the error message:

Failure 2666 Invalid date supplied for PE.CONTACT_DATE.

CAN I DO this kind of operation? Am I doing something wrong?

Thanks

Capp Luckett

	<Prev	Next>		<<First	<Prev	Next>	Last>>