Mload NOT aborting even on RDBMS Failure
Posted: Thu Oct 22, 2009 6:50 pm
Hi
I am writing a custom query in my MLoad stage to load table 1. The 'After' script of Mload stage has another INSERT statement to load some data into table 2. I cant chage this flow.
The After script job sometimes gives me following error BUT THE JOB "DOESNT" ABORT.
**** 14:41:55 UTY1008 RDBMS failure: 3706, Syntax error: Data Type XYZ does not match
a Defined Type name.
Could someone please suggest what teradata/ds code I should write in my after script to make the job abort.
I am NOT setting 'Treat SQL Errors as Non Fatal' option (the checkbox)
The following variable are available in Mload through auto generated script. Can I use these??
&SYSRC
&SYSETCNT
&SYSUVCNT
Pleaseeeeee Helpppp
Thanks
I am writing a custom query in my MLoad stage to load table 1. The 'After' script of Mload stage has another INSERT statement to load some data into table 2. I cant chage this flow.
The After script job sometimes gives me following error BUT THE JOB "DOESNT" ABORT.
**** 14:41:55 UTY1008 RDBMS failure: 3706, Syntax error: Data Type XYZ does not match
a Defined Type name.
Could someone please suggest what teradata/ds code I should write in my after script to make the job abort.
I am NOT setting 'Treat SQL Errors as Non Fatal' option (the checkbox)
The following variable are available in Mload through auto generated script. Can I use these??
&SYSRC
&SYSETCNT
&SYSUVCNT
Pleaseeeeee Helpppp
Thanks