Archives of the TeradataForum
Message Posted: Mon, 07 Jun 2005 @ 00:14:07 GMT
I was having a problem with getting a stored procedure to compile and was getting these errors:
SPL1033:E(L196), Unexpected text 'ELSE'._ SPL1033:E(L197), Unexpected text 'SET'._ BEGIN IF TRIM(SNGL_STEP_OVRIDE) NOT IN ('ONLY', 'REMAINING')
The line number of the compilation error has nothing to do with the above SQL, buuuut:
When I add a comment statement between a BEGIN (BLOCK) statement and an IF statement The Stored Procedure Compiles:
BEGIN /* IF NO 1 */ IF TRIM(SNGL_STEP_OVRIDE) NOT IN ('ONLY', 'REMAINING').
Anybody have an explanation for this? The compiled stored procedure is out on the Teradata database.
This is a V2R5.1 site.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|