Env Variables for Default Conversion

this_is_venki · Post by **this_is_venki** » Mon Mar 27, 2006 1:28 am

Hi

My parallel jobs does some Gud ETL Functionality. :D

The only problem is that some of Column's values are getting truncated in some stages (Like Varchar2(40) to Varchar2(30)) and in some later stages getting transformed back to the original length.(like Varchar2(30 to Varchar2(40))

So finally when i get the data the column value shows some truncation.

I can go through each and every stage to find out the root cause.
But that is very cumbersome since there are around 20 stages and 15 such jobs which are showing similar problems.

Is there any environment variable which, when set will log all such truncations that happen.I went through the list but couldn't find the exact match...

Any help...

Thanks in Advance,
Venky

kumar_s · Post by **kumar_s** » Mon Mar 27, 2006 1:32 am

Unhandled String truncation should through out an waring. Was the message been handled?

ray.wurlod · Post by **ray.wurlod** » Mon Mar 27, 2006 2:57 am

Of course VarChar(40) will be irrecoverably truncated if loaded into a VarChar(30) column. How could it be otherwise?