Any TD keyword could be used as an attribute/columnname/variable only if the the variable is between " and ".
FROM TABLE1 BORR
is a MS SQL code..in which [...] tells even if i give [CUSTOMER(space)ID] or [ORIG(space)CUSTOMER(space)ID] with spaces inbetween would be considered as same as the attribute name....(space would not be considered)...
Do we have like this kind in TERADATA ?
You do the same you should do in MS SQL Server instead of the proprietary  syntax, use double quotes:
You CONVERT example is not valid syntax in MS. But col1 seems to be a datetime, depending on your TD release this is probably:
CAST(CAST(DATE AS FORMAT 'yyyy-mm-dd') AS CHAR(10))
Wow...thank you Dieter..we will be using TD 14.10 for our migration...
being a TD lover n learner, I will surely encounter way many doubts....pls bear and clarify me sparing some time..!!!
Question #3 :- RAISEERROR() in MS-SQL...is there any clever way of equivalent TD function instead of writing a big worked out UDF for this ?
If you are talking about raising errors in TD objects as such for particular situation could be seen only in STORED PROCEDURES. We specially handle errors in STORED PROCEDURES by using EXCEPTION HANDLING techniques. Please refer forum
What is the best file format which supports fastload ? There are various...but would like to know the best file format when connected with LINUX - a fastload supports efficiently ?