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 |
wht happens if we close cursor with cursor with hold option?
How to design maps
How would you find out the total number of rows in a db2 table?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
How many buffer pools are available in db2?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
Which isolation level provides maximum concurrency?
What is the physical storage length of date data type?
What is collection in db2 bind?
What is the SQL Communications Area and what are some of its key fields?
Which command is used to connect to a database in DB2 ? Give the Syntax.
how to identify the pseudo conversation by seeing the program