![]() |
Hi, i have a bteq which uses repeat function to load a file into a table. we have a parameter for the input file. if the parameter is not available, the script is failing with a Return code 0, inspite of using the label to exit if errorcode <>0.
21 Jun 2016
| 2 comments
,
|
![]() |
Hi ,
07 Oct 2014
| 1 comment
,
|
![]() |
Hi all,
17 Sep 2014
| 2 comments
,
|
![]() |
|
![]() |
I am using a CONTINUE HANDLER as part of my stored procedure to manage Dropping of Indexes. I do not want the SP to error out becuase an Index doesn't exist as I am just wanting to drop it any way. The CONTINUE HANDLER does just fine if there is 1 index missing if there are multiple then the handler is no longer managing the process and the SP errors out with a message of 'Index doesn't exist' DECLARE CONTINUE HANDLER FOR SQLSTATE VALUE '52004'
31 May 2011
| 1 comment
,
|
![]() |
The Teradata Multiload utility provides the capability to perform batch maintenance on tables (insert, update, delete and upsert). It loads data from external sources and provides the capability to restart jobs interrupted by errors, exceptions and failures.
01 Feb 2010
| 1 comment
,
|
![]() |
In the first article in this series on Teradata Error Handling, we introduced the larger architecture and load utility environment. in this article the focus will be on the Fastload Utility and some of the techniques applicable to handling errors, exceptions and failures that can occur within a High Availability system.
31 Jan 2010
| 4 comments
,
|