Teradata Forums / Teradata / Teradata Advanced Analytics User Group / need to Compare header date in file 1 with system date in file 2 / Latest Posts

RE: need to Compare header date in file 1 with system date in file 2

joedsilva — Mon, 26 Feb 2007 23:18:35 GMT

You can do it via bteq,

import the file contents to a table, do an SQL comparison, use bteq .if statements to do further processing etc.

But don't you think it's better to do this job via your batch script itself ?

At least in Unix that's what I would have done. SQL is quite cumbersome for all this sort of work.

need to Compare header date in file 1 with system date in file 2

chinnababu — Mon, 26 Feb 2007 21:40:52 GMT

I have 2 input files i.e file 1 and file2
file 1 is header file which contains date as 02/27/2006
file 2 contains system date
i have to compare file1 and file2 dates if they match i need to process otherwise needs to abend
how can i write Teradata sql

Help me in this regard
Thanks in advance and also thanks for earlier replys to my questions

Regards
Chinnababu