Archives of the TeradataForum

Message Posted: Wed, 12 May 2005 @ 03:39:53 GMT

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

Hi Dave:

There does not appear to be a problem with your script. Since you say the results are "unpredictable" this leads one to believe that sometimes it works fine and other times it does not. Otherwise, I would think the failure would be predictable.

If this interpretation is correct, than the problem has to be in your data. I would first be suspicious of the way the previous and current months are entered in the input record. Is it possible that the value(s) being compared are not what you expect due to truncation of the CHAR(6) because it is not in the proper location within the record and therefore not read the way you want? If this is not the case, then I would check the way this record is created and making sure it matches the FORMAT being used by BTEQ to read the record.

The only other thing I can think of at this time is the data type of your A5.continent column. Is it CHAR(6) also? If not, you will be getting some automatic conversion occurring and it may not be all that you hoped. You might also try a TRIM on the column and the field in your WHERE clause.

Good luck,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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