Can I modify the datatype from Integer to Decimal ? Whwn i tried doing this using alter statement got error like "Cannot alter the specified attribute(s) for XXXX. [SQL State=HY000, DB Errorcode=3558] "
Suggest some better wats to do this..
Thanks in Advance,
please help me to resolve this :
For each source first, middle, last, title, and full name field, parse the field into individual words using one or more spaces as a delimiter
kindly tel me how to write teradata sql for this, am new to teradta.