How can you split a table in to exactly half?
Answer Posted / nirmal khatri
Hi
We can do it by SQL also, below is SQL which is working on
iSeries(AS/400)
insert into nk11581/temp1 (select * from nk11581/temp1
where rrn(temp1) in(
SELECT distinct dec((rrn(temp1)/2)) FROM nk11581/temp1
))
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a page in db2?
What is alias in db2?
What is buffer pool and list some of them?
Explain about rct.
What is database alias db2?
can all users have the privilage to use the sql statement select * (dml)?
What is the use of with ur in db2?
What is isolation level in db2?
What is scrollable cursor in db2?
How does db2 sample database connect?
How to access db2 tables in mainframe?
Define declaration generator (dclgen).
Is schema the same as database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.