Hi
The issue happening here is : inner select query is returing multiple rows at a time but update command can only update a single row at a time.
I did not find any query/command to do in simple SQLs. But following link
may be helpful for you.
http://www.dbforums.com/db2/909019-h...er-tables.html...
nsarda2
Last Activity: Jul 28 '14, 12:56 PM
Joined: May 15 '09
Location:
-
Hi
I used following method
1) export the data in a delimited file.
2) Open the deleimited file using edit plus on windows.
3) the replace the new line character (\n) with nothing
and then import the data.Leave a comment:
-
HI
Please paste the error message.
If the problem is resolved then paste the solutions.
ThanksLeave a comment:
No activity results to display
Leave a comment: