Suppose I have 1000 rows in a db2 table. I want to update first 100 records, How do I do it?
Submitted by: Administratoris 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
Submitted by: Administrator
there is a column indexnum int(supposed start from 1), you
can use the Update Table Set XXX=XXX where indexnum < 101
Submitted by: Administrator
Read Online IBM MainFrame Job Interview Questions And Answers
Top IBM MainFrame Questions
| ☺ | How do define Dynamic array in COBOL how do u define single dimensional array and multidimensional array in your COBOL? |
| ☺ | Can 88 level variable be declared in FD section? |
| ☺ | What is difference b/w file-aid tool and file-aid utility? |
| ☺ | How to handle -911 (deadlock) error in a db2 program so that the program will never abend? |
| ☺ | Suppose I have 1000 rows in a db2 table. I want to update first 100 records, How do I do it? |
Top Mainframe Technical Categories
| ☺ | IBM MainFrame Interview Questions. |
| ☺ | IBM AS400 Interview Questions. |
| ☺ | JCL Interview Questions. |
| ☺ | IMS DB Interview Questions. |
| ☺ | CICS Interview Questions. |
