|
|
|
Junior Member
 
Group: Forum Members
Last Login: 4/22/2007 2:58:00 PM
Posts: 18,
Visits: 1
|
|
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
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/24/2008 2:47:14 PM
Posts: 425,
Visits: 398
|
|
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.
|
|
|
|