IBM MainFrame Question: Download Questions PDF
Suppose I have 1000 rows in a db2 table. I want to update first 100 records, How do I do it?
Answer:
is there identity column in this table, for example, if
there is a column indexnum int(supposed start from 1), you
can use the Update Table Set XXX=XXX where indexnum < 101
there is a column indexnum int(supposed start from 1), you
can use the Update Table Set XXX=XXX where indexnum < 101
Download IBM MainFrame Interview Questions And Answers
PDF
Previous Question | Next Question |
How to handle -911 (deadlock) error in a db2 program so that the program will never abend? | Can 88 level variable be declared in FD section? |