Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Batch processing using BTEQ
From:   Michael Larkins

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023