write a query following data.
123.45 is input.write a query after decimal (ex:.45) load
into database ?how it possible?
- 3 Answers
- 7321 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is difference between user and database in teradata?
What is spool space?
Why teradata is used?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What do you mean by fastexport in teradata?
Which is faster fastload or multiload?
Explain teradata architecture?
What is bteq utility in teradata?
What are the advantages of teradata?
How can we check the version of Teradata that we are using currently?
What are the components used in smp and massively parallel processing (mpp) machines?
What is basic teradata query language?
Explain the parallel data extension in teradata?
What are the uses of client software involved in teradata?
