write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 7256 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Assuming the column type to be decimal type and the same table to be updated, the string function can be used.
update dbname.tbname
set salary=
substr(cast (salary as char(10)),index(cast (salary as char(10)),'.'))
>>>salary is of type decimal..
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / ankal
assuming this value is sal colume i mean sal=123.45; u want to update it with after decimal value.i think The following query try.
update table_name set sal=sal-cast(sal as int));
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / tdguy
Above answers are correct, but data type should be taken
care of.
| Is This Answer Correct ? | 1 Yes | 0 No |
Why MLOAD needs Work Tables?
Explain teradata utilities?
How is MLOAD Teradata Server restarted after execution?
How a Referential integrity is handled in Teradata?
What is inner join and outer join?
What are the different functions performed in development phase?
Does SDLC changes when you use Teradata instead of Oracle?
What are the uses of bynets in multi-node systems?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What is smp and mpp platforms?
Can you connect multiload from ab initio?
Teradata 
