0 - 3 of 3 tags for length

I tried to find out the reason but I couldn't find it .. my Question is if I use only LENGTH() function in SQL Assistant it works and when I use it in BTEQ it doesn't ... 
 
I need to know the reason and if only LENGTH() is not to be used then why it works in SQL Assistant. :)

Hi all,

I have to load some data using Teradata Parallel Transporter...

 

I have a record like:

1234ANA MARIA       20111209

 

I need to load something like:

PID: 1234
NAME: ANA MARIA

DATE: 2011-11-09

 

I expected to do something like:

Hi

I have a few Decimal, Character and Integer columns in my table. How may I write a query in Teradata to get the maximum permissible characters/digits in each of those columns? Please help this newbie.

Thanks and regards
Abhishek