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

DATE: 2011-11-09


I expected to do something like:


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