Archives of the TeradataForum

Message Posted: Mon, 11 Aug 2003 @ 18:12:30 GMT

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

Did you try using actual variables in Queryman or Bteq? (In Queryman use Import mode and replace the variable names with '?'.)

> UPDATE TAB_A
>      SET COL1 = ?
>      WHERE CAST((COALESCE(BirthDate,DATE) (FORMAT 'YYYYMMDD')) AS CHAR(8))
>                        <> COALESCE(?,(CAST((DATE (FORMAT 'YYYYMMDD')) AS CHAR(8))))
>      OR    CAST((COALESCE(signUpDate,DATE) (FORMAT 'YYYYMMDD')) AS CHAR(8))
>                        <> COALESCE(?,(CAST((DATE(FORMAT 'YYYYMMDD')) AS CHAR(8))))
>      ) ;

The Import file should contain 3 data vales per line, separated by the delimiter character. (A tab by default)

For better analysis, would need to see a sample of the input, and the table definition.

Mike Dempsey
Teradata Client Tools

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