Could you please let me no the query for below
I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
Answer / devika
update XYZ
set empname(2,4) = 'PQRS'
where substr(empname(2,4))='ABCS'
Is This Answer Correct ? | 3 Yes | 0 No |
Mention the different locking levels that are available in db2.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Can we use select * statement in cobol program without giving field names ???
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Which catalog tables contain authorization information?
wht happens if we close cursor with cursor with hold option?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
i want to maintain uniqueness on pdf without make lf??????????
What is data manager?
What is the usage of open cursor command?
Discuss about db2 bind?